{"id":25457,"date":"2026-01-26T18:18:16","date_gmt":"2026-01-26T18:18:16","guid":{"rendered":"https:\/\/synder.com\/help\/?p=25457"},"modified":"2026-06-25T17:54:23","modified_gmt":"2026-06-25T17:54:23","slug":"how-to-reconcile-your-afterpay-clearing-account-while-using-synder-in-per-transaction-mode","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/how-to-reconcile-your-afterpay-clearing-account-while-using-synder-in-per-transaction-mode\/","title":{"rendered":"Afterpay: Manual Clearing Account Reconciliation Using Excel (Per Transaction)"},"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 Afterpay is a sales-only integration<\/strong> in Synder. Synder syncs sales and refunds<\/strong> from Afterpay, but payouts and processing fees are not synced automatically<\/strong> and must be recorded manually.<\/p>\n\n\n\n This guide explains how to:<\/p>\n\n\n\n QuickBooks Online is used as an example, but the same reconciliation approach applies to other supported accounting integrations and to other payment platforms that do not support payout and fee syncing<\/strong>.<\/p>\n\n\n\n Use this guide if:<\/strong><\/p>\n\n\n\n After completing this guide, your Afterpay clearing account will reconcile correctly<\/strong>, with all sales, payouts, and fees accurately reflected in your books.<\/p>\n\n\n\n <\/p>\n\n\n\n To reconcile your Afterpay clearing account, complete the steps below in the order given<\/strong>. Regular manual entries are crucial for proper reconciliation of integrations without fee and payout support. Without it, the clearing account balance won\u2019t be cleared. We\u2019ll highlight a few efficient ways of processing these manual entries. <\/p>\n\n\n\n QuickBooks Online and some other accounting software have tools that can help you automate posting Payouts. We suggest reviewing this guide about integrations without payout support.<\/a><\/p>\n\n\n\n The number you received is your total Afterpay fee for the selected month. Record it in your books by creating a journal entry: debit<\/strong> the Afterpay fees expense<\/strong> account and credit<\/strong> the Afterpay (required for Synder) Clearing account <\/strong>for that amount.<\/p>\n\n\n\n From the same report, sum the Settlement Amount<\/strong> column using =SUM(G:G)<\/strong> function.<\/p>\n\n\n\n By following this guide<\/a>, find out the clearing account amounts from your QuicBooks. <\/p>\n\n\n\n If the balances between your Afterpay and QuickBooks report don’t match, it’s often caused by unsynchronized transactions. Follow the steps below to make sure that Synder has successfully synced your Afterpay data:<\/p>\n\n\n\n If you\u2019ve checked all the basics but the discrepancy still persists, follow the steps below to download the report from Afterpay and compare it with the report from QuickBooks. This will help identify the transactions causing differences.<\/p>\n\n\n\n <\/p>\n\n\n\n We will also need a report of the AfterPay clearing account from your accounting software. <\/p>\n\n\n\n Follow this link<\/em><\/a> to find the exact steps on how to generate a clearing account report in QuickBooks Online<\/em><\/p>\n\n\n\n Note<\/em><\/strong>:<\/strong> If your QuickBooks 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>\n\n\n\n Afterpay report includes a lot of transaction details that you dont need for comparison.<\/p>\n\n\n\n <\/p>\n\n\n\n Afterpay 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:<\/strong> <\/p>\n\n\n\n As a result, Excel will group multiple transactions with the same ID into one and sum their amounts. Here\u2019s how the end result should look like.<\/p>\n\n\n\n <\/p>\n\n\n\n 1.Create a new sheet for your Comparison Analysis.<\/strong> Here\u2019s how the end result should look:<\/p>\n\n\n\n <\/p>\n\n\n\n Our objective is to match transaction amounts from Afterpay 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 1. Set up your comparison formula<\/strong><\/p>\n\n\n\n =VLOOKUP(A3,C:D,2,FALSE)<\/p>\n\n\n\n Where:<\/em><\/p>\n\n\n\n In the Difference<\/strong> column, calculate the difference by subtracting the looked-up amount from the Afterpay amount.<\/p>\n\n\n\n 2.<\/strong> Identify discrepancies<\/strong><\/p>\n\n\n\n Perfect matches should show 0 in the difference column.<\/p>\n\n\n\n Common discrepancy indicators include:<\/p>\n\n\n\n <\/p>\n\n\n\n 1. Missing transactions in QuickBooks Online<\/strong><\/p>\n\n\n\n Possible causes:<\/strong><\/p>\n\n\n\n Actions to take:<\/strong><\/p>\n\n\n\n 2. Amount differences<\/strong><\/p>\n\n\n\n Possible causes:<\/strong><\/p>\n\n\n\n Actions to take:<\/strong><\/p>\n\n\n\n 3. Extra transactions in QuickBooks Online<\/strong><\/p>\n\n\n\n Possible causes:<\/strong><\/p>\n\n\n\n Actions to take:<\/strong><\/p>\n\n\n\n <\/p>\n\n\n\n Get in touch with support when you\u2019ve identified specific transactions causing issues but can\u2019t resolve them.<\/p>\n\n\n\n What to include in your support request:<\/strong><\/p>\n\n\n\n <\/p>\n\n\n\n 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 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>\n\n\n\n Reach out to Synder Team<\/em><\/a> <\/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":" 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. Afterpay is a sales-only integration in Synder. Synder syncs sales and refunds from Afterpay, but […]<\/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":[456,437],"tags":[],"ppma_author":[349],"class_list":["post-25457","post","type-post","status-publish","format-standard","hentry","category-afterpay-payment-integration","category-payment-integrations-main"],"yoast_head":"\n\n
\n
Main Reconciliation Flow<\/strong><\/h2>\n\n\n\n
For most cases, reconciliation is complete after recording payouts and fees.<\/p>\n\n\n\nStep 1: Add Payouts Manually:<\/strong><\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\nStep 2: Add expenses manually<\/strong><\/h3>\n\n\n\n
<\/strong>Tax and expense information can be found in the Afterpay reports. Here\u2019s how:<\/p>\n\n\n\n\n
<\/li>\n<\/ol>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n\n
=SUM(H:H), where H is the column where Merchant Fee excl Tax is located.<\/li>\n<\/ol>\n\n\n\n
<\/figure>\n\n\n\nStep 3: Sum total Afterpay sales<\/strong><\/h3>\n\n\n\n
<\/figure>\n\n\n\n
<\/p>\n\n\n\n
Step 4: Compare Afterpay Settlement Amount sum to QuickBooks report<\/strong><\/p>\n\n\n\n
The amounts you will see in the QuickBooks Online clearing report will match your Afterpay Settlement amount, meaning the reconciliation was successful. Congratulations!<\/strong><\/p>\n\n\n\nIf Your Clearing Account Does Not Reconcile<\/strong><\/h2>\n\n\n\n
\n
Step 1: Download required reports<\/strong>
<\/strong>
You should already have a report from Afterpay if you\u2019ve followed the main reconciliation flow. If not, please download it by following the steps above.<\/h3>\n\n\n\nStep 2: Prepare your Excel data for comparison<\/strong><\/h3>\n\n\n\n
<\/figure>\n\n\n\n
<\/strong>Create a new clean Afterpay report by copying the values of Afterpay Order ID <\/strong>and Settlement Amount <\/strong>columns into a new sheet..
Here\u2019s how your clean report should look after a cleanup. <\/p>\n\n\n\n
<\/figure>\n\n\n\n
QuickBooks register report also has a lot of information that we don\u2019t need. Perform the same steps, but with Transaction ID<\/strong> and Transaction Currency<\/strong> amount lines.<\/p>\n\n\n\n
<\/figure>\n\n\n\nStep 3: Consolidate multiple lines into one entry per transaction<\/strong><\/h3>\n\n\n\n
\n
\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n\n
\n
Step 4: Organize your data<\/strong><\/h3>\n\n\n\n
2. In your Comparison Analysis sheet, create columns for:<\/strong><\/p>\n\n\n\n\n
Copy and paste columns from your Clean Shopify report.
<\/li>\n\n\n\n
Copy and paste columns from your Clean QuickBooks report.
<\/li>\n\n\n\n
<\/figure>\n\n\n\nStep 5: Compare data using VLOOKUP<\/strong><\/h3>\n\n\n\n
\n
\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n\n
Step 6: Address common discrepancies<\/strong><\/h3>\n\n\n\n
\n
\n
\n
\n
\n
\n
When to reach out to support<\/strong><\/h2>\n\n\n\n
\n
Best practices for ongoing reconciliation<\/strong><\/h2>\n\n\n\n
\n