Reconciliation templatesAutomate bank reconciliation in NetSuite
Every morning Modern reads the previous day of transactions from Chase, matches them to payments, deposits and journals in NetSuite, and explains each match so your team only reviews the exceptions.
TriggerDaily at 6:00
Steps5 steps, from trigger to sign-off
ControlController approves matches before they are reconciled
Free to start. No card needed.
Daily at 6:00The instruction
“Every day at 6:00, pull the previous day of transactions from our Chase operating account. Match each one to NetSuite payments, deposits, transfers and journals by amount, reference and a date within 3 days. Propose matches with a short note, and list anything unmatched with the closest candidates. Mark matches as reconciled only after the controller approves them.”
Works with every major ERP
- +100 more
How it runs
5 steps from trigger to sign-off
- 01
Read bank transactions
Pulls the previous day of debits and credits with dates, amounts and references.
Chase - 02
Search NetSuite
Looks for payments, deposits, transfers and journals with matching amounts and references.
NetSuite - 03
Propose matches
Explains each match, including one-to-many and many-to-one matches.
Modern - 04
List the exceptions
Lists unmatched lines with the closest candidates and a suggested fix.
Modern - 05
Approve and reconcile
The controller approves the matches, then Modern marks them reconciled in NetSuite.
NetSuite
Related templates
More reconciliation automations
Monthly, working day 3Reconciliation
Reconcile intercompany balances at month end
Compares intercompany balances across every NetSuite subsidiary on working day 3, explains differences and builds the rec in Excel.
5 stepsUse template →- Monthly, working day 2
Reconciliation
Recharge intercompany costs automatically
Finds shared costs paid by one NetSuite subsidiary, applies your recharge rules and drafts matching intercompany invoices and bills.
4 stepsUse template → 
When a Shopify payout is paidReconciliation
Reconcile Shopify payouts to the bank
Breaks every Shopify payout into orders, fees, refunds and adjustments, and drafts entries in Xero that match the bank deposit.
4 stepsUse template →
FAQs
Propose bank reconciliation matches daily: FAQs
Can’t find what you’re looking for? Send us a message and a person on the team will answer.
Yes. Add each account to the instruction and Modern reconciles them in the same run, with a separate exception list for each.
Modern proposes journals for fees, interest and other lines with no entry in NetSuite, using the accounts you name, for your approval.
Yes. Modern reads bank data from Chase, Plaid or your bank feed and proposes matches in Xero, QuickBooks, Sage or NetSuite.