Case Studies Finance Operations

Stabilising Financial Controls and Close Processes for a Multi-Entity, Multi-Currency Group

Engagement Overview
  • Industry: Multi-entity commercial group
  • Functional currencies: USD, EUR, AUD, DKK
  • Accounting system: Microsoft Dynamics NAV (Navision)
  • Engagement type: End-to-end finance operations — ongoing

Executive Summary

A multi-entity group operating across four currencies and several geographic locations engaged Sapphire Digital Accounting Australia to restructure its finance operations. The business was experiencing significant friction across accounts payable and receivable, month-end close, intercompany reconciliations, and audit readiness. Fragmented workflows, the absence of standardised controls, and decentralised documentation had resulted in recurring reconciliation breaks, protracted close timelines, and audit inefficiencies.

Sapphire's engagement team redesigned the end-to-end close and reconciliation architecture, introduced structured workflows across all transactional functions, and implemented a five-day month-end close framework. The result was a material improvement in processing efficiency, a significant reduction in reconciliation variances, and a demonstrably more audit-ready finance function.

Client Overview

The client is a mid-to-large-sized group operating across multiple jurisdictions, with a decentralised operational structure and a complex intercompany funding model. The business's financial operations involve cross-border transactions, legal entity consolidations, and a high volume of payables and receivables activity managed through a number of shared communication channels.

Engagement Scope

The engagement covered the full transactional and period-end finance function. Sapphire assumed operational responsibility for the following areas:

  • Accounts Payable — invoice receipt, three-way matching, approval workflow, vendor payment execution, and aging management
  • Accounts Receivable — invoice issuance, collections tracking, cash application, and debtor reconciliation
  • Month-End Close — period-end cut-off, accruals, journal entry preparation, and Trial Balance sign-off
  • Intercompany Accounting — cross-entity loan schedules, intercompany elimination entries, and balance confirmation
  • Balance Sheet Reconciliations — account-level substantiation and variance commentary
  • Year-End Close and Audit Support — audit file preparation, auditor query management, and year-end adjustments
  • Group Financial Consolidation — entity-level submissions and consolidated reporting

Key Challenges

4.1 Multi-Jurisdiction Complexity

The client's decentralised structure introduced coordination risk across time zones and compliance environments. Approval processes were inconsistent between entities, and documentation standards varied significantly, creating a fragmented control environment that was difficult to audit or scale.

4.2 Unstructured Communication Channels

Finance transactions were being initiated and tracked across multiple shared email inboxes — segmented by function (vendor invoices, customer queries, intercompany communications) but without centralised oversight. This created a material risk of duplicate processing, missed items, and incomplete audit trails.

4.3 Multi-Currency Exposure and Revaluation Risk

The group transacted in four currencies with no standardised exchange rate policy. This resulted in inconsistent forex conversion approaches across entities, unreliable revaluation entries, and difficulty reconciling intercompany balances where the same transaction was recorded at different rates by different parties.

4.4 Intercompany Reconciliation Breaks

Frequent cross-entity funding transactions were not being reconciled on a consistent cycle. Mismatches arose from timing differences, inconsistent currency conversion, and recording errors — none of which were systematically identified or resolved within the month-end window.

4.5 Month-End Close Delays

There was no structured close calendar. The absence of a sequenced close plan, combined with upstream reconciliation backlogs and incomplete data submissions from entities, meant the close process was reactive and unpredictable — routinely extending beyond an acceptable window.

4.6 Audit Preparedness Deficiencies

Supporting documentation was dispersed across email inboxes, shared drives, and individual workstations without consistent folder structures or naming conventions. Audit queries required significant manual effort to resolve, and the lack of structured reconciliation backups created repeated audit findings.

Approach and Solution

5.1 Centralised Inbox Governance

Rather than consolidating multiple inboxes — which carried operational risk during transition — the team introduced a structured master tracking register across all shared inboxes. Each incoming item was categorised, timestamped, and assigned to an accountable owner under a defined SLA framework. A duplication control mechanism was implemented to flag items processed across channels, and a daily review checklist was introduced as a standard operating procedure.

The rationale for this approach was to impose control at the point of receipt rather than attempting a disruptive system change — ensuring coverage without creating transition gaps.

5.2 Accounts Payable Process Redesign

The AP function was restructured around a standardised four-stage processing workflow: invoice receipt, three-way matching against purchase orders and goods receipt notes, structured approval routing, and ERP posting. Vendor master governance controls were introduced to prevent unauthorised supplier additions or bank detail changes.

