10.4 Working 5 Group Retained Earnings & Intra-Group Adjustments

10.4 Working 5 Group Retained Earnings & Intra-Group Adjustments

Core Principle: In the Consolidated Statement of Financial Position, Working 5 (Group Retained Earnings) brings together the cumulative earnings belonging to the equity holders of the parent. Because the group is a single economic entity, all internal transactions—such as intra-group receivables, payables, inventory profits, and non-current asset transfer gains—must be eliminated in full. The critical distinction in accounting for the Provision for Unrealised Profit (PUP) is the identity of the selling entity: downstream sales impact the parent alone (W5), whereas upstream sales impact subsidiary profits (W2), meaning the Non-Controlling Interest (NCI) shares in the PUP.

---

1. Structure and Logic of Working 5 (Group Retained Earnings)

Working 5 consolidates all revenue reserves attributable to the parent company's shareholders. It begins with 100% of the parent company's separate retained earnings and incorporates the parent's share of subsidiary post-acquisition growth, adjusted for consolidation eliminations:

                      Working 5: Group Retained Earnings Pro-Forma
  ─────────────────────────────────────────────────────────────────────────────
  Working 5: Group Retained Earnings                                         $
  ─────────────────────────────────────────────────────────────────────────────
  Parent company retained earnings (100% per separate SFP)                 XXX
  Adjustments to Parent's separate earnings:
    • Less: Acquisition transaction fees expensed (if capitalized by P)    (XX)
    • Less: Finance cost on deferred consideration unwinding (IAS 37/IFRS 3)(XX)
  Parent's share of post-acquisition reserves from subsidiaries:
    • Add: Parent % of Sub post-acquisition movement (from W2)              XXX
  Goodwill impairment:
    • Less: Parent share of goodwill impairment (from W3)                  (XX)
  Provision for Unrealised Profit (PUP) on Inventory:
    • Less: 100% of PUP where PARENT is the seller (Downstream)            (XX)
  Intra-group transfers of Non-Current Assets (PPE):
    • Less: Unrealised profit on disposal (if PARENT was seller)           (XX)
    • Add: Cumulative excess depreciation on transferred asset (if P sold)  XX
  ─────────────────────────────────────────────────────────────────────────────
  CONSOLIDATED RETAINED EARNINGS                                           XXX
  (Carried to Equity on Consolidated Statement of Financial Position)
  ═════════════════════════════════════════════════════════════════════════════

---

2. Elimination of Intra-Group Trading Balances

When group entities trade with each other on commercial credit, the selling entity records a Trade Receivable (current asset) and the buying entity records a Trade Payable (current liability). From the single economic entity perspective, the group cannot owe money to itself. If these internal debts were left unadjusted, group assets and liabilities would be artificially inflated.

                    Intra-Group Balance Elimination Flow
  ┌─────────────────────────┐                     ┌─────────────────────────┐
  │     PARENT COMPANY      │                     │   SUBSIDIARY COMPANY    │
  │ Current Assets:         │                     │ Current Liabilities:    │
  │ Trade Receivables $50k  │                     │ Trade Payables $50k     │
  └────────────┬────────────┘                     └────────────┬────────────┘
               │                                               │
               └───────────────────────┬───────────────────────┘
                                       ▼
                     CONSOLIDATION ELIMINATION ENTRY:
                 Dr Intra-Group Trade Payables  $50,000
                 Cr Intra-Group Trade Receivables $50,000

Reconciling In-Transit Items Prior to Elimination

In exam scenarios, the balance shown in the parent's receivables ledger rarely equals the balance shown in the subsidiary's payables ledger. This discrepancy is almost always caused by timing differences at the reporting date:

A. Cash in Transit (CIT)

The buying entity sent a cheque or electronic bank transfer before year-end, but the selling entity did not receive or record it until after the reporting date:

• Example: Parent shows receivable of $80,000; Subsidiary shows payable of $60,000. Subsidiary sent $20,000 cash on 30 December, received by Parent on 3 January.
• Step 1: Record Cash in Transit in the Seller's Books (as if received at year-end):

Dr Cash and Cash Equivalents (Group Current Assets)    $20,000
   Cr Intra-Group Trade Receivables (Current Assets)          $20,000

