Login Try Free

QuickBooks Online Groups · Track 2 · Tutorial 1 of 3

Close the books in QuickBooks, then reload

BrizoConsol keeps re-reading recent months from QuickBooks, so an entry posted late in QuickBooks changes your group figures overnight. Close the books in QuickBooks first, then reload the month once in BrizoConsol. That copy is final.

You will needYour companies connected to QuickBooks and mapped to the group chart, as in Track 1. Admin access in each QuickBooks company, which closing the books needs.
By the endOctober 2026 closed in all three QuickBooks companies, and reloaded and checked in BrizoConsol, ready for the group entries.

1Know why the order matters

You are closing October 2026 for Your Group: Maple Inc, Maple UK Ltd and Maple Pacific Pte Ltd, each in its own QuickBooks Online company.

Finish October in QuickBooks, close the books with a closing date of 31 October 2026, reload Oct-2026 in BrizoConsol for each company, then check the figures against QuickBooks
Close at the source first, so the reload is the last one that matters.
Every nightBrizoConsol re-reads the last 12 months of trial balances from each QuickBooks company, and the last 6 months of invoices and bills.
A lock in BrizoConsolStops group entries — journals, eliminations, exchange rates — but not these reads. A company’s October figures still change if its QuickBooks books change.
Closing the books in QuickBooksProtects the month at the source. BrizoConsol doesn’t read QuickBooks’ closing date, so it is up to you to set it.

2Close the books in each QuickBooks company

Do this once each company’s accountant has posted the last October entries.

  1. In QuickBooks, open Maple Inc.
  2. Go to Settings → Account and settings → Advanced, and edit Accounting.
  3. Switch on Close the books, and set the Closing date to 31 October 2026.
  4. Choose Allow changes after viewing a warning and entering password, set a password, and save.
  5. Repeat in Maple UK Ltd and Maple Pacific Pte Ltd.

Use the password option. QuickBooks doesn’t block a closed month outright: with only a warning, anyone can click through it and change October. With a password, only someone who knows it can.

3Reload October in BrizoConsol

Last night’s copy may be missing entries posted today. Reload the month now that it is closed:

  1. Select Maple Inc in the entity selector.
  2. Open Settings → Organisation Settings → Data Loading.
  3. On the Oct-2026 row, click Reload.
  4. GL is ticked; tick Invoices and Bills too. If class reporting is switched on, tick P&L by Class too. Click Start Load.
  5. Repeat for Maple UK Ltd and Maple Pacific Pte Ltd.
Data Loading for Maple Inc: Oct-2026 just reloaded, its general ledger, invoices, bills and transactions each loaded a few seconds ago, and the Reload button on each period
Reload October (1); each data type then shows when it was last loaded (2).

QuickBooks has no separate Transactions box: the Transactions column fills from the same loads. The payments and credits behind each invoice and bill come in with Invoices and Bills, and the ledger lines with GL, so this reload brings everything October needs for drill-down and settlements.

4Check each company against QuickBooks

  1. Select Maple Inc, and open Reports → All Reports → Trial Balance for Oct-2026.
  2. Compare total assets, total liabilities and net profit with Maple Inc’s trial balance in QuickBooks at 31 October.
  3. Repeat for the other two. Their reports are in GBP and SGD, as in QuickBooks.

Then open Review → Month End Status for the group, on Oct 2026.

Month End Status for Oct 2026 after the reload: the three Maple companies with GL, invoices and bills loaded, P&L tracking not loaded and overall Partial, with eliminations, NCI and CTA still to come
Every company’s GL is loaded (1); without class reporting, each shows Partial (2).

Check

Each company’s trial balance matches QuickBooks, and Month End Status shows 3 / 3 under Data loaded, with GL, Invoices and Bills Loaded for every company.

Month End Status expects a P&L by class for every QuickBooks company. Until class reporting is switched on and loaded — Track 3 — P&L tracking shows Not loaded and the company shows Partial rather than Ready. That doesn’t affect the consolidation.

October is still open in BrizoConsol: the eliminations come next. Lock it there once the group entries are posted, as in Review everything before you report.

5If October has to change later

  1. In QuickBooks, post the correction, entering the closing-date password when asked.
  2. Reload Oct-2026 in BrizoConsol for that company, and check it again.

A correction posted in QuickBooks reaches the trial balance with the next nightly read even if you don’t reload — reloading brings it in now, so you can check it.

6If something goes wrong

You can’t find Close the booksClosing the books needs admin access in that QuickBooks company. Ask an admin.
A company’s figures differ from QuickBooksEntries were posted after the last load. Close the books and reload the month.
Group figures changed after the closeSomeone changed October in QuickBooks — easily done if only the warning was set. Switch to the password option, and check the Data Loading page for when October was last loaded.
The month stays Not loadedCheck the connection on Data Loading — a Token expired badge in the Organisation Hierarchy means it needs Reconnect Now. Reconnect, then load the month.
New accounts appeared in October’s loadMap them before going on, or their balances are left out of the group. See Build the group chart from a QuickBooks company.

Want more detail? See the documentation

Monthly Close — QuickBooks Online Data Loading Month End Status
Next in Close the month with QuickBooks Eliminate intercompany invoices and bills All tutorials