Weekly scheduled payment runs replaced ad-hoc disbursements, providing treasury visibility and reducing the risk of duplicate payments. Creditor aging reports and monthly vendor reconciliation statements were introduced as standard deliverables.

5.3 Accounts Receivable Discipline

A structured AR collection tracker was implemented, supported by standardised follow-up communication templates and a clear escalation path. Cash application was formalised through direct mapping against open invoice ledgers, reducing unallocated receipts and improving the accuracy of debtor balances at period-end.

5.4 Multi-Currency Accounting Framework

A group-wide exchange rate policy was documented and implemented, prescribing monthly average rates for transaction recording and closing rates for balance sheet revaluation. Forex gain and loss calculations were standardised across entities, with currency-specific reconciliation schedules and variance analysis introduced as a month-end control.

This eliminated the rate inconsistency that had previously caused intercompany mismatches and ensured comparability of entity-level results during consolidation.

5.5 Intercompany Reconciliation Model

An intercompany matrix was maintained covering all lending and borrowing entities, with monthly cross-confirmation of balances between counterparties. Timing differences were documented and cleared within defined windows, and currency conversion was standardised to the agreed rate policy. This reduced the volume of elimination adjustments required at consolidation and improved confidence in intercompany loan schedules.

5.6 Five-Day Month-End Close Framework

A structured, day-sequenced close plan was introduced:

  • Days 1–2 — Accounts Payable and AR cut-off; bank transaction posting; accrual identification
  • Day 3 — Intercompany entries; accruals and prepayments posting
  • Day 4 — Bank, general ledger, and sub-ledger reconciliations
  • Day 5 — Management review; Trial Balance finalisation; P&L and Balance Sheet issuance

The framework provided predictability across the close cycle and enabled earlier identification of exceptions. Standard close deliverables — Trial Balance, P&L, Balance Sheet, and variance commentary — were defined and issued within the five-day window.

5.7 Balance Sheet Substantiation

Account-level reconciliation schedules were prepared for all balance sheet lines, with supporting documentation attached and clear explanations for variances. Monthly review meetings were introduced to sign off reconciliations before close, with year-end deep-dive analysis conducted in preparation for audit.

5.8 Audit Readiness Infrastructure

A structured audit file was maintained throughout the year, organised by balance sheet line and supported by GL extracts, reconciliation statements, and source documentation. Auditor queries were managed through a centralised query log, with responses coordinated across departments to minimise turnaround time and reduce the risk of inconsistent information being provided to auditors.

Tools and Systems

The following systems and tools underpinned the engagement:

  • Microsoft Dynamics NAV (Navision) — primary ERP for transaction processing, GL management, and financial reporting
  • Excel-based reconciliation models — structured templates for balance sheet substantiation, intercompany matrices, and currency reconciliations
  • Shared inbox management and tracking registers — centralised control across multiple communication channels
  • Cloud-based document storage — structured audit file maintenance and version-controlled reconciliation backups

Results and Impact

The following outcomes were observed over the course of the engagement. Where quantified improvements are cited, they reflect direct measurement against pre-engagement baselines established during the diagnostic phase.

Area Baseline State Post-Engagement State
Invoice processing cycle Unstructured; no SLA in place 40% reduction in average processing time
Month-end close duration Variable; frequently exceeded target 30% reduction in close cycle duration; consistent 5-day delivery
Intercompany reconciliation Monthly breaks; no standard resolution process Structured monthly confirmation; breaks identified and cleared within period
Audit query turnaround Ad-hoc; time-intensive for finance team Centralised query log; materially reduced response time
FX revaluation accuracy Inconsistent rates applied across entities Standardised rate policy; clean entity-level and consolidated FX position
Reconciliation coverage Partial; no consistent balance sheet substantiation Full account-level coverage; supporting documentation attached

Audit outcome: The year-end audit was completed with minimal audit adjustments and a significantly reduced volume of queries compared to prior periods. No material control weaknesses were identified in transactional processes.

Conclusion

This engagement demonstrates the operational and control improvements achievable when structured finance processes are applied consistently across a complex, multi-entity environment.

The core value delivered was not efficiency improvement in isolation — it was the establishment of a control environment that gave management reliable financial information within predictable timeframes, and gave the audit process a clean, well-documented trail to work from.

For finance leaders managing similar complexity — whether across multiple entities, currencies, or jurisdictions — the principal discipline remains the same: process standardisation and structured reconciliation are the foundation on which everything else depends. Technology and offshore capacity can scale delivery, but they cannot substitute for that foundation.

Key Results

40%
Reduction in Invoice Processing Time
30%
Faster Month-End Close Cycle
5-Day
Standardised Close Framework
100%
Reconciliation Coverage Achieved