Consolidated Balance Sheet — Complete User Guide — Two Accounts Web

Comprehensive guide for generating, analysing, and understanding the Consolidated Balance Sheet — combining multiple divisions or business segments into a single financial picture

Table of Contents

1. What Is the Consolidated Balance Sheet?
   • Division-Based Consolidation
   • How It Differs from the Standard Balance Sheet
2. Enabling from the Customize Menu
3. Field-by-Field Guide
   • Report Header Fields
   • Report Columns (Periods)
   • Report Footer
4. Settings Configuration
   • Divisions
   • Interdivisional Loan Account
5. Creating a Consolidated Balance Sheet Report
6. How the Consolidated Balance Sheet Is Calculated
   • Transaction Loading and Pre-Processing
   • Per-Division Balance Calculation
   • Interdivisional Elimination
   • Consolidated and Elimination Columns
7. Drill-Down Capabilities
8. Sample Data and Report Output
   • Sample Setup
   • Standard Division Balance Sheets
   • Consolidated Balance Sheet Output
   • Verification of Calculation
9. Common Issues and Solutions
10. Accounting Regulation Compliance

1. What Is the Consolidated Balance Sheet?

The Consolidated Balance Sheet combines the financial positions of multiple divisions or business segments within a single company into one unified report. It shows the overall financial position of the entire business as if all divisions were a single entity.

This is specifically a division-based consolidation — all divisions are part of the same legal entity (same company database) but are tracked separately using the Division field on transactions. This is distinct from multi-entity group consolidation which combines separate legal entities (parent + subsidiaries).

1.1 Division-Based Consolidation

In business scenarios where a single legal entity operates through multiple divisions (e.g., "Retail Division," "Wholesale Division," "Export Division"), each division can be tracked independently using the Division field on transactions. The Consolidated Balance Sheet combines these divisions and eliminates inter-division balances.

1.2 How It Differs from the Standard Balance Sheet

2. Enabling from the Customize Menu

The Consolidated Balance Sheet report is a standard report — it is always available under:

• Reports → Financial Statements → Consolidated Balance Sheet

No toggle in Customize Menu is needed to enable it. However, the following related settings have their own tab dependencies:

For the Consolidated Balance Sheet to produce meaningful results, you must have at least two Divisions defined, and transactions must be tagged with those Divisions.

3. Field-by-Field Guide

3.1 Report Header Fields

Location: Reports → Financial Statements → Consolidated Balance Sheet → New Report

3.2 Report Columns (Periods)

Each period represents a "snapshot" date. When a Division is specified, the report adds extra columns to show the consolidation process.

3.3 Report Footer

The Footer field accepts multi-line text. Common uses include:

• Disclosure of consolidation methodology (e.g. "Inter-division balances have been eliminated")
• Segment reporting notes
• Date of authorisation
• Rounding conventions

4. Settings Configuration

4.1 Divisions

Location: Settings → Divisions

Divisions are the building blocks of the consolidated report. Each division represents a separate business segment, department, or operational unit within the same company.

How divisions are assigned to transactions:

• Sales invoices, receipts — set the Division at the header level or per-line
• Purchase invoices, payments — set the Division at the header level or per-line
• Journal entries — set the Division on each journal entry line
• Payslips — Division can be set per earnings/deduction/contribution line
• Opening balance entries — Division field available
• Employee, Customer, Supplier records — default Division can be assigned, auto-populating new transactions

4.2 Interdivisional Loan Account

Location: Settings → Chart of Accounts → Balance Sheet → Interdivisional Loan

The Interdivisional Loan account is a system account that serves as the clearing account for interdivisional balances. It appears automatically in the Chart of Accounts under Balance Sheet.

Two mechanisms create balances in this account:

5. Creating a Consolidated Balance Sheet Report

1. Set up Divisions — Go to Settings → Divisions, create at least two divisions (e.g. "Retail" and "Wholesale")
2. Tag transactions — Ensure transactions are assigned to divisions (Sales Invoices, Purchase Invoices, Payments, Receipts, Journal Entries, etc.)
3. Go to Reports → Financial Statements → Consolidated Balance Sheet
4. Click New Report
5. Enter a Title (optional)
6. Enter a Description (optional)
7. Choose the Accounting Method — Accrual or Cash Basis
8. Choose the Layout
9. Add Periods — one per division you want to consolidate:
   • Click Add to add a period row
   • Enter the Date (same date for all divisions being consolidated)
   • Select the Division (e.g. "Retail" for first row, "Wholesale" for second)
   • Optionally enter a custom Column Name
   • Add additional periods for comparative dates if needed
10. Optionally adjust Rounding, Exclude Zero Balances, Show Account Codes
11. Optionally select Groups to Collapse
12. Click Save
13. The report generates with columns for each division, a "Consolidated" column (sum), and an "Eliminations" column (interdivisional adjustments)

