This is a well-known gap — and the workarounds described above (G/L dimensions, recurring journals, external Excel schedules) are exactly what companies end up with before looking for a dedicated solution.
We built TreasuryView specifically to address this problem for finance teams managing bank and intercompany loan portfolios. It's a standalone cloud SaaS — not a BC extension — which means it sits alongside your BC environment and handles the loan lifecycle that BC was never designed to manage natively.
Directly relevant to your client's scenario:
- Both sides of intercompany lending are tracked simultaneously — loan receivable in the lending entity, loan payable in the borrowing entity — with a single loan record driving both (mirroring)
- Automated amortization schedules are generated from the loan parameters (principal, rate type, margin, tenor, repayment structures, capitalizations) — no manual schedule maintenance
- Interest accrual tracking with support for floating rate benchmarks plus fixed and mixed structures, including day-count conventions
- Repayment tracking with actual vs. scheduled reconciliation — you can see at a glance if a repayment is outstanding
- Audit trail on every calculation and every change — critical for intercompany arrangements that need to withstand a transfer pricing review
- Market rate feeds integrated natively, so floating rate interest calculations update automatically without manual lookups
On the ERP side: TreasuryView doesn't write back to BC's GL (by design — we stay on the right side of the Agency Radius), but it exports clean .xls journal-ready data for interest accruals and repayments that your client's team posts into BC. In practice this is far cleaner than trying to automate GL writes through a custom extension, and it keeps the two systems' responsibilities clearly separated.
Onboarding: Sub-one-day setup. No implementation project, no IT dependency, no consultant required. Loan data can be imported directly or entered manually. The free 30-day trial includes full access to the computation engine — real data, real calculations, not sample data.
Pricing: $290/month, cancel anytime. For a group company actively managing intercompany loans on a commercial basis, the governance and accuracy benefit typically pays for itself in the first month-end close.
Worth a look: www.treasuryview.com — the free trial is the fastest way to evaluate fit for your client's specific structure.
Happy to answer specifics if you want to describe the loan structure in more detail (number of entities, fixed vs. floating, currencies involved).
