Skip to main content
When aiGust has no connector for an administration’s bookkeeping, you can import it from Excel files. You create the administration in aiGust, and upload its data step by step. An Excel import always creates a new administration, from scratch. You can’t add historic data from Excel to an administration that comes from a connector: aiGust can’t combine financial years from two sources.
Check your files carefully before you upload them. Today, you can’t correct or delete data once it’s imported.

The steps

  1. Create the administration.
  2. Define the financial years and periods.
  3. Upload the starting balances.
  4. Upload the transactions.
Steps 2 to 4 are one wizard: Financial periods and starting balances. Each upload step has a template. Download it, and copy your data into the right columns. Your bookkeeping export probably won’t match the template right away, so expect some work in Excel to convert it.

Step 1: Create the administration

  1. Click Settings in the main rail, and choose Excel imports.
  2. Click Add new administration.
  3. Basic information: fill in the Name, the VAT Number and the Legal type. Click Next.
  4. About the company: search and select the Economic activity, and choose the Company type. See Sectors and company types. Click Next.
  5. Address: fill in the address of the company. Click Next.
  6. Is this correct?: check the details, and click Submit.
Add administration dialog, step 1 of 4, Basic information, with the Name FC De Kampioenen, the VAT Number BE9988998782 and the Legal type PLC. A Next button.

Step 1 of 4: the name, VAT number and legal type.

Add administration dialog, step 2 of 4, About the company, with the Economic activity 93121 Activities of football clubs, in the sector Sports and subsector Sports club, found by searching for Activities of football clubs, and the Company type Operating Company. Buttons Back and Next.

Step 2 of 4: the economic activity and company type.

Add administration dialog, step 3 of 4, Address, with the fields Address line 1, Address line 2, Postal code 1000, City Brussels and Country Belgium. Buttons Back and Next.

Step 3 of 4: the address.

Add administration dialog, step 4 of 4, Is this correct?, listing the Details (name FC De Kampioenen, VAT number BE9988998782, legal type PLC, company type Operating Company), the Economic activity (NACE code Activities of football clubs) and the Location (country BE, city Brussels, postal code 1000). Buttons Back and Submit.

Step 4 of 4: check and submit.

The administration now appears in the list of administrations, and on Excel imports.
Excel imports page with an Add new administration button, and the message There is no data to display.

The administrations imported from Excel.

Step 2: Define the financial years

Open the administration. It doesn’t have any figures yet: you land on Import data, which shows what still needs to be done.
Import data page of the administration FC De Kampioenen, explaining that you import data from Excel files in several steps. Three sections: Administration added, Financial periods and starting balances, open, with a button Financial periods and starting balances, and Transaction import.

Import data: the steps to fill the administration.

  1. Click Financial periods and starting balances.
  2. Click Add period for each financial year you’ll upload.
  3. For each financial year, fill in:
    • Period ID: the ID of the financial year. aiGust proposes the year, such as 2025. Use the ID your bookkeeping uses for that financial year, because your transactions will refer to it.
    • Period start date and Period end date.
    • Booking periods: how the financial year is split into periods: months, quarters or the whole year.
  4. Click Next.
The financial years must follow each other, without gaps.
Financial periods and starting balances dialog, step Define the periods for the data you will upload, asking for the start and end date of the financial periods and the intervals in which the transactions are booked. Two rows: Period ID 2025 from 01-01-2025 to 31-12-2025, and Period ID 2026 from 01-01-2026 to 31-12-2026, both with Booking periods Quarters and a bin icon. A calendar is open to pick 31 December 2026. Add period buttons above and below, and a Next button.

Two financial years, each split into quarters.

Step 3: Upload the starting balances

aiGust needs the balance of each GL account at the start of the first financial year you upload. These are mainly the balance sheet accounts: at the start of a financial year, the P&L accounts are zero. For example: if you start with financial year 2023, give the balances on the first day of financial year 2023.
  1. Click Download beginning balances template file, and fill it in. The file needs these columns:
  2. Drag the file to the dialog, or click Select a file to upload. Upload a clean file, with only these columns and your data.
  3. Link the columns, and choose the formats:
    • Under Required columns, every column needs a column of your file.
    • Under Optional columns, you can leave a column on None.
    • Choose the Date format your file uses, such as dd/MM/yyyy or yyyy-MM-dd.
    • Choose the Value format: 1.234,56, with a decimal comma, or 1,234.56, with a decimal point.
    The Preview below shows your data as aiGust reads it. If your column names aren’t on the first row of your file, change the Header position.
  4. Click Next.
Every date must match the date format. Otherwise, the preview shows Date format mismatch! and you can’t continue. Check the amounts too: aiGust leaves an amount it can’t read empty.
Spreadsheet with the columns first_day, glaccount_code, glaccount_description and amount_eur, and one row: 01/01/2024, 400000, Customers, 121697.

The template for the starting balances.

Financial periods and starting balances dialog, step Beginning balances, asking for the beginning balances of each GL account in a clean Excel file with the required columns first_day, glaccount_code, glaccount_description and amount_eur. A drop zone Select a file to upload, max. 50 MB, and a button Download beginning balances template file. Buttons Back and Next.

Upload the starting balances.

Step 4: Upload the transactions

The last step of the wizard is the transactions. Upload all transactions of the financial years you defined. Download the template to see the format. You can give the amount in one column, or split it into debit and credit: As with the starting balances, link the columns to your file, and choose the Date format and Value format. Every date must match the date format. An amount aiGust can’t read is imported as 0, so check your amounts before you upload. aiGust places each transaction in the right financial year and period by its date. aiGust then prepares the data and calculates everything. Come back after 10 to 15 minutes: the figures are there.

Add data later

To add a new financial year later:
  1. Define the new financial year, as in step 2.
  2. Upload its transactions, as in step 4. You don’t need starting balances again.
Upload all transactions of the period you add. If you upload in the middle of a financial year, make sure you don’t miss any transactions.

Transactions you already uploaded

aiGust only imports the transactions it doesn’t have yet. So you can upload a file that partly overlaps with a previous upload. aiGust recognises a transaction by all its columns, except the amount. If you upload a transaction again with a corrected amount, aiGust sees it as the same transaction, and skips it. You can’t correct an amount this way.