Template · Reconcile · Opening soon

Payroll reconciliation template

Check every net pay line from your payroll run against what left the bank. Missing, duplicated and late payments show up as soon as the bank updates.

Book a demo

You bring

Payroll lines12 rows

Payroll datePayroll amountPayroll employee

Bank entries12 rows

Bank dateBank amountBank description

Mammoth does the work

You get

One table13 rows

Each net pay line matched to a bank payment, or flagged.

MatchedCheck the dateNot paid from the bank

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.

Payroll reconciliation: the resultSample data13 rows

10 matched1 check the date1 paid but not in payroll1 not paid from the bank

Date	Payroll employee	Amount	Bank description	Bank date	Days apart	Status
2026-09-27	K. Brown	2,353.69	SALARY K. BROWN	2026-09-28	1	Matched
2026-09-27	D. Murphy	2,374.41	SALARY D. MURPHY	2026-10-03	6	Check the date
2026-09-27	J. Silva	2,415.72	SALARY J. SILVA	2026-09-28	1	Matched
2026-09-27	B. Okafor	2,691.36	SALARY B. OKAFOR	2026-09-28	1	Matched
2026-09-27	C. Nguyen	2,692.08	SALARY C. NGUYEN	2026-09-28	1	Matched
2026-09-27	L. Garcia	2,728.97	SALARY L. GARCIA	2026-09-28	1	Matched
2026-09-27	I. Schmidt	3,019.29	SALARY I. SCHMIDT	2026-09-28	1	Matched
2026-09-27	H. Tanaka	3,205.75	·	·	·	Not paid from the bank

13 rows in the result · made from Payroll lines (12 rows) and Bank entries (12 rows) · first 8 shown. Sample data: illustrative figures, not business results.

What is a payroll reconciliation?

A payroll reconciliation compares what payroll says each person should be paid with the payments that left the bank, so errors are fixed before the next run.

How it works

How to use the payroll 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 payroll run and the bank payments (2 tables)

Payroll lines

Payroll date
Payroll amountMoney in positive, money out negative.
Payroll employee

Bank entries

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

The steps it runs

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

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

Payroll 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.