What Excel formats does BrizoConsol support?
BrizoConsol accepts .xlsx and .xls files. The AI supports trial balance (single or multi-column), P&L and Balance Sheet in the same workbook, and multi-sheet workbooks where each sheet represents a different entity.
Do I need to format my Excel file in a specific way?
No. The AI analyses your workbook as-is. It detects column headers, sheet structure, and layout type automatically. You only need to review and confirm any account mappings it flags — everything else is handled for you.
What is account mapping and do I need to do it manually?
Account mapping matches the account names in your Excel file to a common chart of accounts so all entities are comparable. The AI maps most accounts automatically — you only need to confirm or adjust the ones it isn't certain about. Mappings are saved for future uploads.
Can I mix Excel entities with directly connected accounting software?
Yes. A group can include entities from Xero, QuickBooks, MYOB, Zoho Books, and Excel — all consolidated together. BrizoConsol treats them identically in the consolidation engine.
How do I update figures for a new period?
Simply re-upload a new Excel file for the relevant entity and period. Your consolidated reports update automatically. Account mappings from previous uploads are remembered — no need to re-map each time.
What if my workbook has P&L and Balance Sheet on different tabs?
The AI recognises this structure automatically. It reads both sheets, identifies which is the P&L and which is the Balance Sheet, and reconstructs the full financial position for consolidation.
How do I import an Excel trial balance?
In BrizoConsol, add a new entity and select Excel as the source. Upload your .xlsx or .xls trial balance file. The AI analyses the layout, maps your accounts to the common chart of accounts, and loads the data. Your entity then joins the consolidation group automatically.
Can I consolidate multiple Excel workbooks?
Yes. You can add multiple entities from Excel — each as a separate upload — and consolidate them together. You can also include a mix of Excel entities alongside Xero, QuickBooks, MYOB, and Zoho Books organisations in the same group.
Does BrizoConsol support Excel consolidation?
Yes. BrizoConsol accepts Excel trial balances, P&L statements, and balance sheets as entity data sources. Imported Excel entities use the same consolidation engine as directly connected accounting software — including intercompany eliminations, multi-currency translation, and group financial statements.
Can I import historical periods from Excel?
Yes. You can upload Excel files for multiple historical periods. Each upload is assigned to a specific entity and period, allowing you to build a full comparative dataset across periods.
How does AI account mapping work?
When you upload an Excel file, BrizoConsol's AI reads your account names and matches each one to a standard chart of accounts. It suggests the closest match and flags any accounts it isn't confident about for your review. Confirmed mappings are saved so future uploads for the same entity load without re-mapping.
