Free tool

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.

Bank statement

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.

Ledger

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

Bank side: what the bank has not seen yet
ItemAmount
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
Book side: what the ledger has not recorded yet
ItemAmount
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

Every open line, with the reason it is open and the next step
SideLineReasonNext step
Bank2026-09-22 CHECK 4476 -$1,875.00Likely transpositionThe two amounts have the same digits in a different order. Correct the ledger. Pairs with 2026-09-19 Tidewater Canvas -$1,857.00.
Bank2026-09-24 RETURNED ITEM -$3,200.00Returned itemA deposited check bounced. Put the amount back on the customer and book the reversal.
Bank2026-09-30 SERVICE CHARGE -$45.00Bank feeBook it. A suggested entry is in the export.
Bank2026-09-30 INTEREST PAID $18.62InterestBook it. A suggested entry is in the export.
Ledger2026-06-14 Bay Area Signs -$310.00Stale checkContact the payee, or void and reissue.
Ledger2026-09-19 Tidewater Canvas -$1,857.00Likely transpositionThe two amounts have the same digits in a different order. Correct the ledger. Pairs with 2026-09-22 CHECK 4476 -$1,875.00.
Ledger2026-09-28 Pacific Marine Electric -$4,640.00Outstanding check or paymentNormal until it is old. Follow up if it passes the stale age.
Ledger2026-09-30 Harbor Waste -$980.00Outstanding check or paymentNormal until it is old. Follow up if it passes the stale age.
Ledger2026-09-30 Deposit $15,725.00Deposit in transitConfirm it clears in the first days of next month.

How each line matched

Matches by pass
PassBankLedger
Exact2026-09-03 ADP PAYROLL -$38,915.622026-09-03 ADP payroll -$38,915.62
Exact2026-09-15 ACH HARBOR PROPERTIES -$14,500.002026-09-15 Harbor Properties rent -$14,500.00
Exact2026-09-17 ADP PAYROLL -$39,104.882026-09-17 ADP payroll -$39,104.88
Exact2026-09-18 AMEX EPAYMENT -$6,322.182026-09-18 American Express -$6,322.18
Reference2026-09-05 CHECK 4471 -$2,150.002026-08-29 Coastline Rigging -$2,150.00
Date window2026-09-02 DEPOSIT $12,480.002026-08-31 Deposit $12,480.00
Date window2026-09-12 STRIPE TRANSFER $9,847.352026-09-11 Stripe payout $9,847.35
Date window2026-09-26 DEPOSIT $22,300.002026-09-25 Deposit $22,300.00
Many to one2026-09-09 REMOTE DEPOSIT $18,600.002026-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.

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:

PassBank lineLedger line or lines
ExactSep 3 ADP payroll, -$38,915.62Sep 3 payroll, -$38,915.62
ExactSep 15 rent, -$14,500.00Sep 15 rent, -$14,500.00
ExactSep 17 ADP payroll, -$39,104.88Sep 17 payroll, -$39,104.88
ExactSep 18 Amex payment, -$6,322.18Sep 18 Amex payment, -$6,322.18
ReferenceSep 5 check 4471, -$2,150.00Aug 29 check 4471, -$2,150.00
Date windowSep 2 deposit, $12,480.00Aug 31 deposit, $12,480.00
Date windowSep 12 Stripe transfer, $9,847.35Sep 11 Stripe payout, $9,847.35
Date windowSep 26 deposit, $22,300.00Sep 25 deposit, $22,300.00
Many to oneSep 9 remote deposit, $18,600.00Sep 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:

SideLineReason
Bank onlySep 22 check 4476, -$1,875.00Likely transposition. Ledger has check 4476 at -$1,857.00. Difference $18.00, a multiple of nine
Bank onlySep 24 returned item, -$3,200.00Returned item. A customer check bounced
Bank onlySep 30 service charge, -$45.00Bank fee
Bank onlySep 30 interest, $18.62Interest
Ledger onlySep 19 check 4476, -$1,857.00The other half of the transposition
Ledger onlySep 28 check 4479, -$4,640.00Outstanding check
Ledger onlySep 30 check 4480, -$980.00Outstanding check
Ledger onlyJun 14 check 4412, -$310.00Stale. Outstanding 108 days
Ledger onlySep 30 deposit, $15,725.00Deposit 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

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.