Close Navigation
Property Manager Sign up as a
Property Manager
It takes just 15 seconds with no credit card needed

By submitting your details, you are agreeing to our Terms and Conditions

How to Import a Bank Statement (Dec 21)

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 Excel Statement accordingly

 

Step 4: Every column is mandatory apart from reference and payee. We recommend putting the payee as a TE number reference, to make the reconciliation process easier

 

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

Still have a question?

Our support staff are ready to help with any technical issues.
To get in touch please use our online chat below