6. How the Consolidated Balance Sheet Is Calculated

This section explains the calculation logic behind the Consolidated Balance Sheet. Understanding these concepts helps you interpret the numbers and troubleshoot unexpected results.

6.1 Transaction Loading and Pre-Processing

When the Consolidated Balance Sheet is generated, the system first loads all General Ledger transactions and applies several pre-processing steps identical to the standard Balance Sheet:

1. Cost of Goods Sold Calculation — determines COGS based on inventory valuation method
2. Fixed Asset Disposal Entries — generates reversing entries for disposed assets
3. Intangible Asset Disposal Entries — same for disposed intangible assets
4. Realised Investment Gains/Losses — calculates gains or losses on investments

If Cash Basis is selected, invoices are matched to receipts/payments and converted to cash basis.

6.2 Per-Division Balance Calculation

For each period column (each division), the following calculation is performed:

Step 1 — Revalue foreign currency accounts up to the period date
Step 2 — Filter all transactions on or before the period date
Step 3 — Filter transactions to the specific Division for this column
Step 4 — Group by Balance Sheet account
Step 5 — Sum the base currency amount for each account

Division Balance = Sum of (base currency amount) for all transactions
    where the account is a Balance Sheet account
    and the date is on or before the period date
    and the Division matches this column's Division

6.3 Interdivisional Elimination

The key step that makes this a "Consolidated" Balance Sheet is the interdivisional elimination. There are two elimination mechanisms that work together:

Mechanism 1 — Real Interdivisional Transactions Naturally Cancel

When you record an actual interdivisional loan or transfer (via Inter Account Transfer or Journal Entry), the same amount appears as a Dr in one division and a Cr in another division. When the division balances are summed, these entries naturally offset:

Division A (Retail) has:
    Cash:                  200,000
    Loan to B:             100,000  (Dr — asset, money owed by B to A)
    Other Assets:          300,000
    Payables:              150,000
    Equity:                450,000
    Sum:                        0 ✓  (each division balances on its own)

Division B (Wholesale) has:
    Cash:                  150,000
    Loan from A:           100,000  (Cr — liability, money owed to A)
    Other Assets:          200,000
    Payables:              100,000
    Equity:                150,000
    Sum:                        0 ✓

Consolidated (sum of all division columns):
    Interdivisional Loan:        0  (100,000 Dr + 100,000 Cr = 0 — fully eliminated)
    All other accounts:    sum of Division A + Division B
    Sum:                        0 ✓  (consolidated also balances)

This is the NORMAL case. No additional elimination entry is needed.
The Eliminations column shows zero for the Interdivisional Loan account.

Mechanism 2 — Computed Balancing Figure (Safety Net)

After summing all division balances, the system performs a check. If the total of all division balances is NOT zero, it means there are uneliminated interdivisional differences. The system posts the reverse difference as a computed balancing entry to the Interdivisional Loan account:

Sum of all division balances = Total Assets − Total Liabilities − Total Equity
    across all divisions combined

If the sum is NOT zero:
    Difference = Sum(all division balances)
    System posts a virtual entry:
        Cr (or Dr) Interdivisional Loan: Difference × (−1)
    This amount appears in the "Eliminations" column
    The Consolidated column now balances (Assets = Liabilities + Equity)

Example — Unbalanced divisions:

If Division A has a loan receivable of 50,000 from Division B, but Division B
has NOT recorded the corresponding loan payable, then Division A shows a Dr of
50,000 with no matching Cr in Division B.

The sum of all division balances = 50,000 (not zero).
The system adds:
    Cr Interdivisional Loan (Eliminations): 50,000
    This makes the Consolidated column balance.

This indicates an issue — every interdivisional transaction should have a
matching entry in the other division. The computed figure is a safety net,
not a replacement for proper interdivisional accounting.

6.4 Consolidated and Elimination Columns

When at least one period has a Division assigned, the report generates three column types:

Important: The Consolidated column is NOT simply the sum of division columns. It equals the sum of all division columns PLUS the eliminations column. In normal operation (when all interdivisional transactions are properly recorded on both sides), the eliminations column is zero and the Consolidated column equals the sum of division columns. A non-zero eliminations column indicates that some interdivisional entries are missing or unbalanced.

7. Drill-Down Capabilities

Each amount in the division columns is clickable (except the Interdivisional Loan row). Clicking any account balance opens a transaction viewer showing the individual General Ledger transactions that make up that amount.

Each drill-down view displays:

• Date — the transaction date
• Transaction — the document type and reference
• Division — which division the transaction belongs to
• Counterparty — customer, supplier, or employee name
• Amount — the transaction amount in base currency
• Running Balance — cumulative balance after each transaction

8. Sample Data and Report Output

8.1 Sample Setup

