Skip to content

CPD lab · Close

Intercompany reconciliation

Two group companies' intercompany ledgers, one in sterling and one in euros: reconcile them with your AI tool, and sort the FX revaluation, the cash in transit, a one-sided recharge and a misposting from the items that simply agree.

All the ways to get this lab

Comes with Month-end close and controls, and with the year. 29 labs open now.

The brief

You work in group finance at Halvergate, a maker of measuring instruments. Halvergate Instruments Ltd in the UK keeps its books in sterling; Halvergate Instruments (Ireland) Ltd keeps its books in euros. They trade with each other in euros. It is Monday 2 November 2026 and the October intercompany reconciliation is due.

The pack has both companies' intercompany ledgers for October (8 lines each), the group intercompany policy with October's rates, an email from the Irish financial controller and the UK euro bank account for early November. Every company, rate and figure is invented, so you can paste it into any AI tool.

Use your AI tool to reconcile the two ledgers in euros, item by item, as the policy says. Post nothing: your job is the reconciliation table, for the group financial controller to review.

Give one line for every line in both ledgers (U-01 to U-08 and I-01 to I-08). In matched_to, give the line it agrees to in the other ledger, or leave it blank.

Action, one per line. AGREE: the item is in both ledgers for equal and opposite euro amounts; dates and sterling values may differ. FX: the line exists only because of exchange rates (a sterling revaluation with no euro value), so there is nothing to match and nothing for the other company to book. TRANSIT: cash sent before 31 October and received after, so the receiving company records cash in transit. BOOK: a valid item in one ledger only, which the other company must book in October. MOVE: an item that belongs to a different group company, so it is reversed here and posted to the right intercompany account.

action_by is the company that must make an entry: UK, IE, or NONE when no entry is needed.

Check that the reconciliation balances to the cent: after the entries in your table, the two euro balances should be equal and opposite, and the UK's sterling balance should equal its euro balance at the closing rate.

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 reconcile intercompany balances held in different currencies, separating exchange differences and timing items from real errors, and to agree which company corrects each one.

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.

  • uk-intercompany-ireland.csv

    UK company's intercompany account with Ireland, October 2026 (8 lines; + means Ireland owes the UK)

  • ie-intercompany-uk.csv

    Irish company's intercompany account with the UK, October 2026 (8 lines; + means the UK owes Ireland)

  • group-intercompany-policy.txt

    Group policy for intercompany items, with October's group rates

  • email-ireland-financial-controller.txt

    Email from the Irish company's financial controller

  • uk-euro-bank-november.txt

    UK company's euro bank account, first receipts in November

The traps

The pack has 6 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, matched_to, action, action_by, 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:

  • Exchange differences understood
  • Each difference classified
  • Reconciliation proved
  • Corrections owned by the right company
  • Group data kept out of personal accounts

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

Price

  • Month-end close and controls, £79. 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.