{"id":25671,"date":"2026-02-12T18:24:22","date_gmt":"2026-02-12T18:24:22","guid":{"rendered":"https:\/\/synder.com\/help\/?p=25671"},"modified":"2026-06-12T13:42:26","modified_gmt":"2026-06-12T13:42:26","slug":"walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users","status":"publish","type":"post","link":"https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/","title":{"rendered":"Walmart USA: 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 Walmart is a sales-only integration in Synder. <\/strong>Synder syncs sales, refunds, and processing fees from Walmart. Payouts are not synced automatically 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. The same reconciliation approach applies to other supported accounting integrations<\/strong> and to other platforms that do not support payout syncing.<\/p>\n\n\n\n Use this guide if:<\/p>\n\n\n\n After completing the steps, your Walmart clearing account will reconcile with sales, <\/strong>payouts, and fees reflected accurately in your books.<\/p>\n\n\n\n Complete the steps below in order.<\/p>\n\n\n\n Manual payout entries are required to clear the Walmart clearing account balance.<\/p>\n\n\n\n Some accounting platforms support rules or other automation for posting payouts. Use the guide for integrations without payout support to configure automation.<\/p>\n\n\n\n When payouts are recorded and Synder data is synced, the clearing account balance should match the expected ending balance.<\/p>\n\n\n\n Some accounting platforms support rules or other automation for posting payouts. Use the guide for integrations without payout support to configure automation.<\/a><\/p>\n\n\n\n When payouts are recorded and Synder data is synced, the clearing account balance should match the expected ending balance.<\/p>\n\n\n\n After a cycle closes, the Walmart and the QuickBooks Online clearing account balance will be zero. <\/strong><\/p>\n\n\n\n Congratulations on reconciling your clearing!<\/p>\n\n\n\n Note: In Walmart, the entire amount is converted into a scheduled payout. When a balance remains, it indicates adjustments that Walmart applied to a later cycle and should be reviewed in subsequent settlements.<\/em><\/p>\n\n\n\n <\/p>\n\n\n\n If Walmart and QuickBooks Online balances do not match, the cause is commonly missing or unsynced transactions. Complete the checks below before moving to advanced comparison.<\/p>\n\n\n\n If balances still do not match, use Advanced comparison (Excel method)<\/strong> to identify specific discrepancies.<\/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 and how to find this sum.<\/em><\/p>\n\n\n\n Walmart transactions may appear as multiple line items in QuickBooks Online (for example, one line per product or fee). Consolidate to a single row per transaction with the total amount.<\/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 it should look:<\/p>\n\n\n\n 1. Create a new sheet for your Comparison Analysis. Here\u2019s how the end result should look:<\/p>\n\n\n\n Our objective is to match transaction amounts from Walmart 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 In the Difference<\/strong> column, subtract the looked-up QuickBooks Online amount from the Walmart amount. 2. Identify discrepancies. Perfect matches should show 0 in the difference column.<\/p>\n\n\n\n Discrepancy indicators:<\/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 Contact support when you identify specific transactions causing reconciliation issues and cannot resolve them.<\/p>\n\n\n\n Include the following in your request:<\/p>\n\n\n\n A consistent reconciliation routine saves time, reduces errors, and keeps your finances 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. Main Reconciliation Flow If your clearing account does not reconcile Limitations When to contact support […]<\/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":[383,56,405],"tags":[],"ppma_author":[349],"class_list":["post-25671","post","type-post","status-publish","format-standard","hentry","category-manual-reconciliation-per-transaction","category-reconciliation","category-walmart-ecommerce-integration"],"yoast_head":"\n\n
\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n<\/ul>\n\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\nWalmart clearing account reconciliation flow<\/strong><\/h2>\n\n\n\n
Record payouts manually<\/strong><\/h3>\n\n\n\n
\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n<\/ol>\n\n\n\n\n
<\/figure>\n\n\n\nFinish the Reconciliation<\/strong><\/h3>\n\n\n\n
If your clearing account does not reconcile<\/strong><\/h2>\n\n\n\n
\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n<\/ol>\n\n\n\nStep 1: Download required reports<\/strong><\/h3>\n\n\n\n
\n
<\/li>\n\n\n\nStep 2: Prepare your Excel data for comparison<\/strong><\/h3>\n\n\n\n
<\/figure>\n\n\n\n
<\/strong>Walmart report includes a lot of transaction details that you don’t need for comparison.
Copy values of Purchase Order #<\/strong> and Amount columns<\/strong> into a new sheet. This will be our Walmart clean report. <\/p>\n\n\n\n
<\/figure>\n\n\n\n
QuickBooks Online register report also has a lot of information that we don\u2019t need. Lines we should focus on are:<\/p>\n\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
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
\n\n
<\/strong><\/li>\n\n\n\n
<\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
<\/strong>Repeat the same consolidation steps for the Walmart report if the Walmart data also contains multiple lines per transaction.<\/p>\n\n\n\nStep 4: Organize your data<\/strong><\/h3>\n\n\n\n
2. In your Comparison Analysis<\/strong> sheet, create columns for:<\/p>\n\n\n\n\n
Copy and paste columns from your Clean Walmart report.<\/li>\n\n\n\n
Copy and paste columns from your Clean QuickBooks Online report.<\/li>\n\n\n\n<\/strong>Step 5: Compare data using VLOOKUP<\/strong><\/h3>\n\n\n\n
\n
\n\n
<\/li>\n<\/ul>\n<\/li>\n\n\n\n
\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/figure>\n\n\n\n
<\/p>\n\n\n\n
<\/figure>\n\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n<\/ul>\n\n\n\nStep 6: Address common discrepancies<\/strong><\/h3>\n\n\n\n
\n
\n
\n
\n
\n
\n
<\/li>\n<\/ol>\n\n\n\nLimitations<\/strong><\/h2>\n\n\n\n
\n
<\/li>\n\n\n\n
When to contact support<\/strong><\/h2>\n\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n<\/ul>\n\n\n\nBest practices for ongoing reconciliation<\/strong><\/h2>\n\n\n\n
\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n
<\/li>\n\n\n\n