How to Automate Intercompany Loans Tracking and Ensure Audit-Ready Precision after Spreadsheets?

Build a System of Record in 3 Days.

Book a LIVE demo

Author: Lars Gratza

Managing Intercompany Loans in Excel? And it does not work any more...

If you manage intercompany loans in Excel, you already know the pattern:

  • Lender file.
  • Borrower file.
  • Monthly interest tab.
  • “final_v3_updated_real_final.xlsx”.

It works. Until it doesn’t.

Once you pass 20–30 loans across multiple entities, spreadsheets stop being flexible and start becoming fragile. Balances drift. Interest calculations get manually adjusted. Month-end becomes reconciliation instead of reporting.

This guide shows how to move from scattered Excel files to a centralized intercompany loan system in 2–3 days.

PS: it is no heavy IT projects.

See more about Intercompany Loan management. 

TL;DR

Problem:

  • Error-prone spreadsheets
  • Lender/borrower balances don’t tie
  • Manual accruals
  • No audit trail
  • Reporting takes days

Solution:

  • Centralized intercompany loan database
  • Mirrored lender/borrower logic
  • Automated interest accruals
  • Forward-looking cash flow visibility
  • Full audit trail
  • Controlled user access

Time to value:

First clean portfolio operational in 2–3 days

Results observed:

  • Reporting time reduced up to 50% 
  • Reconciliation breaks close to zero
  • Audit requests handled within hours

The Real Problem: Most Intercompany Loan Processes start in Excel

At first, it feels efficient. But at one point, problems accure.

80% clients turn to us, have similar problems: 

  • Someone overwrites a formula.
  • A fixing date assumption is wrong.
  • A margin was changed but not documented.
  • One entity updated their file. The other didn’t.

Now balances don’t match.

80% clients turn to us, have similar characteristics:

  • 50–150 intercompany loans
  • Annual renewals
  • Multiple currencies
  • Rolling 3M benchmarks
  • Historic transactions must remain untouched

Spreadsheets break with this. 

A Professional Intercompany Debt Setup has:

No IT needed, no setup fee. 

 One single source of truth.

Zero calculation errors. 

1. Complete dashboard overview

See all loans, interest, amortization schedules, and termination dates in one place. At once. 

2. Automated calculations and statements:

Accruals, interest, and reporting generated automatically for every loan 

3. Centralized approval workflows

Changes and updates go through controlled, auditable processes 

3. Full audit trail

Every change tracked, timestamped, and fully transparent 

Try treasuryview out for free
demo with our expert

Step-by-Step:
How to Replace Your Excel Intercompany Setup to One Automated System

Step 1.
Import Your Existing Excel Portfolio. No need to build tracking from scratch.

Simple process:

  • Upload Excel matrix
  • Map fields (nominal, rate type, margin, reset frequency, maturity, entities)
  • Validate conventions and holiday calendars.
  • Run preview cashflows

Expected result in TreasuryView:

  • Full portfolio is visible
  • Monthly interest schedule generated
  • Residual debt reports available

PRO TIP:

For quick win, start with the 10 biggest positions first. 

Step 2.
Remove Double Entry With a Mirrored Intercompany Loan

Create one loan and show it under both entities automatically. Process:

Create one intercompany loan:

  • Select lender
  • Select borrower
  • Set currency
  • Define interest logic
  • Enable mirroring

Expected outcome in TreasuryView:

  • Balances tie by design.
  • Reconciliation disappears as a recurring task.

Step 3.
Set Arm’s-Length Rates and Document Them

Goal: Pricing you can defend in front of auditors.

Process: 

  1. Loan → Terms → choose base rate, margin policy, rounding. 
  2. Loan → Documents → attach transfer pricing memo or benchmark quotes. 
  3. Log version notes so approvals are clear. 

Expected outcome in TreasuryView: Rates trace back to a source. Documentation travels with the loan.

Step 4.
Capture IFRS 9 Fields and Automate Monthly Statements

Goal: Cut close time and keep auditors happy.

Process: 

  1. Loan → Accounting → set classification and EIR notes if used. 
  2. Automation → Interest Runs → schedule monthly interest, recipients, format [PDF/XLS]. 
  3. Test a run for the current period, then verify totals against a control loan. 

Expected outcome in TreasuryView: Statements arrive on time. Accruals and payments match policy. 

Step 5.
Create Your Own Dashboard with Relevant Reports

Goal: See all your key KPIs at a glance. 

