Troubleshooting
Common issues
No transactions found
In most cases, this is caused by the following:
- invalid date: your date format was not recognised -> check if the date format in the CSV file and set the custom date format accordingly
- The most common date formats are interpreted automatically, but if not you can set a custom date format in the import settings
- empty description an entry line didn't have a description -> check if the description column is set correctly
- import settings incomplete
- make sure the file settings are set up correctly
- bank rule «standard» is set to «1020» or similar
- transaction rule «standard» is set to «1099» or similar (not a bank account!)
- file type invalid:
- accrio currently only accepts CSV / TXT / XLSX* (*Excel in beta, only the first sheet in a workbook is imported).
- if you have a different format, you might be able to convert it to a CSV using Excel, Google Sheets or Numbers very easily: Click on «save as» and select «CSV UTF-8 comma-separated» as the file format
- you can also ask our support team to add support for your file format by contacting.
- corrupt syntax / file opened Excel
- Excel unfortunately has a tendency to corrupt CSV files when just opened by double clicking the file. Therefore we recommend to
- make a copy of the csv file and only open the copy in Excel. This way you can always go back to the original file if something goes wrong.
- only import original csv files in accrio (have not been edited in Excel)
- Excel unfortunately has a tendency to corrupt CSV files when just opened by double clicking the file. Therefore we recommend to
tip
If you are still having issues, please contact our support team.
No headers found
- headers are not in the first row
- set line offset correncly (import settings > file settings > 1 > line offset)
- file type invalid:
- the file has to be a CSV file (not an Excel file or any other format)
- you can convert your file to CSV using Excel, Google Sheets or Numbers very easily: Click on «save as» and select «CSV UTF-8 comma-separated» as the file format
- corrupt syntax / file opened Excel
- Excel unfortunately has a tendency to corrupt CSV files when just opened by double clicking the file. Therefore we recommend to
- make a copy of the csv file and only open the copy in Excel. This way you can always go back to the original file if something goes wrong.
- only import original csv files in accrio (have not been edited in Excel)
- Excel unfortunately has a tendency to corrupt CSV files when just opened by double clicking the file. Therefore we recommend to
Issues sending transactions to bexio
- credit and debit account are identical
- make sure you have set up the import settings correctly
- «book fee's to account» has to be an expense account (e.g. 68xx). It cannot be a bank account (e.g. 1020)
- transaction rules > «standard» has to be a transfer account (e.g. 1099). It cannot be a bank account (e.g. 1020)
- make sure you have set up the import settings correctly
- account not found
- a transaction is missing a debit or credit account
- tax code not found
- you're tax code was not found
- your company is not subject to VAT. Bexio only accepts VAT codes if your company is subject to VAT. If you are not subject to VAT, you have to remove all tax codes from the transaction rules.
- bexio account not connected
- make sure you have connected your bexio account in the settings
- double entries
- accrio currently doesn't support automatic deduplication. Therefore you should make sure, that you don't import the same transactions twice. If you are sure that you have not imported the same transactions twice, please contact our support team.