Workflow · Reconcile · Opening soon
POS sales reconciliation
Reconcile daily sales by payment type against card payouts and cash counts. Use the previous day’s sales for payout matching, then compare what was sold with what was actually taken.
Someone typed
“every day match POS sales totals by payment type to what the card processor and cash drawer actually took”
The agent read it as
Every day, match Square Sales by day and payment type to Square payouts and Square cash drawer report actually took, using the previous day’s sales for payouts.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
File
Square Sales by day and payment type
CSV export · 16 rows
File
Square payouts
CSV export · 14 rows
File
Square cash drawer report
CSV export · 14 rows
Step
Align payout dates
Step 1
Join
Bring in card payouts
16 of 16 paired
Join
Bring in cash counts
16 of 16 paired
Step
Compare sales with takings
Step 4
Result
POS Sales Match
16 rows
Schedule
Runs Every day
Proposed
- FileSquare Sales by day and payment typeCSV export · 16 rows
- FileSquare payoutsCSV export · 14 rows
- FileSquare cash drawer reportCSV export · 14 rows
- StepAlign payout datesStep 1
- JoinBring in card payouts16 of 16 paired
- JoinBring in cash counts16 of 16 paired
- StepCompare sales with takingsStep 4
- ResultPOS Sales Match16 rows
- ScheduleRuns Every dayProposed
Checked on the sample files: every step ran, 16 rows came out, and the join paired 16 of 16 rows; the join paired 16 of 16 rows.
- Download Square Sales by day and payment type sample (16 rows)Square Dashboard: Reports > Sales summary > Export > Group by day and payment type
- Download Square payouts sample (14 rows)Square Dashboard: Balance > Payouts > Export
- Download Square cash drawer report sample (14 rows)Square Dashboard: Team > Cash management > Reports > Export
What you get back
The result of that run, the rows to look at first.
POS Sales MatchSample data16 rows
| Sales date | Payment type | Match status | Difference | POS net sales | Amount taken | Payout status |
|---|---|---|---|---|---|---|
| 2026-10-28 | Card | Payout adjustment | · | 2,140 | · | Adjustment |
| 2026-10-15 | Cash | Amount differs | 20 | 295 | 275 | Paid |
| 2026-09-18 | Card | Agrees | 0 | 1,820 | 1,820 | Paid |
| 2026-09-18 | Cash | Agrees | 0 | 310 | 310 | Paid |
| 2026-09-25 | Card | Agrees | 0 | 1,920 | 1,920 | Paid |
| 2026-09-25 | Cash | Agrees | 0 | 280 | 280 | Paid |
| 2026-10-02 | Card | Agrees | 0 | 2,010 | 2,010 | Paid |
| 2026-10-02 | Cash | Agrees | 0 | 265 | 265 | Paid |
| 2026-10-09 | Card | Agrees | 0 | 1,765 | 1,765 | Paid |
| 2026-10-09 | Cash | Agrees | 0 | 340 | 340 | Paid |
| 2026-10-15 | Card | Agrees | 0 | 2,235 | 2,235 | Paid |
| 2026-10-22 | Card | Agrees | 0 | 1,860 | 1,860 | Paid |
How do you reconcile sales totals by payment type?
Export your Square sales data, card payouts, and cash counts, then load them into the workflow. It lines up payout dates, brings in each source, and compares sales with takings by payment type. Rows that do not match stay separate so you can review them.
How it works
How to use the POS Sales Match workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
POS Sales Match: questions
What export do I use from Square?
Use exports that show sales by payment type, payout or settlement details, and cash count records for the day. The workflow reads spreadsheet-style files, so a CSV or XLSX export is usually enough.
What happens to rows that do not match?
They are not forced into a match. They stay as exceptions so you can review the difference and decide what to fix.
How do you change the matching rules?
You change the rules in words, for example which date to use, how to match payment types, and what counts as a match. Then the workflow uses those instructions on the next file you export.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
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 workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Payment processing fees by methodTrack payment processing fees by method each month, total sales and fees, and flag fee rates that are too high.See the workflow Built by the agent
- Three-way matchEach PO line: matched, partly received, billed more than received, or price differsSee the workflow Template
- Invoice reconciliationEach invoice paid in full, part-paid, overpaid or not paid, and payments with no invoiceSee the workflow Template