A company operates two divisions: Retail Division and Wholesale Division. Both are part of the same legal entity but tracked separately via the Division field.

Opening Balances (1 January 2026)

Verification — each division balances independently:
  Retail Division:      100 + 200 + 150 + 300 + 80 − 120 − 500 − 130 = 0 ✓
  Wholesale Division:    50 + 100 + 80 + 200 + 0 − 60 − 80 − 200 − 90 = 0 ✓

Transactions During January 2026

Ending Balances (31 January 2026) — Per Division

8.2 Standard Division Balance Sheets

Retail Division (unconsolidated)

Retail Division — Balance Sheet
As at 31 January 2026
                                        Amount (BDT)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
ASSETS
  Cash at Bank                             150,000
  Accounts Receivable                      250,000
  Inventory                                150,000
  Fixed Assets (net)                       300,000
  Interdivisional Loan                     100,000
Total Assets                               950,000

LIABILITIES
  Accounts Payable                          70,000

EQUITY
  Capital — Owner                          500,000
  Retained Earnings                        380,000
Total Liabilities & Equity                 950,000

Wholesale Division (unconsolidated)

Wholesale Division — Balance Sheet
As at 31 January 2026
                                        Amount (BDT)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
ASSETS
  Cash at Bank                              60,000
  Accounts Receivable                      400,000
  Inventory                                180,000
  Fixed Assets (net)                       200,000
Total Assets                               840,000

LIABILITIES
  Accounts Payable                         160,000
  Interdivisional Loan                     100,000

EQUITY
  Capital — Owner                          200,000
  Retained Earnings                        380,000
Total Liabilities & Equity                 840,000

8.3 Consolidated Balance Sheet Output

Consolidated Balance Sheet — All Divisions
As at 31 January 2026
                        Retail     Wholesale   Elim.    Consolidated
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
ASSETS

Cash at Bank           150,000     60,000          0       210,000
Accounts Receivable    250,000    400,000          0       650,000
Inventory              150,000    180,000          0       330,000
Fixed Assets (net)     300,000    200,000          0       500,000
Interdivisional Loan   100,000          0   (100,000)           0

Total Assets           950,000    840,000   (100,000)    1,690,000

LIABILITIES

Accounts Payable        70,000    160,000          0       230,000
Interdivisional Loan         0    100,000   (100,000)           0

Total Liabilities       70,000    260,000   (100,000)      230,000

EQUITY

Capital — Owner        500,000    200,000          0       700,000
Retained Earnings      380,000    380,000          0       760,000  ¹

Total Equity           880,000    580,000          0     1,460,000

Total Liab. & Equity   950,000    840,000   (100,000)    1,690,000

Note ¹: Retained Earnings is 380,000 + 380,000 = 760,000. This includes the current period profit from both divisions (Retail: 200,000 revenue − 30,000 salary = 170,000; Wholesale: 300,000 revenue − 10,000 rent = 290,000; Total profit = 460,000 added to opening RE of 220,000 + the 80,000 interdivisional interest adjustment).

8.4 Verification of Calculation

CONSOLIDATED ACCOUNTING EQUATION:
  Total Assets:    210,000 + 650,000 + 330,000 + 500,000 + 0 = 1,690,000
  Total Liabilities: 230,000 + 0 = 230,000
  Total Equity:      700,000 + 760,000 = 1,460,000
  1,690,000 = 230,000 + 1,460,000 ✓

ELIMINATION VERIFICATION:
  Interdivisional Loan:
    Retail:  100,000 Dr  (asset — loan receivable from Wholesale)
    Wholesale:  (100,000) Cr  (liability — loan payable to Retail)
    Combined: 0 ✓  (naturally offsetting)
    
  The Eliminations column shows (100,000) — the reversal of Wholesale's
  interdivisional loan liability, so the consolidated entity shows no
  loan between its own divisions.

DIVISION BALANCE VERIFICATION:
  Retail:    Assets = 150 + 250 + 150 + 300 + 100 = 950,000
            Liab + Eq = 70 + 500 + 380 = 950,000 ✓
  Wholesale: Assets = 60 + 400 + 180 + 200 = 840,000
            Liab + Eq = 160 + 100 + 200 + 380 = 840,000 ✓

CONSOLIDATED:
  Assets: 950,000 + 840,000 + (100,000) elimination = 1,690,000 ✓
  Liab:   70,000 + 260,000 + (100,000) elimination = 230,000 ✓
  Equity: 880,000 + 580,000 = 1,460,000 ✓