Process: 

  1. Portfolio View -> Choose your Report -> Edit your Report -> Add to dashboard 

Expected outcome in TreasuryView: Audit ready reports and KPIs visible with a few clicks. 

Try treasuryview out for free

Ready to have your debt closing Month-End without usual Firefighting?

Month-end loan manager checklist

  • Re-run all accruals and interest calculations automatically to ensure accuracy 
  • Verify nominal balances for both lenders and borrowers in one central system 
  • Export monthly statements and accounting files for internal reporting and finance systems 
  • Prepare the audit pack including loan terms, supporting documents, change log, and monthly results 

The "Day-Close" Checklist:

  • Instant Re-Calculation: Run all accruals and interest calculations globally with one click to ensure 100% mathematical certainty. 
  • Single-Source Verification: Verify nominal balances for both lenders and borrowers in a unified system—no more cross-checking two different spreadsheets. 
  • One-Click Accounting Export: Generate monthly statements and accounting files ready for upload into your ERP or finance systems.
  • Automated Audit Pack: Instantly compile the full audit trail 

Results You can Expect from Using TreasuryView for your
Intercompany Debt Management

up to
50%

Month-end prep time cut – within the first 4 weeks of using a centralized system .

near
zero

Reconciliation breaks reduced, eliminating manual corrections across entities 

hours, not days/weeks

to close audit requests, accelerating review cycles by 5-10 days. 

clear visibility of interest cost

of intercompany loans by entity, loan, and currency, enabling faster decision making 

Ready to take your intercompany loans out from Excel and remove structural risk from multi-entity intercompany funding?

Try treasuryview out for free
demo with our expert

FAQ: Intercompany Loan Management Beyond Spreadsheets

Accounting teams can create journal entries directly from the loan record. Accruals, interest, and principal postings are automatically generated.
Yes. The mirror setting in TreasuryView ensures that lender and borrower see one synchronized record.
 
Every change is tracked in the audit trail for full transparency. 
Set an arm’s-length interest rate in line with transfer pricing rules.
 
Store your rate decision and supporting documentation in the internal memo attached to the loan record for audit purposes. 

Yes. Loan classification and expected interest rate (EIR) notes can be captured within the system, making IFRS 9 reporting and disclosures straightforward. 

“One record. Two views.” Lender and borrower see the same loan, automatically generating balanced accounting entries without manual duplication. 

Yes. Monthly statements, reports, and accounting exports can be generated in Excel or PDF formats.

Intercompany loans integrate seamlessly into broader position management.

Cash flows, netting, and internal funding can all be tracked centrally alongside loans, providing a complete view of group financing. 

You can modify an existing intercompany loan in several ways. Edit the loan directly to update interest rates, maturities, or other deal details, or create a new tranche with updated terms while keeping the original record intact.

Yes. Loan limits are controlled via the nominal amount, ensuring no entity exceeds its approved borrowing or lending capacity.

Current exposure and any potential additional drawdowns are always visible, making it easy to monitor and manage credit risk in real time. 

Each intercompany loan has its own interest and repayment schedule, which can be reviewed for any desired period.

Clear dashboards and reports allow you to track interest and principal payments in real time, ensuring full visibility across all loans and entities. 

Late or missed payments can be manually recorded in the loan’s interest and repayment schedule. The system then automatically recalculates interest, ensuring accurate balances and updated payment tracking. 

Each intercompany loan can be assigned its own currency.

If desired, a single reporting currency can be selected for all loans to consolidate results. Exchange rates are updated daily, ensuring accuratevaluation and transparent reporting across entities. 

Changes such as modified maturities, updated interest rates, or increased nominal amounts can be applied at any time for all loan details. A full audit trail ensures that every change is tracked and fully transparent. 

No, TreasuryView is not intercompany netting software.

TreasuryView is purpose-built for debt, intercompany loan management, hedge, and FX exposure management—not for operational payment netting or clearing cycles .

That means, TreasuryView manages:

  • Intercompany loan tracking (principal, interest, multi-currency)
  • Mirrored lender/borrower positions
  • Interest accrual automation
  • Audit trails and reporting
  • FX and interest rate risk analytics

TreasuryView does not:

  • Execute multilateral netting runs
  • Offset payable/receivable invoices
  • Automate settlement clearing cycles

However, intercompany loans can be tracked alongside broader funding and exposure management, so you still get full visibility of internal financing positions.

See more closely what TreasuryView is.

See more FAQ about Treasury Management System or Contact us in any questions/concerns. 

Scroll to Top