Uploading via Excel or CSV | BrizoConsol Documentation

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.

Go to Global Settings → Organisation HierarchyThe hierarchy tree shows all entities. Entities not yet connected show an UNCONNECTED badge.

Click the entity to select itThe right-hand panel opens showing Organisation Details and the Connection section below.

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.

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

The Data Loading page has two upload buttons. Both accept up to 12 files at a time, up to 2 MB each, and uploading a month again replaces it.

Option A — Import Actual CSV

For CSV trial balances where you say which column holds what. Available on every plan.

Click Import Actual CSVThe Upload Actual CSV dialog opens. Drag in your CSV files, or click to browse.

Define the columnsUnder Column Definitions, choose which column holds the Account Code, Account Name, YTD Debit and YTD Credit.

Choose the month for each file, and uploadUnder Files, set the month each file holds, then click Upload.

Option B — BrizoFileBot

For Excel, CSV, TXT or TAB files in any layout. Click BrizoFileBot; the Upload Actual Financials dialog opens. Drop in your files and the AI classifies them — multi-sheet workbooks included — as described in Step 4. BrizoFileBot is not included in the Standard edition.

💡 Which should I use? Use Import Actual CSV for a plain CSV trial balance you export the same way every month. Use BrizoFileBot for anything else — Excel workbooks, paired P&L and Balance Sheet files, general ledger exports, or layouts that change.

Step 4 — AI Classification and Clarification

With BrizoFileBot, the AI does the heavy lifting after the file is uploaded. Here is what happens:

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.

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

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.

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.