What this tutorial covers: How to set up an entity for Excel or CSV upload, access the Data Loading page, and use BrizoFileBot to upload your trial balance. Use this when an entity's accounting system is not directly supported — such as SAP, NetSuite, Sage, or any spreadsheet-based setup.

🛈 Direct connection available? If the entity uses Xero, QuickBooks, MYOB, or Zoho Books, connect it directly instead — data will sync automatically each period without any manual uploads. See Connecting Entities to Xero, QuickBooks, MYOB, or Zoho Books.

Step 1 — Set the Entity to Upload via Excel / CSV

Start in the Organisation Hierarchy to configure this entity's connection type.

1
Go to Global Settings → Organisation HierarchyThe hierarchy tree shows all entities. Entities not yet connected show an UNCONNECTED badge.
2
Click the entity to select itThe right-hand panel opens showing Organisation Details and the Connection section below.
3
Click Upload via Excel / CSV filesIn the Connection section, click the Upload via Excel / CSV files button. The entity is now set to manual upload mode.
4
Confirm the connection type in the right panelThe Connection section now shows Connected via CSV. Two buttons appear in the Data Source field: Excel / CSV Import and Load Data.
💡 Need to switch to a direct connection later? Click Reset in the Connection section to remove the CSV connection. The entity can then be connected to Xero, QuickBooks, MYOB, or Zoho Books instead. Existing uploaded data is not affected.

Step 2 — Go to the Data Loading Page

There are two ways to get to the Data Loading page:

From How
Organisation Hierarchy With the entity selected, click Load Data in the Data Source field — takes you directly to this entity's Data Loading page
Left navigation Navigate to Organisation Settings → Data Loading from the left sidebar — make sure the correct entity is selected in the entity switcher first

The Data Loading page shows a list of all periods and their load status — Not loaded yet for periods with no data, and a timestamp for periods where data has been successfully imported.

Step 3 — Upload Your File

There are two ways to upload — the upload dialog or BrizoFileBot. Both use the same AI classification engine.

Option A — Upload Dialog

1
Click Upload Actual FinancialsThe upload dialog opens. Drag and drop your file into the upload area, or click to browse.
2
Select your file(s)Upload up to 12 files per session — CSV, Excel (.xls and .xlsx), TXT, or TAB format, up to 2 MB per file. Excel workbooks with multiple sheets are handled automatically — no need to split files by entity or period.
3
The AI begins classifying immediatelyOnce the file is dropped, the AI scans the structure automatically — no further action required at this point.

Option B — BrizoFileBot

Click the BrizoFileBot button at the bottom of the Data Loading page. BrizoFileBot is an AI assistant that guides you through the upload conversationally — useful if you are unsure about your file format or need help identifying the right data to upload.

💡 Which should I use? For most uploads, the upload dialog is faster. Use BrizoFileBot when you have questions about the file, want guidance on format, or the AI is asking for clarification and you prefer a conversational approach.

Step 4 — AI Classification and Clarification

After the file is uploaded, the AI does the heavy lifting. Here is what happens:

1
Structure pass

The AI scans headers, column positions, and sheet names to classify the file layout — single or multi-column trial balance, P&L + Balance Sheet, multi-sheet workbook, general ledger transaction detail, or other formats. It identifies the account code column, account name column, period columns, and debit/credit structure.

2
Clarifying questions (if needed)

If anything is ambiguous, the AI asks before extracting any data. Common questions include:

What it might ask Why
Reporting year Month headers show Jan, Feb without a year — confirm which year before extraction
Sheet selection Multi-sheet workbook — which worksheet(s) to import
Account code column Multiple columns could be the account code — confirm the right one
New accounts found Accounts in the file not yet in the chart of accounts — confirm classifications before import completes
3
Review and confirm

The proposed mapping is shown before anything is extracted. Review and adjust if needed — then confirm. Nothing is extracted until you confirm.

4
Data is loaded

BrizoConsol extracts, validates, and loads the data. A confirmation banner shows the file classification, columns used, and periods loaded. The Data Loading page updates — the relevant periods now show a load status timestamp instead of Not loaded yet.

File Formats BrizoConsol Accepts

No fixed template required. BrizoConsol handles the most common accounting export formats automatically.

Trial Balance (Standard)

Account code, name, debit and credit columns — single or multi-column — in any order.

P&L + Balance Sheet

P&L and Balance Sheet on separate tabs or the same sheet. AI reads both and reconstructs the full trial balance.

Multi-Sheet Workbooks

One workbook, multiple entities or periods. Each sheet is classified separately — no need to split files.

Single-Column Layout

Accounts listed with net amounts in a single column — common in simpler accounting exports.

Multi-Column Layout

Debit and credit in separate columns, or period columns side-by-side. AI identifies the structure automatically.

General Ledger Export

Transaction-level rows with account, date, and debit/credit amounts. Rolled up to monthly trial balance rows automatically.

💡 P&L-only files are not accepted. A standalone Profit & Loss without a matching Balance Sheet cannot be imported — both are required because together they form a complete trial balance.

Every Month — Repeat the Upload

Unlike direct connections, CSV entities do not sync automatically. Each period requires a manual upload. At month-end, export the trial balance from your accounting system and upload it via the Data Loading page. The existing period data is replaced cleanly — no need to remove previous uploads first.

⚠ Missing periods in consolidated reports? Check the Data Loading page — if a period shows Not loaded yet, that period has no data and will not contribute to consolidated outputs for that month. Upload the missing period to resolve.