When you upload a CSV or Excel file, Finbooks checks its format and content before importing anything. If the file doesn't match what the connection expects, it is marked Rejected and no transactions are imported.
This article explains how to read the result, the most common causes of rejection and what to do next.
How to check what went wrong
Right after you click Upload CSV, Finbooks validates each file and takes you to the Check Import Result step. Follow these steps to read the result:
in the Check Import Result step, find your file in the list
read the Rows count, File status and import status columns (see the table below)
if the file is Rejected with a number of rows with errors, click on See errors to open the error details drawer, where you can see the specific error for each row
click on Export errors to download the error list as a CSV file
If the import status is Malformed, no error report is available: the header of the file is wrong, so there are no row errors to show. Check the header against the guide for your connection.
When the header is wrong, the app shows a Download template CSV button. It is the quickest fix: download the template and copy your transactions into it.
Import result by file status:
File status | Rows count | Import status | What it means |
Uploaded | Number of transactions imported | Imported or In progress | the format is correct and the file has been accepted |
Rejected | 0 | Malformed | the header of the file is wrong, nothing was imported and no error report is available |
Rejected | 0 | Number of rows with errors | the file has rows that can't be read, so the whole file is rejected and nothing was imported |
⚠️ Errors are not stored
The error details are only available while you are on the Check Import Result step. If you leave the page or start a new upload, they are lost. Download the error report with Export errors before leaving, or upload the file again to see the errors again.
Common causes of rejection and how to fix them
Check the causes below in order. Most rejections come from the first four.
The file type doesn't match the connection
Some connections accept CSV files only, others accept native Excel (.xlsx) files. Check the connection guide for your platform to see which format it supports.
If the guide asks for the file exactly as the platform exports it, upload it without converting it. Re-saving a file in a different format can change its structure.
The file was edited or re-saved
Opening a CSV in Excel and saving it again can add changes you can't see, for example extra quotation marks in the header or in the first rows. This is enough to get the file rejected.
If you need to check a file, open it in a plain text editor (Notepad on Windows, TextEdit on Mac). To learn more, read What is a CSV file and how to edit it.
The file is not the one the connection guide asks for
Each connection guide tells you which report to download. A different report from the same platform, or a file from a different platform, will not match the expected structure.
Check that you are uploading the file requested in the guide, covering your full history, and into the connection created for that platform.
The platform is not supported with a native file
If Finbooks doesn't support the platform's native file, the platform's export can't be uploaded as it is. You need to put your transactions into the Finbooks custom CSV and upload it to a custom connection.
crypto, follow How to compile the crypto Custom CSV
traditional finance (stocks, bonds, ETFs, derivatives and similar), follow How to compile the TradFi custom CSV
For all your options, read My platform isn't supported: what are my options?.
The custom CSV doesn't follow the Finbooks format
If you compiled a custom CSV, the file is rejected when its header or columns don't match the template:
the first row must be the header, and it must match a Finbooks template exactly: same column names, same order, no extra or missing columns
all 13 columns must be present, even if some are empty
each row is a single transaction
mandatory columns must always be filled in
For the crypto custom CSV, the header can be in English, Italian, French, Spanish or Portuguese, as long as it matches one Finbooks template exactly. For the TradFi custom CSV, the header must be in English.
You can use either a comma or a semicolon as the separator between columns.
The header of the crypto custom CSV, in English, is:
` TYPE,CATEGORY,TRANSACTION DATE,OUT CURRENCY,OUT AMOUNT,OUT FIAT VALUE,IN CURRENCY,IN AMOUNT,IN FIAT VALUE,FEE CURRENCY,FEE AMOUNT,NOTES,ORIGINAL ID `
The header of the TradFi custom CSV (English only) is:
` ASSET CLASS,TYPE,EXCHANGE CODE,CATEGORY,TRANSACTION DATE,OUTGOING ASSET,OUTGOING AMOUNT,INCOMING ASSET,INCOMING AMOUNT,FEE CURRENCY,FEE AMOUNT,POSITION ID,NOTES `
You can start from the crypto template, which already contains the header.
If the header is wrong, the app shows a Download template CSV button: download the template and copy your transactions into it. For the TradFi custom CSV there is no template link, so follow the TradFi guide.
ℹ️ Crypto and traditional finance are separate
Use the crypto custom CSV for crypto and the TradFi custom CSV for traditional investments. If you only see the traditional finance section in your account, read How to enable the Crypto section.
Dates are not in a supported format
The TRANSACTION DATE column is mandatory and must use one of these formats:
yyyy-MM-dd HH:mm:ss
yyyy-MM-dd HH:mm
dd/MM/yyyy HH:mm:ss
dd/MM/yyyy HH:mm
For example, a transaction on 02 January 2024 at 9.45 pm can be written as 2024-01-02 21:45 or 02/01/2024 21:45.
Dates and times must also match your local timezone. Finbooks can't detect the timezone used by the platform, so convert timestamps to your local time before uploading.
Numbers use a decimal comma
If you use a comma as the decimal separator, you must enclose the number in quotation marks, otherwise the comma is read as a column separator and the row breaks. You can also use a point as the decimal separator.
Format | Example | Result |
Decimal comma without quotation marks | 2999,85 | wrong |
Decimal comma with quotation marks | "2999,85" | correct |
Decimal point | 2999.85 | correct |
Mandatory values are missing
What you must fill in depends on the transaction type:
Incoming, the received asset and amount
Outgoing, the sent asset and amount
Trade, both the sent and the received asset and amount
Every row also needs its type, category and date. For the full list of columns, check the guide for crypto or traditional finance.
The platform changed its export format
Platforms update their files from time to time. This can lead to an unsupported format, missing columns, unrecognised transaction types or headers that no longer match.
If you believe the file should be supported, contact Finbooks Support. Details are in the section below.
Common error messages
Message | What it usually means |
Some errors were found in the header: one or more column headers do not match our required format, and we are unable to suggest a valid correction. | the header of the file doesn't match the expected one: check the file type, check whether the file was edited, and check that the header matches the connection guide or the custom CSV template exactly |
Unrecognised columns: no Finbooks CSV template matches this file | the header doesn't match any Finbooks template in any supported language: compare the header with the template and correct the names and order, or start again from the template with Download template CSV |
Unrecognized section | the file contains a section the software can't recognise: upload exactly the report requested in the connection guide, unedited |
If you see an unexpected technical error message, contact Finbooks Support and attach the file.
There are no partial imports
Finbooks imports a file all or nothing. If even one row has an error, the whole file is rejected and no transactions from that file are imported.
When the import status shows a number of rows with errors, open See errors to see why each row failed, fix those rows in the source file and upload the file again. Because nothing was imported from the rejected file, you won't create duplicates by uploading the corrected file.
What to do next
Follow these steps after a rejection:
if the import status shows rows with errors, open See errors and download the list with Export errors. If it shows Malformed, there is no error report: check the header instead
compare the error with the causes above and fix the file. If the header is wrong, click on Download template CSV and copy your transactions into the template
upload the corrected file again:
in an existing connection, click on Connections in the left-hand menu, click on the three dots at the end of the connection line, then select Import new file
from the last step of the upload procedure, click on Import new CSV
check the new result in Check Import Result
If you don't want to compile the file yourself, you can use the paid CSV file formatting service. The result depends on the data you provide.
How to contact Support
If the file is still rejected, contact Finbooks Support by chat or at customer.support@finbooks.com and send:
the name of the file and the platform it comes from
the original file, exactly as you downloaded it
the error report downloaded with Export errors
Our team will check whether the format is supported and help you with the next step.
For the full upload procedure, read How to upload a CSV/Excel file.
Quick answers
Can I upload an Excel file?
It depends on the connection. Some connections accept native Excel (.xlsx) files, others accept CSV only. Check the connection guide for your platform.
Why does my file show Malformed?
Malformed means the header of the file is wrong, so the whole file was rejected and no transactions were imported. Check that you are uploading the file requested in the guide, unedited, or that your custom CSV header matches a Finbooks template exactly. The quickest fix is the Download template CSV button: download the template and copy your transactions into it.
Why is Check Import Result not working after I left the page?
The error details are not stored once you leave the upload procedure. Upload the file again and click See errors before leaving the page.
Are any transactions imported from a rejected file?
No. A file is imported all or nothing: if one row has an error, the whole file is rejected. For a Rejected file, Rows count shows 0 because no transactions were imported.
Can I download an error report for a Malformed file?
No. Malformed means the header of the file is wrong, so no error report is available. Check the header against the connection guide.
