The MTD Deadline For 6 April 2026 is Almost Here.Get Prepared Today For Free!

Getting Started & Account Setup

Linking Your Bank Account to RentalBux — Manual & Automatic Options

4 min read
Feb 25, 2026
Updated Mar 3, 2026

Getting your bank transactions into RentalBux is the foundation of everything else — your MTD figures, your reconciliation, your reports. The good news is there are two ways to do it, and both are straightforward. This guide walks you through each option so you can choose the one that works best for you.

Why linking your bank account is important?

Without a bank connection, you'd need to enter every rent receipt and every expense manually. That's slow, error-prone, and the opposite of what MTD digital record-keeping is supposed to achieve. A linked bank account means:

  • Transactions are imported automatically (or via quick monthly upload)

  • RentalBux auto-categorises income and expenses against HMRC's chart of accounts

  • Your quarterly MTD figures are based on verified bank activity, not manual estimates

  • Bank reconciliation takes minutes, not hours

Option 1 — Automatic bank linking (Open Banking)

This is the fastest and most hands-off option. Once connected, RentalBux pulls in new transactions every day automatically. You just review and confirm the categorisations.

How to set it up

  1. Go to Bank > Bank Accounts in the sidebar menu

  2. Click Connect Bank Account

  3. You'll be redirected to your bank's own secure login page

  4. Grant read-only access to RentalBux

  5. Select from the list of Supported Banks

  6. Scan shown QR code with your banking app or continue logging in with your browser

  7. You'll be redirected back to RentalBux. Your bank will appear as Connected in your bank settings

Supported UK banks

Barclays, Lloyds, HSBC, NatWest, Santander, Nationwide, TSB, Metro Bank, First Direct, Monzo, Starling, Revolut, Tide — plus most UK building societies and challenger banks. If your bank isn't listed, use Option 2 (manual upload) instead.

Security — What you need to know

  • RentalBux uses Open Banking, which is regulated and authorised by the FCA

  • Your bank credentials are never stored by RentalBux — you authenticate directly with your bank

  • Access is read-only: RentalBux can see your transactions but cannot make payments or transfers

Option 2 — Manual bank linking (CSV upload)

If you prefer full control over what gets imported, or your bank doesn't support Open Banking, manually adding a bank and uploading statements works just as well.

How to manually add your bank

  1. Select enter bank manually from the Bank Account section

  2. Enter Account holder name, bank name, account number and other required details

  3. Click on Save

How to prepare your bank statement

  1. Log in to your online banking and navigate to Statements or Transaction History

  2. Set the date range you want to import (one month at a time works best)

  3. Export or download as CSV (sometimes labelled as 'Excel' or 'Spreadsheet' — make sure it's a .csv or .xlsx file)

  4. Check the file has these four columns: Account Number, Amount, remarks and transaction Date (DD/MM/YYYY format). Remove any subtotal rows or blank rows

How to upload your statement

  1. Go to Bank Account > select Import Bank Statement

  2. Click Upload File and select your prepared CSV or Excel file

  3. RentalBux will preview the transactions and ask you to confirm the column mapping (which column is the date, which is the amount, etc.). Do this once — RentalBux remembers the format for your bank

  4. Click Confirm Import. Your transactions appear in the reconciliation queue

 

Format question

Answer

Which file types are accepted?

CSV, XLS, XLSX, PDF

Maximum file size?

10MB per upload (less the better)

Date format required?

DD/MM/YYYY

Can I import multiple months at once?

Yes — just make sure there are no gaps between periods

What if my file has a password?

Remove the password before uploading — RentalBux cannot open protected files

After importing — What happens next

Regardless of whether you used automatic or manual linking, the process from here is the same. RentalBux will:

  1. Analyse each transaction and suggest a category based on the description and your previous choices

  2. Show you a list of categorised transactions for review. Green items are confidently categorised.

  3. Allow you to match each transaction to an existing invoice or bill — or create a new record from the transaction

  4. Update your running balance as you work through the queue

Troubleshooting common issues

Issue

Likely cause

Fix

File won't upload

Wrong format

Re-export from your bank as CSV or XLSX

Dates showing in wrong order

US date format (MM/DD/YYYY) in file

Re-map the date column in the preview step

Amounts showing as negative

Bank exports outgoings as negative values

Toggle 'reverse debit sign' in column mapping

Duplicate transactions appearing

Overlapping date ranges imported twice

Delete the import and re-import with a clean date range