Excel Import and Export
Upload financial data from Excel or CSV and export registers to Excel.
How to open
- In the left menu, select Finance.
- 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
- Select what you are uploading (for example, "Money movements").
- Upload an
.xlsxor.csvfile 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.xlsxfiles and are picked the same way. - Map the file columns to system fields. Most columns are matched automatically.
- Click Preview: you will see which rows will be created, which are skipped as duplicates, and where the errors are.
- Click Import.
- 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
externalIdcolumn are not created again — the same file can be uploaded several times. - Payments without
externalIdare compared by invoice number, amount, and date.
How to export
- In the Export block, click All registers or select a single register.
- The
.xlsxfile 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.