Creating custom file imports

We do not currently have default import formats for all UK banks. 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 Enter Transactions > Banking Tab > then click the ‘Enter Transactions’ button for bank account you wish to enter transactions for. .

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 FR Books which row is the heading and where the first row of data (transactions) begin. Below is an example:

Next, FR Books 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.

‍