Fast, clean, MTD-ready bank reconciliation
Connect via Open Banking or upload CSV statements to automatically match transactions against your invoices and bills — then resolve any exceptions and export clean data for your accountant.
Bank Reconciliation — all guides
Four guides covering everything from initial bank connection to year-end export for your accountant.
Bank reconciliation capabilities
Connect your bank account and transactions appear automatically — usually within 24 hours. No manual exports. Your records stay current every day.
RentalBux matches incoming bank transactions to invoices and bills by amount, date and description. Matched transactions are reconciled instantly.
Transactions that can't be auto-matched are flagged for review. Link to an existing record, create a new entry, or mark as non-business.
Export reconciled data filtered by property — a clean ledger for your accountant at year-end or for any HMRC enquiry.
Connect multiple bank accounts and map each to the correct property. Transactions are allocated automatically based on your account-to-property mapping.
Every reconciliation session is logged with a timestamp and transaction count — a complete audit trail for HMRC record-keeping requirements.
Why bank reconciliation is essential for MTD for landlords
HMRC's MTD for Income Tax requires digital records that accurately reflect your financial activity. Bank reconciliation confirms that your RentalBux records match your actual bank activity — that every rent payment is recorded, every expense is logged, and there are no duplicate entries. Submitting a quarterly MTD update based on unreconciled records is risky: you might understate income (missing a rent payment that arrived late) or overstate expenses (logging a bill twice). Reconciling before each quarterly submission takes minutes with RentalBux and prevents hours of correction work later.
Open Banking vs CSV import
If your bank supports Open Banking (most major UK banks do), connecting RentalBux via Open Banking is the most efficient option. Transactions appear automatically, usually within 24 hours. The connection is authorised via your bank's own security system — your bank credentials are never shared with RentalBux — and can be revoked at any time from your bank's own app. If you prefer manual control, or your bank doesn't support Open Banking, CSV upload works equally well. Most banks allow you to export a CSV for any date range. Upload it to RentalBux and the auto-matching engine processes it identically to an Open Banking import.
Resolving unmatched transactions
After each import, most transactions match automatically. For those that don't, RentalBux presents them in a review queue. For each unmatched transaction you can: manually link it to an existing invoice or bill, create a new income or expense entry on the spot, or mark it as non-business (excluded from MTD records but visible in your transaction history). Once every transaction is resolved, your reconciliation is complete and you're ready to submit your quarterly update.
Frequently asked questions
Open Banking connections use FCA-regulated account information services provided through Finexer Ltd (FRN: 925695). Your bank credentials are never shared with RentalBux — the connection is authorised directly with your bank. You can revoke access at any time from your bank's own portal.
RentalBux accepts standard CSV exports from all major UK banks. The file needs at minimum a transaction date, description and amount column. The import tool lets you map your CSV columns to these fields if they have different names. Setup guides include export instructions for Barclays, Lloyds, NatWest, HSBC and Santander.
Yes. Many agents provide monthly statements showing rent collected, management fees deducted, and the net amount paid to you. Upload this as a CSV and RentalBux treats it the same as a bank import — matching rent receipts to invoices and agent fees to expense records.
Mark it as "non-business" in the reconciliation queue. It's excluded from your MTD records and income statement, but remains visible in your transaction history with a non-business flag for audit purposes.
Continue with more guides
Still need help?
Our UK-based support team is here to help. Reach out by phone, email, or browse our resources.