Template · Reconcile · Opening soon
Vendor statement reconciliation template
Compare a supplier's statement with your payables, invoice by invoice. See what they think you owe that you have not booked, and what you have booked that they have not.
You bring
Statement24 rows
InvoiceStatement amount
Ledger24 rows
Ledger invoiceLedger amount
Mammoth does the work
You get
One table25 rows
Each invoice: agrees, differs, or appears on only one side.
Missing from your ledgerNot on their statementSupplier says you owe moreAgrees
- 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.
Vendor statement reconciliation: the resultSample data25 rows
21 agrees2 supplier says you owe more1 missing from your ledger1 not on their statement
| Invoice | Statement amount | Ledger amount | Difference | Status |
|---|---|---|---|---|
| PW-7105 | 797.75 | · | 797.75 | Missing from your ledger |
| PW-7090 | · | 312.50 | -312.50 | Not on their statement |
| PW-7109 | 185.91 | 135.91 | 50 | Supplier says you owe more |
| PW-7114 | 2,913.36 | 2,863.36 | 50 | Supplier says you owe more |
| PW-7100 | 3,274.57 | 3,274.57 | 0 | Agrees |
| PW-7101 | 2,583.75 | 2,583.75 | 0 | Agrees |
| PW-7102 | 2,957.91 | 2,957.91 | 0 | Agrees |
| PW-7103 | 469.90 | 469.90 | 0 | Agrees |
What is a vendor statement reconciliation?
A vendor statement reconciliation checks the balance a supplier says you owe against your accounts payable ledger, invoice by invoice, to catch missing invoices, unapplied payments and pricing differences.
How it works
How to use the vendor statement 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
A supplier's statement and your payables ledger (2 tables)
Statement
- Invoice
- Statement amount
Ledger
- Ledger invoice
- Ledger amount
The steps it runs
- 1Match columns: Statement
- 2Match columns: Ledger
- 3Total by ledger invoice
- 4Total by invoice
- 5Line up both sides by invoice
- 6Compare
Every step is an ordinary Mammoth step you can open and change.
Vendor statement 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.
Get early access to this template
Bring your data, check the columns, and the result rebuilds on every refresh.
More account reconciliation templates
Match two sets of records line by line, and see what agrees, what differs and what is missing on either side.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the template
- Three-way matchEach PO line: matched, partly received, billed more than received, or price differsSee the template
- Invoice reconciliationEach invoice paid in full, part-paid, overpaid or not paid, and payments with no invoiceSee the template
- Credit card reconciliationEach charge matched, missing from expenses, or booked but not on the statementSee the template
- Payroll reconciliationEach net pay line matched to a bank payment, or flaggedSee the template
- Intercompany reconciliationEach reference: agrees (adds to zero), differs, or is booked on one side onlySee the template
- Inventory reconciliationEach SKU: agrees, over, short, or only on one sideSee the template
- GL account reconciliationEach account: agrees, differs, or appears on one side onlySee the template