Checkbook calculator
| Date | Check # | Description | Payment (−) | Deposit (+) | Cleared | Balance |
|---|
Tick Cleared once a transaction shows on your bank statement. Everything stays in this browser on this device. Nothing is sent to us. Download a CSV to keep a backup.
Result
–
On this page
How to balance a checkbook, step by step
- Mark cleared items. Go through your statement and tick every check, card payment and deposit in your register that appears on it.
- Start with the bank's ending balance from the statement.
- Add deposits in transit: deposits in your register that aren't on the statement yet.
- Subtract outstanding checks and payments: items in your register the bank hasn't paid yet. The result is your adjusted bank balance.
- Update your register with anything only the bank knows about: subtract service fees, add interest. The result is your adjusted register balance.
- Compare. If the two match, you're balanced. If not, see the checks below.
Adjusted register balance = register balance − bank fees + interest
Difference = adjusted register balance − adjusted bank balance → should be $0.00
Worked example
This is the sample data loaded in the calculator. Clear it when you're ready to use your own.
| Statement ending balance | $3,796.65 |
| + Deposit in transit (Sep 28 refund) | +$75.00 |
| − Outstanding check #1043 (car insurance) | −$148.00 |
| Adjusted bank balance | $3,723.65 |
| Register balance | $3,728.23 |
| − Monthly service fee | −$5.00 |
| + Interest earned | +$0.42 |
| Adjusted register balance | $3,723.65 |
| Difference | $0.00: balanced |
Checkbook won't balance? How to find the difference
The calculator runs these checks automatically on the difference:
- Difference equals one transaction: you probably forgot to record it, recorded it twice, or forgot to tick it as cleared.
- Difference equals twice a transaction: you likely entered a payment as a deposit, or the other way round. Entering a $40 payment as a deposit makes you $80 off.
- Difference divisible by 9: a classic sign of transposed digits, such as writing $63.50 as $36.50 (off by $27). Any swap of two digits creates a difference that's a multiple of 9.
- Difference that's a round number ($1, $10, $100): usually an addition or subtraction slip in a running balance.
- No match in your register: look on the statement for a transaction of exactly that amount that you never recorded.
Still off? Check that last month's ending balance matches this month's starting balance. Look for automatic payments and card transactions you didn't write down. And compare every amount against the statement, digit by digit.
Keeping a check register
Record every transaction the day it happens: checks, debit card purchases, ATM withdrawals, transfers, automatic payments and deposits. Note the check number so you can match it on the statement. Writing a check? Our Check Writer spells out the amount in words, and the check writing guide shows how to fill in each line.
Frequently asked questions
Why do I need to balance my checkbook if I bank online?
Your online balance doesn't know about checks you've written that haven't been cashed, or payments scheduled for later. Spending based on it can lead to overdrafts. Reconciling also catches bank errors and fraud. Federal Regulation E sets deadlines for reporting unauthorized electronic transfers, so review statements promptly.
What if a check has been outstanding for months?
Contact the payee. Banks may refuse checks older than six months (Uniform Commercial Code §4-404). Keep it in your register until it clears, or until you void it and add the amount back.
Is my data safe?
Everything is saved only in your browser's local storage on this device. Nothing is uploaded. Clearing your browser data erases it, so download a CSV backup. Don't use a shared or public computer.
Can I import transactions from my bank?
Yes. Download a CSV from your bank and import it. The importer reads Date, Check #, Description, Payment, Deposit and Cleared columns, and also a single signed Amount column. Rename your bank's columns if needed.
Method and privacy
All sums are calculated in whole cents to avoid rounding errors. The reconciliation uses the standard formula taught in personal finance and accounting courses (adjusted bank balance vs adjusted book balance). The diagnostic checks look for single items, doubled items, multiples of 9 and round numbers. Your register is stored with your browser's localStorage and never leaves your device.
Related tools: Check Writer · Currency in Words · Credit Card Payoff Calculator · Loan Payment Calculator