When to use this workflow

Skip this step if your consolidated financials will start from the earliest period of activity across all your companies.

Use this workflow if you want your consolidated reporting to begin in a later period. Here's why it's needed: JustConsolidate's period consolidation workflows consolidate period activity, not ending balances. So if you're starting consolidated reporting mid-stream, you'll need to load an opening balance sheet for each subsidiary first, then run the period consolidation workflows from there.



How it works

To consolidate an opening balance sheet, click Opening Balance Sheet on the workflow panel and follow the steps below.


Step 1 — Select the opening period

Choose the calendar year and month you want consolidated financials to begin. The first month of your fiscal year is recommended.


What you need to know: To create an opening balance sheet position, the system extracts balances from the period prior to the period you enter. For example, if you want consolidated financials to begin in January 2023, enter January 2023 — JustConsolidate will extract balances from December 2022. P&L accounts will also be extracted and reduced to one Debit(Credit) balance that will be pushed into Retained Earnings. Think of this approach as a typical year-end closing of the accounts to prepare for the next fiscal year.


With your desired period selected, click Lock OBAL Period.


Step 2 — Extract subsidiary balances

Click Run Workflow in the Extract Subsidiary Balances column to pull account balance details from each subsidiary. You can select all to run the extract across every subsidiary at once.


Step 3 — Review and post

For each subsidiary, click Review. You'll see two side-by-side tables:

Left side — Subsidiary trial balance (as extracted from QBO):

  • Balance sheet accounts reflect the ending balance in the period prior to your opening period
  • All P&L account activity is summed into a single DR/CR balance and shown as Net Income, which will post to Retained Earnings in the parent company

Right side — Parent-formatted consolidation entry:

  • The extracted balances reformatted into the parent company's COA (based on your mappings)
  • Displayed as a traditional DR/CR trial balance — this is the consolidation journal entry that will post to your parent QBO company
  • The Retained Earnings balance shown here is the sum of the subsidiary's Retained Earnings and extracted Net Income

You have two options:

  • Click Confirm & Post to post the consolidation JE to your parent company, or
  • Click Reviewed to mark the entry as reviewed without posting (useful if you want to come back to it)

Repeat for each subsidiary with period activity to consolidate.


Step 4 — Post reviewed entries (optional)

If you marked any entries as Reviewed but didn't post them in Step 3, you can return and click Confirm to post them.




Other Information


1. Foreign currency subsidiaries

All balance sheet accounts in the opening balance sheet are translated at the period-end rate for the extract period. After posting, you may need to manually adjust some translated balances to reflect historical exchange rate differences.

To adjust: Post the opening balance sheet JE to your parent QBO company, then open the posted OBAL JE directly in QBO and modify the affected balances. Offset your adjustment to the CTA account or the appropriate gain/loss account, as needed.



2. Consolidation journal entry posting details

  • Each JE posts with the subsidiary's name in the Division Name (Location) field
  • Entries are dated the last day of the fiscal period prior to your opening period
  • JE numbers follow a consistent syntax to make them easy to identify: OBXXX(realm ID of QBO company)


3. Consolidated reporting in QBO

Once you've posted consolidation entries for every subsidiary, the rest of your consolidation and reporting work happens directly in your parent QBO company.

  • Adjusting entries — Book intercompany eliminations, minority interest adjustments, and other consolidation entries directly in the parent company. Consider creating a dedicated Division (Location) to segment these adjustments from your subsidiary-sourced balances.
  • Segmented reporting — P&L, Balance Sheet, and Cash Flow reports in QBO can be filtered by Division (Location) and Class, giving you full flexibility to run both segmented and consolidated views.


4. Re-consolidating the opening balance sheet

Need to redo your opening balance sheet? Just re-run the workflow. This is useful when:

  • A subsidiary's balances have changed
  • You've updated COA mappings
  • You want to change the opening period

The system will automatically detect and delete the original entry before posting the updated one.


5. Potential error message on posting: Retained Earnings not found

If you've modified the spelling of the Retained Earnings account in your parent QBO company — including adding account numbers to the name field — you'll see an error asking you to restore the default QBO spelling.

How to Resolve: Restore the account name to QuickBooks' default spelling and remove any account numbers from the name field.