We do not currently have default import formats for all UK banks or payment platforms. However, if you use a bank which does not currently have a default import format you can still use the file import method to input your transactions by creating a custom file import.

To do this you need to go to Banking > Bank Accounts then click the ‘Enter Transactions’ button for bank account you wish to enter transactions for.

You will need to ensure the entry method is set to 'File Import'.

After this, click the 'Custom Import Formats' button, then 'Add New Custom File Import'

Name your import and upload the file you are creating a format for. This must be a CSV file

You will then be asked to tell Pandle which row is the heading and where the first row of data (transactions) begin. Below is an example:

Next, Pandle will need to know which heading is the date (and the format of the date), which heading is for the description and which heading(s) is for the amount (and the format). Please note, some banks keep the amount under one heading and some have a heading for money in and and a heading for money out.

Finally, click 'Save File Import Format' and the new format will be displayed in the list of default formats when you next upload a file.

Did this answer your question?