Bank Statement Reconciliation for Estate Accounting

Reconciliation is the process of matching your accounting records to bank statements. It's one of the most important tasks in estate accounting—and one of the most commonly neglected.

Why Reconciliation Matters

Catches Errors Early

A transaction entered as $500 instead of $5,000 will show up immediately during reconciliation.

Detects Missing Transactions

Automatic bank fees, interest payments, or checks you forgot to record all surface during reconciliation.

Satisfies Court Requirements

Courts expect your accounting to match bank records. Discrepancies raise red flags.

Prevents Fraud

Regular reconciliation can detect unauthorized transactions before they become major problems.

The Reconciliation Process

Step 1: Gather Documents

• Bank statement for the period
• Your accounting records for the same period
• Previous reconciliation (if any)

Step 2: Compare Ending Balances

Your accounting should show the same ending balance as the bank statement. If it doesn't, you need to investigate.

Step 3: Identify Differences

Common reasons for differences:

In Your Records, Not on Bank Statement:

• Outstanding checks (written but not yet cashed)
• Deposits in transit (made after statement cutoff)

On Bank Statement, Not in Your Records:

• Bank fees
• Interest earned
• Automatic payments
• Direct deposits

Step 4: Adjust Your Records

Record any transactions from the bank statement that you missed:

• Bank service charges
• Interest credited
• Automatic debits
• Wire transfers

Step 5: Verify the Balance

After adjustments, your records should match the bank:

Your Balance + Deposits in Transit - Outstanding Checks = Bank Balance

If they still don't match, investigate further.

Reconciliation Best Practices

Reconcile Monthly

Don't wait until you're preparing the combined account. Monthly reconciliation catches problems when they're fresh and easier to resolve.

Use a Checklist

For each statement:

• [ ] Compare beginning balance to previous reconciliation
• [ ] Match all deposits
• [ ] Match all withdrawals
• [ ] Account for all bank fees
• [ ] Account for all interest
• [ ] Verify ending balance

Keep Documentation

Save copies of:

• Bank statements
• Reconciliation worksheets
• Notes explaining any discrepancies

Investigate Discrepancies Immediately

A $10 difference might seem minor, but it could indicate a larger problem. Never just "adjust" to make numbers match without understanding why.

Common Reconciliation Challenges

Multiple Bank Accounts

Reconcile each account separately. Don't combine them until each is verified.

Investment Accounts

Brokerage statements are more complex. You may need to reconcile:

• Cash balances
• Security positions
• Dividends and interest
• Buy/sell transactions

Closed Accounts

When closing an estate account, perform a final reconciliation before the balance goes to zero.

Statement Timing

Bank statements may not align with your accounting periods. Be careful about transactions near cutoff dates.

What to Do When Things Don't Match

Small Differences (Under $10)

• Check for transposed digits
• Verify interest calculations
• Look for small bank fees

Medium Differences

• Compare transaction by transaction
• Check for duplicate entries
• Look for transactions recorded in wrong period

Large Differences

• Verify all deposits and withdrawals
• Check for missing transactions
• Look for incorrect amounts
• Consider bank errors (rare but possible)

Documenting Reconciliation

For each reconciliation, document:

1. Date performed
2. Period covered
3. Bank statement balance
4. Your book balance
5. Reconciling items (outstanding checks, deposits in transit)
6. Adjusted balance (should match)
7. Any discrepancies found and how resolved

Reconciliation and Court Filings

When you file a court accounting:

• All bank accounts should be reconciled through the reporting date
• You should be able to explain any reconciling items
• Supporting documentation should be available if requested

Conclusion

Bank reconciliation isn't glamorous, but it's essential for accurate estate accounting. Make it a regular habit, and you'll catch errors before they become problems.

Estate Bookkeeper helps streamline reconciliation by organizing your transactions and making it easy to compare against bank statements.