What this article covers: The complete month-end close process for BrizoConsol groups with entities that upload trial balance data as Excel or CSV files — from exporting from your accounting system through to distributing consolidated reports.

This is the complete workflow for accountants managing entities that are not directly connected to BrizoConsol — such as those using SAP, NetSuite, Sage, or spreadsheet-based accounting. Work through each step in order.

⚠️ BrizoConsol will not alert you if a manual entity has not been refreshed for the current period. If the upload is skipped, consolidation runs using the previous period's figures without any warning. Make the upload a non-negotiable first step.

Part 1 — Finalise and Upload Data

1Complete month-end in your accounting systemIn your system

Do all of this before exporting. The export captures the state of the books at the moment it is run — any entries posted after the export will not be in BrizoConsol.

  • Post all month-end journals: depreciation, accruals, prepayments, expense provisions
  • Complete bank reconciliation for all accounts
  • Reconcile accounts receivable and payable
  • Lock or close the period in your accounting system to prevent backdated changes after the upload
  • Run a Trial Balance report as at the last day of the month and save it — you will compare this to BrizoConsol after uploading
2Export the trial balanceIn your system

Export from your accounting system in whatever format it produces — no reformatting required. BrizoConsol accepts:

  • Standard trial balance — accounts in rows, months in columns
  • Cumulative or YTD trial balance — same layout, year-to-date figures
  • Multi-sheet workbook — one worksheet per period
  • Paired P&L + Balance Sheet workbook — both statements together
  • General ledger / transaction detail export — BrizoConsol rolls these up to monthly trial balance rows automatically
  • Two-row Excel header format (e.g. Xero-style exports from connected systems used elsewhere)
ℹ️ File formats: CSV, Excel (.xlsx or .xls), TXT, TAB. Up to 12 files per upload, 2 MB per file. See Uploading Trial Balances via Excel / CSV for the full format guide.
3Upload to BrizoConsol and confirm the mappingIn BrizoConsol

BrizoConsol classifies the file structure automatically and shows you the proposed mapping before extracting any data.

  • Go to Organisation Settings → Data Loading
  • Click BrizoFileBot (the Upload Actual Financials dialog opens) and drag in your file
  • Review the AI-proposed mapping — check the account code column, account name column, period columns, and debit/credit representation
  • Adjust any mapping that looks incorrect — sheet selection, column assignments, or the reporting year if month headers do not include a year
  • Click Confirm — nothing is extracted until you confirm
  • Check the success banner — it confirms the file classification, columns used, periods loaded, and any warnings
  • Go to Organisation Settings → Data Loading and confirm the period row shows an updated Load Status timestamp
💡 If new accounts appear in your upload that do not yet exist in BrizoConsol's Chart of Accounts for this entity, you will be prompted to confirm or adjust their account section (Asset, Liability, Equity, Revenue, Expense) before the import completes.
4Verify the trial balance in BrizoConsolIn BrizoConsol

Spot-check the uploaded figures against the trial balance you exported from your source system.

  • Go to Reports → Trial Balance in BrizoConsol and select this entity
  • Compare total assets, total liabilities, net profit, and equity against your saved trial balance export
  • If figures differ: check the sign convention — revenue and liability accounts should be negative amounts in the upload file. Re-upload with corrections if needed.
  • Check new accounts have been assigned correct sections — go to Organisation Settings → Chart of Accounts for this entity to review and correct

Part 2 — Consolidate in BrizoConsol

4Review each entity's trial balanceVerify

Before running eliminations, confirm BrizoConsol has the correct figures for every entity.

  • Switch to each entity using the organisation selector (top-left dropdown)
  • Go to Reports → Trial Balance
  • Compare to the trial balance you exported from the source system — total debits, total credits, net profit, and equity should all match
  • If figures differ: go to Organisation Settings → Data Loading, check the Load Status timestamp, re-upload the file for the affected period, and re-check

Switch back to the group level before continuing.

5Review auto eliminationsEliminate

Auto Elimination rules are rebuilt automatically each time data is uploaded. Clear anything they held back for this period.

  • Go to Intercompany → Elimination Review and select the Actual scenario and the period you are closing
  • Method 4 proposals — click Review and post, check the entry and click Approve & Post
  • Method 2 differences — check the Difference and the treatment applied (FX, Write off or Timing). To change it, click Change treatment, adjust and click Confirm & Replace. A Timing difference set to Review before posting is not posted until approved
  • Entries not posted — a Method 1 period outside tolerance, or a rule whose invoice or bill name criterion was not met (the reason is shown under the row). Correct the data or the rule in Intercompany → Elimination Rules, or reject the row
  • Move on when Waiting for approval and Check the difference treatment list no rows for the period
6Post one-off elimination entriesEliminate

For any intercompany balances not covered by auto rules.

  • Go to Intercompany → Other Eliminations
  • Click + Add entry
  • Enter the Elimination ID, date and description
  • Add debit and credit lines — select the CCOA account and amount for each line
  • If the debit and credit base totals differ, allocate the difference under Difference Treatments (FX, timing or write-off)
  • Click Confirm
  • Verify the entry shows Balanced
💡 To cover intercompany balances no rule handles yet, open Intercompany → Elimination Rules and click Suggest Rules: BrizoElim reviews your companies’ charts of accounts and suggests elimination rules for you to confirm.
7Post journal adjustmentsAdjust

For accounting standard adjustments: fair-value entries, impairments, reclassifications.

  • Go to Adjustments → GAAP Journals
  • Click Add a new journal entry
  • Enter the Journal ID, date, Journal Type and description (the scenario is the one selected on the page)
  • Add debit and credit lines with the correct CCOA accounts
  • Check the form shows Entry is balanced, then click Confirm
ℹ️ CTA and NCI: there is nothing to post. BrizoConsol posts them automatically every time the group is recalculated. On Review → Month End Status, check that the CTA and NCI / JV cards show Posted.
8Review the consolidated reportsReview

Switch to the group entity and review the consolidated outputs.

  • Go to Reports → Profit & Loss — check revenue, gross profit, and net profit vs prior month and prior year
  • Go to Reports → Balance Sheet — confirm Total Assets = Total Liabilities + Equity. Any imbalance indicates a missing elimination or journal entry.
  • Go to Reports → Cashflow — review operating, investing, and financing movements
  • Use the period comparison selector (Actual vs Last Year or Actual vs Budget) to make variances immediately visible
  • Click into any line that looks unexpected — drill-down shows which entities and accounts are driving the number
  • Go to Pulse → Key Metrics — check health scores for unexpected movements
💡 If the Balance Sheet does not foot, check Intercompany → Elimination Review first — a missing intercompany elimination is the most common cause.
9Distribute reports to stakeholdersDistribute

Once consolidated figures are signed off:

  • Go to Insight Packages — confirm the last delivery date shows the current period. If not yet delivered, click Generate to trigger manually.
  • To share a specific report: open the report, click the export button (top right), download as PDF or Excel
  • For board or investor reporting: use the Comparing Periods view to present Actual vs Budget side by side