Import bank transactions

Download your transactions from your bank and import them directly into Farm Focus as a csv or qif format.

Updated yesterday

Once you have downloaded the transaction list from your bank's website, you can import the file into your farm business. Note it is best practice to use Bank Feeds, if available.

TIP: The file format needs to be either a CSV or QIF. Ask your bank if you need help with downloading your transaction list file.

  1. Go to the In the Actuals screen.

  2. Click on the upload arrow at the top right of the screen and in the Import file page select Bank transaction file.

  3. Select the correct Bank account from the dropdown menu.

  4. Import your bank transaction:

    a. Select from the dropdown list the bank account you are importing the transaction for.

    b. Click to Browse your folders. The file you have exported from your online banking will be located in your Downloads folder with the account number, time and date in the heading,

    c. Click to Import the file

  5. Your bank transactions will now be listed in order of payment date in your Needs Action Screen.

TIP: It is best practice to use bank feeds. Currently, BNZ, ANZ, ASB, Rabobank and Westpac customers with Farm Focus can sign up for bank feeds. (Rabobank is currently the only bank feed available for Australian farmers).

For NZ customers select the CSV for Kiwibank and Heartland Bank.

For Australian customers select the CSV for Commonwealth Bank, Westpac (AUS), ANZ (AUS), Rabobank (AUS) and NAB.

What happens next?

The transactions will remain in the Needs Action screen until they have been
โ€‹coded, or matched to an invoice.

Create coding rules to save time and ensure that transactions are consistently and accurately coded every time.

Did this answer your question?