Workflow · Reconcile · Opening soon
Deposit reconciliation
Match your bank statement export to your QuickBooks deposits export by date and amount. See one row per bank deposit with a clear status.
Someone typed
“match the bank statement export to our quickbooks deposits by date and amount, one row per bank deposit, and show Status: "Agrees" when it matches, else what's off or missing”
The agent read it as
match my Bank statement export to my QuickBooks deposits export by date and amount, one row per bank deposit, and show Status: "Agrees" when it matches, else what's off or missing
What the agent built
2 steps, each one an ordinary Mammoth step you can open and change.
File
Bank statement export
CSV export · 18 rows
File
QuickBooks deposits export
CSV export · 20 rows
Join
Match QuickBooks deposits
16 of 18 paired
Step
Set status
Step 2
Result
Bank deposit matches
18 rows · 2 flagged
Schedule
Runs when you say
Proposed
- FileBank statement exportCSV export · 18 rows
- FileQuickBooks deposits exportCSV export · 20 rows
- JoinMatch QuickBooks deposits16 of 18 paired
- StepSet statusStep 2
- ResultBank deposit matches18 rows · 2 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 18 rows came out, and the join paired 16 of 18 rows.
- Download Bank statement export sample (18 rows)Bank portal: Accounts > Statements > Checking account > Download CSV
- Download QuickBooks deposits export sample (20 rows)QuickBooks Online: Reports > Deposit Detail > Customize > Export to CSV
What you get back
The result of that run, the rows to look at first.
Bank deposit matchesSample data18 rows
16 agrees2 missing on QuickBooks
| Bank date | Bank description | Bank amount | QB transaction type | QB name | QB memo | QB account | QB clr | Status |
|---|---|---|---|---|---|---|---|---|
| 2026-09-18 | Deposit - Atlas Studio project payment | 985 | · | · | · | · | · | Missing on QuickBooks |
| 2026-10-02 | Deposit - Harbor Books ORD-7781 | 820 | · | · | · | · | · | Missing on QuickBooks |
| 2026-09-03 | Deposit - Northwind Cafe INV-1048 | 1,450 | Deposit | Northwind Cafe | Bank transfer for invoice INV-1048 | Checking | R | Agrees |
| 2026-09-05 | Deposit - Harbor Books ORD-7781 | 820 | Deposit | Harbor Books | Card batch ORD-7781 | Checking | R | Agrees |
| 2026-09-09 | Deposit - Solstice Gym Sept memberships | 2,190 | Deposit | Solstice Gym | September membership batch | Checking | R | Agrees |
| 2026-09-12 | Deposit - Blue Peak Dental | 1,765 | Deposit | Blue Peak Dental | Treatment plan receipts | Checking | R | Agrees |
| 2026-09-16 | Deposit - Meadow Labs retainer | 3,400 | Deposit | Meadow Labs | Monthly retainer | Checking | R | Agrees |
| 2026-09-19 | Deposit - Cedar Market POS batch | 1,240 | Deposit | Cedar Market | POS batch 0919 | Checking | R | Agrees |
| 2026-09-23 | Deposit - Luna Kids tuition | 1,595 | Deposit | Luna Kids | Tuition payments | Checking | R | Agrees |
| 2026-09-26 | Deposit - Pine Tech license renewal | 2,725 | Deposit | Pine Tech | Annual license renewal | Checking | R | Agrees |
| 2026-09-30 | Deposit - River Hotels event deposit | 1,860 | Deposit | River Hotels | Event deposit | Checking | R | Agrees |
| 2026-10-06 | Deposit - Northwind Cafe INV-1061 | 1,485 | Deposit | Northwind Cafe | Invoice INV-1061 | Checking | R | Agrees |
How do you reconcile deposits?
Export your bank statement and your QuickBooks deposits. Then match the rows by date and amount, one bank deposit per row, and mark each one as Agrees or show what is missing or different.
How it works
How to use the Bank deposit matches 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.
Bank deposit matches: questions
What export should I use?
Use a bank statement export and a deposits export from QuickBooks. The file should include the date and amount for each deposit.
What happens when a row does not match?
The row stays in the result with a status that shows it does not agree. You can see whether the date, amount, or a deposit record is missing.
How do I change the matching rules?
You can change the rules in words, for example by asking to match on date and amount, or by adding another field if your file includes it.
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.
- Duplicate payments checkCheck for duplicate payments in QuickBooks exports by matching vendor payments to bills and flagging duplicate payment cases.See the workflow Built by the agent
- Match an Amex statement to QuickBooksMatch Amex statement lines to QuickBooks card charges by date, payee, and amount. See which lines agree, are missing, or are duplicates.See the workflow Built by the agent
- Match Brex transactions to QuickBooksMatch exported Brex card transactions to QuickBooks expenses by date and amount, then see which rows agree and what needs a check.See the workflow Built by the agent
- Match Expensify reports to XeroCheck approved Expensify expenses against Xero bills, see which match, and list rows that need a look.See the workflow Built by the agent
- Match Ramp transactions to NetSuiteMatch Ramp card transactions to your NetSuite credit card register, then flag agreed, missing, mismatched, and extra lines.See the workflow Built by the agent
- Parcel invoice auditAudit UPS freight invoices against tracking detail, flag duplicate charges, late deliveries, and unexpected surcharges.See the workflow Built by the agent