Template · Reconcile · Opening soon

Bank reconciliation template that does the matching for you

Bring your bank lines and your ledger. The template matches them on amount and date, flags pairs whose dates are far apart, and lists what is missing on either side. It runs again every time the bank feed updates.

Book a demo

You bring

Bank lines80 rows

Bank dateBank amountBank description

Ledger entries85 rows

Ledger dateLedger amountLedger reference

Mammoth does the work

You get

One table90 rows

Every line matched, flagged for a date check, or missing from one side.

MatchedCheck the dateNot in bankNot in ledger

Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
Your files, as they areUpload a file or connect a source. Your column names do not have to match.
Runs again by itselfWhen new data arrives, every step runs again and the result updates.

What you get back

The real result of this template, run on sample data.

Bank reconciliation: the resultSample data90 rows

71 matched4 check the date10 not in bank5 not in ledger

Date	Bank description	Amount	Ledger reference	Ledger date	Days apart	Status
2026-09-11	DD PEAK SOFTWARE	-4,779.83	Peak Software bill	2026-09-11	0	Matched
2026-09-11	DD BRITISH GAS	-3,443.14	British Gas bill	2026-09-09	2	Matched
2026-09-12	DD NORTHERN COURIERS	-3,491.73	Northern Couriers bill	2026-09-05	7	Check the date
2026-09-12	FPS CEDAR & CO	4,751.08	INV-2023	2026-09-12	0	Matched
2026-09-14	·	1,796.67	Transfer 6	2026-09-14	·	Not in bank
2026-09-14	FPS FJORD OUTDOOR	4,232.82	INV-2055	2026-09-14	0	Matched
2026-09-14	FPS OAKRIDGE SCHOOL	5,006.37	·	·	·	Not in ledger
2026-09-15	DD STAPLES	-4,957.69	Staples bill	2026-09-14	1	Matched

90 rows in the result · made from Bank lines (80 rows) and Ledger entries (85 rows) · first 8 shown. Sample data: illustrative figures, not business results.

What is a bank reconciliation?

A bank reconciliation checks every line on your bank statement against your own books, so the two balances agree and anything missing, duplicated or mistyped shows up. Most teams do it monthly, by hand, in a spreadsheet.

Bank statement only as a PDF? Convert it with the free bank statement converter

How it works

How to use the bank reconciliation template

1Bring your dataConnect a source, or upload a file.
2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.

See the exact columns and steps ›

What it needs

Bank lines and your ledger entries (2 tables)

Bank lines

Bank date
Bank amountMoney in positive, money out negative.
Bank description

Ledger entries

Ledger date
Ledger amountSame sign as the other side: money in positive.
Ledger reference
Ledger account(optional)

The steps it runs

1Match columns: Bank lines
2Match columns: Ledger entries
3Bring in ledger entries with the same amount
4Match each line once, closest date first

Every step is an ordinary Mammoth step you can open and change.

Bank reconciliation: questions

What counts as a match?

The same amount, booked within a few days of each other (3 by default, and you can change it). Each line is used once, closest date first.

My ledger keeps debits and credits in two columns. Does that work?

Yes. Point the amount at both columns and choose which way round they go.

Does it update by itself?

Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.

Can I change the steps?

Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.

Do my column names have to match?

No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.