MYOB Groups · Track 2 · Tutorial 3 of 3
Follow a figure to the MYOB posting
Available on ProPremium
A group figure looks wrong. Rather than open three company files, drill into it in BrizoConsol: first to the company, then to the MYOB postings that make up that company’s amount.
1Understand the trail
Group Travel for October 2026 is 7,923.08, and Wattle Pty Ltd’s part looks high. You will follow it to the MYOB entries behind it.
BrizoConsol reads each MYOB company file’s ledger with its monthly trial balance, so every posting is there — sales and purchases, payments and general journals alike. A month’s ledger is kept only once it agrees with that month’s trial balance. The nightly read keeps the last 12 months current; you don’t need to switch anything on.
2Open the drill panel
- Select Your Group, and open Reports → Profit & Loss for Oct-2026.
- Click the October amount on the Travel row.
The drill panel lists each company’s balance on the account. Its Data Type is myob, and In Local is the amount in the company’s own currency — AUD 4,180.00 for Wattle Pty Ltd, translated at 1.1700 AUD per SGD to SGD 3,572.65.
3Read Wattle Pty Ltd’s MYOB postings
- Click Wattle Pty Ltd’s row — rows with postings behind them show a ▸ caret.
- Read the source rows: one for each ledger line that posted to the account in October.
| Source | The transaction type, in MYOB’s own words — Bill, Invoice, CustomerPayment, SupplierPayment, GeneralJournal and so on. |
|---|---|
| Part | MYOB’s journal type in front of the transaction type — Purchase Bill, General GeneralJournal. |
| Document | The transaction’s number in MYOB. A general journal shows as Journal GJ000088. |
| Amount | In Wattle Pty Ltd’s currency, AUD, as in MYOB’s ledger. The rows add up to its In Local amount. |
Entries that cancel each other out are hidden; click Show N postings that offset each other to see them.
4Open the source
A number is a link when it matches an invoice or bill BrizoConsol has loaded for the company. Click 00000231, and Documents opens on that bill, with the supplier, date, status and lines.
Other postings — payments, general journals — don’t open in BrizoConsol. Find them in MYOB by their date, type and number.
In the example, Journal GJ000088 is a month-end accrual of 1,000.00 for travel claims not yet submitted. With the 1,940.00 bill for a site visit, it explains why October is high.
Check
Wattle Pty Ltd’s source rows add up to its AUD 4,180.00 in the drill panel. If not, a red line under the table says how much of the movement isn’t reconciled to a document.
Bills and invoices older than the last 3 months may not be loaded, so their numbers aren’t links. Load the month with Invoices and Bills ticked to make them open.
5Trace a balance sheet figure
On a balance sheet account, such as trade debtors, the trail also shows where the month started and ended: the opening balance, the month’s movement and the closing balance, with the MYOB postings that moved it listed underneath.
The month’s movement is the balance at the end of October less the balance at the end of September, so September’s trial balance must be loaded too. In a year-to-date view, the movement is YTD movement, and the rows run from the start of the company’s fiscal year.
6When the trail stops
If BrizoConsol can’t show the MYOB postings, a notice above the table says why:
| MYOB ledger lines for Oct-2026 are not loaded for Travel. Load that month again to read its ledger. | Reload the month on Data Loading with GL ticked. Ledger lines are read for the last 12 months; an older month needs this load. |
|---|---|
| The ledger holds no line for this account in Oct-2026, so the figure is explained by the imported trial balance only. | Nothing in the loaded ledger posted to the account that month. |
| The month before Oct-2026 has no imported MYOB trial balance… | Load September on Data Loading, then drill again. |
| No MYOB Actual trial balance is imported for Oct-2026. | Load the month’s trial balance first. |
| Source postings belong to one account, and this row is a group of them. | You drilled a total. Drill a single account’s amount. |
| MYOB ledger lines explain the local Actual import only… | The report is on another scenario, such as Budget, or another accounting standard. Switch to Actual and the base standard. |
| MYOB accounting detail requires the Free, Pro or Premium edition. | Ledger lines aren’t read on Standard, so the trail stops at the drill panel. |
Want more detail? See the documentation