How to Import a Bank Statement

How to Import a Bank Statement

This article covers how to import a bank statement into the Arthur bank feed. This is only for users who subscribe to the Arthur bank feed and are unable to connect their live bank feed.

Bank statements can be imported to the Arthur bank feed as often as you want ie, daily, weekly, monthly etc. Always ensure you are importing the bank from the last imported bank lines to void duplicate bank lines

To import your bank statement to Arthur, follow the steps below.

Step 1: Go to Financials > Bank Accounts

Step 2: Click the drop down on the relevant bank account > Import Bank Statement

Step 3: Download the sample template > Fill in the CSV doc accordingly

Step 4: Every column is mandatory apart from reference and payee. Column A is your Bank ID, which can be found when you click on ‘start rec’ on your bank account screen. In this case your bank ID is 92967

Step 5: Make sure the date format is YYYY-MM-DD, to change the entire columns format easily, select the whole column at the top of the spreadsheet > drop down where it says general > more number formats > select date on the left hand side > choose the 3rd option from the bottom

Step 6: Upload from selected device > confirm everything on the confirm screen

Note: any errors will highlight in RED, and duplicates will highlight in ORANGE

For a step-by-step video explanation of this process, please click here.