NetSuite bank reconciliation from the bank statement
“reconcile our bank statement against the netsuite transactions posted to the operating bank account for the month, matching on amount and date within three days, and list statement lines missing in netsuite, netsuite lines missing on the statement, and matches whose amounts differ”
Reconcile our Bank statement CSV against the NetSuite transaction lines for operating bank account for the month, matching on amount and date within three days, and list statement lines missing in NetSuite, NetSuite lines missing on the statement, and matches whose amounts differ.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileBank statement CSVCSV export · 35 rows
- FileNetSuite transaction lines for operating bank accountCSV export · 33 rows
- StepNumber bank statement linesStep 1
- StepExpand NetSuite candidatesStep 2
- JoinBring in NetSuite candidates35 of 35 paired
- StepMatch and flag reconciliation linesStep 4
- ResultBank reconciliation flags35 rows · 4 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 35 rows.
- Download Bank statement CSV sample (35 rows)NetSuite: Banking > Reconcile Bank Statement > Export Statement Lines
- Download NetSuite transaction lines for operating bank account sample (33 rows)NetSuite: SuiteQL export from transactions joined to transaction accounting lines for the operating bank account
What you get back
The result of that run, the rows to look at first.
| Bank statement line # | NetSuite line # | NetSuite document number | Status | Difference | Statement date | NetSuite date | Statement description | NetSuite memo | Statement amount | NetSuite amount |
|---|---|---|---|---|---|---|---|---|---|---|
| 21 | · | · | Missing in NetSuite | · | 2026-10-16 | · | Service fee reversal | · | 15 | · |
| 32 | · | · | Missing in NetSuite | · | 2026-10-27 | · | Bank fee monthly maintenance | · | -12 | · |
| 30 | 29 | PMT-3154 | Amount differs | 5 | 2026-10-25 | 2026-10-25 | ACH customer payment Bluebird Dental | Bluebird Dental payment | 940 | 935 |
| 35 | 33 | CHK-1060 | Amount differs | 390 | 2026-10-30 | 2026-10-30 | Bank fee returned deposit item | Payroll run | -35 | -425 |
| 1 | 1 | DEP-2001 | Agrees | 0 | 2026-10-01 | 2026-10-01 | Opening deposit transfer | Opening deposit transfer | 25,000 | 25,000 |
| 2 | 2 | PMT-3141 | Agrees | 0 | 2026-10-02 | 2026-10-02 | Stripe payout ref 9011 | Stripe payout ref 9011 | 1,840.50 | 1,840.50 |
| 3 | 3 | PMT-3142 | Agrees | 0 | 2026-10-02 | 2026-10-02 | ACH customer payment Northstar Labs | Northstar Labs payment | 1,295 | 1,295 |
| 5 | 5 | BP-1181 | Agrees | 0 | 2026-10-03 | 2026-10-03 | Vendor bill payment Harbor Office Supply | Harbor Office Supply bill payment | -412.75 | -412.75 |
| 4 | 4 | PMT-3143 | Agrees | 0 | 2026-10-03 | 2026-10-03 | ACH customer payment Brightline Studio | Brightline Studio payment | 860 | 860 |
| 6 | 6 | DEP-2002 | Agrees | 0 | 2026-10-04 | 2026-10-04 | Square deposit | Square deposit | 2,240 | 2,240 |
| 7 | 7 | DEP-2003 | Agrees | 0 | 2026-10-05 | 2026-10-05 | ATM cash deposit | ATM cash deposit | 500 | 500 |
| 9 | 9 | BP-1182 | Agrees | 0 | 2026-10-06 | 2026-10-06 | Bill payment - Apex Telecom | Apex Telecom bill payment | -268.40 | -268.40 |
How it works
How to use the Bank reconciliation flags workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on 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 reconciliation flags: questions
How do you reconcile a bank statement against NetSuite transactions?
Which export should you use from NetSuite?
What happens to rows that do not match?
How do you change the reconciliation rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- 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
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Match customer payments to open invoicesMatch bank payments to QuickBooks open invoices by customer and amount, and see what is still unapplied.See the workflow Built by the agent
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent