What is Bank Reconciliation?
Bank reconciliation is the process of matching balances and transactions in a company’s accounting records against bank statements and other financial account records. In accounting and bookkeeping, it confirms that recorded cash, deposits, withdrawals, fees, refunds, and transfers agree with what actually happened in the bank or payment account.
For merchants, reconciliation is especially important because money may pass through card processors, marketplaces, wallets, gateways, banks, and settlement accounts before reaching the operating account. Timing differences, processing fees, chargebacks, refunds, currency conversion, rolling reserves, and payout delays can all create gaps between sales reports and bank balances.
Practitioners use bank reconciliation to detect missing transactions, duplicate entries, unauthorized payments, posting errors, and unsettled amounts. A disciplined reconciliation process supports reliable cash management, accurate financial statements, cleaner month-end close, and better confidence in payment and accounting data. When reconciliation is weak, businesses may overstate revenue, understate fees, overlook fraud, or make decisions based on cash balances that are not fully explained.
Bank Reconciliation Scenario for Merchant Payouts
An online merchant receives daily card processor payouts, weekly marketplace settlements, refunds, chargebacks, reserve releases, supplier payments, and bank fees. The bank balance looks correct, but accounting records show a different cash position because some payouts are net of fees and several refunds were recorded twice. Bank reconciliation identifies timing differences, missing entries, duplicate transactions, and processor deductions before management relies on the cash balance for tax, payroll, or supplier payment decisions.
How Bank Reconciliation Is Performed in Practice
- Collect the bank statement, accounting ledger, payment processor reports, marketplace settlement reports, card statements, and any loan or reserve account activity for the period.
- Compare bank transactions against recorded ledger entries, matching deposits, withdrawals, fees, transfers, refunds, chargebacks, payroll payments, and supplier payments.
- Separate true errors from timing differences, such as outstanding checks, pending card settlements, deposits in transit, processor reserves, or transactions posted just after period end.
- Investigate unmatched items, duplicate entries, missing invoices, incorrectly categorized transfers, and unexplained bank charges before closing the period.
- Post correcting entries where appropriate and document the reason for each adjustment, especially for processor fees, refund deductions, chargeback losses, and bank charges.
- Review the reconciled balance with the bookkeeper, accountant, or finance lead and retain reconciliation reports as evidence for audit, tax, and internal control purposes.
Common Bank Reconciliation Mistakes
- Reconciling only the main bank account while ignoring payment processor clearing accounts, marketplace balances, credit cards, PayPal, or reserve accounts.
- Accepting auto-matched transactions without reviewing whether deposits were split correctly between sales, fees, refunds, taxes, and chargebacks.
- Leaving old unreconciled items in suspense accounts, which can hide missing deposits, duplicated expenses, or unrecorded liabilities.
- Confusing transfers between company accounts with revenue or expenses, leading to overstated income or costs.
- Failing to investigate small recurring bank fees or processor deductions that can materially affect margin over time.
- Closing the month before reconciliation is complete, which makes cash reports and financial statements unreliable.
Practical Tips for Reliable Bank Reconciliation
- Reconcile all cash, card, processor, marketplace, and clearing accounts on a fixed schedule, not only before tax filing.
- Use processor settlement reports to break net deposits into gross sales, fees, refunds, chargebacks, reserves, and taxes where applicable.
- Investigate aged unreconciled items quickly while bank descriptions, emails, invoices, and business context are still available.
- Set approval rules for manual journal entries affecting cash, processor clearing, refunds, or owner withdrawals.
- Use consistent naming for transfers between accounts so they are not treated as revenue or expense.
- Review reconciliation exceptions with someone independent of daily payment entry where the business has enough staff for segregation of duties.
Tools Used for Bank Reconciliation
- Accounting platforms such as QuickBooks Online, Xero, NetSuite, Sage Intacct, or Zoho Books with bank feed and reconciliation modules.
- Bank statements, card statements, and CSV exports from business bank accounts and credit cards.
- Payment processor and marketplace reports from systems such as Stripe, PayPal, Shopify Payments, Amazon, Adyen, Square, or WooCommerce integrations.
- Reconciliation checklists, exception logs, clearing account schedules, and month-end close workpapers.
- Approval workflows for correcting entries, write-offs, refunds, chargebacks, and unusual bank transactions.
Metrics for Monitoring Bank Reconciliation Quality
- Number and value of unreconciled transactions at period end.
- Age of unreconciled items, especially items older than one close cycle.
- Difference between bank statement balance and ledger cash balance before reconciliation.
- Number of duplicate, missing, or manually corrected transactions discovered during reconciliation.
- Processor payout variance between expected settlement reports and actual bank deposits.
- Reconciliation completion time after month-end, which indicates whether cash reporting is timely enough for management decisions.
Compliance and Control Considerations for Bank Reconciliation
Bank reconciliation supports accurate financial reporting, tax records, fraud detection, and internal controls. Requirements depend on the jurisdiction, accounting framework, company size, lender covenants, audit status, and industry. Businesses should retain reconciliation evidence, bank statements, processor reports, and explanations for correcting entries. Where possible, the person approving payments should not be the only person reconciling bank activity, especially in businesses with high transaction volume or cash leakage risk.
FAQ
What is bank reconciliation?
Bank reconciliation is the process of comparing the cash balance in a company’s accounting records with the balance and transactions shown on bank statements. In accounting and bookkeeping, it helps confirm that deposits, card processor payouts, refunds, fees, payroll, vendor payments, bank charges, and transfers have been recorded correctly. For online merchants, reconciliation should also connect bank activity to payment gateway reports, settlement batches, chargebacks, and accounting software entries, not only to the headline bank balance.
Why does bank reconciliation matter for small businesses and online merchants?
Bank reconciliation matters because the bank balance alone rarely tells the full financial story. Card settlements may arrive net of processing fees, refunds can reduce deposits days after the original sale, and chargebacks or failed payments may appear later than the customer transaction. Regular reconciliation gives owners and finance teams better cash visibility, cleaner bookkeeping, fewer month-end surprises, and stronger evidence for tax filing, audits, lending requests, and management reporting.
How does bank reconciliation work in practice?
In practice, the finance team imports or reviews bank transactions, matches each item to invoices, receipts, payment processor reports, payroll records, vendor bills, transfers, or journal entries, and then investigates unmatched differences. Common reconciling items include timing differences, bank fees, duplicate entries, missing receipts, processor reserves, foreign exchange differences, refunds, and chargebacks. The process normally ends with a reviewed reconciliation report showing the accounting balance, bank statement balance, outstanding items, explanations, and approval.
What is a practical example of bank reconciliation for an ecommerce business?
An ecommerce store may show 500 successful card orders in its platform, but the bank receives fewer settlement deposits because the payment processor deducted fees, held a rolling reserve, netted refunds, and removed chargeback amounts. Bank reconciliation ties the ecommerce order report, payment processor settlement file, refund log, chargeback record, and bank deposit to the general ledger. Without this step, revenue, fees, cash, and receivables can all be misstated even when the bank account appears to have money in it.
What common mistakes should businesses avoid in bank reconciliation?
Common mistakes include reconciling only once a year, treating payment processor deposits as gross revenue, ignoring fees and refunds, failing to separate owner withdrawals from business expenses, and leaving unmatched transactions unexplained. Another frequent issue is relying on automated bank feeds without reviewing whether the coding is correct. Good bookkeeping requires source documents, clear account mapping, investigation of differences, and a documented sign-off, especially where multiple currencies, gateways, or bank accounts are involved.
How often should a business perform bank reconciliation?
A small business should usually reconcile bank accounts at least monthly, aligned with the month-end close. High-volume merchants, companies with many refunds or chargebacks, and businesses using multiple payment providers may need weekly or even daily settlement reconciliation for key accounts. The right frequency depends on transaction volume, cash risk, reporting deadlines, and how quickly management needs reliable cash information. The goal is not only to find errors, but to keep financial statements and cash decisions current.
How can businesses improve bank reconciliation over time?
Businesses can improve bank reconciliation by using a consistent chart of accounts, connecting bank feeds carefully, importing payment processor settlement reports, documenting reconciliation rules, and assigning review responsibility. Useful metrics include unreconciled items, age of reconciling differences, close time, number of manual adjustments, and recurring error types. As the business grows, accounting software, approval workflows, settlement automation, and monthly review checklists help make reconciliation more reliable and less dependent on one person’s memory.