Bank statement upload

Alexi Glackin
Alexi Glackin
  • Updated

In Jupix, there are two versions of the reconcile screen:

  • Manual reconciliation - This is the default setting when you first start with Jupix
  • Automated statement upload - This feature allows you to upload a copy of your bank statement into Jupix, to reconcile your bank receipts and payments to your Jupix accounting records
    For more information on Using Auto Reconcile, click here

Bank statements can only be imported in .csv format. The banking formats we support are:

  • Barclays
  • Handlesbank
  • HSBC
  • HSBC V2
  • HSBC Net
  • Lloyds
  • Lloyds Commercial
  • Natwest
  • Natwest Bus
  • QIF

This article includes: 

How to use automated bank statement upload

The automated statement upload feature can only be turned on by Jupix support so if this isn't currently available to you, please contact support by clicking Submit a request and using the contact form at the bottom of this article.


It's important that you don't open the file, only save it. Opening the file will corrupt the data

  1. Download the previous days bank statement and save it to your desktop
  2. Click the Residential Lettings department tab
  3. On My Dashboard, scroll down to Accounts. Click Reconcile alongside the relevant client account 
  4. Click Upload Statement
  5. To locate your bank statement file on your computer, click Browse
  6. When the file has been located, click Upload
  7. The Bank Statement Items populate

How to reconcile your transactions

  1. Click on an entry in the left hand Bank Statement Items 
  2. A list of possible related transactions displays on the right hand Rent Account Items to reconcile against. Click the correct entry in the Rent Account Items
  3. Once the item is selected, it moves to the bottom of the screen. Jupix allows you to Learn the transaction, which enables you to Auto Match the transaction in future


Currently, only standing order payments can be learned

Faster payments inwards (FPI) transactions can be ticked to Learn but won't automatically match on the next reconciliation.