{"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-03-17T15:33:49","modified_gmt":"2026-03-17T15:33:49","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":"Per-Transaction: Walmart USA Clearing Account Reconciliation Guide"},"content":{"rendered":"\n<ul class=\"wp-block-advgb-summary advgb-toc alignnone\">\n<li class=\"toc-level-1\"><a href=\"#main-reconciliation-flow-3ea4e3cd-5cea-4292-a4af-711d0558820b\">Main Reconciliation Flow<\/a><\/li>\n<li class=\"toc-level-1\"><a href=\"#if-your-clearing-account-does-not-reconcile-cdc2bbc6-a17b-4eca-8d21-bc4472e12aaa\">If your clearing account does not reconcile<\/a><\/li>\n<li class=\"toc-level-1\"><a href=\"#limitations-fe5acf14-0523-4863-bf08-9cfe37464e73\">Limitations<\/a><\/li>\n<li class=\"toc-level-1\"><a href=\"#when-to-contact-support-c6bc584d-35e3-4eb2-825a-7542a90f18a3\">When to contact support<\/a><\/li>\n<li class=\"toc-level-1\"><a href=\"#best-practices-for-ongoing-reconciliation-4348c21c-a120-4e4b-b6aa-d9a78978a83f\">Best practices for ongoing reconciliation<\/a><\/li>\n<\/ul>\n\n\n\n<p><strong>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<p>This guide explains how to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Record Walmart payouts manually<br><\/li>\n\n\n\n<li>Walmart clearing account reconciliation<br><\/li>\n\n\n\n<li>Investigate unreconciled data<br><\/li>\n<\/ul>\n\n\n\n<p>QuickBooks Online is used as an example. <strong>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<p>Use this guide if:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You use Walmart with Synder<br><\/li>\n\n\n\n<li>Your clearing account does not reconcile or zero out automatically<br><\/li>\n\n\n\n<li>You need to record payouts manually<br><\/li>\n\n\n\n<li>You need to verify that Walmart transactions and accounting records match<\/li>\n<\/ul>\n\n\n\n<p>After completing the steps, your <strong>Walmart 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-3ea4e3cd-5cea-4292-a4af-711d0558820b\"><strong>Walmart clearing account reconciliation flow<\/strong><\/h2>\n\n\n\n<p>Complete the steps below in order.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"record-payouts-manually-6d569d42-9d15-422c-a8f3-fa6ad321a3b7\"><strong>Record payouts manually<\/strong><\/h3>\n\n\n\n<p>Manual payout entries are required to clear the Walmart clearing account balance.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Log in to QuickBooks Online and go to <strong>Accounting<\/strong>.<br><\/li>\n\n\n\n<li>Select <strong>Bank transactions<\/strong>, then select the bank statements account that receives Walmart payouts.<br><\/li>\n\n\n\n<li>On the <strong>For review<\/strong> tab, select the deposit to categorize.<br><\/li>\n\n\n\n<li>Select <strong>Record as transfer<\/strong>.<br><\/li>\n\n\n\n<li>In <strong>Transferred to<\/strong>, select the <strong>Walmart<\/strong> clearing account (required for Synder).<br><\/li>\n\n\n\n<li>Select <strong>Add<\/strong>.<br><\/li>\n<\/ol>\n\n\n\n<p>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<p>When payouts are recorded and Synder data is synced, the clearing account balance should match the expected ending balance.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"486\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-1024x486.png\" alt=\"\" class=\"wp-image-25675\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-1024x486.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-300x142.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-768x364.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-1536x729.png 1536w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-1080x512.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-60x28.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-150x71.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Some accounting platforms support rules or other automation for posting payouts. <a href=\"https:\/\/synder.com\/help\/how-to-reconcile-integrations-without-payout-support-in-synder\/\">Use the guide for integrations without payout support to configure automation.<\/a><\/p>\n\n\n\n<p>When payouts are recorded and Synder data is synced, the clearing account balance should match the expected ending balance.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"finish-the-reconciliation-5a3a44fc-bc0f-407f-95b2-f8fecb3ff78f\"><strong>Finish the Reconciliation<\/strong><\/h3>\n\n\n\n<p>After a cycle closes, the Walmart and the QuickBooks Online clearing account balance <strong>will be zero.&nbsp;<\/strong><\/p>\n\n\n\n<p>Congratulations on reconciling your clearing!<\/p>\n\n\n\n<p><em>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><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"if-your-clearing-account-does-not-reconcile-cdc2bbc6-a17b-4eca-8d21-bc4472e12aaa\"><strong>If your clearing account does not reconcile<\/strong><\/h2>\n\n\n\n<p>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<ol class=\"wp-block-list\">\n<li>In Synder, filter transactions by status.<br><\/li>\n\n\n\n<li>On the <strong>Platform transactions<\/strong> page, confirm all transactions in the reconciliation period are in <strong>Synced<\/strong> or <strong>Skipped<\/strong> status. Any other status indicates the transaction is not in the books or requires review and will prevent reconciliation.<br><\/li>\n\n\n\n<li>Confirm you are comparing the correct totals (for example, sales totals may differ from cash totals).<br><\/li>\n\n\n\n<li>If the platform was disconnected during the reconciliation period, run <strong>Historical Import<\/strong> on the <strong>Platform transactions<\/strong> page to retrieve missing transactions.<br><\/li>\n<\/ol>\n\n\n\n<p>If balances still do not match, use <strong>Advanced comparison (Excel method)<\/strong> to identify specific discrepancies.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-1-download-required-reports-94b1ab2a-d387-4762-bbc6-16561cc78ebd\"><strong>Step 1: Download required reports<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Download the Walmart detailed report for the same reconciliation period used when recording payouts and fees.<br><\/li>\n\n\n\n<li>Generate a Walmart clearing account report from QuickBooks Online for the same reconciliation period.<\/li>\n<\/ol>\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 and how to find this sum.<\/em><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-2-prepare-your-excel-data-for-comparison-a9394725-b1e0-4300-a800-d6511b3ca565\"><strong>Step 2: Prepare your Excel data for comparison<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"623\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-33-1024x623.png\" alt=\"\" class=\"wp-image-25679\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-33-1024x623.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-33-300x182.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-33-768x467.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-33-1536x934.png 1536w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-33-1080x657.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-33-60x36.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-33-150x91.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-33.png 1600w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong><br><\/strong>Walmart report includes a lot of transaction details that you don&#8217;t need for comparison.<br>Copy values of <strong>Purchase Order #<\/strong> and <strong>Amount columns<\/strong> into a new sheet. This will be our Walmart clean report.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"553\" height=\"827\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-26.png\" alt=\"\" class=\"wp-image-25672\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-26.png 553w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-26-201x300.png 201w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-26-40x60.png 40w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-26-100x150.png 100w\" sizes=\"(max-width: 553px) 100vw, 553px\" \/><\/figure>\n\n\n\n<p><br>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<ul class=\"wp-block-list\">\n<li>Transaction ID<\/li>\n\n\n\n<li>Transaction Currency Amount<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"887\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-32.png\" alt=\"\" class=\"wp-image-25678\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-32.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-32-300x260.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-32-768x665.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-32-60x52.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-32-150x130.png 150w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-3-consolidate-multiple-lines-into-one-entry-per-transaction-493b57f2-835e-4400-ada2-a0394e15ae0c\"><strong>Step 3: Consolidate multiple lines into one entry per transaction<\/strong><\/h3>\n\n\n\n<p>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<ol class=\"wp-block-list\">\n<li>Select an empty cell in an empty row.<br><\/li>\n\n\n\n<li>Go to <strong>Data<\/strong> \u2192 <strong>Consolidate<\/strong>.<br><\/li>\n\n\n\n<li>In <strong>Reference<\/strong>, select both columns A and B (ID and amount columns).<br><\/li>\n\n\n\n<li>Select <strong>+<\/strong> to add the reference.<br><\/li>\n\n\n\n<li>In <strong>Use labels in<\/strong>, select both:<br>\n<ul class=\"wp-block-list\">\n<li><strong>Top row<\/strong><strong><br><\/strong><\/li>\n\n\n\n<li><strong>Left column<\/strong><strong><br><\/strong><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Select <strong>OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"728\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-28-1024x728.png\" alt=\"\" class=\"wp-image-25674\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-28-1024x728.png 1024w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-28-300x213.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-28-768x546.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-28-400x284.png 400w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-28-1080x767.png 1080w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-28-60x43.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-28-150x107.png 150w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-28.png 1171w\" sizes=\"(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. Here\u2019s how it should look:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"829\" height=\"682\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-31.png\" alt=\"\" class=\"wp-image-25677\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-31.png 829w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-31-300x247.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-31-768x632.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-31-60x49.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-31-150x123.png 150w\" sizes=\"(max-width: 829px) 100vw, 829px\" \/><\/figure>\n\n\n\n<p><strong><br><\/strong>Repeat the same consolidation steps for the Walmart report if the Walmart data also contains multiple lines per transaction.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-4-organize-your-data-b7c637d6-054d-456b-92ae-a6eb180a8151\"><strong>Step 4: Organize your data<\/strong><\/h3>\n\n\n\n<p>1. Create a new sheet for your Comparison Analysis.<br>2. In your <strong>Comparison Analysis<\/strong> sheet, create columns for:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Walmart Transaction ID.&nbsp;<\/li>\n\n\n\n<li>Walmart Amount<br>Copy and paste columns from your Clean Walmart report.<\/li>\n\n\n\n<li>QuickBooks Online Transaction ID<\/li>\n\n\n\n<li>QuickBooks Online Transaction Amount<br>Copy and paste columns from your Clean QuickBooks Online report.<\/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<h3 class=\"wp-block-heading\" id=\"step-5-compare-data-using-vlookup-adcff7dd-f1eb-4235-99a7-f47afb832a34\"><strong><\/strong><strong>Step 5: Compare data using VLOOKUP<\/strong><\/h3>\n\n\n\n<p>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<ol class=\"wp-block-list\">\n<li>In the <strong>Lookup<\/strong> column, use:<br>\n<ul class=\"wp-block-list\">\n<li>=VLOOKUP(A3,C:D,2,FALSE)<br><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Breaking down the formula:<br>\n<ul class=\"wp-block-list\">\n<li>A3 = Walmart transaction ID<br><\/li>\n\n\n\n<li>C:D = QuickBooks Online data range (ID in column C, amount in column D)<br><\/li>\n\n\n\n<li>2 = returns the amount from the second column in the range<br><\/li>\n\n\n\n<li>FALSE = exact match<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"981\" height=\"759\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-30.png\" alt=\"\" class=\"wp-image-25676\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-30.png 981w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-30-300x232.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-30-768x594.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-30-60x46.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-30-150x116.png 150w\" sizes=\"(max-width: 981px) 100vw, 981px\" \/><\/figure>\n\n\n\n<p>In the <strong>Difference<\/strong> column, subtract the looked-up QuickBooks Online amount from the Walmart amount.<br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"981\" height=\"759\" src=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-27.png\" alt=\"\" class=\"wp-image-25673\" srcset=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-27.png 981w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-27-300x232.png 300w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-27-768x594.png 768w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-27-60x46.png 60w, https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-27-150x116.png 150w\" sizes=\"(max-width: 981px) 100vw, 981px\" \/><\/figure>\n\n\n\n<p>2. Identify discrepancies. Perfect matches should show 0 in the difference column.<\/p>\n\n\n\n<p>Discrepancy indicators:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Negative value: QuickBooks Online amount is higher than the Walmart amount<br><\/li>\n\n\n\n<li>Positive value: Walmart amount is higher than the QuickBooks Online amount<br><\/li>\n\n\n\n<li>#N\/A: Transaction ID exists in Walmart but not in QuickBooks Online<br><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-6-address-common-discrepancies-12ebe836-008d-4950-86e1-9f88fb842dcf\"><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 Walmart 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 Walmart 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 Walmart connections in Synder.<\/li>\n\n\n\n<li>Review any manual clearing account adjustments.<br><br><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"limitations-fe5acf14-0523-4863-bf08-9cfe37464e73\"><strong>Limitations<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Walmart integration does not support payout syncing. Payouts must be recorded manually.<br><\/li>\n\n\n\n<li>Synder does not fetch fees and refunds for Walmart Canada. Import this information manually.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"when-to-contact-support-c6bc584d-35e3-4eb2-825a-7542a90f18a3\"><br><strong>When to contact support<\/strong><\/h2>\n\n\n\n<p>Contact support when you identify specific transactions causing reconciliation issues and cannot resolve them.<\/p>\n\n\n\n<p>Include the following in your request:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reconciliation period (start and end dates)<br><\/li>\n\n\n\n<li>Specific transaction IDs<br><\/li>\n\n\n\n<li>Screenshots of the transactions in Walmart and QuickBooks Online<br><\/li>\n\n\n\n<li>Summary of findings (for example, \u201c5 missing fulfillment fees totaling $47.50\u201d)<br><\/li>\n\n\n\n<li>Currency and marketplace details, if applicable<br><\/li>\n\n\n\n<li>Steps already completed<br><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"best-practices-for-ongoing-reconciliation-4348c21c-a120-4e4b-b6aa-d9a78978a83f\"><strong>Best practices for ongoing reconciliation<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Reconcile monthly.<br><\/li>\n\n\n\n<li>Monitor multiple currency clearing accounts when selling internationally.<br><\/li>\n\n\n\n<li>Review Synder alerts for failed sync transactions.<br><\/li>\n\n\n\n<li>Keep timezone settings consistent across Walmart, Synder, and reconciliation periods.<br><\/li>\n\n\n\n<li>Document manual entries made to clearing accounts.<br><\/li>\n\n\n\n<li>Review unsupported transaction types periodically.<\/li>\n<\/ul>\n\n\n\n<p>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><\/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>\n","protected":false},"excerpt":{"rendered":"<p>Main Reconciliation Flow If your clearing account does not reconcile Limitations When to contact support Best practices for ongoing reconciliation Walmart is a sales-only integration in Synder. Synder syncs sales, refunds, and processing fees from Walmart. Payouts are not synced automatically and must be recorded manually. This guide explains how to: QuickBooks Online is used [&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":""},"categories":[383,56],"tags":[],"ppma_author":[349],"class_list":["post-25671","post","type-post","status-publish","format-standard","hentry","category-reconcile-in-per-transaction-mode","category-reconciliation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Per-Transaction: Walmart USA Clearing Account Reconciliation Guide - Synder<\/title>\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\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Per-Transaction: Walmart USA Clearing Account Reconciliation Guide - Synder\" \/>\n<meta property=\"og:description\" content=\"Main Reconciliation Flow If your clearing account does not reconcile Limitations When to contact support Best practices for ongoing reconciliation Walmart is a sales-only integration in Synder. Synder syncs sales, refunds, and processing fees from Walmart. Payouts are not synced automatically and must be recorded manually. This guide explains how to: QuickBooks Online is used [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/\" \/>\n<meta property=\"og:site_name\" content=\"Synder\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-12T18:24:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-17T15:33:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-1024x486.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=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Per-Transaction: Walmart USA Clearing Account Reconciliation Guide - Synder","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\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/","og_locale":"en_US","og_type":"article","og_title":"Per-Transaction: Walmart USA Clearing Account Reconciliation Guide - Synder","og_description":"Main Reconciliation Flow If your clearing account does not reconcile Limitations When to contact support Best practices for ongoing reconciliation Walmart is a sales-only integration in Synder. Synder syncs sales, refunds, and processing fees from Walmart. Payouts are not synced automatically and must be recorded manually. This guide explains how to: QuickBooks Online is used [&hellip;]","og_url":"https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/","og_site_name":"Synder","article_published_time":"2026-02-12T18:24:22+00:00","article_modified_time":"2026-03-17T15:33:49+00:00","og_image":[{"url":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-1024x486.png"}],"author":"vili.varazi","twitter_card":"summary_large_image","twitter_misc":{"Written by":"vili.varazi","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/","url":"https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/","name":"Per-Transaction: Walmart USA Clearing Account Reconciliation Guide - Synder","isPartOf":{"@id":"https:\/\/synder.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/#primaryimage"},"image":{"@id":"https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/#primaryimage"},"thumbnailUrl":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29-1024x486.png","datePublished":"2026-02-12T18:24:22+00:00","dateModified":"2026-03-17T15:33:49+00:00","author":{"@id":"https:\/\/synder.com\/help\/#\/schema\/person\/5c93e62bed7fbd7e7cf5e39dc10e5fad"},"breadcrumb":{"@id":"https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/#primaryimage","url":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29.png","contentUrl":"https:\/\/synder.com\/help\/wp-content\/uploads\/sites\/2\/2026\/02\/image-29.png","width":1600,"height":759},{"@type":"BreadcrumbList","@id":"https:\/\/synder.com\/help\/walmart-clearing-account-reconciliation-guide-for-per-transaction-synder-users\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/synder.com\/help\/"},{"@type":"ListItem","position":2,"name":"Per-Transaction: Walmart USA Clearing Account Reconciliation Guide"}]},{"@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:\/\/synder.com\/help\/#\/schema\/person\/image\/cae83c3feb798615e936e036a7c725e0","url":"https:\/\/secure.gravatar.com\/avatar\/9af36cc631e0d1da5c7105bf5ef14141?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9af36cc631e0d1da5c7105bf5ef14141?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\/reconcile-in-per-transaction-mode\/\" class=\"advgb-post-tax-term\">Reconcile in Per Transaction Mode<\/a>","<a href=\"https:\/\/synder.com\/help\/category\/reconciliation\/\" class=\"advgb-post-tax-term\">Reconciliation<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Reconcile in Per Transaction Mode<\/span>","<span class=\"advgb-post-tax-term\">Reconciliation<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 2 months ago","modified":"Updated 3 weeks ago"},"absolute_dates":{"created":"Posted on February 12, 2026","modified":"Updated on March 17, 2026"},"absolute_dates_time":{"created":"Posted on February 12, 2026 6:24 pm","modified":"Updated on March 17, 2026 3:33 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\/9af36cc631e0d1da5c7105bf5ef14141?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\/25671"}],"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=25671"}],"version-history":[{"count":4,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/25671\/revisions"}],"predecessor-version":[{"id":26722,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/posts\/25671\/revisions\/26722"}],"wp:attachment":[{"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/media?parent=25671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/categories?post=25671"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/tags?post=25671"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/synder.com\/help\/wp-json\/wp\/v2\/ppma_author?post=25671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}