Drill Down in Reports | BrizoConsol Documentation

What this article covers: How drill-down works in BrizoConsol reports — the drill panel that opens inline, source postings for Zoho Books, Xero, QuickBooks Online and MYOB, Xero invoice-level detail, and auto-elimination detail pages.

Every report in BrizoConsol is interactive. Click any account amount to open the drill panel and see every transaction behind that figure. Depending on your accounting system, you can expand individual rows further to see the source documents and journal entries that produced the movement.

1. Opening the Drill Panel

Click any account amount cell in a report. The drill panel opens inline and loads every posting behind that account for the selected period. The panel heading shows the account name and code, and the report name, period, and scope are shown below it.

The four summary cards across the top of the panel give a quick read of what the drill contains:

Card What it shows

Closing Balance / Total Amount / Month movement / YTD Amount The total of the rows listed — label changes based on whether the account is a balance sheet account, a movement-basis account, or a YTD cell

Transactions Number of rows currently visible after any active filter

Elims/Adj Total of elimination and journal rows only — the consolidation adjustments within this figure

Period The period the drill was opened for; if opened from a Budget or Forecast column, a scenario badge (e.g. Budget) appears beside the period

2. Filtering and Sorting

The toolbar below the summary cards gives two ways to narrow the table.

Type filter chips — one chip per data type that actually appears in the rows (e.g. Xero, Zoho, CSV, Journal, Elimination, Auto-elimination). Click All to reset. Only types present in the current rows are shown, so a chip that would match nothing is never offered.

Search box — type to filter rows by any text visible in the table (name, reference, date, amount). The row count at the right of the toolbar updates as you type.

Column sorting — click any column header to sort ascending, click again to sort descending, click a third time to restore the original order. A small ▲ or ▼ beside the header name shows the active sort. Amount columns sort by the underlying number, not the formatted text; the Date column sorts by calendar date.

3. Reading the Table

Each row in the drill table represents one posting. The columns are:

Column What it shows

Organisation The organisation the posting belongs to; a ▸ caret appears if the row has expandable source records

Account The account code and name (the code follows the report’s show-account-code setting)

Data Type Where the posting came from, as a badge — for example xero, zoho, qbo, myob or csv for loaded figures, elimination types in teal, auto-elimination in amber, journals in indigo

Standard The accounting standard the posting belongs to — Base for the company’s own figures

Date Posting date (d-Mon-yy format)

Currency The posting’s currency badge; N.A. when none applies

In Local Amount in the posting’s own currency

Exchange Rate Rate used to translate it to the report currency

Amount Amount in the report currency; the rows add up to the cell you clicked

Elimination and journal rows are highlighted with a light teal background to distinguish consolidation adjustments from the underlying entity data at a glance.

The total row at the bottom of the table sums the Amount of all rows currently shown.

4. Source Postings (Zoho Books, Xero, QuickBooks Online, MYOB)

Rows from a Zoho Books, Xero, QuickBooks Online or MYOB entity that have source records behind them show a ► caret in the Organisation cell. Click the row to expand it and see the postings that produced the movement. Source postings explain the Actual scenario under the local accounting standard only; when they cannot be shown, a notice above the table says why and what to load.

Connector What the source rows are

Zoho Books Zoho’s own postings — invoices, bills, journals, payments and expenses. Needs Transactions loaded for the month.

Xero One row per document line that posted to the account (the invoice, bill or credit note number, party, date and net amount), plus ledger postings no document explains, such as bank charges, currency gains and manual journals. Ledger postings are stated in the base currency.

QuickBooks Online The ledger lines that moved the account, with their date, transaction and party. The movement is the month’s year-to-date balance less the previous month’s, so the previous month’s trial balance must also be loaded. Needs the Free, Pro or Premium edition.

MYOB Every MYOB ledger line that moved the account, with its date, the transaction it belongs to and its type. The month is chosen by the date each transaction occurred. The movement is the month’s year-to-date balance less the previous month’s, so the previous month’s trial balance must also be loaded. Needs the Free, Pro or Premium edition.

The source sub-table shows:

Column What it shows

Date Date of the source posting

Source Kind of source record (e.g. Invoice, Bill, Journal, Payment, Expense); for QuickBooks Online and MYOB, the transaction type

Document Reference number — linked to the Documents page when the document type supports it; shown as a button that expands the full entry inline when it is a journal, payment, or expense. For QuickBooks Online and MYOB, a ledger line opens its invoice or bill when that document is held in BrizoConsol.

