Bank Reconciliation Best Practices: Process, Automation & Close
Master bank reconciliation with this complete guide. Learn the step-by-step process, automation strategies to reduce close time by 90%, common issues and solutions, month-end procedures, and compliance best practices.
In This Guide
What is Bank Reconciliation?
Bank reconciliation is the process of matching and verifying that your company's cash balance per the general ledger agrees with the cash balance per the bank statement, after accounting for timing differences and errors. It's a critical internal control that detects fraud, errors, and unauthorized transactions.
The reconciliation identifies three types of items: (1) Timing differences - transactions recorded in GL but not yet on bank statement (outstanding checks, deposits in transit); (2) Bank-side items - transactions on bank statement but not yet in GL (fees, interest, NSF checks); (3) Errors - mistakes made by company or bank requiring correction.
Why Bank Reconciliation Is Critical
Bank reconciliation is one of the most important accounting controls. It detects fraud (unauthorized withdrawals, forged checks), prevents errors (duplicate payments, miscoded transactions), ensures accurate financial statements (correct cash balance), and satisfies audit requirements. Companies that don't reconcile regularly are at high risk of fraud and financial misstatement.
The Reconciliation Formula
Starting from Book Balance (GL):
The 9-Step Bank Reconciliation Process
Follow this systematic process for accurate, complete reconciliations every period:
Obtain Bank Statement
Day 1 of closeDownload the official bank statement for the reconciliation period.
Details:
- Use PDF or electronic statement from bank portal
- Verify statement covers the full period (e.g., entire month)
- Note beginning balance, ending balance, and statement date
- Save statement in permanent accounting records
Compare Beginning Balance
Day 1 of closeVerify the bank statement beginning balance matches your prior period ending reconciled balance.
Details:
- Pull prior month's reconciliation ending balance
- Confirm it matches bank statement beginning balance
- Investigate any discrepancies before proceeding
- Document any adjustments needed
Match Cleared Transactions
Days 1-2 of closeIdentify transactions that appear in both your accounting records and the bank statement.
Details:
- Match deposits: GL cash receipts to bank deposits
- Match disbursements: GL cash payments to bank withdrawals
- Mark matched transactions as "cleared"
- Set aside unmatched items for investigation
Identify Outstanding Items
Day 2 of closeDocument transactions in your records that haven't cleared the bank yet.
Details:
- Outstanding checks: issued but not yet cashed
- Deposits in transit: sent but not yet posted by bank
- Electronic payments in process
- Wire transfers pending
Record Bank-Side Items
Day 2 of closeAdd transactions that appear on bank statement but not in your GL.
Details:
- Bank fees and service charges
- Interest income earned
- NSF (bounced) checks
- Bank errors (debits or credits)
Prepare Reconciliation
Day 3 of closeCreate the formal reconciliation tying book balance to bank balance.
Details:
- Start with GL cash balance (book balance)
- Add: Deposits in transit
- Subtract: Outstanding checks
- Add/subtract: Bank statement adjustments
- Result should equal bank statement ending balance
Investigate Reconciling Items
Days 3-4 of closeResearch and resolve any discrepancies or unusual items.
Details:
- Research unidentified bank transactions
- Follow up on old outstanding checks (>90 days)
- Verify deposits in transit clear within 1-2 business days
- Document explanations for all reconciling items
Book Journal Entries
Day 4 of closeRecord necessary adjustments to correct the GL cash balance.
Details:
- Bank fees and charges → Expense
- Interest income → Other income
- NSF checks → Reverse original deposit, charge customer
- Bank errors → Investigate and record correctly
Review and Approve
Day 5 of closeFinal review by senior accountant or controller before finalizing.
Details:
- Verify reconciliation balances (book balance + adjustments = bank balance)
- Review reasonableness of outstanding items
- Ensure all reconciling items are documented
- Obtain management sign-off
Timing: Complete Reconciliation in 5 Days or Less
Best-in-class organizations complete bank reconciliation within 5 business days of month-end. With automation, many complete it in 1-2 days. Delays in reconciliation increase the risk of undetected errors and fraud, and slow down financial close. Establish strict deadlines and accountability for timely completion.
Common Issues & Solutions
Here are the most common bank reconciliation issues and how to resolve them:
Stale Outstanding Checks
Checks issued months ago that haven't been cashed
Impact:
Overstated outstanding checks inflate reconciled cash balance
Solution:
- Identify outstanding checks >90 days old
- Contact payees to reissue or void
- Void unclaimed checks after statutory period (typically 6-12 months)
- Reclassify to unclaimed property liability if required by state law
Deposits in Transit Not Clearing
Deposits that should have cleared but didn't appear on bank statement
Impact:
May indicate recording error, deposit never made, or bank processing delay
Solution:
- Verify deposit was actually submitted to bank (check deposit receipts)
- Contact bank if deposit was made but not posted
- If deposit wasn't made, reverse entry and investigate
- Deposits should clear within 1-2 business days; longer gaps indicate problems
Duplicate Transactions
Same transaction recorded multiple times in GL or bank
Impact:
Misstates cash balance and creates reconciling differences
Solution:
- Implement controls to prevent duplicate entry (unique transaction IDs)
- Review transaction details carefully during matching
- Reverse duplicate GL entries if found
- Contact bank to reverse duplicate bank transactions (rare)
Timing Differences on Electronic Payments
ACH, wire, or credit card payments processed on different dates
Impact:
Creates temporary reconciling items that should clear next period
Solution:
- Understand typical timing for each payment method (ACH = 1-2 days, wire = same day)
- Record transactions on bank processing date, not initiation date
- Implement cut-off procedures for period-end transactions
- Track electronic payments in transit as reconciling items
Unidentified Bank Transactions
Transactions on bank statement with unclear purpose or origin
Impact:
Cannot reconcile until identified; may indicate fraud or errors
Solution:
- Contact bank for transaction details and supporting documentation
- Review transaction description, amount, date for clues
- Check with team members who may have initiated transaction
- If fraudulent, report immediately and file dispute with bank
Bank Errors
Bank incorrectly posts deposit, withdrawal, or fee
Impact:
Causes reconciling difference that won't resolve on its own
Solution:
- Document the error with supporting evidence (your records vs. bank statement)
- Contact bank to report and request correction
- Follow up until bank posts correcting entry
- Track as reconciling item until bank resolves
Automation Strategies: Reduce Reconciliation Time by 90%
Manual bank reconciliation in Excel is time-consuming and error-prone. Modern automation reduces reconciliation time from hours to minutes while improving accuracy:
Bank Feed Integration
Automatically import bank transactions into your accounting system daily
Benefits:
How to Implement:
Connect accounting system to bank via secure API or file feed. Transactions import daily and are auto-categorized based on rules.
AI-Powered Transaction Matching
Machine learning automatically matches bank transactions to GL entries
Benefits:
How to Implement:
AI compares amounts, dates, vendor names, and reference numbers to find matches. Suggests matches with confidence scores; accountant approves or adjusts.
Rule-Based Auto-Categorization
Define rules to automatically categorize and code bank transactions
Benefits:
How to Implement:
Create rules: "If vendor = AWS AND amount > $1K → Cloud Infrastructure Expense". System applies rules as transactions import.
Three-Way Matching for Payables
Automatically match bank payments to invoices and purchase orders
Benefits:
How to Implement:
System compares bank withdrawal to AP payment entry to vendor invoice. Flags mismatches for investigation before payment.
Variance Alerts and Exception Management
Automated alerts for reconciling items requiring attention
Benefits:
How to Implement:
Set thresholds (e.g., "Alert if outstanding check > $5K and > 60 days old"). System sends notifications for review.
Real Results: Automation Impact
Month-End Reconciliation Checklist
Use this checklist to ensure complete and accurate bank reconciliations every month:
Pre-Reconciliation Setup (Day 0-1)
Reconciliation Execution (Days 1-3)
Exception Investigation (Days 2-4)
GL Adjustments & Finalization (Days 4-5)
Internal Controls & Fraud Prevention
Bank reconciliation is a detective control (finds issues after they happen). Layer it with preventive controls to stop fraud before it occurs:
Separation of Duties
Different people should: (1) authorize payments, (2) enter transactions in GL, (3) have bank access to initiate transactions, and (4) perform reconciliation. Never allow one person to control all aspects of the cash cycle.
Positive Pay for Checks
Upload a file of issued checks (check number, amount, payee) to your bank daily. Bank only honors checks that match the file, preventing forged or altered checks from clearing.
ACH Debit Blocks and Filters
Set up ACH debit blocks to prevent unauthorized electronic withdrawals. Use ACH filters to only allow debits from approved company IDs. This prevents fraudulent ACH debits from draining your account.
Dual Approval for Large Payments
Require two signatures or approvals for payments above a threshold (e.g., $10K). Implement approval workflows in your payment system. This prevents one person from initiating fraudulent large payments.
Daily Monitoring and Alerts
Review bank activity daily, not just monthly. Set up alerts for transactions above thresholds, unusual activity, or low balances. Early detection limits fraud losses and enables faster recovery.
Independent Review of Bank Statements
Have someone outside the accounting department (CFO, controller, board member) review unopened bank statements monthly. This provides oversight and can catch fraud perpetrated by accounting staff.
Red Flags: Signs of Potential Fraud
Watch for these warning signs during reconciliation:
- • Unusual or unexplained bank transactions
- • Consistent reconciling items that never resolve
- • Missing or altered bank statements
- • Reconciliation performed only by one person with no oversight
- • Significant or frequent adjusting entries to cash
- • Employee reluctant to take vacation or share duties
Frequently Asked Questions
How often should we perform bank reconciliations?
Best practice is to reconcile all bank accounts monthly at minimum, ideally within 5 business days of month-end. Many organizations with good controls reconcile weekly or even daily using automated tools. Daily reconciliation enables you to catch fraud, errors, and unauthorized transactions immediately rather than discovering them 30+ days later. For high-volume accounts (operating accounts with hundreds of transactions monthly), daily reconciliation is strongly recommended. For low-volume accounts (savings accounts, escrow accounts), monthly is typically sufficient. Quarterly reconciliation is inadequate for controls and compliance purposes.
What should we do with old outstanding checks that never get cashed?
Outstanding checks that remain uncleared for 6-12 months (depending on your state) should be voided and potentially reclassified as unclaimed property. First, contact the payee to determine if they still have the check and intend to cash it. If yes, ask them to cash it promptly or offer to reissue. If no response or check is lost, void the original check in your system and reissue if appropriate. After the statutory period (varies by state, typically 1-3 years), unclaimed checks must be reported and remitted to the state as unclaimed property under escheatment laws. Don't just leave old outstanding checks on your reconciliation indefinitely—this overstates your cash position and violates unclaimed property laws.
How can we prevent and detect bank fraud?
Implement these controls to prevent and detect bank fraud: (1) Separation of duties - different people should authorize payments, enter transactions, and reconcile accounts; (2) Positive pay - send your bank a list of checks issued; bank only honors checks on the list; (3) Dual signatures or approval workflows for payments above threshold amounts; (4) ACH debit blocks and filters to prevent unauthorized electronic withdrawals; (5) Daily bank reconciliation or monitoring to catch fraudulent transactions immediately; (6) Regular review of bank statements by someone outside the accounting team; (7) Segregation of banking access - limit who can view account numbers and initiate transactions. Many fraud schemes succeed because the same person handles multiple functions and can cover their tracks. Strong controls and daily monitoring are your best defenses.
What's the difference between a bank reconciliation and a cash reconciliation?
Bank reconciliation ties your GL cash account balance to a specific bank statement ending balance, accounting for timing differences (outstanding checks, deposits in transit) and bank-side items (fees, interest). Cash reconciliation is broader and includes reconciling all cash accounts (multiple bank accounts, petty cash, undeposited funds) to the total cash balance on your balance sheet. A comprehensive cash reconciliation includes: (1) Reconciling each individual bank account to its statement; (2) Reconciling credit card merchant processor to deposits in bank; (3) Reconciling petty cash count to GL balance; (4) Reconciling payment processor (Stripe, PayPal) to bank deposits; (5) Ensuring the sum of all reconciled cash accounts equals the Cash line on your balance sheet. Most companies perform bank reconciliation monthly, but may do comprehensive cash reconciliation quarterly or annually.
Automate Your Bank Reconciliation
See how Era automates bank feeds, transaction matching, and reconciliation to reduce close time by 90% and eliminate manual errors.