How to Import a Bank Statement

Modified on Wed, 21 Feb 2024 at 11:07 AM

[embed]https://www.youtube.com/watch?v=KgbzmrjpghM[/embed]   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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article