What this article covers: How to use the Data Loading page in BrizoConsol — selecting data types to load per period, reloading individual periods or date ranges, and connector-specific features such as Transactions, QuickBooks P&L by Class and Zoho Books Reporting Tag Setup.

The Data Loading page gives you control over when data is refreshed from your connected accounting system. Go to Organisation Settings → Data Loading from the left navigation.

🛈 Connected and upload entities: This article covers entities connected via Xero, QuickBooks, MYOB, or Zoho Books. An entity set up for upload has its own Data Loading page too: it lists each period with when it was last loaded, and uploads trial balances with Import Actual CSV or BrizoFileBot — see Uploading via Excel or CSV.

Data Types

When you load a period, you choose which data types to refresh. The data types available depend on the entity's connector and plan.

Data Type Description
Loads the trial balance for the selected period. Available on all connected entities.
Loads customer invoice records for the period. Available on Xero, QuickBooks, MYOB, and Zoho Books connections.
Loads supplier bill records for the period. Available on Xero, QuickBooks, MYOB, and Zoho Books connections.
Loads dimension data for profit and loss reporting. Available on Xero leaf entities once additional access is switched on (tracking categories), QuickBooks leaf entities once P&L by Class is switched on (classes), MYOB leaf entities once P&L by job is switched on (jobs, computed from the loaded ledger), and Zoho Books leaf entities on entitled plans (reporting tags).
Document-level detail behind the period. Zoho Books: journals, expenses, payments, credits and refunds, on an entitled plan with additional scope authorisation. QuickBooks Online: payment settlements and ledger lines, on Free, Pro and Premium — filled by the GL, Invoices and Bills loads. Xero: shown once transactions are switched on for the connection.

The Period Table

The main table lists all periods with a load-status column for each data type available on the entity. Each period row shows whether GL, invoices, bills, and any connector-specific types have been loaded, and when they were last updated.

Use the Filter periods search bar to find a specific month. Use the All / Incomplete / Complete filter to show only periods with missing data or fully loaded periods. The total period count appears in the bottom-right — e.g. 13 Periods.

Period rows can be individually selected using the checkbox on the left. Select multiple periods and use the bulk bar that appears at the bottom of the table to load them in one action.

Loading a Period

Click the Reload or Load missing button on any period row. A dialog opens showing the period and a list of data type checkboxes.

1
Click Reload or Load missing on the period rowThe Load Period dialog opens with the available data types pre-checked based on what is missing for that period.
2
Select the data types to loadCheck GL, Invoices, Bills, and any connector-specific types (Tracking Category P&L, Transactions) that you want to refresh. A period that already has everything loaded will pre-check GL only.
3
Click Start LoadBrizoConsol fetches the selected data types from the connected accounting system. The Load Status for each data type updates once the import completes.

Loading Multiple Months

Click Sync now at the top of the page, or use the period selection checkboxes and the Load selected bulk action, to reload a date range in one action.

1
Click Sync nowA date range dialog opens. Use the quick-select buttons (Last 3 months, Last 6 months, Last year) or choose a From and To month manually.
2
Select data types and click Start LoadBrizoConsol fetches the selected data types for all months in the range. Load Status columns update as each period completes.

Zoho Books — Reporting Tags and Transactions

Zoho Books leaf entities on Free, Pro, or Premium plans have two additional data features on the Data Loading page. See Connecting an Entity to Zoho Books for plan and access details.

Reporting Tag Setup

The Reporting Tag Setup button appears in the page header for entitled Zoho leaf entities. Click it to import and classify reporting tags — the same flow described in the Zoho Books article. Once tags are imported and classified, the P&L by Reporting Tag checkbox in the load dialog refreshes the reporting-tag dimension data for each selected period.

Transactions

The Transactions checkbox appears in the load dialog for entitled Zoho leaf entities that have also completed the additional scope authorisation (re-authorising the connection from Organisation Settings → Data Loading → Enable additional access). When enabled, checking Transactions loads each selected period's journals, expenses, payments, credits, and refunds. Once the additional access is approved, the nightly refresh also reads Transactions for the current month and the two before it, and keeps them up to date. Older months in the plan’s window are filled in one month a night, and are not read again after that.

🛈 Status badges on Transactions:
  • Pro only — the entity is not on an entitled plan. Transactions is unavailable until the Zoho Books subscription is upgraded to Free, Pro, or Premium.
  • Reauth required — the entity is entitled but the connection has not been re-authorised for the additional scope bundle. Go to Organisation Settings → Data Loading and complete the Enable additional access step.

Xero — Transactions and P&L by Tracking Category

Xero leaf entities read two extra kinds of data on Free, Pro and Premium editions. Both are switched on together with Enable additional access on the Xero permissions card at the top of Data Loading; the permissions they read with are normally granted when the entity is connected, so no new Xero approval is needed. Only users who can administer the entity’s data see the button.

Transactions

Once switched on, the Transactions checkbox in the load dialog loads each selected month’s payments, credit notes, prepayments and overpayments against the documents they settle, and the ledger lines behind each account’s movement. Transactions are not part of the nightly refresh: load the months you need, and load a month again after significant changes in Xero. Until the access is switched on, the checkbox is disabled with Enable additional access on the connection before transactions can be loaded.

P&L by Tracking Category

The P&L by Tracking Category checkbox loads Xero’s monthly profit and loss by tracking category for the selected periods. See Xero Tracking Categories & Consolidation.

QuickBooks Online — Transactions and P&L by Class

QuickBooks Online leaf entities load document-level detail on Free, Pro and Premium editions.

Transactions

The Transactions column has no checkbox of its own. It is filled by the other loads: a month’s payment settlements are read with its Invoices and Bills, and its ledger lines with the GL. Clicking Load missing on a period whose Transactions are missing therefore asks for GL, Invoices and Bills. The loaded detail feeds the settlement details on the Invoices & Bills pages and the source postings in report drill-down.

Each night BrizoConsol also re-reads, for each QuickBooks entity, one older month of invoices and one of bills that still hold an unpaid document, so a document that was paid after its month was first loaded shows its current settlement.

P&L by Class

Reading the profit and loss by class makes one report read per month, so it stays off until it is switched on. While it is off, an Additional reads panel under the sync bar shows Switch on P&L by class — click it to turn it on for the connection. Only a data administrator can switch it on, from a working connection. Once on, the P&L by class column appears and Class Setup lets you choose the classes to report.

Forecast and Budget Data

Forecast and budget movements are not uploaded from this page. Open Forecast or Budget in the left navigation, choose the statement, and use the Import icon or Input Mode — see Entering Budget & Forecast Data.

💡 Tip: Use Sync now at the start of each reporting period to ensure all recent data is current before running consolidated reports or creating Insight Packages.

Related Articles

Connecting Your Accounting Software Connecting an Entity to QuickBooks Online Connecting an Entity to Zoho Books Adding a New Entity Organisation Detail