Multi-company financial consolidation for Philippine business groups

Many Philippine businesses grow into groups of companies: separate corporations for retail, distribution, manufacturing, logistics, real estate or new branches. Each company keeps its own books, but owners and lenders want to see the group as one. Financial consolidation combines the companies' statements and removes transactions between them, so the group's results are not inflated by internal sales, loans and charges.

Why consolidation is hard

• Each company uses a different chart of accounts
• Intercompany transactions are recorded on one side but not the other, or at different amounts
• Companies close on different timelines
• Consolidation happens in spreadsheets maintained by one person
• Management reports and statutory statements use different numbers

Step 1: Standardize the chart of accounts

Adopt a common chart of accounts for all companies, with entity-specific accounts only where necessary. If companies must keep local accounts, map them to a group chart. Standard structure makes every later step easier and enables comparisons between companies.

Step 2: Make intercompany transactions visible

Typical intercompany transactions in Philippine groups:

• Sales of goods between a manufacturing and a distribution company
• Management fees and shared services charges
• Rent between a property company and operating companies
• Advances and loans between companies
• Employees transferring between companies

Record each with intercompany account codes that identify the counterpart company, and agree amounts monthly. A transaction recorded by one company should be recorded by the other in the same period.

Step 3: Reconcile intercompany balances

Before consolidation, compare each pair of companies' intercompany receivables and payables, and sales and purchases. Resolve differences by agreed rules (for example, the seller's invoice prevails) by a fixed day of the close.

Step 4: Eliminate

In consolidation:

• Eliminate intercompany receivables and payables against each other
• Eliminate intercompany sales and purchases so group revenue reflects sales to outside customers only
• Remove unrealized profit on inventory still held within the group
• Eliminate investments in subsidiaries against their equity
• Account for non-controlling interests where ownership is less than 100%

Complex structures and statutory consolidation require your auditor's input on the applicable standards.

Step 5: Report

Produce consolidated management reports monthly, with drill-down to each company. Statutory consolidated statements follow annual requirements.

A monthly consolidation calendar

Agree the calendar with every company's finance team and publish it for the year.

Management consolidation vs. statutory consolidation

Get management consolidation working in the system first; statutory consolidation then becomes a refinement, not a rebuild.

Systems that make consolidation routine

A multi-company system should:

• Keep each company's books separate with its own registrations and filings
• Share a common chart of accounts and master data
• Record intercompany transactions on both sides automatically where possible
• Produce consolidated and per-company reports from the same data

Cirquolus supports one or several companies with multiple branches, and financial management connects payables, receivables, journals, trial balance and financial statements. For broader ERP considerations, read ERP for groups of companies.

Frequently asked questions

What is financial consolidation?

Combining the financial statements of related companies into one set for the group, after removing transactions and balances between them.

What are intercompany eliminations?

Adjustments that remove internal sales, purchases, receivables, payables and investments between group companies so consolidated figures reflect only dealings with outsiders.

Do all groups need consolidated financial statements?

Requirements depend on ownership structure and applicable reporting standards. Management consolidation is useful for any group; consult your auditor on statutory requirements.

How long should monthly consolidation take?

With a common chart of accounts and integrated intercompany recording, management consolidation can be produced within days of month-end.