Bank reconciliation is one of the most critical yet often overlooked accounting processes for online sellers. It's the procedure of comparing your accounting records with your bank statement to ensure they match and that all transactions are accurately recorded. For sellers managing multiple bank accounts, payment processors like PayPal, and various marketplace payment systems (Amazon, Shopify, Etsy, eBay, Walmart), regular bank reconciliation is absolutely essential.
What is Bank Reconciliation?
Bank reconciliation is the process of verifying that your company's accounting records accurately reflect the transactions shown on your bank statement. Despite careful record-keeping, discrepancies between your books and the bank statement are common. These differences are usually temporary—due to timing issues—but some may indicate errors or fraudulent activity that needs investigation.
The goal of bank reconciliation is to identify and explain every difference between your accounting records and your bank statement, ultimately confirming that both show the same ending cash balance.
Why Bank Reconciliation Matters
- Accuracy = Ensures your financial records are correct and reliable
- Fraud Detection = Catches unauthorized transactions or errors immediately
- Tax Compliance = Provides accurate cash position for tax reporting
- Business Decisions = Gives you true cash available for operations and growth
- Audit Trail = Creates documentation for audits and reviews
The 5-Step Bank Reconciliation Process
Follow these five essential steps to properly reconcile your bank account each month:
Step 1: Gather Your Bank Statement and Accounting Records
Start by collecting your official bank statement for the period you're reconciling (usually one month) and your accounting records for the same period. Your accounting records might include:
- Your general ledger cash account
- Accounting software reports (QuickBooks, Xero, Wave, etc.)
- Check register or transaction history
- Deposit records and receipts
- Credit card statements (if reconciling credit cards)
Ensure both documents cover the same time period and that your bank statement is complete and official from your financial institution.
Step 2: Compare Your Ending Balances
Write down the ending balance from your bank statement and the ending balance from your accounting records. Note that these likely won't match initially—that's normal. Your goal is to identify and explain every difference.
| Bank Statement | Your Records |
|---|---|
| Shows transactions that have cleared the bank | Shows all transactions you've recorded, cleared or not |
| Includes bank fees and interest | May not include bank fees if not yet recorded |
| May include NSF checks or reversals | May show checks you haven't yet learned failed |
| Reflects actual cleared transactions only | Reflects timing of when you recorded transactions |
Step 3: Identify Discrepancies and Outstanding Transactions
Go through both the bank statement and your accounting records line by line. Match each transaction and note any differences. Common discrepancies include:
Outstanding Checks
Checks you've written and recorded in your books but haven't yet cleared the bank. These are normal and temporary.
Deposits in Transit
Deposits you've recorded and sent to the bank but that haven't yet appeared on the bank statement. This is common for deposits made near the end of the month.
Bank Fees and Interest
Monthly maintenance fees, overdraft fees, wire transfer fees, or interest earned on the account. These appear on the bank statement but might not be in your accounting records yet.
Timing Differences
Differences in when transactions are recorded between your system and the bank system, particularly with electronic transfers.
Errors
Recording mistakes in either your books or bank statement (though bank errors are rare). These must be corrected immediately.
Step 4: Record Missing Transactions and Make Adjustments
For any items that should be in your accounting records but aren't, record them now:
- Bank fees - Record as an expense
- Interest earned - Record as income
- Automatic payments - Record if not yet recorded
- NSF checks - Reverse the original deposit if applicable
- Service charges - Record as an expense
For outstanding checks and deposits in transit, note them but don't record them again—they'll clear the bank in the future.
Step 5: Verify Balances Match
After recording all necessary adjustments, recalculate both balances:
Bank Statement Balance + Deposits in Transit - Outstanding Checks = Adjusted Bank Balance
Your Accounting Records + Bank Fees (recorded) - Any Errors = Adjusted Book Balance
If the adjusted balances now match, congratulations—your bank reconciliation is complete! If they don't match, go back and check for:
- Transposed numbers (e.g., recording $150 instead of $105)
- Duplicate transactions
- Forgotten deposits or checks
- Arithmetic errors
Timing Matters
Most discrepancies are timing issues—outstanding checks and deposits in transit that will reconcile naturally
Investigate Thoroughly
Any unexplained differences need investigation to catch fraud, errors, or accounting mistakes early
Document Everything
Keep detailed records of your reconciliation process, adjustments, and any items that didn't match
Common Bank Reconciliation Mistakes
Avoid these frequent errors that can throw off your reconciliation:
- Reconciling to the wrong date - Always use the bank statement's end date
- Forgetting to record bank fees - These should be recorded as expenses
- Including deposits twice - Don't re-record deposits in transit when they clear
- Arithmetic errors - Always double-check your calculations
- Ignoring suspicious transactions - Investigate immediately if something doesn't look right
- Not tracking outstanding checks - Keep a list and remove them when they clear
- Skipping months - Reconcile every month without fail for accurate records
How Often Should You Reconcile?
The answer is simple: monthly. Most businesses should reconcile their bank accounts at least once per month, ideally within a few days of receiving the bank statement. Here's why:
- Catches fraud or errors quickly before they compound
- Keeps your accounting records accurate for decision-making
- Simplifies tax preparation at year-end
- Identifies cash flow issues early
- Meets audit and compliance requirements
For high-volume sellers, consider reconciling weekly or even daily to maintain tighter control over your cash and catch issues immediately.
Tools and Software for Bank Reconciliation
Modern accounting software makes reconciliation much easier. Many tools now offer automatic bank reconciliation features that match transactions for you:
- QuickBooks Online - Automatic matching and reconciliation features
- Xero - Smart bank feed matching and reconciliation tools
- Wave - Free accounting software with basic reconciliation features
- FreshBooks - Cloud-based with automatic transaction matching
Many of these integrate directly with your bank, automatically importing transactions and reducing manual entry and errors. Download our Cash Flow Template for tracking and reconciliation management.
Bank Reconciliation: Key Facts
Recommended frequency for reconciling bank accounts for accuracy
The complete process from gathering documents to verifying matching balances
Time limit for banks to report and resolve errors on statements
Of discrepancies are timing issues, not fraud or errors
Frequently Asked Questions About Bank Reconciliation
Go back and check for: transposed numbers, duplicate transactions, missed transactions, arithmetic errors, or bank errors. Start with small differences and work your way up. Most discrepancies under $100 are often simple recording errors. Contact your bank immediately if you find amounts that don't match or suspicious transactions.
Keep bank reconciliation statements for at least 7 years for tax purposes. Many businesses keep them indefinitely. These documents are crucial for audits, tax disputes, and fraud investigations. Store them securely, either physically or digitally.
Outstanding checks are checks you've written and recorded in your books that haven't yet cleared the bank. Deposits in transit are deposits you've made and recorded that haven't yet appeared on the bank statement. Both are normal and temporary—they'll reconcile once they clear.
Yes, absolutely. Each bank account should be reconciled separately. If you have accounts at different banks or use payment processors like PayPal or Stripe, reconcile each one independently. This gives you accurate cash position across all accounts.
Contact your bank immediately and report the error. Banks have 60 days from the statement date to investigate and resolve errors. Provide documentation of the discrepancy and request a written explanation. Follow up in writing to create an audit trail. Most banks can resolve simple errors within a few business days.
When you receive an NSF check (check that bounced), the bank returns it unpaid and deducts a fee from your account. You must reverse the original deposit in your accounting records and record the NSF fee as an expense. Follow up with the customer to resolve payment.
Conclusion: Make Bank Reconciliation Your Monthly Habit
Bank reconciliation might seem tedious, but it's one of the most important financial tasks you can do. It ensures your accounting records are accurate, catches fraud or errors immediately, and gives you confidence in your cash position. By following these five simple steps monthly, you'll maintain tight control over your finances and have the accurate information you need to run your ecommerce business successfully.
Start making bank reconciliation part of your monthly accounting routine this month. Your future self—and your tax accountant—will thank you.
Action Items
- Schedule a monthly bank reconciliation on a calendar reminder
- Gather your bank statement and accounting records for this month
- Follow the 5-step process to reconcile your account
- Record any bank fees or interest earned in your accounting system
- Keep detailed documentation of your reconciliation process
- Review our Cash Flow Template for tracking transactions
- Contact your bank immediately if you find unexplained discrepancies