Property Manager Icon 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 7 day trial today

How to Import a Bank Statement


Please ensure you are subscribed to the live bank feed


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