Reconcile intercompany balances across entities
Once a month, WebRun opens NetSuite, pulls the intercompany receivable and payable balances for each entity pair, compares them to the tested transactions in Exactera, and posts a Google Sheets breakdown of any balance that does not tie out.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I reconcile intercompany balances against my transfer pricing records?
WebRun ties out your intercompany balances each month. It opens NetSuite, pulls the receivable and payable balance for each entity pair, compares those to the tested transactions recorded in Exactera, and posts a Google Sheets breakdown that puts every nonzero difference at the top, so mismatches surface early instead of at year end.
- Intercompany balances are tied out monthly, not at close
- Every mismatch shows its exact difference for review
- Currency differences are kept out of the mismatch list
Built for corporate controllers · multinational tax teams · intercompany accountants · transfer pricing analysts
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
system.netsuite.comin a real browser with your saved login - no setup, no API keys. -
1
NetSuite - pull intercompany balances
netsuite.com How to Automate NetSuite
WebRun opens NetSuite to pull intercompany balances. - Open NetSuite and run the intercompany receivables and payables by entity pair
- Capture the balance, currency, and counterparty for each pair
- Note the period-end date for the balances
Done when Every entity pair's intercompany balance is captured.
-
2
Exactera - compare to tested transactions
exactera.com How to Automate Exactera
WebRun opens Exactera to compare tested transactions. - Open Exactera and read the tested transactions for each entity pair
- Compare the recorded amounts to the NetSuite balances
- Mark each pair as tied out or as a difference to explain
Done when Each entity pair is compared and marked tied or mismatched.
-
3
Google Sheets - post the reconciliation
google.com How to Automate Google Sheets
WebRun opens Google Sheets to post the reconciliation. - Open the reconciliation sheet and update each entity pair row
- Show the NetSuite balance, the Exactera amount, and the difference
- Put pairs with a nonzero difference at the top for review
Done when The sheet shows every pair with its difference, mismatches first.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it post journal entries to fix a mismatch?
No. WebRun only reads balances and writes the reconciliation to a sheet. Any correcting entry stays a human decision made in your ERP.
What counts as a mismatch?
Any entity pair whose NetSuite balance does not equal the recorded amount in Exactera. WebRun shows the difference so an accountant can explain or resolve it.
Does it handle multiple currencies?
Yes. It captures the currency for each balance and keeps the comparison within the same currency per entity pair, so a rate difference is not mistaken for a mismatch.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.