{"id":19737,"date":"2023-05-29T17:05:21","date_gmt":"2023-05-29T17:05:21","guid":{"rendered":"https:\/\/synder.com\/help\/?p=19737"},"modified":"2026-06-12T13:42:29","modified_gmt":"2026-06-12T13:42:29","slug":"how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/","title":{"rendered":"Stripe: Manual Clearing Account Reconciliation Using Excel (Summary Sync)"},"content":{"rendered":"\n<p class=\"has-pale-cyan-blue-background-color has-background wp-block-paragraph\"><strong>Want a faster way?<\/strong> Use Synder\u2019s built-in <a href=\"https:\/\/synder.com\/help\/transaction-reconciliation-how-to-compare-your-payment-platform-data-with-your-accounting-records\/\">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<ul class=\"wp-block-advgb-summary advgb-toc alignnone\">\n<li class=\"toc-level-1\"><a href=\"#overview-98a24cd5-9c8e-49b5-b774-e11a6738d550\">Overview<\/a><\/li>\n<li class=\"toc-level-1\"><a href=\"#main-reconciliation-flow-d0fe1bcc-e74a-49a9-8944-b4a7ff25189b\">Main reconciliation flow<\/a><\/li>\n<li class=\"toc-level-1\"><a href=\"#if-your-clearing-account-does-not-reconcile-aacca9a0-49ec-48d4-9786-0037e28cd47b\">If your clearing account does not reconcile<\/a><\/li>\n<li class=\"toc-level-1\"><a href=\"#when-to-reach-outnbsp-to-support-e2342ce1-c856-489b-89e4-30b9d5c64670\">When to reach out&nbsp; to support<\/a><\/li>\n<li class=\"toc-level-1\"><a href=\"#best-practices-for-ongoing-reconciliation-9c73f94d-b13b-43b5-bfcd-cd8734a64b6a\">Best practices for ongoing reconciliation<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"overview-98a24cd5-9c8e-49b5-b774-e11a6738d550\"><strong>Overview<\/strong><\/h2>\n\n\n\n<p>Synder syncs sales, refunds, payouts, and fees from Stripe. Depending on your configuration, transactions are recorded in your accounting platform as summarized journal entries.<\/p>\n\n\n\n<p>This guide explains how to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Identify the starting and ending balance of your Stripe account<br><\/li>\n\n\n\n<li>Reconcile your clearing account<br><\/li>\n\n\n\n<li>Compare Stripe and accounting data to identify discrepancies<br><\/li>\n<\/ul>\n\n\n\n<p>QuickBooks Online is used as an example. The same reconciliation approach applies to other supported accounting integrations.<\/p>\n\n\n\n<p><strong>Use this guide if:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You use Stripe with Synder<\/li>\n\n\n\n<li>You use Synder in Summary Sync mode<\/li>\n\n\n\n<li>Your clearing account does not reconcile or zero out automatically<\/li>\n\n\n\n<li>You want to verify that Stripe and accounting records match<\/li>\n<\/ul>\n\n\n\n<p>After completing the steps, your <strong>Stripe clearing account will reconcile with sales, <\/strong>payouts, and fees reflected accurately in your books.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"main-reconciliation-flow-d0fe1bcc-e74a-49a9-8944-b4a7ff25189b\"><strong>Main reconciliation flow<\/strong><\/h2>\n\n\n\n<p>To reconcile your Stripe clearing account, we need to figure out the starting and ending balances in your Stripe account. Knowing your starting and ending balances gives you a clear reference point for matching your QuickBooks Online accounts. Stripe provides simple access to both balances on their reports page:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Visit the reports page.<\/li>\n\n\n\n<li>Go to the \u2018Balances\u2019 tab.<\/li>\n\n\n\n<li>Select the date range you are reconciling.<\/li>\n<\/ol>\n\n\n\n<p>It will show you both the starting and the ending balances of your Stripe account:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"476\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-1024x476.png\" alt=\"\" class=\"wp-image-26611\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-1024x476.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-300x139.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-768x357.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-1536x713.png 1536w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-1080x502.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-60x28.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-150x70.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"starting-balance-c5b33aa9-ab11-49dc-8537-6edd4d6996fa\"><strong>Starting balance<\/strong><\/h3>\n\n\n\n<p>If you have been using Stripe before Synder, please ensure that your Stripe starting balance matches the opening balance of your <strong>Stripe(required by Synder)<\/strong> clearing account.&nbsp;<\/p>\n\n\n\n<p>For example, if you began using Synder on October 1, your Stripe clearing account balance in Synder would be $0, while the actual balance in Stripe is different. Using the example above, the Stripe starting balance on October 1 is $22,193.10, so the opening balance for the Stripe clearing account in Synder should also be $22,193.10.&nbsp;<\/p>\n\n\n\n<p>After syncing all transactions, the ending balance in Stripe will match the balance in your Stripe clearing account.<br><br>Next, compare this amount with the ending balance from your clearing account report in Synder for the same date:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Navigate to <strong>Reporting\u2192 Balance sheet<\/strong>.<\/li>\n\n\n\n<li>Select <strong>Balance Sheet<\/strong>.<\/li>\n\n\n\n<li>Select column display to <strong>Months.<\/strong><\/li>\n\n\n\n<li>Locate the Stripe clearing account for the reconciled month.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"380\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-58-1024x380.png\" alt=\"\" class=\"wp-image-26609\" style=\"width:798px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-58-1024x380.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-58-300x111.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-58-768x285.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-58-1536x569.png 1536w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-58-1080x400.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-58-60x22.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-58-150x56.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-58.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>The result is the clearing account balance for the selected period.<\/p>\n\n\n\n<p><strong>Congratulations!<\/strong><\/p>\n\n\n\n<p>The amounts you will see in the Synder Balance sheet report will match your Stripe balance, meaning the reconciliation was successful.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"if-your-clearing-account-does-not-reconcile-aacca9a0-49ec-48d4-9786-0037e28cd47b\"><strong>If your clearing account does not reconcile<\/strong><\/h2>\n\n\n\n<p>If the balances between your Stripe and QuickBooks Online report don&#8217;t match, it&#8217;s often caused by unsynchronized transactions. Follow the steps below to make sure that Synder has successfully synced your Stripe data.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to Synder and filter transactions by status. Make sure that all the transactions within your reconciliation period are in statuses: <strong>Synced<\/strong> or <strong>Skipped <\/strong>on the Platform transactions page.<br>All the other statuses indicate that the transaction is not in your books or needs additional checking. As long as such transactions are present, your books won\u2019t reconcile.<\/li>\n\n\n\n<li>Make sure you are comparing the right numbers (sales might not equal cash, for example). It\u2019s important to use the right numbers for reconciliation and comparison.<\/li>\n\n\n\n<li>If your platform was disconnected within the reconciliation period, make sure you run a <strong>Historical Import<\/strong> on the Platform transactions page to retrieve any missing transactions.<\/li>\n<\/ol>\n\n\n\n<p>If after that your balances still don&#8217;t match, follow the steps below to identify discrepancies by comparing Stripe and QuickBooks Online data in Excel.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-1-download-required-reports-dab496a5-23c2-4f61-bad3-d18f6e580cf0\"><strong>Step 1: Download required reports<\/strong><\/h3>\n\n\n\n<p>Here\u2019s how you can download a Balance change from activity report inStripe:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Log into your Stripe Dashboard.<\/li>\n\n\n\n<li>Navigate to Reports \u2192 Balance Summary.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"396\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-56-1024x396.png\" alt=\"\" class=\"wp-image-26608\" style=\"width:618px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-56-1024x396.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-56-300x116.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-56-768x297.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-56-1536x593.png 1536w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-56-1080x417.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-56-60x23.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-56-150x58.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-56.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>Set your date range for the reconciliation period.<\/li>\n\n\n\n<li>Select the \u201cBalance change from activity\u201d report.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"287\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-50-1024x287.png\" alt=\"\" class=\"wp-image-26601\" style=\"width:646px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-50-1024x287.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-50-300x84.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-50-768x215.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-50-1536x430.png 1536w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-50-1080x302.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-50-60x17.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-50-150x42.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-50.png 1600w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li>Important: When downloading, ensure you include all 54 columns.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"728\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image16-1024x728.png\" alt=\"\" class=\"wp-image-26614\" style=\"width:650px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image16-1024x728.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image16-300x213.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image16-768x546.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image16-400x284.png 400w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image16-1080x768.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image16-60x43.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image16-150x107.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image16.png 1434w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>We will also need a report of the Stripe clearing account from your accounting software.&nbsp;<\/p>\n\n\n\n<p><a href=\"https:\/\/synder.com\/help\/how-to-download-the-clearing-account-report-from-quickbooks-online\/\"><em>Follow this link<\/em><\/a><em> to find the exact steps on how to generate a clearing account report in QuickBooks Online<\/em><\/p>\n\n\n\n<p><strong><em>Note<\/em><\/strong><strong>:<\/strong> If your QuickBooks Online clearing account has tens of thousands of transactions, it might not download the full dataset. After downloading one of the reports above, check for data completeness. If the report is missing data, try the alternative download method.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-2-prepare-your-excel-data-for-comparison-b24ae9f2-5b7f-448c-bd65-6ca47cb80175\"><strong>Step 2: Prepare your Excel data for comparison<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"how-to-prepare-your-stripe-report-b583565f-2fb8-4046-9970-c2817d95d7c6\"><strong>How to prepare your Stripe report<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"873\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-55-1024x873.png\" alt=\"\" class=\"wp-image-26607\" style=\"width:769px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-55-1024x873.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-55-300x256.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-55-768x655.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-55-1080x921.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-55-60x51.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-55-150x128.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-55.png 1161w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Stripe report includes a lot of transaction details that you don&#8217;t need for comparison.<br>You need the <strong>balance_transaction<\/strong> and <strong>net <\/strong>columns.<br>The <strong>balance_transaction <\/strong>column contains IDs that need to be cleaned for easier matching. You can use the following formula to extract the clean ID:<br><strong>=MID(A2, 8, 13)<\/strong><strong><br><\/strong><strong><br><\/strong><strong><em>Where:<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>A2 =\u00a0 the cell containing the original ID<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Here\u2019s how the end result should look like.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"497\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image3-1024x497.png\" alt=\"\" class=\"wp-image-26613\" style=\"width:750px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image3-1024x497.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image3-300x146.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image3-768x373.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image3-1080x524.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image3-60x29.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image3-150x73.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image3.png 1306w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><br>Copy values of <strong>Purified ID <\/strong>and <strong>total <\/strong>columns into a new sheet. This will be our Stripe <strong>clean <\/strong>report.<\/p>\n\n\n\n<p>Here\u2019s an example of how it should look like.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"541\" height=\"868\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-47.png\" alt=\"\" class=\"wp-image-26600\" style=\"width:400px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-47.png 541w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-47-187x300.png 187w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-47-37x60.png 37w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-47-93x150.png 93w\" sizes=\"auto, (max-width: 541px) 100vw, 541px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"how-to-prepare-your-quickbooks-online-report-80e253f9-43ab-4645-bd37-f21d6bf4905b\"><strong>How to prepare your QuickBooks Online report<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"798\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-54-1024x798.png\" alt=\"\" class=\"wp-image-26605\" style=\"width:689px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-54-1024x798.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-54-300x234.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-54-768x599.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-54-1080x842.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-54-60x47.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-54-150x117.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-54.png 1433w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>The QuickBooks Online report also contains details that aren&#8217;t needed for comparison. You only need the Num and Amount columns. However, first, we need to remove payout (transfer) entries and any empty cells.<br>You can do this by filtering the Transaction type column.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"675\" height=\"834\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-49.png\" alt=\"\" class=\"wp-image-26602\" style=\"width:503px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-49.png 675w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-49-243x300.png 243w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-49-49x60.png 49w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-49-121x150.png 121w\" sizes=\"auto, (max-width: 675px) 100vw, 675px\" \/><\/figure>\n\n\n\n<p><strong>The num <\/strong>column contains IDs that need to be cleaned for easier matching. You can use the following formula to extract the clean ID:<br><strong>=LEFT(C3, 13)<\/strong><strong><br><\/strong><strong><br><\/strong><strong><em>Where:<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>C3 =\u00a0 the cell containing the original ID<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Here\u2019s how the end result should look like.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"794\" height=\"486\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-52.png\" alt=\"\" class=\"wp-image-26604\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-52.png 794w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-52-300x184.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-52-768x470.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-52-60x37.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-52-150x92.png 150w\" sizes=\"auto, (max-width: 794px) 100vw, 794px\" \/><\/figure>\n\n\n\n<p>Copy values of <strong>Purified ID <\/strong>and <strong>Amount<\/strong>columns into a new sheet. This will be our Stripe <strong>clean <\/strong>report.<\/p>\n\n\n\n<p>Here\u2019s an example of how it should look like.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"523\" height=\"974\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-48.png\" alt=\"\" class=\"wp-image-26599\" style=\"width:407px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-48.png 523w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-48-161x300.png 161w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-48-32x60.png 32w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-48-81x150.png 81w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-3-consolidate-multiple-lines-into-one-entry-per-transaction-c2f20ee5-403a-4da1-9da2-18aec61d568d\"><strong>Step 3: Consolidate multiple lines into one entry per transaction<\/strong><\/h3>\n\n\n\n<p>Stripe transactions may appear as multiple line items in QuickBooks Online (e.g., one per product or fee). For accurate reconciliation, you need to consolidate these into a single row per transaction, showing the total amount. Use Excel\u2019s Consolidate function:&nbsp;<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click on an empty cell in an empty row.<\/li>\n\n\n\n<li>Go to <strong>Data<\/strong> \u2192 <strong>Consolidate.<\/strong><\/li>\n\n\n\n<li>In the reference box, select <strong>both<\/strong> columns<strong> A<\/strong> and <strong>B<\/strong> (your ID and amount columns).<\/li>\n\n\n\n<li>Click the<strong> + (plus sign)<\/strong> to add this reference.<\/li>\n\n\n\n<li>In the <strong>Use<\/strong> labels in the section, check <strong>BOTH<\/strong> boxes:\n<ol class=\"wp-block-list\">\n<li>\u2611\ufe0f Top row (uses column headers);<\/li>\n\n\n\n<li>\u2611\ufe0f Left column (uses IDs as grouping criteria)<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Click <strong>OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"649\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-51-1024x649.png\" alt=\"\" class=\"wp-image-26603\" style=\"width:656px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-51-1024x649.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-51-300x190.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-51-768x487.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-51-1080x685.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-51-60x38.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-51-150x95.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-51.png 1426w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>As a result, Excel will group multiple transactions with the same ID into one and sum their amounts.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-4-organize-your-data-5e226466-6791-419c-ae66-09e03722a25a\"><strong>Step 4: Organize your data<\/strong><\/h3>\n\n\n\n<p><strong>1. Create separate worksheets for:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Stripe original report data<\/li>\n\n\n\n<li>QuickBooks Online report data\u00a0<\/li>\n\n\n\n<li>Comparison Analysis (your working sheet)<\/li>\n<\/ul>\n\n\n\n<p><strong>2. In your Comparison Analysis sheet, create columns for:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Stripe Transaction ID<\/li>\n\n\n\n<li>Stripe Amount<\/li>\n\n\n\n<li>QuickBooks Online Transaction ID<\/li>\n\n\n\n<li>QuickBooks Online Transaction Amount\u00a0<\/li>\n\n\n\n<li>Lookup<\/li>\n\n\n\n<li>Difference<\/li>\n<\/ul>\n\n\n\n<p>Here\u2019s how the end result should look:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"584\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-60-1024x584.png\" alt=\"\" class=\"wp-image-26612\" style=\"width:658px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-60-1024x584.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-60-300x171.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-60-768x438.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-60-1536x875.png 1536w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-60-1080x615.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-60-60x34.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-60-150x85.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-60.png 1846w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Step 5: Compare data using VLOOKUP<\/strong><\/p>\n\n\n\n<p>Our objective is to match transaction amounts from Stripe and QuickBooks Online that have shared IDs. This process helps us identify any discrepancies in amounts or missing transactions within QuickBooks Online.<\/p>\n\n\n\n<p><strong>1. Set up your comparison formula<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Copy your cleaned Stripe IDs and amounts to columns A and B.<\/li>\n\n\n\n<li>In the <strong>Lookup<\/strong> column, use <strong>VLOOKUP<\/strong> to find matching QuickBooks Online amounts:<\/li>\n<\/ol>\n\n\n\n<p><strong>=VLOOKUP(A3,C:D,2,FALSE)<\/strong><\/p>\n\n\n\n<p><em>Where:<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A3 = Stripe ID you\u2019re looking up<\/li>\n\n\n\n<li>C:D = Your QuickBooks Online data range (ID in column C, amount in column D)<\/li>\n\n\n\n<li>2 = Returns the amount from the 2nd column (QuickBooks Online amount)<\/li>\n\n\n\n<li>FALSE = Exact match only<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"567\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-53-1024x567.png\" alt=\"\" class=\"wp-image-26606\" style=\"width:641px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-53-1024x567.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-53-300x166.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-53-768x425.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-53-1080x598.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-53-60x33.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-53-150x83.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-53.png 1474w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>In the <strong>Difference<\/strong> column, calculate the difference by subtracting the looked-up amount from the Stripe amount.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"785\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-57-1024x785.png\" alt=\"\" class=\"wp-image-26610\" style=\"width:643px;height:auto\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-57-1024x785.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-57-300x230.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-57-768x589.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-57-1080x828.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-57-60x46.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-57-150x115.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-57.png 1440w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>2.<\/strong> <strong>Identify discrepancies<\/strong><\/p>\n\n\n\n<p>Perfect matches should show 0 in the difference column.<\/p>\n\n\n\n<p>Common discrepancy indicators include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Negative number<\/strong> = QuickBooks Online amount is higher than the Stripe amount.<\/li>\n\n\n\n<li><strong>Positive number<\/strong> = Stripe amount is higher than the QuickBooks Online amount.\u00a0<\/li>\n\n\n\n<li><strong>N\/A<\/strong> = Transaction ID exists in Stripe but not in QuickBooks Online.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-6-address-common-discrepancies-df5a93cb-adf9-4ddd-8fdd-efa4bfb1eeab\"><strong>Step 6: Address common discrepancies<\/strong><\/h3>\n\n\n\n<p><strong>1. Missing transactions in QuickBooks Online<\/strong><\/p>\n\n\n\n<p><strong>Possible causes:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Transaction failed to sync due to network issues<\/li>\n\n\n\n<li>Transaction filtered out by Synder settings<\/li>\n\n\n\n<li><a href=\"https:\/\/synder.com\/help\/unsupported-amazon-transaction-types-guide\/\">Unsupported transaction type<\/a><\/li>\n<\/ul>\n\n\n\n<p><strong>Actions to take:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Check Synder\u2019s sync logs for failed transactions.<\/li>\n\n\n\n<li>Force a manual sync in Synder for the missing period.<\/li>\n\n\n\n<li>Confirm timezone settings match between Stripe reports (PST\/UTC) and Synder.<\/li>\n<\/ol>\n\n\n\n<p><strong>2. Amount differences<\/strong><\/p>\n\n\n\n<p><strong>Possible causes:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Currency conversion differences between marketplaces<\/li>\n\n\n\n<li>Partial refunds not properly matched to original orders<\/li>\n\n\n\n<li>Difference in fee calculations between Stripe reports and Synder processing<\/li>\n<\/ul>\n\n\n\n<p><strong>Actions to take:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Check for currency conversions if selling in multiple countries.<\/li>\n\n\n\n<li>Look for reserve balance movements in the same period.<\/li>\n\n\n\n<li>Check for related adjustment entries in subsequent periods.<\/li>\n<\/ol>\n\n\n\n<p><strong>3. Extra transactions in QuickBooks Online<\/strong><\/p>\n\n\n\n<p><strong>Possible causes:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Manual entries created by your accounting team<\/li>\n\n\n\n<li>Duplicate syncing from multiple sync attempts<\/li>\n\n\n\n<li>Journal entries or adjustments made outside of Synder<\/li>\n\n\n\n<li>Starting balance entries when first setting up clearing accounts<\/li>\n<\/ul>\n\n\n\n<p><strong>Actions to take:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Check if descriptions indicate manual entry.<\/li>\n\n\n\n<li>Verify transaction source in QuickBooks Online (look for \u201cSynder\u201d in descriptions).<\/li>\n\n\n\n<li>Check for duplicate Stripe connections in Synder.<\/li>\n\n\n\n<li>Review any manual clearing account adjustments.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"when-to-reach-outnbsp-to-support-e2342ce1-c856-489b-89e4-30b9d5c64670\"><strong>When to reach out&nbsp; to support<\/strong><\/h2>\n\n\n\n<p>Get in touch with support when you\u2019ve identified specific transactions causing issues but can\u2019t resolve them.<\/p>\n\n\n\n<p><strong>What to include in your support request:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reconciliation period (start and end dates)<\/li>\n\n\n\n<li>Specific transaction IDs<\/li>\n\n\n\n<li>Screenshots of problematic transactions in both Stripe and QuickBooks Online<\/li>\n\n\n\n<li>Summary of your findings (e.g., \u201cFound 5 missing fulfillment fees totaling $47.50\u201d)<\/li>\n\n\n\n<li>Currency\/marketplace information if applicable<\/li>\n\n\n\n<li>Steps already taken to resolve the issue<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"best-practices-for-ongoing-reconciliation-9c73f94d-b13b-43b5-bfcd-cd8734a64b6a\"><strong>Best practices for ongoing reconciliation<\/strong><\/h2>\n\n\n\n<p>Staying on top of your clearing accounts requires consistency. Here are key practices to help you keep your books accurate and your reconciliation process smooth over time:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Reconcile monthly rather than waiting for quarter-end.<\/li>\n\n\n\n<li>Monitor multiple currency clearing accounts if selling internationally.<\/li>\n\n\n\n<li>Keep an eye on alerts in Synder for failed sync transactions.<\/li>\n\n\n\n<li>Maintain timezone consistency across Stripe, Synder, and reconciliation periods.<\/li>\n\n\n\n<li>Document any manual entries made to clearing accounts.<\/li>\n\n\n\n<li>Review unsupported transaction types periodically as Synder adds support.<\/li>\n<\/ol>\n\n\n\n<p>A consistent reconciliation routine saves time, reduces errors, and keeps your financials audit-ready. By following these best practices, you\u2019ll avoid surprises down the line and ensure your clearing accounts stay clean and reliable month after month.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/synder.com\/contact\/\"><em>Reach out to Synder Team<\/em><\/a><strong> <\/strong>via online support chat or email with any questions you have \u2013 we are always happy to help you!<\/p>","protected":false},"excerpt":{"rendered":"<p>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. Overview Main reconciliation flow If your clearing account does not reconcile When to reach out&nbsp; [&hellip;]<\/p>\n","protected":false},"author":2316,"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,376,438,56,380,437],"tags":[],"ppma_author":[349],"class_list":["post-19737","post","type-post","status-publish","format-standard","hentry","category-manual-reconciliation-summary-sync","category-transaction-recording-summary","category-stripe-payment-integration","category-reconciliation","category-payouts-settlement-clearing","category-payment-integrations-main"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Stripe: Manual Clearing Account Reconciliation Using Excel (Summary Sync)<\/title>\n<meta name=\"description\" content=\"Effortlessly reconcile Stripe summaries with Stripe reports. Synder guides you through the streamlined reconciliation process\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Stripe: Manual Clearing Account Reconciliation Using Excel (Summary Sync)\" \/>\n<meta property=\"og:description\" content=\"Effortlessly reconcile Stripe summaries with Stripe reports. Synder guides you through the streamlined reconciliation process\" \/>\n<meta property=\"og:url\" content=\"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/\" \/>\n<meta property=\"og:site_name\" content=\"Synder\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-29T17:05:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-12T13:42:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-1024x476.png\" \/>\n<meta name=\"author\" content=\"Vili Varazi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vili Varazi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Stripe: Manual Clearing Account Reconciliation Using Excel (Summary Sync)","description":"Effortlessly reconcile Stripe summaries with Stripe reports. Synder guides you through the streamlined reconciliation process","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/","og_locale":"en_US","og_type":"article","og_title":"Stripe: Manual Clearing Account Reconciliation Using Excel (Summary Sync)","og_description":"Effortlessly reconcile Stripe summaries with Stripe reports. Synder guides you through the streamlined reconciliation process","og_url":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/","og_site_name":"Synder","article_published_time":"2023-05-29T17:05:21+00:00","article_modified_time":"2026-06-12T13:42:29+00:00","og_image":[{"url":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-1024x476.png","type":"","width":"","height":""}],"author":"Vili Varazi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vili Varazi","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/#article","isPartOf":{"@id":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/"},"author":{"name":"Vili Varazi","@id":"https:\/\/synder.com\/help\/#\/schema\/person\/5c93e62bed7fbd7e7cf5e39dc10e5fad"},"headline":"Stripe: Manual Clearing Account Reconciliation Using Excel (Summary Sync)","datePublished":"2023-05-29T17:05:21+00:00","dateModified":"2026-06-12T13:42:29+00:00","mainEntityOfPage":{"@id":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/"},"wordCount":1747,"commentCount":0,"image":{"@id":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-1024x476.png","articleSection":["Manual Reconciliation \u2014 Summary Sync","Transaction Recording: Summary","Stripe","Reconciliation","Payouts, Settlement &amp; Clearing","Payment Integrations"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/","url":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/","name":"Stripe: Manual Clearing Account Reconciliation Using Excel (Summary Sync)","isPartOf":{"@id":"https:\/\/synder.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/#primaryimage"},"image":{"@id":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59-1024x476.png","datePublished":"2023-05-29T17:05:21+00:00","dateModified":"2026-06-12T13:42:29+00:00","author":{"@id":"https:\/\/synder.com\/help\/#\/schema\/person\/5c93e62bed7fbd7e7cf5e39dc10e5fad"},"description":"Effortlessly reconcile Stripe summaries with Stripe reports. Synder guides you through the streamlined reconciliation process","breadcrumb":{"@id":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/#primaryimage","url":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59.png","contentUrl":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2023\/05\/image-59.png","width":1600,"height":743},{"@type":"BreadcrumbList","@id":"https:\/\/synder.com\/help\/how-to-reconcile-stripe-daily-summary-in-quickbooks-using-stripe-reports\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/synder.com\/help\/"},{"@type":"ListItem","position":2,"name":"Stripe: Manual Clearing Account Reconciliation Using Excel (Summary Sync)"}]},{"@type":"WebSite","@id":"https:\/\/synder.com\/help\/#website","url":"https:\/\/synder.com\/help\/","name":"Synder","description":"Articles &amp; FAQ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/synder.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/synder.com\/help\/#\/schema\/person\/5c93e62bed7fbd7e7cf5e39dc10e5fad","name":"Vili Varazi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c7e783f0a0a89846c226f120be7272f0f3c28caaff855c0cf408e3ba7a2cd757?s=96&d=mm&r=g35f8d0cee651e41638777f346be65b43","url":"https:\/\/secure.gravatar.com\/avatar\/c7e783f0a0a89846c226f120be7272f0f3c28caaff855c0cf408e3ba7a2cd757?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c7e783f0a0a89846c226f120be7272f0f3c28caaff855c0cf408e3ba7a2cd757?s=96&d=mm&r=g","caption":"Vili Varazi"},"url":"https:\/\/synder.com\/help\/author\/vili-varazi\/"}]}},"author_meta":{"display_name":"Vili Varazi","author_link":"https:\/\/synder.com\/help\/author\/vili-varazi\/"},"featured_img":null,"coauthors":[{"link":"https:\/\/synder.com\/help\/author\/vili-varazi\/","display_name":"Vili Varazi"}],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/synder.com\/help\/category\/reconciliation\/manual-reconciliation-summary-sync\/\" class=\"advgb-post-tax-term\">Manual Reconciliation \u2014 Summary Sync<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/transaction-recording-summary\/\" class=\"advgb-post-tax-term\">Transaction Recording: Summary<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/payment-integrations-main\/stripe-payment-integration\/\" class=\"advgb-post-tax-term\">Stripe<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/reconciliation\/\" class=\"advgb-post-tax-term\">Reconciliation<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/transaction-recording-summary\/payouts-settlement-clearing\/\" class=\"advgb-post-tax-term\">Payouts, Settlement &amp; Clearing<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/payment-integrations-main\/\" class=\"advgb-post-tax-term\">Payment Integrations<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Manual Reconciliation \u2014 Summary Sync<\/span>","<span class=\"advgb-post-tax-term\">Transaction Recording: Summary<\/span>","<span class=\"advgb-post-tax-term\">Stripe<\/span>","<span class=\"advgb-post-tax-term\">Reconciliation<\/span>","<span class=\"advgb-post-tax-term\">Payouts, Settlement &amp; Clearing<\/span>","<span class=\"advgb-post-tax-term\">Payment Integrations<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 3 years ago","modified":"Updated 5 months ago"},"absolute_dates":{"created":"Posted on May 29, 2023","modified":"Updated on June 12, 2026"},"absolute_dates_time":{"created":"Posted on May 29, 2023 5:05 pm","modified":"Updated on June 12, 2026 1:42 pm"},"featured_img_caption":"","series_order":"","authors":[{"term_id":349,"user_id":2316,"is_guest":0,"slug":"vili-varazi","display_name":"Vili Varazi","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/c7e783f0a0a89846c226f120be7272f0f3c28caaff855c0cf408e3ba7a2cd757?s=96&d=mm&r=g","author_category":"","first_name":"Vili","last_name":"Varazi","user_url":"","job_title":"","description":""}],"_links":{"self":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/19737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/users\/2316"}],"replies":[{"embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/comments?post=19737"}],"version-history":[{"count":5,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/19737\/revisions"}],"predecessor-version":[{"id":28953,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/19737\/revisions\/28953"}],"wp:attachment":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/media?parent=19737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/categories?post=19737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/tags?post=19737"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/ppma_author?post=19737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}