Template · Reconcile · Opening soon

Credit card reconciliation template

Match every card charge to an expense entry by amount and date. See which charges have no receipt booked and which expenses never hit the card, every time the statement updates.

Book a demo

You bring

Card lines60 rows

Card dateCard amountCard merchant

Expense entries55 rows

Expense dateExpense amountExpense description

Mammoth does the work

You get

One table61 rows

Each charge matched, missing from expenses, or booked but not on the statement.

Matched

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.

Credit card reconciliation: the resultSample data61 rows

53 matched1 check the date6 missing from expenses1 not on the statement

Date	Card merchant	Amount	Expense description	Expense date	Days apart	Status
2026-09-22	UBER	36.45	Uber receipt	2026-09-24	2	Matched
2026-09-22	PRET A MANGER	375.55	Pret A Manger receipt	2026-09-24	2	Matched
2026-09-22	UBER	465.06	Uber receipt	2026-09-24	2	Matched
2026-09-23	ADOBE	244.30	Adobe receipt	2026-09-23	0	Matched
2026-09-23	ZOOM	258.94	Zoom receipt	2026-09-24	1	Matched
2026-09-23	TRAINLINE	294.21	Trainline receipt	2026-09-24	1	Matched
2026-09-23	ZOOM	379.42	Zoom receipt	2026-09-24	1	Matched
2026-09-24	PRET A MANGER	436.45	Pret A Manger receipt	2026-09-25	1	Matched

61 rows in the result · made from Card lines (60 rows) and Expense entries (55 rows) · first 8 shown. Sample data: illustrative figures, not business results.

What is a credit card reconciliation?

A credit card reconciliation checks each charge on the card statement against the expenses booked in your accounts, so missing receipts and personal or duplicate charges show up before the books close.

How it works

How to use the credit card 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

Your card statement and your expense entries (2 tables)

Card lines

Card date
Card amountMoney in positive, money out negative.
Card merchant

Expense entries

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

The steps it runs

1Match columns: Card lines
2Match columns: Expense entries
3Bring in expense entries with the same amount
4Match each line once, closest date first

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

Credit card reconciliation: questions

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.