We need to know what format the dates are in so we can process the file correctly. We'll prompt you to confirm this before uploading.

To find out what format the dates are in:

• Open your QIF file in a text editor. If you’re a Windows user, you can use Notepad, or use TextEdit if you use a Mac
• Find a date linked to a transaction and take note of their order. We need to know the order of day, month and year
• Select the correct date order when you upload your file

The maximum file size you can upload is 250 MB.

Tips to create your CSV file

There are two ways to create the CSV file to import:

• Adjust the CSV file from your bank to match one of our CSV file templates
• Download a template file. Then copy and paste information from your bank into our template

CSV file with three columns

Download a three-column CSV template

1. The file must contain columns labelled Date, Description and Amount and be in that order.
2. Separate dates in the Date column by a slash, such as 04/01/2021.
3. The Description column must contain text. It can't be blank.
4. The text in the Description column must all be on one line.
5. The Amount column must only contain numbers.
6. Payments in and payments out must both be in the Amount column.
7. Payments out must have a negative value.

CSV file with four columns

Download a four-column CSV template

1. The file must contain columns labelled Date, Description, Money in, Money out and be in that order.
2. Separate dates in the Date column by a slash, such as 04/01/2021.
3. The Description column must contain text. It can't be blank.
4. The text in the Description column must all be on one line.
5. The Money in and Money out columns must only contain numbers.
6. Payments in must be in the Money in column.
7. Payments out must be in the Money out column.

Add more details with columns

If you want to upload more detailed transaction information, you can add more columns in your file. You can include information like:

• Transaction reference
• Payee name
• Address

Extra Column Headings

Any new column headings must match one of the column headings below:

Header options	Information in your column
Cheque number	For example, 650240
Cheque
Cheque ref
Document number
Reference	For example, a 20-inch lemon drizzle cake
Reference number
Transaction reference
Transaction ref
Payee name	For example, Jane Doe
Payee
Payee description
Customer reference
Customer
Cust ref
Address Line 1	For example, Newcastle upon Tyne
Address
Street
House/street
Address Line 2
Address Line 3
City
Town/city
Town
Postcode	For example, NE13 9AA
Post code
Post-code
Phone number	For example, 07700 900 982
Phone
Phone #
Payee bank ID	For example, HSBC
Payee BankID
BankID
Bank ID
Payee account	For example, 12345678
Payee account number
Payee account ref