Template · Reconcile · Opening soon

Payment reconciliation template: match payouts to bank deposits

Bring the payouts from your payment processor and your bank lines. Each payout is matched to the deposit it became, and anything that never landed shows up.

Book a demo

You bring

Payout lines32 rows

Payout datePayout amountPayout reference

Bank entries35 rows

Bank dateBank amountBank description

Mammoth does the work

You get

One table36 rows

Each payout matched to its bank deposit, flagged for a date check, or missing.

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.

Payment reconciliation: the resultSample data36 rows

30 matched1 check the date4 not from a payout1 not in the bank

Date	Payout reference	Amount	Bank description	Bank date	Days apart	Status
2026-09-11	po_1Q07347	1,466.09	STRIPE PAYMENTS UK	2026-09-11	0	Matched
2026-09-11	po_1Q07310	5,059.82	STRIPE PAYMENTS UK	2026-09-11	0	Matched
2026-09-13	po_1Q07384	3,240.76	STRIPE PAYMENTS UK	2026-09-15	2	Matched
2026-09-13	po_1Q07421	3,995.68	STRIPE PAYMENTS UK	2026-09-14	1	Matched
2026-09-15	po_1Q07458	2,912.98	STRIPE PAYMENTS UK	2026-09-17	2	Matched
2026-09-16	po_1Q07532	2,488.17	STRIPE PAYMENTS UK	2026-09-16	0	Matched
2026-09-16	po_1Q07495	4,503.98	STRIPE PAYMENTS UK	2026-09-18	2	Matched
2026-09-17	po_1Q07569	905.29	STRIPE PAYMENTS UK	2026-09-17	0	Matched

36 rows in the result · made from Payout lines (32 rows) and Bank entries (35 rows) · first 8 shown. Sample data: illustrative figures, not business results.

What is payment reconciliation?

Payment reconciliation checks that the money a payment processor says it paid out (Stripe, PayPal, Shopify Payments) arrived in your bank, payout by payout. A payout is the sum of many payments less fees, so it is matched on its net amount.

How it works

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

Payouts from Stripe, PayPal or Shopify, and your bank lines (2 tables)

Payout lines

Payout date
Payout amountMoney in positive, money out negative.
Payout reference

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: Payout 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.

Payment reconciliation: questions

Does it match single customer payments or payouts?

Payouts, the lump sums your processor sends to the bank. They are what the bank statement shows, so they are what can be checked against it.

What counts as a match?

The same amount, landing within a few days of the payout date (3 by default, and you can change it). Each payout and deposit is used once.

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.