DR = CR VERIFICATION (all transactions):
  Total Debits:  200,000 (AR-R) + 300,000 (AR-W) + 150,000 (Cash-R)
                 + 100,000 (Inv-W) + 50,000 (AP-R) + 20,000 (Loan-R)
                 + 20,000 (Cash-W) + 30,000 (Salary-R) + 10,000 (Rent-W)
                 = 880,000
  Total Credits: 200,000 (Sales-R) + 300,000 (Sales-W) + 150,000 (AR-R)
                 + 100,000 (AP-W) + 50,000 (Cash-R) + 20,000 (Cash-R)
                 + 20,000 (Loan-W) + 30,000 (Cash-R) + 10,000 (Cash-W)
                 = 880,000
  DR = CR ✓

9. Common Issues and Solutions

9.1 Consolidated Column Does Not Balance

Cause: The sum of all division balances is non-zero, and the computed balancing figure could not resolve the difference. This can happen when significant interdivisional transactions are recorded on only one side (e.g., Division A shows a loan receivable but Division B has no matching loan payable), or when many transactions lack a Division assignment.

Solution: Check the Eliminations column — if the Interdivisional Loan account shows a non-zero amount in the eliminations, it means the divisions do not balance naturally. Review all interdivisional transactions and ensure each has a matching entry in the other division. Use Inter Account Transfer to record both sides. Also verify that all transactions have a Division assigned — unassigned transactions do not appear in any division column.

9.2 Interdivisional Loan Account Has Balance After Consolidation

Cause: Interdivisional loans between divisions are not perfectly mirrored — one division recorded a loan receivable but the other division did not record the corresponding loan payable.

Solution: Review all inter-division transactions. For every loan from Division A to Division B, there must be a matching entry: Dr Loan Receivable in A and Cr Loan Payable in B (or Cr Cash in A and Dr Cash in B). The amounts must match exactly.

9.3 Transactions Missing from Division Columns

Cause: Transactions without a Division field set do not appear in any division column. They only contribute to the Consolidated column indirectly through the elimination mechanism.

Solution: Ensure all transactions have a Division assigned. This can be set at the transaction header level or per-line depending on the document type. Use the drill-down to identify which transactions are unassigned.

9.4 Consolidated Total Differs from Standard Balance Sheet

Cause: The standard Balance Sheet shows ALL transactions (including unassigned ones). The Consolidated Balance Sheet only includes transactions assigned to the divisions included in the report periods. If some transactions lack a Division, the two reports will differ.

Solution: This is expected behaviour if you have unassigned transactions. To make the Consolidated report match the standard BS, ensure every transaction has a Division and include all divisions in the report periods.

9.5 Multiple Periods with Different Dates

Cause: If your report has periods with different dates (e.g., Retail at 31-Jan and Wholesale at 28-Feb), the columns show balances as at different dates, and the Consolidated column would mix dates — which is not meaningful.

Solution: For a valid consolidated balance sheet, all period rows should have the same Date. Use different dates only for comparative analysis (e.g., Q1 vs Q2 consolidated).

9.6 Eliminations Column Shows Unexpected Amounts

Cause: The elimination mechanism only operates on the Interdivisional Loan account. If the Eliminations column shows a non-zero amount in the Interdivisional Loan row, it means the divisions do not balance naturally — some interdivisional transactions are missing their matching entries on the other side.

Solution: Review all interdivisional transactions (Inter Account Transfers, Journal Entries, or any transaction that credits one division and debits another). Every interdivisional Dr must have a corresponding interdivisional Cr in another division. If the amounts do not match, the computed elimination figure ensures the consolidated report still balances. To resolve, record the missing entries or correct the mismatched amounts. If the Eliminations column shows activity in accounts other than Interdivisional Loan, verify that no manual Journal Entries directly reference the Interdivisional Loan account.

9.7 Drill-Down on Interdivisional Loan Returns No Transactions

Cause: The Interdivisional Loan balance in the Eliminations column is a computed balancing figure, not from actual transactions. Therefore, no drill-down is available.

Solution: This is by design. To see the underlying interdivisional transactions, drill into the Interdivisional Loan amounts in the individual division columns instead.

10. Accounting Regulation Compliance

10.1 IFRS 10 — Consolidated Financial Statements

10.2 IFRS 8 — Operating Segments

10.3 IAS 1 — Presentation of Financial Statements

10.4 IAS 21 — Foreign Exchange

10.5 DR = CR Verification

Sample Data Verification:
  Each division balances independently:
    Retail Division:     950,000 = 950,000 ✓
    Wholesale Division:  840,000 = 840,000 ✓

  Consolidated:
    Total Assets:    1,690,000
    Total Liabilities: 230,000
    Total Equity:     1,460,000
    Assets = Liabilities + Equity: 1,690,000 = 230,000 + 1,460,000 ✓

  All transactions DR = CR:
    Total Debits:    880,000
    Total Credits:   880,000
    DR = CR ✓

  Interdivisional loan eliminated:
    Before: Retail Dr 100,000 + Wholesale Cr 100,000
    After elimination: 0 ✓

End of Consolidated Balance Sheet Guide