Excel-based IC Tool
Why we built the IC Tool on Excel
Finance teams already live in Excel, so building the intercompany calculation engine on that platform removes the need for a new interface or weeks of training. Every formula stays visible and auditable, giving finance and tax teams the rigour of a dedicated system without losing the flexibility Excel offers every day.
Six reasons finance teams choose Excel-based tooling
Universal in finance
Every finance team already works in Excel, so there is no learning curve, no new platform to roll out, and no vendor lock-in to negotiate before the first calculation runs. Analysts, controllers, and tax managers can open the workbook and start working immediately, keeping the whole team productive from day one of adoption.
Full transparency
Every calculation sits in plain view, so nothing is hidden behind proprietary code or a locked, unreadable interface. You can trace any invoice number, allocation key, or markup straight back to its source data, giving finance and tax teams genuine confidence in the numbers rather than trust placed in a black box.
Flexible & extensible
New entities, transaction types, and pricing policies can be added without raising a change request or waiting on a vendor's development queue for months. The workbook structure flexes around your group as it grows, so the tool keeps pace with restructurings, acquisitions, and new intercompany arrangements as they arise.
Audit-ready by design
External and internal auditors already know how to navigate Excel, so handing them an intercompany calculation workbook they can open and trace themselves speeds up fieldwork considerably. Fewer follow-up questions and much less back-and-forth mean review cycles finish faster, with noticeably less friction overall.
ERP-agnostic
The tool consumes data exported from any ERP — Netsuite, SAP, Oracle, or Microsoft Dynamics — without requiring a dedicated integration project or lengthy IT sign-off before use begins. Groups running several ERPs across different entities can still consolidate everything into one consistent calculation framework.
Fast onboarding
Because the tool sits on top of your existing systems rather than replacing them, implementation is measured in weeks rather than months of configuration. Most groups can go live within two to three weeks, with minimal disruption to finance operations and no lengthy, drawn-out procurement cycle to manage beforehand.
See the IC Tool in action
A live demonstration built on your own intercompany data is the fastest way to see why Excel-based tooling works so well in practice for finance teams. You will see actual entities, actual flows, and actual numbers, rather than a generic sales deck, so the value becomes obvious within the first few minutes of the call.
- Live on your own data
- No new platform to adopt
- Full transparency
- Onboard in 2 – 3 weeks
Frequently asked
Excel-based IC Tool FAQ
Isn't Excel too fragile for this?+
Ad-hoc spreadsheets built by one analyst and passed around by email are genuinely fragile. A structured, version-controlled, Excel-based tool is a different proposition entirely: it combines the transparency finance teams already trust with rigorous data controls and a standardised, repeatable calculation process.
Can it scale to hundreds of entities?+
Yes. The tool is already used by groups running dozens of legal entities and processing hundreds of intercompany transactions every month without performance issues. Where transaction volumes justify it, we connect the workbook to the ERP for automated data feeds, removing manual entry entirely from the process.
What if we outgrow Excel?+
The underlying methodology, cost-allocation logic, and calculation framework are fully portable and independent of Excel itself. When a group eventually migrates to a dedicated intercompany platform, the IC Tool effectively becomes the functional specification that guides and speeds up that migration project.