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, 10 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 Upload Actual Financials 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 run automatically after each data upload. Review them to confirm they balanced correctly.

  • Go to Adjustments → Auto Elimination and check each rule — look for any that show as unmatched or partially matched
  • Go to Adjustments → Elim. Validation
  • Review the validation report — confirm no intercompany balances remain uneliminated
  • Check the FX Diff column — a non-zero value means the difference has been posted to the FX Gain/Loss account configured in the rule. Confirm this is correct.
6Post one-off elimination entriesEliminate

For any intercompany balances not covered by auto rules.

  • Go to Adjustments → Elimination Entries
  • Click Add a new Elimination Entry
  • Enter date, description, and accounting standard
  • Add debit and credit lines — select the CCOA account and amount for each line
  • Set a Foreign Exchange Gain/Loss Account if the entry involves foreign currency
  • Click Confirm
  • Verify the entry shows Balanced
💡 Use BrizoElim (the button at the bottom of the Elimination Entries page) to run AI-assisted detection of intercompany balances that may have been missed.
7Post journal adjustmentsAdjust

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

  • Go to Adjustments → Journal Entries
  • Click Add Journal Entry
  • Select date, scenario, and accounting standard
  • Add debit and credit lines with the correct CCOA accounts
  • Click Confirm — verify the entry shows Balanced
ℹ️ Year-end only: also post CTA (Adjustments → CTA → Post CTA Journal) and NCI if applicable (Adjustments → NCI → Post NCI Journal). Verify both — confirm fully balanced.
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 → Cash Flow — 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 Adjustments → Elim. Validation 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