{"id":25128,"date":"2025-10-07T11:54:32","date_gmt":"2025-10-07T11:54:32","guid":{"rendered":"https:\/\/synder.com\/help\/?p=25128"},"modified":"2026-09-22T19:03:32","modified_gmt":"2026-09-22T19:03:32","slug":"reconciling-shopify-transactions-in-oracle-netsuite-with-synder","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/reconciling-shopify-transactions-in-oracle-netsuite-with-synder\/","title":{"rendered":"Shopify: Manual Clearing Account Reconciliation \u2014 Oracle NetSuite (Summary Sync)"},"content":{"rendered":"\n
Want a faster way?<\/strong> Use Synder\u2019s built-in Transaction Reconciliation module<\/a> to automatically compare your payment platform data against your accounting records \u2014 no Excel needed. This guide covers the manual method for users who prefer to verify data outside Synder.<\/p>\n\n\n\n Efficiently managing and reconciling sales transactions is crucial for any business, particularly when integrating e-commerce solutions like Shopify with accounting systems like Oracle NetSuite. <\/p>\n\n\n\n Once you are onboarded to Synder and have connected all the platforms, you\u2019ll see a list of daily summaries showing your most recent Shopify sales.. <\/p>\n\n\n\n In our example, where Shopify sales and payments are processed through PayPal and Shopify Payments gateways, you\u2019ll see two daily summaries \u2014 one for each payment gateway:<\/p>\n\n\n\n You\u2019ll see the journal entry totals, which represent the net amount earned \u2014 with refunds and fees already excluded.. It should match the report from Shopify.<\/p>\n\n\n\n Go to the Synder<\/strong> \u2192 Summaries<\/strong> tab on the left-hand side menu.<\/p>\n\n\n\n Tip<\/em><\/strong>: Make sure the status shows \u201cfully fetched\u201d, which means that all the transactions for the day were successfully imported to Synder, and that the totals align accurately.<\/em><\/p>\n\n\n\n In Shopify, go to Reports<\/strong> in the left-hand side menu \u2192 Finances summary<\/strong> and select the needed day (in our example, it\u2019s April 30, 2023).<\/p>\n\n\n\n Once you sync both summaries to the books, your income statement (P&L) will get updated according to your mapping. In this example, Synder\u2019s default mapping is used \u2014 all PayPal sales are posted to one account, and all Shopify Payments sales to another. You can customize this mapping to fit your need and use groups<\/a> in Synder\u2019s mapping table to view detailed platform-level data in your profit and loss report.<\/p>\n\n\n\n To see your income statement in Oracle NetSuite, go to Financial<\/strong> \u2192 Reports <\/strong>\u2192 Income Statement.<\/strong><\/p>\n\n\n\n Select the required period and click Refresh<\/strong> (in our example, it is the entire period, which extends until 30 April 2023).<\/p>\n\n\n\n The total income in the profit and loss will equal \u201cTotal sales\u201d minus \u201cTaxes\u201d (Located on the balance sheet)<\/em> from the Finances summary Shopify report, which is $11367.6 = $11528.38 – $160.78.<\/p>\n\n\n\n The \u201cGross sales\u201d from the Shopify report equals the sum of the Shopify and PayPal sales from the profit and loss: $14012.64 = $9772 + $4240.64<\/p>\n\n\n\n This way, you\u2019ll always be able to see how Synder is updating your income statement.<\/p>\n\n\n\n <\/p>\n\n\n\n Once the journal entries are synced to the books, the clearing account balances will rise, as Synder uses a separate clearing account for each platform to simplify reconciliation. If your Shopify has manual orders or Shopify POS, the orders will be broken down into separate categories as well, so you may have several clearing accounts per Shopify.<\/p>\n\n\n\n You\u2019ll be able to match synced payout amounts under the Match Bank Data option and reconcile in one click, as pictured below:<\/p>\n\n\n\n <\/p>\n\n\n\n There are several reasons why daily journal entry totals may not match the totals from the payment processor reports. Below are the most common reasons and solutions:<\/p>\n\n\n\n The \u201cPartially fetched\u201d status means that some transactions for the day weren\u2019t imported successfully. If you click \u201cSee details\u201d for a summary with such a status, you\u2019ll be able to see that some transactions are Not Ready, which means that the app is still processing them; that\u2019s why the total won\u2019t match.<\/p>\n\n\n\n If you enable multi-currency in Synder, this means that a summary for one day will have several journal entries (each in its own currency), so the total will show the combined amount for all summaries (converted to your home currency).<\/p>\n\n\n\n If the totals still don\u2019t match after checking the common causes, there might be other reasons. <\/strong>In all other cases, it\u2019s recommended to turn to the support team, attaching the screenshots with the totals from the payment processor you were comparing against. The support team will be able to look into the issue and tell which reports should be used in your specific case.<\/p>\n\n\n\n Reach out to the Synder Team<\/em><\/a> via online support chat, phone, or email with any questions you may have about Oracle NetSuite or Shopify \u2013 we\u2019re always happy to help you!<\/p>\n","protected":false},"excerpt":{"rendered":" Want a faster way? Use Synder\u2019s built-in Transaction Reconciliation module to automatically compare your payment platform data against your accounting records \u2014 no Excel needed. This guide covers the manual method for users who prefer to verify data outside Synder. Efficiently managing and reconciling sales transactions is crucial for any business, particularly when integrating e-commerce […]<\/p>\n","protected":false},"author":2233,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","footnotes":"","_ppma_block_editor_authors":""},"categories":[382,463,399,56,458,398],"tags":[],"ppma_author":[338],"class_list":["post-25128","post","type-post","status-publish","format-standard","hentry","category-manual-reconciliation-summary-sync","category-oracle-netsuite-accounting-integration","category-shopify-ecommerce-integration","category-reconciliation","category-accounting-integrations-main","category-ecommerce-integrations-main"],"yoast_head":"\n
In this article, we\u2019ll focus on the process of reconciling Shopify sales and payouts in NetSuite using Synder.<\/p>\n\n\n\nMatching journal entry total to the reports in Shopify<\/strong><\/h2>\n\n\n\n
\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\nMatching profit and loss to Shopify reports<\/strong><\/h2>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\nReconciling journal entries in Oracle NetSuite<\/strong><\/h2>\n\n\n\n
The account that represents all online sales will be cleared out automatically, as Synder synchronizes payouts (money transfers from your payment processor to your bank) and posts them to your books, debiting the clearing and crediting the checking account. So if the payout for April 30 happens on May 4, then it\u2019ll be on May 4 that the clearing account balance will go down, and the checking account balance will go up.
<\/p>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\nWhy do my daily totals not match Shopify?<\/strong><\/h2>\n\n\n\n
A summary is \u201cPartially fetched\u201d\/\u201cPartially synced\u201d<\/strong><\/h3>\n\n\n\n
Solution:<\/em><\/strong>
Please wait for the app to finish processing your day (some platforms, like Amazon, won\u2019t approve their fees for up to 2 weeks, so this process can take a long time), or contact the support team to double-check the reasons for the partly fetched status.<\/p>\n\n\n\nMulti-currency enabled<\/strong><\/h3>\n\n\n\n
<\/strong>Solution:<\/em><\/strong>
A good approach here is to run reports by currency for both the payment processor and your books (you can map each currency to a separate clearing account) and reconcile clearing accounts individually, currency by currency.<\/p>\n\n\n\nOther reasons<\/strong><\/h3>\n\n\n\n