Bank Reconciliation Tool
Match your bank statement to your ledger line by line, in passes you can see, and get a reconciliation that ties to 0.00. Every line that does not match is named, with the reason it is open and what to do about it.
Reconcile the account
Open your bank statement and the cash account from your ledger. The exact matches clear themselves, the deposit that settles three invoices is found, and what is left is a short list of items with the reason each one is open.
Your statement and ledger
Bank statement
The statement period's transactions, as CSV from online banking.
halvorsen-operating-statement-sep-2026.csv · 13 lines. Date, description and amount, or debit and credit columns.
Columns
09/02/2026 · 09/03/2026 · 09/05/2026
DEPOSIT · ADP PAYROLL · CHECK 4471
Optional.
12480.00 · -38915.62 · -2150.00
Optional.
Optional.
Ledger cash account
This month's activity, and the items still open from last month's reconciliation.
halvorsen-operating-register-sep-2026.csv · 16 lines. QuickBooks Online: the account register. Xero: Account Transactions. NetSuite: the account register.
Columns
06/14/2026 · 08/29/2026 · 08/31/2026
Bay Area Signs · Coastline Rigging · Deposit
4412 · 4471 ·
Optional.
· · 12480.00
310.00 · 2150.00 ·
Balances and settings
Both balances on the statement date, typed from the statement and the ledger.
From the statement.
The cash account's balance on the same date.
Blank uses the latest date in the bank file, never today.
How far apart a bank and a ledger line can be and still match on amount.
Outstanding checks older than this are flagged.
Runs entirely in your browser. Nothing you enter is sent to us or stored.
Your reconciliation
Updates as you type
Reconciled
Difference $0.00
20 lines matched in 4 passes. 4 bank items need a book entry, 5 ledger items are still open.
- 4
- Exact
- 1
- Reference
- 3
- Date window
- 1
- Many to one
The reconciliation
| Item | Amount |
|---|---|
| Balance per statement, 2026-09-30 | $98,519.84 |
| Stale check: Bay Area Signs2026-06-14 | -$310.00 |
| Likely transposition: Tidewater Canvas2026-09-19 | -$1,857.00 |
| Outstanding check or payment: Pacific Marine Electric2026-09-28 | -$4,640.00 |
| Outstanding check or payment: Harbor Waste2026-09-30 | -$980.00 |
| Deposit in transit: Deposit2026-09-30 | $15,725.00 |
| Adjusted bank balance | $106,457.84 |
| Item | Amount |
|---|---|
| Balance per ledger, 2026-09-30 | $111,559.22 |
| Likely transposition: CHECK 44762026-09-22 | -$1,875.00 |
| Returned item: RETURNED ITEM2026-09-24 | -$3,200.00 |
| Bank fee: SERVICE CHARGE2026-09-30 | -$45.00 |
| Interest: INTEREST PAID2026-09-30 | $18.62 |
| Adjusted book balance | $106,457.84 |
What to do about each open item
| Side | Line | Reason | Next step |
|---|---|---|---|
| Bank | 2026-09-22 CHECK 4476 -$1,875.00 | Likely transposition | The two amounts have the same digits in a different order. Correct the ledger. Pairs with 2026-09-19 Tidewater Canvas -$1,857.00. |
| Bank | 2026-09-24 RETURNED ITEM -$3,200.00 | Returned item | A deposited check bounced. Put the amount back on the customer and book the reversal. |
| Bank | 2026-09-30 SERVICE CHARGE -$45.00 | Bank fee | Book it. A suggested entry is in the export. |
| Bank | 2026-09-30 INTEREST PAID $18.62 | Interest | Book it. A suggested entry is in the export. |
| Ledger | 2026-06-14 Bay Area Signs -$310.00 | Stale check | Contact the payee, or void and reissue. |
| Ledger | 2026-09-19 Tidewater Canvas -$1,857.00 | Likely transposition | The two amounts have the same digits in a different order. Correct the ledger. Pairs with 2026-09-22 CHECK 4476 -$1,875.00. |
| Ledger | 2026-09-28 Pacific Marine Electric -$4,640.00 | Outstanding check or payment | Normal until it is old. Follow up if it passes the stale age. |
| Ledger | 2026-09-30 Harbor Waste -$980.00 | Outstanding check or payment | Normal until it is old. Follow up if it passes the stale age. |
| Ledger | 2026-09-30 Deposit $15,725.00 | Deposit in transit | Confirm it clears in the first days of next month. |
How each line matched
| Pass | Bank | Ledger |
|---|---|---|
| Exact | 2026-09-03 ADP PAYROLL -$38,915.62 | 2026-09-03 ADP payroll -$38,915.62 |
| Exact | 2026-09-15 ACH HARBOR PROPERTIES -$14,500.00 | 2026-09-15 Harbor Properties rent -$14,500.00 |
| Exact | 2026-09-17 ADP PAYROLL -$39,104.88 | 2026-09-17 ADP payroll -$39,104.88 |
| Exact | 2026-09-18 AMEX EPAYMENT -$6,322.18 | 2026-09-18 American Express -$6,322.18 |
| Reference | 2026-09-05 CHECK 4471 -$2,150.00 | 2026-08-29 Coastline Rigging -$2,150.00 |
| Date window | 2026-09-02 DEPOSIT $12,480.00 | 2026-08-31 Deposit $12,480.00 |
| Date window | 2026-09-12 STRIPE TRANSFER $9,847.35 | 2026-09-11 Stripe payout $9,847.35 |
| Date window | 2026-09-26 DEPOSIT $22,300.00 | 2026-09-25 Deposit $22,300.00 |
| Many to one | 2026-09-09 REMOTE DEPOSIT $18,600.00 | 2026-09-08 Marisol Yachts $7,250.00; 2026-09-08 Keel & Co $6,100.00; 2026-09-08 Driftwood Charters $5,250.00 |
- Runs entirely in your browser. Your statement and ledger are never uploaded and we never see a description or an amount.
- Reconciled as of 2026-09-30, with a 5-day window.
Related reading
Why cash and the ledger disagree, and what it takes to reconcile every account, every month, without exporting anything.
- Glossary
Bank Reconciliation
A bank reconciliation explains the difference between the cash balance in the general ledger and the balance on the bank statement at a point in time, identifying timing differences, bank-only items, and errors, and adjusting the ledger for what belongs in it.
- Glossary
Balance Sheet Reconciliation
Balance sheet reconciliation is the practice of reconciling every balance sheet account, not just cash, on a documented schedule with a named owner and risk tier per account. It is the close deliverable auditors test first, and account reconciliation is the technique it applies, account by account.
- Integration
QuickBooks
QuickBooks is a cloud-based accounting platform that enables businesses to manage finances, track income and expenses, and gain real-time insights into their financial performance.
- Integration
Xero
A cloud-based accounting platform that helps small businesses manage invoicing, expenses, payroll, and financial reporting.
- Use case
Bank Reconciliation
- Use case
Account Reconciliation
- Free tool
Duplicate Payment Detector
- Free tool
Journal Entry Generator
How a bank reconciliation works
What it proves
A bank reconciliation proves that the cash balance in your ledger is right, by showing that every difference between it and the bank's balance on the same date has a reason. The bank and the ledger record the same cash, but not at the same moment. A check you wrote on the 28th is in your ledger on the 28th and in the bank when the payee cashes it. Interest is in the bank on the last day and in your ledger when someone books it.
Those timing items explain most of the gap. The reconciliation lists them on the side they belong to, and when both adjusted balances agree, the ledger is proven. When they do not, the difference is an error somewhere, and it is worth finding before the month is closed on it.
The two sides
Adjusted bank balance = Statement balance + Deposits in transit - Outstanding checks
Adjusted book balance = Ledger balance + Bank credits not booked - Bank debits not booked
Difference = Adjusted bank balance - Adjusted book balance
Items that belong on the bank side are ones the bank has not seen yet: they will clear by themselves. Items on the book side are ones you have not recorded yet: they need an entry. That is the useful split. The bank side is a waiting list. The book side is a to-do list.
Why matching runs in passes
A single rule, same amount and same date, clears most lines in a quiet month and leaves the hard ones. Each later pass is looser than the one before, so it runs only on what the earlier passes left. Exact first, because a match there is nearly certain. Reference next, because a check number is stronger evidence than a date. Then a date window for the payments that take a day or two to settle. Then many to one, for the deposit that is three customer payments, which no one-to-one rule can match.
The order matters for a second reason. A looser pass run first would take lines that belong to a stricter match, and a payroll run matched on a date window to the wrong pay date is harder to spot than one left open.
Why a near amount is never a match
A ledger line of $1,857.00 against a bank line of $1,875.00 looks like a match with an $18 rounding difference. It is not. One of them is wrong, and booking the reconciliation with the two matched would carry the error into next month. The difference is a multiple of nine, which is the mark of two digits typed in the wrong order. The tool reports the pair and the likely cause, and the fix is a correcting entry, not a tolerance.
Stale checks
A check that has been outstanding for months is not a timing difference any more. The payee may have lost it, or it may have been written in error. Most teams follow up after 90 days, and the tool flags checks older than that, but the age is a setting. What to do with a check that is never cashed depends on your state's unclaimed property rules, which this tool does not apply.
Why a reconciliation that does not tie should stay open
The temptation in a reconciliation that is $45 out is to book $45 to miscellaneous expense and move on. The $45 might be a bank fee, which is fine. It might also be the net of a $3,200 returned customer check and a $3,155 deposit nobody recorded, which is not. A difference is a symptom with a cause. The tool's checks on it, a single line, a doubled line, a multiple of nine, catch the common causes. The rest need a person.
Worked example
The sample the tool loads. Invented.
Halvorsen Marine Outfitters sells rigging and deck hardware to boatyards and charter operators. Its staff accountant reconciles the operating account each month in QuickBooks Online, and the controller signs the reconciliation off. This is September 2026.
The inputs:
- Bank statement: 13 lines for September. Ending balance $98,519.84.
- Ledger: 13 lines for September, plus 3 items open from earlier reconciliations: a deposit of $12,480.00 recorded on August 31, check 4471 for $2,150.00 written August 29, and check 4412 for $310.00 written June 14. Ledger ending balance $111,559.22.
- Date window: 5 days.
What matched, by pass:
| Pass | Bank line | Ledger line or lines |
|---|---|---|
| Exact | Sep 3 ADP payroll, -$38,915.62 | Sep 3 payroll, -$38,915.62 |
| Exact | Sep 15 rent, -$14,500.00 | Sep 15 rent, -$14,500.00 |
| Exact | Sep 17 ADP payroll, -$39,104.88 | Sep 17 payroll, -$39,104.88 |
| Exact | Sep 18 Amex payment, -$6,322.18 | Sep 18 Amex payment, -$6,322.18 |
| Reference | Sep 5 check 4471, -$2,150.00 | Aug 29 check 4471, -$2,150.00 |
| Date window | Sep 2 deposit, $12,480.00 | Aug 31 deposit, $12,480.00 |
| Date window | Sep 12 Stripe transfer, $9,847.35 | Sep 11 Stripe payout, $9,847.35 |
| Date window | Sep 26 deposit, $22,300.00 | Sep 25 deposit, $22,300.00 |
| Many to one | Sep 9 remote deposit, $18,600.00 | Sep 8 payments from three customers: $7,250.00, $6,100.00 and $5,250.00 |
Nine bank lines matched to eleven ledger lines. Check 4471 cleared seven days after it was written, outside the window, and matched on its number. The $18,600 deposit is three customer checks deposited together, and only one combination of the open receipts adds up to it.
What is left:
| Side | Line | Reason |
|---|---|---|
| Bank only | Sep 22 check 4476, -$1,875.00 | Likely transposition. Ledger has check 4476 at -$1,857.00. Difference $18.00, a multiple of nine |
| Bank only | Sep 24 returned item, -$3,200.00 | Returned item. A customer check bounced |
| Bank only | Sep 30 service charge, -$45.00 | Bank fee |
| Bank only | Sep 30 interest, $18.62 | Interest |
| Ledger only | Sep 19 check 4476, -$1,857.00 | The other half of the transposition |
| Ledger only | Sep 28 check 4479, -$4,640.00 | Outstanding check |
| Ledger only | Sep 30 check 4480, -$980.00 | Outstanding check |
| Ledger only | Jun 14 check 4412, -$310.00 | Stale. Outstanding 108 days |
| Ledger only | Sep 30 deposit, $15,725.00 | Deposit in transit |
The reconciliation:
Balance per statement 98,519.84
Add deposit in transit 15,725.00
Less outstanding checks 4479, 4480, 4412 -5,930.00
Less check 4476 as booked -1,857.00
Adjusted bank balance 106,457.84
Balance per ledger 111,559.22
Less check 4476 as cleared -1,875.00
Less returned item -3,200.00
Less service charge -45.00
Add interest 18.62
Adjusted book balance 106,457.84
Difference 0.00
Check 4476 appears on both sides because each side holds a different amount for it. Once the ledger is corrected to $1,875.00, the bank-side line becomes an ordinary cleared check and the book side shows a correction of $18.00.
What the accountant does next. Three book entries come straight from the suggested entries export: the $3,200.00 returned check back to the customer's receivable, the $45.00 fee and the $18.62 interest. The fourth is a correction to check 4476 itself, from $1,857.00 to $1,875.00. Then a call to the payee of check 4412, which has been outstanding since June. The deposit in transit and the two September checks should clear in the first week of October, and next month's reconciliation will show whether they did.
What this does not do
This tool reconciles the two files you give it, for one account and one period. It does not connect to your bank or your ledger, read a PDF statement, or post any entry. It matches on amounts, dates and reference numbers only: it does not read remittance advice, know your customers or vendors, or learn from previous months. It cannot tell a real duplicate from two genuine identical payments, and it does not apply unclaimed property rules to old checks. The suggested entries are suggestions for a person to review, not accounting advice.
Questions
A comparison of your bank statement with the cash account in your ledger on the same date, listing every item that explains the difference between them. When the items explain all of it, the ledger's cash balance is proven. Most companies do one for every bank account every month.
A deposit in transit is money you have recorded as received that the bank has not credited yet, usually a deposit made on the last day of the month. An outstanding check is one you have written and recorded that the payee has not cashed yet. Both are timing differences: they belong on the bank side of the reconciliation, and they clear on their own.
The common causes are a transaction entered with two digits swapped, an amount entered with the wrong sign, a bank fee or returned item not booked, a deposit recorded twice, and last month's open items left out of the ledger file. The tool checks the difference against each of these and says which one fits.
Contact the payee. If it was lost, void it and reissue. If it was written in error, void it. A check that is never cashed may eventually have to be reported to your state as unclaimed property, and the rules and timing differ by state. This tool flags old checks but does not apply those rules.
Because nearly the same means one of them is wrong. Matching them would hide the error and carry it into next month. The tool reports a near pair as a likely transposition, so the ledger can be corrected.
No. The files are read and matched in your browser. Nothing is sent to us and nothing is kept when you close the tab.
Yes, if you can export the card statement or the payout report as CSV. A processor that pays out net of fees will leave the fee as a difference on each payout, which the many to one pass does not hide.
It works with exports from any of them, and from any bank that offers CSV. It does not connect to them or post anything back.
One account by hand.
Every account, every month, reviewed.
Statements pulled from every bank and card portal, cash matched to your ledger in passes, and exceptions explained with the working attached. Your team approves the reconciliation, and nothing posts without them.
