Multi-Subsidiary AP Aging to Balance Sheet Reconciliation

Client: Large timeshare operator with multiple legal subsidiaries, running multi-subsidiary NetSuite with complex intercompany activity and pre-audit reconciliation requirements across two specific subsidiaries (internally referenced as 87 and 43).

Ahead of an external audit, the finance team was seeing variances between AP aging reports and the balance sheet's AP control account for two subsidiaries. The variance wasn't small enough to wave off and wasn't large enough to obviously point at a specific transaction — it needed to be traced.

Standard Trial Balance filters weren't producing consistent numbers when sliced by subsidiary, and saved searches intended to surface the reconciling journal entries weren't returning signed-net values correctly. Every refinement of the search surfaced a new inconsistency.

The work was time-sensitive — it was blocking audit prep — and the variance had to be explained and closed before numbers could be signed off.

We worked the reconciliation end-to-end over multiple weeks. The first fix was Trial Balance filtering — identifying which filter combinations produced stable subsidiary-level numbers and which silently included or excluded intercompany legs.

The second fix was saved search formulas. Journal entry lines needed signed-net treatment (debits and credits netted per transaction with correct sign retention), and the existing formulas were aggregating in a way that double-counted some lines. We rebuilt the formulas to produce auditable, signed-net results that matched balance sheet movement.

Both subsidiaries reconciled to zero variance. The reconciliation method was documented so the finance team could run the same process quarterly without us.

• Zero variance reconciliation on both subsidiaries (87 and 43)
• Audit prep unblocked and numbers signed off on schedule
• Reusable Trial Balance filter patterns documented
• Signed-net JE formulas in saved searches produce consistent, auditable output
• Finance team can run the same reconciliation independently going forward

Key Takeaways

• Trial Balance filter behavior in multi-subsidiary environments is subtle and easy to get subtly wrong
• Saved search aggregation of signed JE amounts requires explicit formula design — defaults will often double-count
• Reconciliation is a diagnostic exercise, not a report — the method is as valuable as the number