Creating custom bank file imports

To import details from a bank or credit card where the import format is not listed

Luke Mayo avatar
Written by Luke Mayo
Updated over a week ago

The majority of mainstream bank accounts are covered by default formats within the Bank Feeds.

However, if you use a bank or credit card 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 import bank transactions directly into Business Cloud to save time rekeying them.

Category - you may wish to add a column called Category to your file and add them to the spreadsheet prior to importing. They will then be automatically matched to the right category providing they are entered with exactly the same name (not code). This means that you will need to customise the import as the file layout will have been altered slightly.

If you log onto your online bank account you will normally find an option to export entries over a particular date range. Make sure that you choose a file that is in a CSV format and save it onto your computer.

To create a custom import go to Banking > Bank Accounts > then click the ‘Enter Transactions’ button for the 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 custom format for, either by dragging and dropping it, or by browsing your computer. This must be a CSV file.

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

Next, Farmplan Business Cloud 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 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?