Instead of typing transactions manually, upload your bank statement as a CSV or PDF. TenancyVault extracts the rows and shows them for review — you confirm what goes into your records before anything is saved.
Choose a CSV export from your bank or upload a PDF bank statement. TenancyVault extracts the transaction rows automatically.
Each transaction is shown in a review table. You see the date, description, and amount. You decide what to do with each row before anything is saved.
Mark each transaction as included (it will be saved to your records) or skipped (it is excluded entirely). You can change your mind before confirming.
For each included transaction, assign an expense category and the property it relates to. Use bulk actions to categorise multiple rows at once.
Identify any transactions that are personal transfers — owner drawings, personal payments, or non-business movements. These are kept separate from HMRC expense totals.
Once you are happy with the review, save the transactions to your MTD records. They are now included in your quarter totals and ready to file when you're ready.
Most UK banks offer a CSV or Excel download from their online banking portal. Upload the file and TenancyVault maps the date, description, and amount columns automatically.
Upload a PDF statement directly. TenancyVault extracts the transaction data from the PDF and presents it for review. You can check the imported rows match the original statement before saving.
After import, you always review and confirm transactions before they are saved to your records. Nothing is filed to HMRC automatically at the point of import.
When you assign a category to a transaction, you see plain-English names. TenancyVault maps these to the correct HMRC expense classifications for your quarterly submission. You do not need to know the technical category codes.
| What you see | HMRC category |
|---|---|
| Mortgage interest | Finance charges |
| Insurance | Insurance |
| Repairs & maintenance | Maintenance & repairs |
| Letting agent fees | Letting agent fees |
| Ground rent & service charge | Ground rents & service charges |
| Gas, electricity & water | Utility costs |
| Legal & professional fees | Legal, management & other professional fees |
| Advertising & renewals | Cost of services |
| Personal transfer | Excluded from HMRC totals |
TenancyVault also supports custom review categories per account so you can organise transactions in a way that makes sense for your portfolio before assigning HMRC categories.
Bank statements often include transfers that are not business expenses — owner withdrawals, top-up deposits, inter-account movements, or personal purchases. These should not appear in your HMRC quarterly totals.
During the import review, mark these as personal transfers. They are stored separately and excluded from your HMRC expense totals when you file. Your quarterly figures stay accurate without manual adjustment.
Start free — no credit card required.
