Skip to content
Workflow · Match two lists · Opening soon

NetSuite bank reconciliation from the bank statement

Export your bank statement CSV and export the NetSuite transaction lines for the operating bank account. Then match rows on amount and on a date within three days.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Bank statement CSV
    CSV export · 35 rows
  2. File
    NetSuite transaction lines for operating bank account
    CSV export · 33 rows
  3. Step
    Number bank statement lines
    Step 1
  4. Step
    Expand NetSuite candidates
    Step 2
  5. Join
    Bring in NetSuite candidates
    35 of 35 paired
  6. Step
    Match and flag reconciliation lines
    Step 4
  7. Result
    Bank reconciliation flags
    35 rows · 4 flagged
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 35 rows.

What you get back

The result of that run, the rows to look at first.

Bank reconciliation flagsSample data35 rows
31 agrees2 amount differs2 missing in NetSuite
Bank statement line #NetSuite line #NetSuite document numberStatusDifferenceStatement dateNetSuite dateStatement descriptionNetSuite memoStatement amountNetSuite amount
21··Missing in NetSuite·2026-10-16·Service fee reversal·15·
32··Missing in NetSuite·2026-10-27·Bank fee monthly maintenance·-12·
3029PMT-3154Amount differs52026-10-252026-10-25ACH customer payment Bluebird DentalBluebird Dental payment940935
3533CHK-1060Amount differs3902026-10-302026-10-30Bank fee returned deposit itemPayroll run-35-425
11DEP-2001Agrees02026-10-012026-10-01Opening deposit transferOpening deposit transfer25,00025,000
22PMT-3141Agrees02026-10-022026-10-02Stripe payout ref 9011Stripe payout ref 90111,840.501,840.50
33PMT-3142Agrees02026-10-022026-10-02ACH customer payment Northstar LabsNorthstar Labs payment1,2951,295
55BP-1181Agrees02026-10-032026-10-03Vendor bill payment Harbor Office SupplyHarbor Office Supply bill payment-412.75-412.75
44PMT-3143Agrees02026-10-032026-10-03ACH customer payment Brightline StudioBrightline Studio payment860860
66DEP-2002Agrees02026-10-042026-10-04Square depositSquare deposit2,2402,240
77DEP-2003Agrees02026-10-052026-10-05ATM cash depositATM cash deposit500500
99BP-1182Agrees02026-10-062026-10-06Bill payment - Apex TelecomApex Telecom bill payment-268.40-268.40
35 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Bank reconciliation flags workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your bank statement CSV and export the NetSuite transaction lines for the operating bank account. Then match rows on amount and on a date within three days. The workflow lists statement lines missing in NetSuite, NetSuite lines missing on the statement, and matched lines where the amounts differ.
Which export should you use from NetSuite?
Use an export of the transaction lines for the operating bank account for the month you want to reconcile. The file should include the transaction date and amount.
What happens to rows that do not match?
Rows that do not meet the match rules stay in the exception lists. You can see statement lines missing in NetSuite, NetSuite lines missing on the statement, and matches where the amounts differ.
How do you change the reconciliation rules?
Edit the rules in words, then rerun the workflow. You can change which file you use, the matching fields, and the date window used to find likely matches.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.