(This reduces the Parent's receivable from $80,000 to $60,000).

• Step 2: Eliminate the Matched Intra-Group Balance:

Dr Intra-Group Trade Payables (Current Liabilities)    $60,000
   Cr Intra-Group Trade Receivables (Current Assets)          $60,000

B. Goods in Transit (GIT)

The selling entity dispatched inventory before year-end and invoiced the buyer, but the goods did not arrive at the buyer's warehouse until after year-end:

• Example: Parent shows receivable of $50,000; Subsidiary shows payable of $35,000. Parent dispatched $15,000 of goods on 29 December, delivered to Subsidiary on 4 January.
• Step 1: Record Goods in Transit in the Buyer's Books (as if received at year-end):

Dr Inventories (Group Current Assets)                  $15,000
   Cr Intra-Group Trade Payables (Current Liabilities)        $15,000

(This increases the Subsidiary's payable from $35,000 to $50,000).

• Step 2: Eliminate the Matched Intra-Group Balance:

Dr Intra-Group Trade Payables (Current Liabilities)    $50,000
   Cr Intra-Group Trade Receivables (Current Assets)          $50,000

---

3. Provision for Unrealised Profit (PUP) on Inventory

When one group company sells goods to another at a profit, the selling entity records revenue, cost of sales, and a profit in its separate accounts. However, from the group's perspective, no profit is realized until the inventory is sold to an independent third party outside the group. If any of these goods remain in the purchasing entity's inventory at the reporting date, that closing inventory is recorded at an inflated transfer price containing internal profit. This internal profit must be eliminated through a Provision for Unrealised Profit (PUP).

                      The Realization of Group Inventory
  ┌────────────────┐               ┌────────────────┐               ┌────────────────┐
  │     SELLER     │──Transfer───► │     BUYER      │──Sold to────► │    EXTERNAL    │
  │ (Records internal              │ (Holds in      │   Third Party │   CUSTOMERS    │
  │  profit)                       │  inventory)    │               │ (Profit truly  │
  └────────────────┘               └───────┬────────┘               │  realized!)    │
                                           │                        └────────────────┘
                                           ▼
                                 Goods remaining at year-end
                                 contain UNREALISED PROFIT!
                                 ===> Must create PUP adjustment

Mathematical Formulas: Mark-up on Cost vs. Gross Margin on Sales

In ACCA examinations, the profit pricing structure is specified using one of two distinct conventions:

Rapid Exam Conversion Table

---

4. The Cardinal Rule: Downstream vs. Upstream Inventory Sales

The accounting entry for PUP depends entirely upon who sold the goods:

                       The Golden Rule: Who is the Seller?
                                       │
            ┌──────────────────────────┴──────────────────────────┐
            ▼                                                     ▼
     DOWNSTREAM SALE                                       UPSTREAM SALE
   (Parent Sells to Sub)                                (Sub Sells to Parent)
   ─────────────────────                                ─────────────────────
   • Parent recorded the profit in its separate         • Sub recorded the profit in its separate
     retained earnings.                                   retained earnings.
   • NCI owns shares in Sub, NOT Parent!                • Sub's profit belongs to BOTH Parent and NCI.
   • NCI must NOT bear any PUP!                         • NCI MUST bear its proportionate share!
   
   CONSOLIDATION ENTRY:                                 CONSOLIDATION ENTRY:
   Dr Group Retained Earnings (W5)  [100%]              Dr Sub Post-Acq Profit (W2)      [100%]
   Cr Group Inventory (CSFP)        [100%]              Cr Group Inventory (CSFP)        [100%]
   
   (NCI is completely unaffected)                       (W2 movement is reduced; therefore
                                                         Parent bears P % in W5, and
                                                         NCI bears NCI % in W4!)

---

5. Intra-Group Sales of Non-Current Assets (PPE)

When one group company sells property, plant, or equipment to another group company at a profit:

1. The Group Reality: The asset has simply been relocated within the group enterprise. From an economic perspective, no transaction with an external party took place; therefore, no profit on disposal has been earned, and the asset's carrying amount cannot be inflated above depreciated historical group cost.
2. The Subsequent Depreciation Discrepancy: The purchasing entity records the asset at the higher transfer price and calculates depreciation based on that higher value. Consequently, its annual depreciation charge is higher than historical group depreciation. The group must eliminate this excess depreciation.

Consolidation Steps for PPE Transfers:

• Step 1: Eliminate the Unrealised Profit on Disposal:

Unrealised Gain = Transfer Price - Carrying Amount at Transfer Date

If Parent was the seller:

Dr Group Retained Earnings (Working 5)          [Unrealised Gain]
   Cr Property, Plant and Equipment (CSFP)             [Unrealised Gain]

If Subsidiary was the seller:

Dr Working 2 Subsidiary Post-Acquisition Profit [Unrealised Gain]
   Cr Property, Plant and Equipment (CSFP)             [Unrealised Gain]

• Step 2: Eliminate Cumulative Excess Depreciation:

Annual Excess Depreciation = Unrealised Gain on Disposal / Remaining Useful Life at Transfer Date
Cumulative Excess Depreciation = Annual Excess Depreciation x Post-Transfer Elapsed Time

Consolidation Entry (Reversing excess depreciation to restore group carrying amount):

Dr Property, Plant and Equipment (CSFP)         [Cumulative Excess Depreciation]
   Cr Group Retained Earnings (W5 if P sold) / W2 (if Sub sold) [Cumulative Excess Depreciation]

• Net Balance Sheet Impact:

Net Reduction in PPE = Unrealised Gain - Cumulative Excess Depreciation

---

6. Comprehensive Worked Numerical Example: Complete 5-Working Master Case

Scenario:

Parent plc acquired 80,000 of the 100,000 $1 ordinary shares of Son Ltd on 1 January 20X3 for $260,000 cash. The draft Statements of Financial Position at 31 December 20X4 (2 years post-acquisition) are:

Draft Statements of Financial Position as at 31 December 20X4:
                                               Parent plc ($)    Son Ltd ($)
Non-Current Assets:
  Property, plant and equipment                   700,000        340,000
  Investment in Son Ltd (at cost)                 260,000              -
Current Assets:
  Inventories                                     210,000        130,000
  Trade receivables                               160,000         95,000
  Cash and bank balances                           45,000         20,000
──────────────────────────────────────────────────────────────────────────
Total Assets                                    1,375,000        585,000
══════════════════════════════════════════════════════════════════════════
Equity:
  Ordinary share capital ($1 nominal)             500,000        100,000
  Retained earnings                               620,000        360,000
Current Liabilities:
  Trade payables                                  255,000        125,000
──────────────────────────────────────────────────────────────────────────
Total Equity and Liabilities                    1,375,000        585,000
══════════════════════════════════════════════════════════════════════════

Additional Information:

1. Son Ltd Net Assets at Acquisition (1 Jan 20X3): Retained earnings were $180,000. Son Ltd's land had a fair value $30,000 above book value (non-depreciable). All other net assets equalled book values.
2. NCI Valuation: Group policy is to measure NCI at its proportionate share of identifiable net assets at acquisition date.
3. Goodwill Impairment: Testing at 31 December 20X4 confirmed goodwill is impaired by $10,000.
4. Intra-Group Trading & In-Transit Cash:
   • Parent plc shows a trade receivable of $42,000 due from Son Ltd.
   • Son Ltd shows a trade payable of $30,000 due to Parent plc.
   • On 30 December 20X4, Son Ltd dispatched $12,000 cash to Parent plc, which Parent did not receive until 4 January 20X5.
5. Inventory Sales & PUP:
   • During 20X4, Parent plc sold goods to Son Ltd for $60,000 at a mark-up of 25% on cost (Downstream). At 31 December 20X4, Son Ltd still held $20,000 of these goods in inventory.
   • During 20X4, Son Ltd sold goods to Parent plc for $50,000 at a gross profit margin of 20% on sales (Upstream). At 31 December 20X4, Parent plc still held $15,000 of these goods in inventory.
6. Intra-Group Plant Transfer: On 1 January 20X4 (1 year ago), Parent plc sold a machine with a carrying amount of $40,000 to Son Ltd for $55,000 (profit $15,000). Son Ltd is depreciating the machine over its remaining 5-year useful life on a straight-line basis.

---

Step 1: Working 1 (Group Structure)

• Parent Interest: 80,000 shares / 100,000 total shares = 80%
• Non-Controlling Interest (NCI): 100% - 80% = 20%
• Acquisition Date: 1 January 20X3
• Reporting Date: 31 December 20X4 (2 full years post-acquisition)

---

Step 2: Working 2 (Net Assets of Son Ltd)

• Upstream PUP: Inventory held by Parent from Son Ltd = $15,000. Margin on sales = 20%. Upstream PUP = $15,000 x 20% = $3,000. (Deducted from Son Ltd's post-acquisition profit in W2!)

Working 2: Net Assets of Son Ltd
                                    At Acquisition ($)  At Reporting ($)  Post-Acq Movement ($)
Share capital                            100,000             100,000                 -
Retained earnings per single SFP         180,000             360,000              180,000
Fair value adjustment:
  • Land uplift                           30,000              30,000                 -
Upstream PUP (inventory sold by Son)           -              (3,000)              (3,000)
──────────────────────────────────────────────────────────────────────────────────────────
TOTAL IDENTIFIABLE NET ASSETS            310,000             487,000              177,000
══════════════════════════════════════════════════════════════════════════════════════════
Transfers:
• Net Assets at Acquisition ($310,000) ===> To Working 3 (Goodwill)
• Post-Acquisition Movement ($177,000) ===> Apportioned:
    - Group Retained Earnings (W5): 80% x $177,000 = $141,600
    - Non-Controlling Interest (W4): 20% x $177,000 = $35,400

---

Step 3: Working 3 (Goodwill)

Working 3: Goodwill
Purchase consideration transferred                                  $260,000
Add: NCI at acquisition (Proportionate: 20% x $310,000 net assets)   $62,000
Less: Fair value of net assets acquired (from W2)                  ($310,000)
─────────────────────────────────────────────────────────────────────────────
Goodwill at acquisition (Partial Goodwill)                           $12,000
Less: Accumulated impairment loss to date                           ($10,000)
─────────────────────────────────────────────────────────────────────────────
Goodwill at reporting date (to CSFP Non-Current Assets)               $2,000
═════════════════════════════════════════════════════════════════════════════

---

Step 4: Working 4 (Non-Controlling Interest at Reporting Date)

Working 4: Non-Controlling Interest
NCI at acquisition (from W3)                                         $62,000
Add: NCI share of post-acquisition movement (20% x $177,000 from W2) $35,400
Less: NCI share of impairment (Proportionate method: 0%)                   -
─────────────────────────────────────────────────────────────────────────────
Non-Controlling Interest at 31 Dec 20X4 (to CSFP Equity)             $97,400
═════════════════════════════════════════════════════════════════════════════

---

Step 5: Working 5 (Group Retained Earnings)

• Downstream PUP (Parent sold to Son): Remaining inventory = $20,000. Mark-up on cost = 25%. Downstream PUP = $20,000 x (25 / 125) = $4,000. (Debited 100% to W5).
• Intra-Group Plant Transfer Adjustments (Parent sold):
  • Unrealised profit on disposal: $55,000 - $40,000 = $15,000 (deducted in W5).
  • 1 year elapsed depreciation on transfer gain: $15,000 / 5 years = $3,000 (added back in W5).
  • Net adjustment to W5 and PPE: -$15,000 + $3,000 = -$12,000.
• Goodwill Impairment: Under proportionate method, 100% charged to Parent: -$10,000.

Working 5: Group Retained Earnings
Parent plc retained earnings (per single-entity SFP)                $620,000
Add: Group share of Son post-acquisition movement (80% x $177,000)  $141,600
Less: Goodwill impairment loss (100% to Parent under partial method)($10,000)
Less: Downstream PUP (Parent sold goods to Son)                      ($4,000)
Less: Intra-group plant transfer unrealised gain                    ($15,000)
Add: Plant excess depreciation add-back ($15,000 / 5 years)           $3,000
─────────────────────────────────────────────────────────────────────────────
Group Retained Earnings at 31 Dec 20X4 (to CSFP Equity)             $735,600
═════════════════════════════════════════════════════════════════════════════

---

Step 6: Consolidation Line-by-Line Adjustments

1. Property, Plant and Equipment: $700,000 (Parent) + $340,000 (Son) + $30,000 (Land uplift) - $12,000 (Net plant PUP) = $1,058,000
2. Goodwill: From Working 3 = $2,000.
3. Inventories: $210,000 (Parent) + $130,000 (Son) - $4,000 (Downstream PUP) - $3,000 (Upstream PUP) = $333,000
4. Cash and Bank: $45,000 (Parent) + $20,000 (Son) + $12,000 (Cash in transit) = $77,000
5. Trade Receivables: Parent's receivable adjusted for cash in transit: $160,000 - $12,000 = $148,000. Intra-group cancellation with Son's payable of $30,000: $148,000 (Parent) + $95,000 (Son) - $30,000 (Cancellation) = $213,000 (Or equivalently: $160,000 + $95,000 - $42,000 full internal debt = $213,000).
6. Trade Payables: $255,000 (Parent) + $125,000 (Son) - $30,000 (Cancellation) = $350,000

---

Step 7: The Master Consolidated Statement of Financial Position

Parent Group: Consolidated Statement of Financial Position as at 31 December 20X4
Non-Current Assets:                                                    $
  Property, plant and equipment                                     1,058,000
  Goodwill (from W3)                                                    2,000
Current Assets:
  Inventories                                                         333,000
  Trade receivables                                                   213,000
  Cash and bank balances                                               77,000
─────────────────────────────────────────────────────────────────────────────
Total Assets                                                        1,683,000
═════════════════════════════════════════════════════════════════════════════
Equity:
  Ordinary share capital ($1 nominal - Parent only)                   500,000
  Group retained earnings (from W5)                                   735,600
─────────────────────────────────────────────────────────────────────────────
  Equity attributable to owners of Parent                           1,235,600
  Non-controlling interest (from W4)                                   97,400
─────────────────────────────────────────────────────────────────────────────
Total Equity                                                        1,333,000
Current Liabilities:
  Trade payables                                                      350,000
─────────────────────────────────────────────────────────────────────────────
Total Equity and Liabilities                                        1,683,000
═════════════════════════════════════════════════════════════════════════════
[Mathematical Verification: Total Assets $1,683,000 = Total Equity & Liabilities $1,683,000]

---

7. Common Exam Traps & ACCA Examiner Tips

[!WARNING] ACCA Examiner Trap 1: Deducting Upstream PUP from W5 Directly The most frequent error in advanced consolidation questions is deducting upstream PUP (where the subsidiary sold goods to the parent) directly from Group Retained Earnings in Working 5. If you do this, the parent absorbs 100% of the deduction, and the NCI is shielded from its rightful share of the loss. Upstream PUP must be debited in Working 2 (Subsidiary Net Assets), which automatically reduces both W5 and W4 proportionally.

[!WARNING] ACCA Examiner Trap 2: Applying Mark-up Directly to Sales Value If a question states "goods were sold at a mark-up on cost of 25%" and $40,000 remains in inventory, calculating PUP as $40,000 x 25% = $10,000 is wrong! $40,000 is the transfer price (sales value). The correct calculation is $40,000 x (25 / 125) = $8,000.

[!WARNING] ACCA Examiner Trap 3: Omitting Excess Depreciation on PPE Transfers Eliminating only the initial gain on disposal of PPE is an incomplete adjustment. In subsequent periods, the purchasing entity has charged depreciation on the inflated transfer price. You must calculate the excess depreciation (Gain / Useful Life x Time) and credit it back to retained earnings and PPE.

[!TIP] ACCA Examiner Tip: The 30-Second Balance Sheet Diagnostic If your Consolidated Statement of Financial Position fails to balance by a specific figure in exam conditions:

1. If out by the NCI balance: check whether you placed Working 4 inside Equity.
2. If out by Goodwill: check whether you brought Working 3 into Non-Current Assets.
3. If out by the exact amount of PUP or cash in transit: check whether you performed both the debit and credit legs of the adjustment!