Template · Reconcile · Opening soon

Invoice reconciliation template: match invoices to payments

Match every invoice to the payments made against it. Part-paid and overpaid invoices, invoices never paid and payments with no invoice each get their own flag.

Book a demo

You bring

Invoices30 rows

InvoiceInvoiced

Payment32 rows

Payment invoicePaid

Mammoth does the work

You get

One table31 rows

Each invoice paid in full, part-paid, overpaid or not paid, and payments with no invoice.

Not paidPart-paidNo invoice for this paymentOverpaidPaid in full

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.

Invoice reconciliation: the resultSample data31 rows

24 paid in full2 part-paid1 overpaid3 not paid1 no invoice for this payment

Invoice	Invoiced	Paid	Difference	Status
INV-4217	5,687	·	5,687	Not paid
INV-4226	4,936.34	·	4,936.34	Not paid
INV-4204	4,195.30	·	4,195.30	Not paid
INV-4211	5,652.74	3,391.64	2,261.10	Part-paid
INV-4222	1,686.97	1,012.18	674.79	Part-paid
INV-4190	·	540	-540	No invoice for this payment
INV-4214	715.35	965.35	-250	Overpaid
INV-4200	3,647.52	3,647.52	0	Paid in full

31 rows in the result · made from Invoices (30 rows) and Payment (32 rows) · first 8 shown. Sample data: illustrative figures, not business results.

What is invoice reconciliation?

Invoice reconciliation matches each invoice to the payments recorded against it, so what is still owed, what was overpaid and which payments belong to no invoice are clear before chasing customers or closing the month.

How it works

How to use the invoice 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 invoices and the payments received against them (2 tables)

Invoices

Invoice
Invoiced

Payment

Payment invoice
Paid

The steps it runs

1Match columns: Invoices
2Match columns: Payment
3Total by payment invoice
4Total by invoice
5Line up both sides by invoice
6Compare

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

Invoice reconciliation: questions

A customer paid one invoice in three parts. Does that work?

Yes. Payments are totalled by invoice first, so three part payments that add up to the invoice show it as paid in full.

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.