Format of the file
The file containing the transactions must be in a text-based format (.csv) for Substly to read and analyze the data.
Most banks and credit card issuers allow you to export statements in a text-based format directly from their internet bank. Please contact your bank if you require assistance with exporting data from them.
If there is an option to export "additional data", "all details", or similar, ensure that you check the box and export all information about the transactions. If you don't, some banks/card issuers will not export all the data needed to identify the vendors/services.
Content in the file
As a minimum, the transactions file needs to contain the following columns with information:
date: the date of the payment (the date formatting needs to be YYYY-MM-DD).
description: this field contains information about the transaction needed to identify the service or vendor. It is always present in an exported statement but is named differently from bank to bank. This field is sometimes called: text, recipient or similar.
amount: the amount of the payment.
Optional columns to add to your file if you want Substly to map more transactions automatically or to be able to see your payments in the currency they were charged.
message: this field also contains information about the transaction needed to identify the service or vendor. It is usually excluded in an exported file if you don't ask for "additional data", "all details" etc. Without this field, Substly will only be able to map up a part of your services and costs. This field is sometimes called: place of purchase, vendor or similar.
currency: the currency in which a charge was made (USD, EUR, SEK etc).
Note! The column headers must be named exactly 'date', 'description', etc. Any other wording will prevent Substly from mapping the data correctly.
Example file
Link to an example .csv file (containing the same data as the picture below)
