Multi-Entity Consolidation

Running

Started: 12 minutes ago

Objective

Deliver a consolidated trial balance across entities with FX conversion, intercompany eliminations, and variance analysis.

Reduces consolidation cycle by ~2.5 days and removes manual spreadsheet rollups.

Manual hours saved

120 hrs/mo

Close acceleration

2.5 days

Accuracy

98.7%

Est. annual value

$420k

Why This Matters

Manual consolidation spreadsheets create errors and delay close.
Intercompany mismatches require high-touch review each period.
FX rate selection is inconsistent across entities without a standard policy.

Outputs & Controls

Outputs

Consolidated trial balance (USD) and elimination schedule
Supporting schedules by entity with audit trail
Flux analysis package for controller review

Controls

Human review required for unmatched IC amounts or confidence below 85%
FX rate policy FX-001 enforced with audit logs
All source data cached for compliance and audit requests

Run Summary

Status: Running

Last run: Now

Systems: NS, DW, GS

Audit trail: Full action log with timestamps and SOP rules.

Run Notes

Exceptions route to the approvals queue with full context and audit trail. Non-exception items continue without manual intervention.

All source data, decisions, and outputs are logged for controller review and audit support.

Execution Timeline

Pull Trial Balances

Action: Pulled trial balances from 4 entities in NetSuite

Completed

Duration: 34s

Details

Entity US (USD) — 842 accounts
Entity UK (GBP) — 614 accounts
Entity Singapore (SGD) — 388 accounts
Entity Germany (EUR) — 521 accounts

Audit: Full GL detail exported and cached

Next step

Cross-Reference Non-GL Data

Action: Pulled supplementary data from data warehouse

Completed

Duration: 22s

Details

Revenue by entity — sourced from HubSpot via DW
Headcount by entity — sourced from Bob via DW
Contractor spend by entity — sourced from Clockify via DW

Audit: Data warehouse queries logged (3 queries, 2.1s total)

Next step

Currency Conversion

Action: Converted all entities to USD using month-end rates

99%

Completed

Duration: 8s

Details

GBP → USD: 1.2684 (Bank of England month-end)
SGD → USD: 0.7451 (MAS month-end)
EUR → USD: 1.0842 (ECB month-end)

SOP Rule Applied: Use central bank month-end rates per policy FX-001

Next step

Intercompany Eliminations

Action: Identified 6 intercompany transactions for elimination

72%

Awaiting Review

Duration: 18s

Details

US → UK: Management fee $120,000 — ✅ Auto-matched
UK → Singapore: Shared services $45,000 — ✅ Auto-matched
US → Germany: License fee $84,000 — ⚠️ $84K variance detected
└ US recorded $84,000 | Germany recorded €77,500 (≈ $84,022 at spot)
└ Variance: $22 — likely FX timing difference
└ Recommendation: Approve elimination, post FX adjustment of $22

Agent Reasoning

“The $84K intercompany elimination between US and Germany shows a $22 variance. This is consistent with FX timing differences we’ve seen in prior periods. The spot rate at Germany’s booking date (Jan 14) was 1.0839 vs the month-end rate of 1.0842. Recommending approval with a $22 FX adjustment to the US entity. Flagging for human review because the IC elimination SOP requires review of any unmatched amounts.”

Edit:

Next step

Generate Consolidated Output

Action: Blocked — waiting on Step 4 approval

Waiting

Duration: —

Details

Will produce: Consolidated trial balance (USD), elimination schedule, supporting schedules by entity
Output format: NetSuite upload + Google Sheets backup

Next step

Flux Analysis

Action: Blocked — waiting on Step 5

Waiting

Duration: —

Details

Will produce: Period-over-period variance analysis for all material line items (>5% or >$10K change)
Preview (from prior month data):
└ Legal expense +40% vs prior month — driven by Q4 litigation reserve
└ Travel expense -22% vs prior month — seasonal (holiday period)
└ Revenue +8% vs prior month — new Enterprise deals (3)
Output format: Google Sheets + email to Controller