Skip to content

Excel Import and Export ​

Upload financial data from Excel or CSV and export registers to Excel.

How to open ​

  1. In the left menu, select Finance.
  2. Open Excel (/finance/excel).

What you can upload ​

  • Client invoices.
  • Invoice payments (linked to a cash desk or bank account).
  • Cash desks and bank accounts.
  • Money movements on cash desks and accounts.
  • Financial transactions (income and expenses).

How to import a file ​

  1. Select what you are uploading (for example, "Money movements").
  2. Upload an .xlsx or .csv file from your computer or pick a file in Google Drive or OneDrive in the import blocks below the upload field (connect the cloud once in the "Connectors" section — the same login as for the knowledge base). A file from the cloud goes through the same steps: column mapping, preview, import. Excel Online workbooks are stored in OneDrive as regular .xlsx files and are picked the same way.
  3. Map the file columns to system fields. Most columns are matched automatically.
  4. Click Preview: you will see which rows will be created, which are skipped as duplicates, and where the errors are.
  5. Click Import.
  6. Rows with errors can be downloaded as CSV, corrected, and uploaded again.

Duplicate protection ​

  • Client invoices are compared by number.
  • Movements and payments with an externalId column are not created again — the same file can be uploaded several times.
  • Payments without externalId are compared by invoice number, amount, and date.

How to export ​

  1. In the Export block, click All registers or select a single register.
  2. The .xlsx file downloads automatically.

Roles and permissions ​

  • Import is available to the owner, administrator, and accountant.
  • Export is available to everyone with access to finance.
  • For the investor and auditor, the IBAN on the accounts, movements, and payments sheets of the export is replaced with a mask (for example, KZ86 •••• •••• 0100).

FAQ ​

Which amount format is supported? 1 050,50, 1050.50, and the like. No more than two decimal places.

Why wasn't a movement uploaded? The cash desk or account was not found by name/IBAN, or the row currency differs from the account currency.

Is Google Drive or OneDrive required? No, these are additional ways to pick a file. A bank statement from Google Drive or OneDrive can also be picked on the "Bank statement import" page. Cloud files go only to finance import; they are not added to the knowledge base.

AIDIR client documentation · docs.aidir.kz