Reconciliation templatesAutomate intercompany reconciliation in NetSuite
On working day 3 Modern pulls intercompany balances for every pair of NetSuite subsidiaries, finds the transactions behind each difference and builds the reconciliation workbook in Excel for the controller to sign off.
TriggerMonthly, working day 3
Steps5 steps, from trigger to sign-off
ControlController approves correcting journals and signs off the rec
Free to start. No card needed.
Monthly, working day 3The instruction
“On working day 3 of each month, pull intercompany receivable and payable balances for every pair of subsidiaries in NetSuite. Convert to USD at the month-end rate and list any pair that differs by more than $500. Find the transactions behind each difference, such as timing, FX or missing entries, and build the reconciliation in our Excel template. Propose correcting journals for the controller to approve.”
Works with every major ERP
- +100 more
How it runs
5 steps from trigger to sign-off
- 01
Pull balances
Reads intercompany receivable and payable balances for every subsidiary.
NetSuite - 02
Pair the entities
Lines up each receivable with the matching payable and converts at the month-end rate.
Modern - 03
Explain differences
Traces each difference to timing, FX or a missing entry.
Modern - 04
Build the workbook
Fills your reconciliation template with balances, differences and notes.
Microsoft Excel - 05
Approve the fixes
The controller approves correcting journals before Modern posts them.
NetSuite
Related templates
More reconciliation automations
Daily at 6:00Reconciliation
Propose bank reconciliation matches daily
Matches each bank transaction to NetSuite entries every morning, explains each match and leaves only true exceptions for review.
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
Reconcile intercompany balances at month end: FAQs
Can’t find what you’re looking for? Send us a message and a person on the team will answer.
It converts each balance at the rate you choose, usually the month-end rate in NetSuite, and shows FX differences on their own line.
No. Correcting journals are drafted and posted only after the controller approves them.
Yes. Modern can reconcile entities in Xero, QuickBooks, Sage or NetSuite, including groups that run more than one ledger.