Account Reconciliation: The Foundation of Accurate Books

Account reconciliation is tedious but essential. It's how you know the numbers are real. A balance sheet with unreconciled accounts is just a collection of numbers—you have no idea if they reflect reality.

The discipline of reconciling every balance sheet account monthly catches errors, prevents fraud, and builds confidence that your financial statements can be trusted.

What Account Reconciliation Accomplishes

Verifies Accuracy

• Catches errors: Posting mistakes, missed transactions, wrong amounts
• Identifies cut-off issues: Transactions in wrong period
• Validates balances: Confirms what the GL says matches supporting detail

Supports Financial Statements

• Audit readiness: Reconciliations are primary audit support
• Confident reporting: Can defend every balance sheet number
• Historical record: Documentation of how balances were derived

Serves as Internal Control

• Fraud detection: Unusual items surface during reconciliation
• Error prevention: Regular review catches mistakes early
• Accountability: Clear ownership of account accuracy

Key Accounts to Reconcile

Cash Accounts

• What to reconcile to: Bank statements
• Frequency: Weekly or at minimum monthly
• Common issues: Outstanding checks, deposits in transit, bank fees

Accounts Receivable

• What to reconcile to: AR sub-ledger detail (customer balances)
• Frequency: Monthly
• Common issues: Unapplied payments, credit balances, old items

Accounts Payable

• What to reconcile to: AP sub-ledger detail (vendor balances)
• Frequency: Monthly
• Common issues: Duplicate invoices, missing invoices, debit balances

Payroll Liabilities

• What to reconcile to: Payroll reports, tax filings, benefit statements
• Frequency: Monthly
• Common issues: Timing differences, un-remitted taxes, benefit accruals

Prepaids and Accrued Expenses

• What to reconcile to: Schedules showing what's prepaid/accrued
• Frequency: Monthly
• Common issues: Missed amortization, incorrect accrual amounts

Fixed Assets

• What to reconcile to: Fixed asset sub-ledger or schedule
• Frequency: Monthly or quarterly
• Common issues: Missing additions/disposals, depreciation errors

Debt

• What to reconcile to: Loan statements, amortization schedules
• Frequency: Monthly
• Common issues: Principal vs. interest allocation, accrued interest

Standard Reconciliation Format

Reconciliation Components

• Account name and number: Which account is being reconciled
• Period: Month/year being reconciled
• GL balance: Balance per general ledger
• Supporting balance: Balance per sub-ledger, statement, schedule
• Reconciling items: Items explaining any difference
• Conclusion: Confirmation that account is reconciled
• Preparer/reviewer: Who prepared and reviewed, with dates

Sample Format

Materiality Thresholds

What is Materiality?

Materiality is the amount at which an error or omission would influence decisions. Not every difference needs to be chased down—focus on amounts that matter.

Setting Thresholds

• Account-level threshold: Often 1-5% of account balance
• Overall threshold: Often 0.5-1% of revenue or 5% of net income
• Practical minimum: Set a floor (e.g., $500) below which you don't investigate

Using Thresholds

• Below threshold: Document the difference, but no need to resolve if immaterial
• Above threshold: Must investigate and resolve or record adjustment
• Cumulative effect: Watch for many small items that add up

Reconciliation Schedule and Process

Scheduling

• Build into close calendar: Specific days for specific reconciliations
• Dependencies: Some reconciliations depend on others (bank rec before cash)
• Parallel processing: Different people work different reconciliations

Sample Timeline

Sign-Off Process

• Preparer: Staff accountant completes reconciliation
• Reviewer: Controller or senior reviews and approves
• Documentation: Both signatures with dates

Reconciliation Software

Options by Company Size

• Small/simple: Excel templates with standardized format
• Mid-size: Accounting software built-in or add-on reconciliation
• Larger: Dedicated reconciliation software (BlackLine, FloQast)

Features to Look For

• Standard templates: Consistent format for all reconciliations
• Workflow: Assignment, status tracking, approval routing
• Integration: Pull GL balances automatically
• Audit trail: History of changes and approvals
• Roll-forward: Copy prior period, update for current

Excel Best Practices

If using Excel (common for smaller companies):

• Standardized templates: Same format for all accounts
• Central storage: One location for all reconciliations
• Version control: Clear naming convention with dates
• Links to GL: Link to trial balance for automated balance pull

Common Reconciliation Problems

Chronic Unreconciled Items

Problem: Same differences month after month, never resolved.

Solution: Investigate root cause, adjust if appropriate, implement controls to prevent.

Incomplete Documentation

Problem: Reconciliation says "agreed" but no supporting detail.

Solution: Require specific support attached to every reconciliation.

Late Reconciliation

Problem: Reconciliations completed weeks after close.

Solution: Build into close calendar, hold accountable, automate where possible.

No Review

Problem: Same person prepares and "reviews" reconciliation.

Solution: Implement independent review, even if just sample-based.