Login Try Free

Controls and Audit · Track 3 · Tutorial 3 of 3

Trace a consolidated figure to its source

An auditor picks a consolidated figure and asks where it came from. The drill shows every amount behind it, company by company and entry by entry, adding up to the cell.

You will needAccess to Your Group’s reports. Administrator or Journals & Eliminations Admin access for the Elim. & Journals Report.
By the endTrade receivables for Your Group at October 2026 explained, from the consolidated figure down to the companies’ invoices and the eliminations against them.

1Open the figure’s drill

  1. Select Your Group, and open the balance sheet for Oct-2026.
  2. Click the trade receivables amount. Or right-click it and choose Open drill in new tab.
A Balance Sheet amount for trade receivables at Oct-2026 opens its drill: cards for Closing Balance, Transactions, Elims/Adj and Period, type chips, and rows for Demo Sales Company and Demo Service Company (xero) and an auto-elimination row for Your Group, totalling the cell. A company row expands to its source postings, the invoices behind it; the auto-elimination amount opens the Auto-elimination Detail page with its from and to organisations and entries
The drill’s cards (1), a company’s row (2) and an elimination (3); a company’s source postings (4), and an auto-elimination’s detail (5).

2Read what makes up the figure

Closing BalanceThe total of the rows, equal to the cell. It reads Total Amount, Month movement or YTD Amount for other kinds of figure.
TransactionsHow many rows are shown.
Elims/AdjThe total of the elimination and journal rows: what the consolidation changed.
PeriodThe month the drill is for.

Each row is one amount: its Organisation, Account, Data Type (where it came from, such as xero for a company’s loaded books, auto-elimination, or a journal or elimination type), date, currency, rate and Amount. Click a type chip to show only those rows.

3Follow a company’s amount to its documents

  1. Click a company’s row that shows ▸.
  2. Read its source postings: date, source, document and amount.
  3. Where the document number is a link, click it to open the document.

Source postings are available for companies connected to Xero, QuickBooks Online, MYOB and Zoho Books, for Actual figures. When they can’t be shown, a notice above the table says why.

4Follow an elimination to its entries

  1. On an auto-elimination row, click the amount.

The Auto-elimination Detail page shows the account, From Organisation, To Organisation, the elimination amount, and each entry with its debit and credit. Click a row marked ▸ to see the documents it was built from.

5Find who posted the journals

  1. Open Review → Elim. & Journals Report for Actual and Oct-2026.
  2. Use the type chips and the All entities list to find the entries behind the journal and elimination rows of the drill.

Each entry shows its Reference, Description, User and accounts. Entries posted by rules and calculations show System. For who changed an entry after it was posted, search its reference in the System Audit Trail.

Check

The drill’s rows add up to the consolidated figure, each company’s row ties to its documents, and each elimination or journal row ties to an entry in the Elim. & Journals Report with its author.

6If something goes wrong

What you seeWhat to do
Source postings are not attachedThe notice above the table says why, such as transactions not loaded for the month. Reload the month on Data Loading with the data it names.
A red notice says part of the movement is not reconciled to a documentThe company’s trial balance moved by more than the documents loaded. Reload the month with Transactions, or GL for QuickBooks Online, ticked.
A company’s row has no ▸Its books were uploaded from a file, or no source records are held for it. Ask the company for its ledger.

Want more detail? See the documentation

Drill Down in Reports Elim. & Journals Report Elimination Review
All tutorials