Bank reconciliation is the routine check that your books and your bank agree. For an ecommerce seller it is also where you catch the silent errors that marketplace payouts hide.
Bank reconciliation is the process of comparing the transactions and balance recorded in your accounting records against the transactions and balance reported by your bank, then resolving any differences so the two agree.
When they match, you have evidence your books are complete and accurate for that account. When they do not, the gap points to something missing or wrong: an unrecorded fee, a duplicated entry, a transaction in transit, or an error. Reconciliation is the control that keeps small mistakes from compounding into untrustworthy financial statements.
A reconciliation lines up three things as of a statement date.
Differences usually fall into a few categories: transactions recorded in your books but not yet cleared by the bank, transactions on the bank statement not yet recorded in your books, and outright errors on either side. You work through each until the adjusted balances match.
A clean reconciliation at month-end is the foundation everything else stands on. You cannot trust a P&L drawn from accounts that have never been reconciled.
For a simple business, reconciliation is mechanical. For an ecommerce seller, the bank deposits themselves are the complication.
The deposit from Amazon is not a sale. It is a net figure: gross sales, minus referral fees, minus FBA fees, minus advertising, minus refunds, minus any reserve withheld for that cycle. A single bank line of "$61,240 from Amazon" can represent dozens of transactions and several expense categories compressed into one number.
| WHAT THE BANK SHOWS | WHAT IT ACTUALLY CONTAINS |
| One net deposit | Gross sales for the period |
| Minus referral and fulfillment fees | |
| Minus advertising | |
| Minus refunds | |
| Minus reserve withheld |
If you reconcile by booking that single deposit as one lump of revenue, your bank will technically "match," but your books are wrong: revenue is understated, fees are invisible, and margin is unknowable. True reconciliation for an ecommerce seller means tying the deposit back to the settlement report and recording each component in the right account, not just confirming the number landed.
There are really two layers for a seller. Bank reconciliation confirms your recorded cash matches the bank. Settlement reconciliation confirms that each marketplace deposit decomposes correctly into sales, fees, refunds, and reserves. You need both. The bank reconciliation alone will pass even when the settlement detail behind a deposit was never recorded, which is exactly how sellers end up with reconciled accounts and meaningless margins.
Reconciliation is the difference between books you can act on and books you hope are right. For an ecommerce seller, the hard part is decomposing the net deposit, and doing it by hand across five channels every month is where errors creep in.
ConnectBooks handles the settlement layer automatically. It syncs Amazon, Shopify, Walmart, eBay, and TikTok Shop deposits into QuickBooks Online, QuickBooks Desktop, or Xero, breaks each one into sales, fees, refunds, and reserves, applies FIFO COGS per unit, and reconciles the marketplace clearing balance to the live platform balance. The net deposit ties to the bank and the detail ties to the settlement report. Plans start at $149/mo. For where reconciliation fits in the close, see /blog-posts/year-end-accounting-checklist-ecommerce.
| NEXT STEPReconcile the bank and the settlement behind it, automatically. ConnectBooks decomposes every marketplace deposit, starting at $149/mo. See /pricing. |
It is the process of comparing the cash transactions and ending balance in your accounting records against your bank statement, then resolving any differences so the two agree. A clean reconciliation is evidence your books are complete and accurate for that account, and it is the control that catches missing entries, duplicates, and errors before they distort your financial statements.
Because marketplace deposits are net figures, not sales. A single Amazon deposit bundles gross sales, fees, advertising, refunds, and any reserve into one number. If you reconcile by booking that lump as revenue, the bank will match but your books will be wrong. Real reconciliation ties the deposit back to the settlement report and records each component separately.
Bank reconciliation confirms your recorded cash matches the bank. Settlement reconciliation confirms each marketplace deposit decomposes correctly into sales, fees, refunds, and reserves. You need both, because a bank reconciliation can pass even when the settlement detail behind a deposit was never recorded, leaving you with reconciled accounts but inaccurate margin.
At least monthly, aligned to your statement period, and ideally as part of a regular close. Frequent reconciliation keeps errors small and easy to trace. Letting accounts go unreconciled for months means any discrepancy is buried in a large pile of transactions and far harder to resolve.
Common causes are transactions recorded in your books but not yet cleared by the bank, bank items like fees or interest not yet recorded in your books, duplicated entries, and outright errors. For ecommerce sellers, the most common hidden cause is a marketplace deposit booked as a single lump rather than decomposed into its underlying sales, fees, refunds, and reserves.
Clean, accurate books make this manageable. Start a free trial of ConnectBooks to get settlement-level accuracy and real margin visibility for your ecommerce business. No credit card required.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
