# Bank Reconciliation Calculator

URL: https://speedycalculator.com/calculators/finance/bank-reconciliation/
Last updated: 2026-10-25

> The bank reconciliation calculator reconciles your cash book (ledger) balance with the bank statement balance by adjusting for bank charges, automatic payments, NSF cheques, interest earned, deposits in transit and outstanding cheques.

## Inputs

- Balance as per cash book
- Automatic payments not recorded
- Bank charges
- NSF (bounced) cheques
- Interest earned
- Receivables collected by the bank
- Balance as per bank statement
- Deposits in transit
- Outstanding cheques
- Bank errors (+ add / − subtract)

## Results

- Adjusted book balance
- Adjusted bank balance
- Difference
- Result

## Formula

```
Adjusted book balance = book balance − automatic payments − bank charges − NSF cheques + interest earned + collections by bank
Adjusted bank balance = bank balance + deposits in transit − outstanding cheques ± bank errors
The two adjusted balances should be equal
```

## Explanation

Bank reconciliation catches errors, fraud and timing differences. Items the bank knows about but you don't (fees, interest, returned cheques) adjust the book side; items you know about but the bank hasn't processed yet (deposits in transit, outstanding cheques) adjust the bank side.

### How to use the Bank Reconciliation Calculator

- **Balance as per cash book**
- **Automatic payments not recorded**
- **Bank charges**
- **NSF (bounced) cheques**
- **Interest earned**
- **Receivables collected by the bank**
- **Balance as per bank statement**
- **Deposits in transit**
- **Outstanding cheques**
- **Bank errors (+ add / − subtract)**

Results update as you type, and every field accepts the units shown in its menu.

### How it works

Enter the cash book balance and its adjustments, then the bank statement balance and its adjustments.

### Tips

- Use your real spending from bank statements rather than guesses.
- Automate savings so they happen before you spend.
- Revisit your plan once a year or after any big life change.
- Keep an emergency fund before investing for long-term goals.

### Common mistakes to avoid

- Underestimating irregular expenses such as car repairs, gifts and annual bills.
- Ignoring inflation for long-term goals.
- Taking on high-interest debt to fund wants.

### Inputs explained

FieldWhat to enterBalance as per cash bookAmount in your currencyAutomatic payments not recordedAmount in your currencyBank chargesAmount in your currencyNSF (bounced) chequesAmount in your currencyInterest earnedAmount in your currencyReceivables collected by the bankAmount in your currencyBalance as per bank statementAmount in your currencyDeposits in transitAmount in your currencyOutstanding chequesAmount in your currencyBank errors (+ add / − subtract)Amount in your currency

### What each result means

- **Adjusted book balance** = [Balance as per cash book] - [Automatic payments not recorded] - [Bank charges] - [NSF (bounced) cheques] + [Interest earned] + [Receivables collected by the bank]
- **Adjusted bank balance** = [Balance as per bank statement] + [Deposits in transit] - [Outstanding cheques] + [Bank errors (+ add ÷ − subtract)]
- **Difference** = [Adjusted book balance] - [Adjusted bank balance]

### Example values

How the main result changes when **Balance as per cash book** changes and everything else stays at the example values above:

Balance as per cash bookDifference6,250-6,2509,375-3,12512,500015,6253,12518,7506,25025,00012,500

## Worked example

Inputs — Balance as per cash book: $12,500; Automatic payments not recorded: $450; Bank charges: $35; NSF (bounced) cheques: $300; Interest earned: $22; Receivables collected by the bank: $800; Balance as per bank statement: $13,037; Deposits in transit: $1,500; Outstanding cheques: $2,000; Bank errors (+ add / − subtract): $0.

Results — Adjusted book balance = $12,537.00; Adjusted bank balance = $12,537.00; **Difference = $0.00**; Result = Reconciled – the balances agree.

## FAQ

**What is a bank reconciliation?**
Matching your records with the bank statement to explain every difference.

**What are deposits in transit?**
Deposits you've recorded that the bank hasn't processed yet.

**How often should I reconcile?**
At least monthly, when the statement arrives.

**What formula does the Bank Reconciliation Calculator use?**
Adjusted book balance = book balance − automatic payments − bank charges − NSF cheques + interest earned + collections by bank.