Part Line or payment item within the document

Basis How the amount was calculated (e.g. accrual, cash)

Tax Tax amount on this line — column appears only when at least one row carries a tax value

Amount Amount in the reporting currency, signed for the report direction

Document value Original document amount in the source currency with exchange rate — column appears only when the data includes foreign-currency documents

Balance sheet accounts — for balance sheet accounts, the expanded row also shows a three-cell balance strip above the source table: Opening balance, Month movement (or YTD movement), and Closing balance.

Long lists — source rows are shown 50 at a time, with Previous and Next to page through them. The total under the table covers every row, not just the page.

Coverage line — below the column headers, a grey line reports how many source rows are attached and when the trial balance was last imported (e.g. "3 source rows · trial balance as at 30-Sep-26, imported 01-Oct-26").

Offsetting postings — postings that net to zero against each other, such as a purchase and its matching payment, are hidden by default to keep the list readable. If any are present, a link appears: Show N postings that offset each other. Click it to reveal them; click again to hide them. The rows themselves are not changed — only their visibility.

Expanding an inline entry — clicking a reference that has entry detail behind it (a Zoho or Xero journal, or a Zoho payment or expense) opens the full record in place below the source row:

Entry type What the inline entry shows

Journal Journal number, date, notes, Zoho journal ID; table of lines with Account, Description, Debit, Credit

Payment Payment label, number, date, party, account, amount, currency, exchange rate, Zoho payment ID; table of settled documents with amounts; refunds if any

Expense Expense reference, date, currency, Zoho expense ID; table of lines with Account, Item, Amount, Tax, In local

💡 Tip: If the source sub-table shows a red notice at the bottom — “[amount] of the movement in the row above is not reconciled to a document here” — it means the trial balance row’s amount cannot be fully explained by the source records BrizoConsol retrieved. Reload the month on Data Loading: with GL ticked for QuickBooks Online, and with Transactions ticked for Xero and Zoho Books.

5. Xero Invoice Drill

For Xero entities, clicking a drillable amount in the drill table navigates to the Invoice detail page. This is a separate page that lists every invoice and bill behind the figure for that account and period.

The five summary cards across the top show:

Card What it shows

Total Amount Sum of all document amounts in the filtered view

Overdue Total of documents with an overdue status (shown in red)

Paid Total of fully paid documents (shown in green)

Tax Amount Total tax across filtered rows — shown as — when no tax data is available

Period The period this drill belongs to, with the first transaction date shown below

The filter bar lets you narrow the list by document status: All, Paid, Overdue, or Open. A search box lets you filter by name or document ID.

The table columns are: Id (linked to the document page), Name, Date, Status (colour badge — Overdue in red, Paid in green, Authorised in amber), Type, Item Name, Qty, Unit Price, Amount, and Tax Amount.

Movement reconciliation — a footer strip below the table compares the report cell’s movement figure against the total of the rows listed, and shows the difference. If the difference is not zero it is highlighted in red, signalling that some transactions have not been matched to a document.

6. Auto-Elimination Detail

Clicking a drillable elimination row in the drill table opens the Auto-elimination Detail page. This shows the individual journal entries that make up one auto-elimination for the period.

Six summary cards across the top of the page show: Account, From Organisation, To Organisation, Elimination Amount, Entries, and Period. If both the from and to organisations are known, the route is shown as From Org → To Org beneath the title.

The table lists each journal entry with columns: Organisation, Account, Type (badge), Date, Currency (badge), Exchange Rate, Debit, and Credit. Filter by All, Debit, or Credit using the chips above the table.

For rows built from source documents, a ► caret appears — clicking the row expands the source documents below it: Document (linked to the document page), Contact, Entity, Date, and Eliminated amount.

7. Formula Drill

When a cell is part of a custom formula (for example, a gross margin ratio or a computed subtotal), the drill shows a Formula Breakdown panel above the main table. Each component of the formula appears as a clickable chip showing its label and amount. Clicking a chip narrows the table to only the rows that belong to that component. Click the chip again to see all components together.

The formula equation is shown at the top-right of the breakdown panel (e.g. Gross Margin = Revenue − Cost of Sales = 1,240). The summary cards update when a component is selected so the totals always reflect what is currently visible in the table.

8. Exporting the Drill

PDF and Excel export icons appear in the header bar of every drill page and the auto-elimination detail page. PDF exports the rendered page; Excel exports the table as a spreadsheet. Both exports exclude the filter chips and sort carets so only data appears in the file.