{"id":19680,"date":"2023-05-18T13:42:45","date_gmt":"2023-05-18T13:42:45","guid":{"rendered":"https:\/\/synder.com\/help\/?p=19680"},"modified":"2026-09-22T19:03:30","modified_gmt":"2026-09-22T19:03:30","slug":"how-to-effortlessly-reconcile-shopify-daily-journal-entries-in-quickbooks","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/how-to-effortlessly-reconcile-shopify-daily-journal-entries-in-quickbooks\/","title":{"rendered":"Summary Sync: How to effortlessly reconcile Shopify Journal Entries in QuickBooks?"},"content":{"rendered":"\n
Efficiently managing and reconciling sales transactions is vital for any business, especially when it comes to the seamless integration of e-commerce platforms like Shopify with accounting software such as QuickBooks Online.<\/p>\n\n\n\n
In this article, we\u2019ll focus on the process of reconciling Shopify sales paid via Shopify Payments and PayPal in QuickBooks Online, though you can apply the same flow to any set of payment gateways you use with Shopify. <\/p>\n\n\n\n
Overview:<\/strong><\/p>\n\n\n\n Once you are onboarded to Synder and connect all the platforms, you\u2019ll see the list of summaries representing a few of the latest days of the Shopify sales.\u00a0<\/p>\n\n\n\n In our example, with Shopify sales and Payments coming through PayPal and Shopify Payments gateways, you\u2019ll be able to see 2 summaries per day: <\/p>\n\n\n\n You\u2019ll see the Journal Entry totals, that should reflect the amount of the earned money (refunds, fees should already be excluded from this amount). It should match the report from Shopify.<\/p>\n\n\n\n Go to Synder<\/strong> \u2192 Summaries<\/strong> tab on the left hand side menu.<\/p>\n\n\n\n Tip: Make sure you see the \u201cfully fetched\u201d status, which means that all the transactions for the day were successfully imported to Synder and the totals should match.<\/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 You\u2019ll be able to see that the total of the transactions paid via PayPal will match up to the payment’s amount from PayPal: $6923.05.Matching Journal Entry total to reports in Shopify<\/strong><\/h2>\n\n\n\n
\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
The total of Shopify payments and Shop Pay Installments will be equal to the other summary total: $93.5+ $4511.8= $4605.3.<\/p>\n\n\n\nMatching Profit and Loss to Shopify reports<\/strong><\/h2>\n\n\n\n