How to format your CSV file
To create a basic CSV file you need to create a minimum of three columns: Date, Description and Amount.
- Column A, Date: Always use the UK formatted version of the date - DD/MM/YYYY
- Column B, Description: This can be any description you require to be entered into the description field within a transaction.
- Column C, Amount: This column needs to be formatted like a number to 2 decimal places. Payments into the bank will be positive numbers and payments out of the bank will need to be a negative (e.g. minus sign in front of the number).
However, the above is the minimum requirements that you need. You may have a bank CSV file that has separated the amount columns between payments outs and payments in.
Helpfully, we have already provided you with a list of templates from the major banks that you can choose when you import a CSV.
Banks we currently support are as follows:
HSBC, Lloyds Bank, Natwest, Cater Allen.
When you select the file you wish to upload, you will also be given the option to select which bank the file has come from as well.
Requirements for a successful import
Please ensure you follow the following guidelines...
- There are no comma's in your amounts column
- The date format is DD/MM/YYYY
- If you are using a single amount column, you have used a minus sign for payments out.
- If you are using separate columns for payments and receipts do not include a minus before the payment.
- The file type is "CSV" - character delimiter of comma is used.
- The file type is not .xsl or .xlsx