Template · Reconcile · Opening soon
Cash reconciliation template for daily takings
Compare every day's till or POS takings with what reached the bank, store by store. Deposits that never arrived or came in short show up the day the bank updates.
You bring
Takings lines84 rows
Takings dateTakings amountTakings store
Bank entries83 rows
Bank dateBank amountBank description
Mammoth does the work
You get
One table85 rows
Each day's takings matched to a bank deposit, or flagged as not banked.
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.
Cash reconciliation: the resultSample data85 rows
82 matched2 not banked1 not in takings
| Date | Takings store | Amount | Bank description | Bank date | Days apart | Status |
|---|---|---|---|---|---|---|
| 2026-09-26 | Station Kiosk | 1,121.47 | CASH DEP STATION KIOSK | 2026-09-27 | 1 | Matched |
| 2026-09-26 | Market Hall | 1,764.08 | CASH DEP MARKET HALL | 2026-09-28 | 2 | Matched |
| 2026-09-26 | High Street | 2,912.77 | CASH DEP HIGH STREET | 2026-09-27 | 1 | Matched |
| 2026-09-27 | Station Kiosk | 644.72 | CASH DEP STATION KIOSK | 2026-09-28 | 1 | Matched |
| 2026-09-27 | Market Hall | 1,320.35 | CASH DEP MARKET HALL | 2026-09-28 | 1 | Matched |
| 2026-09-27 | High Street | 2,699.96 | CASH DEP HIGH STREET | 2026-09-28 | 1 | Matched |
| 2026-09-28 | Market Hall | 630.31 | CASH DEP MARKET HALL | 2026-09-29 | 1 | Matched |
| 2026-09-28 | Station Kiosk | 1,150.38 | CASH DEP STATION KIOSK | 2026-09-29 | 1 | Matched |
What is a cash reconciliation?
A cash reconciliation compares the cash and card takings recorded at the till with the deposits that reach the bank, so short deposits, missing bank runs and counting mistakes show up while they are still easy to trace.
How it works
How to use the cash 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
Daily takings from your till or POS, and your bank lines (2 tables)
Takings lines
- Takings date
- Takings amountMoney in positive, money out negative.
- Takings store
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: Takings 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.
Cash reconciliation: questions
What if a deposit comes in short?
The day's takings and the deposit no longer agree, so the takings show as not banked and the deposit as not in takings. The pair sits side by side by date, which makes the gap easy to see.
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
- 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
- Vendor statement reconciliationEach invoice: agrees, differs, or appears on only one sideSee 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