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

Start your 14 day trial today

How to Import a Bank Statement

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