Currently, Clever Accounts only accepts bank statements in CSV for upload. However, Clever Accounts supports multiple CSV formats.
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 for CSV import
Barclays, Cater Allen, Halifax, HSBC, Lloyds, Metro, Natwest, and many more.
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