The process of matching transactions in your accounting records against your bank statement to ensure they agree. Catches errors, duplicates, and unauthorized charges.
Understanding Bank Reconciliation
Bank reconciliation is the process of comparing your internal accounting records against your bank statement to ensure every transaction is accounted for and the balances agree. Any discrepancies — missing transactions, duplicates, or incorrect amounts — are identified and corrected during this process.
The reconciliation process typically involves matching each transaction in your books to a corresponding entry on the bank statement, identifying deposits in transit (recorded in your books but not yet on the statement), outstanding checks, bank fees, and interest that may not yet be in your books.
Regular bank reconciliation — ideally monthly — is a fundamental internal control that catches errors, prevents fraud, and ensures your financial statements are accurate. For ecommerce sellers dealing with multiple payment processors, reconciliation is especially important because each platform has its own fee structure and settlement timing.
Why It Matters for Ecommerce
Ecommerce sellers receive deposits from Amazon, Shopify, Stripe, PayPal, and other platforms — each with different fee deductions and payout schedules. Without regular bank reconciliation, it's easy to miss fee discrepancies, duplicate imports, or lost transactions. Many sellers discover thousands of dollars in unreconciled differences at tax time.
Practical Example
Your books show $12,500 in deposits for January, but your bank statement shows $12,380. During reconciliation, you discover a $50 Stripe fee you forgot to record and a $70 Amazon reimbursement that arrived but wasn't entered. After recording both, the $120 gap is resolved and your books match the bank.
Related Terms
General Ledger
The master record of all financial transactions for a business, organized by account. Every journal entry flows into the general ledger, which is the basis for financial statements.
AccountingUndeposited Funds
A holding account in QuickBooks that temporarily stores received payments before they are grouped into a bank deposit. Prevents mismatches between individual payments and lump-sum bank deposits.
AccountingTrial Balance
A report listing all general ledger accounts and their debit or credit balances at a specific date. Used to verify that total debits equal total credits before preparing financial statements.
Related Tools
Free PrimeConnect tools related to bank reconciliation
Put This Knowledge Into Practice
Now that you understand bank reconciliation, use PrimeConnect's free accounting tools to convert your ecommerce data into QuickBooks-ready formats — 100% browser-based.
Browse Free Tools