Skip to content

CPD lab · Reporting, Close

Consolidation worksheet check

A parent and two subsidiaries at year end: decide for each line whether it is carried, translated, eliminated or adjusted, and the amount that goes into the consolidated statements, with your AI tool.

All the ways to get this lab

Comes with Group accounts: consolidation, translation and intercompany, and with the year. 29 labs open now.

The brief

You work in group finance at Wenlock Holdings Ltd, a UK group. It is Wednesday 11 November 2026 and the consolidation for the year ended Saturday 31 October 2026 is being prepared. The group has a parent (Wenlock Holdings Ltd), an 80% UK subsidiary (Wenlock Fabrication Ltd) and a 100% Irish subsidiary (Wenlock Ireland Ltd) that keeps its books in euros.

The pack has the consolidation worksheet (33 lines: the three trial balances, and five journal lines that are in no trial balance), the intercompany schedule, the exchange rates, the group policy and the notes passed to group finance. Every company and figure is invented, so you can paste it into any AI tool.

Use your AI tool to decide how each of the 33 lines goes into the consolidated statements, and the amount. Post nothing: your job is the table, for a person to review.

The group policy file sets out every rule you need: what is eliminated, how euros are translated, and how unrealised profit, the non-controlling interest and dividends are treated. Follow it. Do not use rates or rules from anywhere else.

Give one line for each worksheet line, in the table columns line_ref, action, consolidated_gbp and note. consolidated_gbp is the amount the line contributes to the consolidated statements, in pounds, with two decimals, debit positive and credit negative; write 0.00 for a line that goes out completely.

Action, one per line. CARRY: the line goes into the consolidated statements at its own amount, with no adjustment; it is already in pounds. TRANSLATE: a euro line from Wenlock Ireland Ltd that stays in the group; the amount is the euro amount at the rate the policy sets for that kind of line. ELIMINATE: the line is removed in full, against another line or an investment; the amount is 0.00, even if the line is in euros. ADJUST: either a journal line that is not in any trial balance (the amount is the journal), or a trial balance line where only part is removed (the amount is what stays).

Do not change a trial balance line to include a journal. Carry or eliminate the line as it stands and show each journal on its own line at the foot of the worksheet. The non-controlling interest line (W-33) is the amount credited to the NCI for the year; take the other side as read.

Then write a short review note: what the AI got wrong, what you checked, and what goes to a person.

Objective: To be able to use an AI assistant to prepare and check a consolidation worksheet, applying eliminations, unrealised profit, non-controlling interest and foreign currency translation, and to refer judgement items to the right person.

What's in the pack

Every name, figure and email in the pack is invented. Use your own AI tool: Claude, ChatGPT, Copilot or Gemini.

  • consolidation-worksheet.csv

    The 33 worksheet lines: three trial balances in their own currencies and five journal lines (debit +, credit -)

  • intercompany-schedule.csv

    Intercompany invoices, payments and the dividend, with which company has recorded each

  • exchange-rates.csv

    The closing, average and historic euro to sterling rates (invented)

  • group-policy.txt

    The group's consolidation policy, including the group structure

  • group-finance-notes.txt

    Emails and a board minute passed to group finance, 20 October to 4 November 2026

The traps

The pack has 7 deliberate traps: cases where AI tools often get it wrong and a person must check. We don't list them here. Finding them is the job, and your feedback names each one you missed.

What you submit

  1. Your result, as a table with the columns line_ref, action, consolidated_gbp, note.
  2. The prompt you used.
  3. A short review note, 150 to 350 words: what the AI got wrong, what you checked, and what goes to a person.

How it's marked

  • Your result, checked line by line against the answer key60%
  • Your review note, marked on traits40%

The review note's traits:

  • Intra-group items removed and the difference explained
  • Unrealised profit and non-controlling interest worked through
  • Rates and dividends applied line by line
  • AI errors found and corrected
  • Judgement items referred to a person

Pass at 80. Under 80, read the feedback and try again. Then write your reflection and copy the entry for your CPD record.

Price

  • Group accounts: consolidation, translation and intercompany, £39. The role track and its labs, this one included. No end date.
  • Everything for a year, £199. Every course, role track and lab for 365 days.
  • Monthly, £19.99 a month, cancel any time. Every lesson, plus 8 marked tasks a month, across every course, role track and lab.

Buying for a team, or want a lab built on your own process? CPD for employers.