NetSuite reconciliation for multi-entity finance teams
Reconciles takes the matching work out of NetSuite reconciliation. You export a saved search of your transactions, upload it with bank statements or processor reports, review matches and exceptions per subsidiary, and bring approved journal entries back into NetSuite through its CSV import.
Your files are processed in your browser and never stored. No card needed.
Why NetSuite reconciliation takes so long at month end
NetSuite holds the books for companies with many subsidiaries, currencies and bank accounts. Its bank matching handles the straightforward lines, while the hard part still ends up in spreadsheets.
- Processor settlements and marketplace payouts arrive net of fees across several currencies.
- Intercompany transfers have to agree on both sides before consolidation.
- High volumes make line by line review slow, and one missed duplicate can hold up the close.
- Each subsidiary has its own accounts, so the same work is repeated many times.
Reconciles runs the matching for every account and entity in one place and hands your team a short list of exceptions with reasons attached.
How to reconcile NetSuite with Reconciles, step by step
-
01 Export a saved search from NetSuite
Create or reuse a transaction saved search filtered to the account, subsidiary and period you are closing, with date, amount, memo, entity and document number as columns. Export the results to CSV or Excel. Download the bank statement for the same account, or the settlement report from your processor.
-
02 Upload the files
Drop the bank statement in the first slot and the NetSuite export in the second. On Scale you can also send files through the API or an SFTP drop on a schedule. Reconciles detects the columns, normalizes currencies and signs and reports the lines read from each file.
-
03 Review matches and exceptions
Exact, one to many and many to one matches are shown with a reason and a confidence score. Exceptions are sorted into unmatched, partial, duplicate, amount difference and date difference, and can be assigned, commented, approved and resolved with a full audit trail.
-
04 Import journal entries back into NetSuite
Approved adjustments are exported as a journal entry CSV laid out for NetSuite. Bring it in with the NetSuite CSV import, map the fields once and save the mapping for next month. The reconciliation report in XLSX or PDF documents the close.
What NetSuite reconciliation with Reconciles covers
- Bank accounts vs NetSuite transactions for every subsidiary.
- Processor settlements from Stripe and Adyen vs deposits and customer payments, see Adyen reconciliation.
- Intercompany balances between subsidiaries, see intercompany reconciliation software.
- General ledger accounts vs their supporting detail, see general ledger reconciliation software.
- Multi-currency activity with conversion differences on their own line.
Built for the Scale plan
NetSuite journal entries and scheduled exports are part of Scale. The plan covers 60 bank and payment accounts, 100,000 transactions matched per month, 25 entities and 40 seats, with approvals, the audit log, SSO (SAML), SCIM and data residency in the US or the EU. Everything is bought and set up in your account, without a sales process. Compare plans on the pricing page.
Controls your auditors expect
Every match records why it was made and who approved it. Exceptions keep their comments and resolution history. Nothing is posted to NetSuite without review, and roles decide who can approve entries for each subsidiary. Read how data is handled on the security page.
Getting your NetSuite export right the first time
A few details make the first run cleaner. Keep one account and one subsidiary per export, so every line in the file belongs to the same bank statement. Include the document number and memo columns, because references in those fields give matches a higher confidence score. Use the same period on both files, and widen the date tolerance to 3 or 7 days if deposits post a day or two after the transaction date. Save the search once and reuse it each month, and the export becomes a routine step in your close.
NetSuite reconciliation questions
You can upload exports at any time, and on your plan you can connect sources so files arrive on a schedule. On Scale, the API and SFTP drop let you send saved search results automatically.
Yes. Each subsidiary is an entity with its own accounts, rules and exceptions queue. Scale includes 25 entities.
Scale. Starter and Growth include the reconciliation report and matched pairs, and Growth adds journal entries for QuickBooks and Xero.
Reconcile a NetSuite account today
Upload a bank statement and a saved search export. You see the first matched pairs before you create an account.