Making Tax Digital for Landlords: Keep Rental Income Records With AI

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Making Tax Digital for Landlords: Keep Rental Income Records With AI.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Making Tax Digital for Landlords: Keep Rental Income Records With AI.

A landlord can use AI to label rent statements, spot missing months and draft questions about expense receipts, then record the verified amount, date and category in compatible software. Making Tax Digital for Income Tax applies in stages when combined qualifying property and self-employment income exceeds the relevant threshold; AI does not replace the software that sends quarterly updates.

The published stages start from 6 April 2026 for qualifying income above GBP 50,000 on the 2024 to 2025 return, 6 April 2027 for above GBP 30,000 on the 2025 to 2026 return, and 6 April 2028 for above GBP 20,000 on the 2026 to 2027 return. The test uses gross income before expenses. Confirm your own position with current official guidance and a qualified adviser where ownership or relief makes the figure unclear.

Follow me on Instagram@sagnikteaches

Check whether your rental income puts you in a stage

Take the filed return for the year associated with the stage, then add the qualifying gross property income and gross self-employment income shown there. Do not subtract letting-agent fees, repairs or finance costs before comparing the total with the threshold. A landlord with GBP 28,000 of gross rent and GBP 24,000 from a separate sole-trader activity has an illustrative combined figure of GBP 52,000. That may put the person in the first stage if those are the correct figures on the relevant return. A landlord with GBP 52,000 of property profit after expenses might have an even higher gross figure; “profit” is the wrong field for the threshold sort.

Connect on LinkedInSagnik Bhattacharya

More than the threshold is the published wording. If your total is exactly GBP 50,000, an AI assistant should not round it to “over” or conclude the next stage without checking the return. Income that is missing from the records, an amended return, jointly held property or a possible exemption needs a tax professional's review. The official checker can help establish when to start; keep its result with your records. The stages and guidance can change, so recheck before you set up a long-term calendar.

Subscribe on YouTube@sagnikteaches

If your accountant is doing this check for a whole client list, the practice-side MTD triage tutorial describes how to track evidence and reminders. As an individual landlord, your more immediate task is to make each rent receipt and property expense findable, complete and correctly dated. That is where AI can reduce clerical effort without deciding tax treatment.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Choose a record path before feeding files to AI

Official guidance defines a digital record as an income or expense record created and stored using software that works with Making Tax Digital for Income Tax. The record needs the amount, the date income was received or an expense incurred, and the relevant category. You must also keep the normal supporting documents such as statements and invoices. An AI chat that reads a PDF and returns a table is only a preparation aid unless the verified records enter a compliant digital route. Check the official software finder for products that support your income sources and the agent arrangement you need.

There are two practical routes. An all-in-one product can hold the records, send quarterly updates and support the year-end return. A spreadsheet can also be used with compatible linking or bridging software, but the products must be digitally linked where required. The official guidance describes digital transfer options, including linked cells and file import. It warns against manually moving submitted digital records by copy and paste between products. Ask a software provider or accountant to demonstrate the complete path with sample data before you rely on it.

For example, a landlord keeps rent in a spreadsheet and uses a separate submission product. A test should show how a new rent row in the spreadsheet reaches the quarterly totals, how an amended row is handled, and how the year-end return draws the data. If the only method is to read an AI summary and type the figures into a second screen, the route has not passed that demonstration. A product name alone is not proof: check support for property income, any other relevant income sources, and access for your adviser.

Write down who does each task before the first reporting period closes. A landlord may enter rent, an agent may send monthly statements, and an accountant may review categories and submit. Without a role sheet, each can assume the other has recorded a repair. An illustrative hand-off says: “Landlord uploads statements and invoices by the 12th each month; bookkeeper enters and reconciles by the 20th; accountant reviews open questions before the quarterly submission; landlord confirms any unexplained receipt.” The dates are internal targets, not official ones. The hand-off should include where the authoritative digital record lives, who can correct it, and how a correction is communicated to the next reviewer.

Make a ledger that keeps the property detail visible

For the everyday working view, keep columns for date received or incurred, property reference, source document, counterparty type, description, gross amount, category, payment method, evidence link and review state. The actual digital record must be held in your compatible setup. A property reference helps you reconcile rent and repairs, even where the official quarterly update groups property income into a property business. Avoid names and addresses in the dataset you give to a general AI tool; use property codes such as P1 and P2.

DatePropertyIllustrative entryAmountEvidence and state
8 AprilP1Monthly rent receivedGBP 1,250 incomeBank reference 04-08; checked
11 AprilP1Letting-agent feeGBP 125 expenseAgent statement A04; review category
3 MayP2Repair invoice paidGBP 310 expenseInvoice R17; business purpose checked
8 MayP1Expected rent absentUnknownQuestion, not a zero record

These are illustrative entries, not an example of approved tax treatment. The absent May rent is a review flag, not a claim that a tenant owes money or a taxable figure. The agent fee and repair need category and allowable-treatment checks by the landlord or adviser. Keep the source statement or invoice linked so a reviewer can verify dates and totals. If the rent comes through an agent net of fees, record the underlying income and deduction according to the appropriate treatment rather than treating the net bank deposit as the whole story without checking the statement.

A landlord who receives one statement for several properties needs a second check. For example, an illustrative statement lists P1 rent of GBP 1,250, P2 rent of GBP 950, an agent fee of GBP 220 and a transfer of GBP 1,980. The transfer matches rent less the fee, but it is not a replacement for the underlying components. Record the source statement reference against each related row and verify that the bank transfer reconciles. If the statement shows a withheld amount whose purpose is unclear, leave it in a question queue. AI may parse the four numbers, but it should not decide whether the withheld amount is an expense or a balance carried forward.

Ask AI to spot gaps, never to invent a transaction

AI can compare a list of expected monthly rent dates with actual ledger rows and produce questions: “P1 has no May receipt; was payment late, received elsewhere, or omitted from the import?” It can also identify a duplicate invoice number or an unusually large fee that deserves inspection. It cannot know whether a bank payment was rent, a deposit, a reimbursement or a personal transfer merely from an amount. Give it de-identified rows and explicit permission to say “uncertain”. Do not upload full statements to a consumer tool unless you have checked the privacy terms and are comfortable with that use.

Review these de-identified property ledger rows for completeness.
Expected rent: P1 GBP 1,250 around the 8th each month;
P2 GBP 950 around the 15th. Period: April to June.
Return missing-month questions, likely duplicate references,
unclear categories and source documents to inspect.
Do not create transactions, decide tax deductions or fill blanks.
Label each finding with the row ID and confidence reason.

Illustrative output: “P1 May: expected receipt not found; inspect bank feed and agent statement. P2 June: two rows share receipt reference J15; inspect for duplicate import. R17: repair category needs source review.” The fix is to open the bank and agent records, not ask the model to make the table balance. If the May payment arrived on 2 June, use the verified receipt date and appropriate accounting basis in your software. An adviser can decide any tax question that follows.

A different error appears when the bank feed contains a GBP 1,200 deposit and AI labels it rent because it came from the same payer. Keep deposits and rent distinguishable in your source notes and require a human to classify ambiguous receipts. Another failure is a repair invoice photographed twice, once as a JPEG and once as a PDF. Match the supplier, date, amount and invoice number before creating two expense records. AI is useful for raising the possible duplicate; it should not delete either file or silently merge records.

When the model marks a transaction as uncertain, make the follow-up question answerable. “What is this payment?” may produce another vague reply. A better note is “The bank shows GBP 460 on 17 May from the letting agent, but the May statement shows no matching rent transfer. Was this a balance adjustment, rent for P2, or something else? Please attach the statement page that explains it.” This is an illustrative question, not a conclusion about the entry. Save the answer with the source reference and update the ledger only once the person responsible for the records accepts it.

Walk through one illustrative rental quarter

Suppose a landlord has two properties, P1 and P2. P1 should bring in GBP 1,250 a month and P2 GBP 950, giving expected rent of GBP 6,600 over three months if every instalment is received in that period. The landlord receives five payments on their normal dates and the sixth, P1's June rent, on 2 July. During April to June, the source evidence therefore shows GBP 5,350 received, subject to the landlord's accounting basis and review. The expected schedule is a completeness tool; it is not a substitute for recording what actually happened.

The landlord also has an illustrative GBP 310 repair invoice, three monthly agent fees of GBP 125 and a GBP 90 insurance charge. The source documents total GBP 775 of listed expenses: GBP 310 plus GBP 375 plus GBP 90. The adviser checks which categories and amounts belong in the digital records and whether any private or non-allowable portion needs adjustment. The landlord's AI check flags the late P1 payment, finds the agent fee statements and prompts for the missing insurance invoice. A reviewer ties every ledger row to evidence before the software produces cumulative totals.

At the second quarter, the 2 July payment must be handled according to the verified date and accounting treatment. The landlord should not add it to the first quarter just to make that quarter match the expected rent schedule. The software's next update covers the tax year to date, so a reviewer can see how the cumulative amount changes. If an earlier mistake is corrected, keep a note of what changed and why. The official guidance allows corrections to digital records to flow into later cumulative updates, but the individual must use the software process correctly.

For a separate illustration, imagine the same landlord also runs a small furniture-making activity with GBP 14,000 gross income on the relevant earlier return and GBP 18,000 gross rental income. The GBP 32,000 combined amount may cross a later threshold even though neither stream reaches it alone. The record plan still distinguishes the trading and property books. This is why a threshold check and a quarterly ledger are different jobs; ask an accountant if the source figures or the stage are uncertain.

Review the software's cumulative update, then submit

Official guidance says quarterly updates are summaries of income and expense category totals, not another full tax return and not a bundle of individual receipts. The compatible software calculates them from digital records for the tax year to date. Check the correct property business, period basis, dates, categories, missing transactions, duplicates and changes since the prior update. If you use standard periods, the first ends on 5 July and the deadline is 7 August; calendar periods end on 30 June for the same deadline. Later deadlines are 7 November, 7 February and 7 May. Confirm the period basis set in your product before the first submission.

If you had no income and no expenses in an update period, official guidance still calls for an update. Do a quick check of bank, agent and invoice sources before marking it nil. If a property is jointly let, the guidance lets you include either income and expenses or income only in quarterly updates. Choosing income only means reporting those expenses after the year ends, by resending the fourth quarterly update before the tax return, and any properties you own alone still need both. Have a qualified adviser choose and document the treatment. If you own multiple properties in one domestic property business, the guidance generally groups their digital records for one property-business update, while keeping property-level working detail helps explain the totals. Lets abroad work differently: the guidance asks for separate digital records for each foreign property, which the software then adds into one foreign property business update. Ask for advice if you also have other property categories or unusual ownership.

Keep the submitted confirmation and the source-to-ledger trail. The quarterly estimate shown after submission is an estimate, and may omit other income not yet supplied; it is not a final tax bill. At the end of the year, you still submit the required tax return through the appropriate software and handle other income and adjustments. The AI and tax-preparation tutorial explains why a draft classification is not a tax decision.

Before clicking submit, compare the new cumulative totals with the last submitted confirmation. If income rose by GBP 5,350 in the illustrative quarter, ask whether the supporting rent ledger accounts for that movement, allowing for corrections and the relevant accounting basis. If expenses jump unexpectedly, open the largest source documents rather than accepting a model's explanation. Check that the update refers to the right business and period, then keep the confirmation where the next quarter's reviewer can find it. This small reconciliation makes a later correction traceable: you can tell whether a difference came from new activity or a change to an earlier record.

Give yourself a repeatable monthly review

Once a month, reconcile rent expected against rent received, look at agent statements, attach invoices, investigate unmatched bank entries and check that property codes are right. This is less stressful than handing an accountant three months of mixed documents just before the deadline. If an adviser collects the evidence, agree what they need and when; the practice records-chase workflow shows how they can ask for precise gaps rather than every file again.

Measure the process by open questions, unsupported ledger rows, duplicate candidates, days from transaction to digital record and the number of corrections found at quarterly review. If AI routinely misclassifies deposits or agent deductions, narrow its job to flagging those items for review. If the software cannot show where a category total came from, fix the ledger and document links before the next submission. A good routine leaves the landlord and adviser able to explain every total from an underlying record.

Ask a qualified tax adviser about threshold status, exemptions, jointly held property, reliefs or allowable expenses. Keep AI on the clerical side: organising evidence, forming questions and noticing inconsistencies. The legal and accounting judgement, the reviewed digital record and the authorised submission are human responsibilities.

Rental-record questions before you submit

Does the income threshold mean rent after expenses?

No. The published qualifying-income test uses gross self-employment and property income before expenses, based on the specified earlier tax return. For a jointly owned property only your share counts, and if you are told your share only after expenses, that net figure is used. If ownership, relief or an amended return makes your figure uncertain, ask a qualified tax adviser to confirm the position before you decide when to join.

Can I keep using a spreadsheet for property records?

Official guidance allows spreadsheets as part of the workflow when compatible software links to those records for the required submissions. Check the complete path, including the year-end return, and keep the digital link intact. A spreadsheet on its own, or an AI-generated summary copied by hand into another program, does not establish that the process meets the requirements.

Must I send a quarterly update if no tenant paid rent?

Official guidance says you still send an update when no income was received and no expenses were incurred during the period. Check whether any repairs, fees or other property transactions occurred before calling it nil. The compatible software prepares the cumulative totals; review them and submit through that software.

Further reads

Sources: official tax authority guidance, Using Making Tax Digital for Income Tax for the first time; Create digital records; Send quarterly updates; Find software that works with Making Tax Digital for Income Tax (read 4 November 2026).

Need a rental-record routine that holds up?

On a 1:1 AI implementation consultation, we can map where your rent and expense evidence arrives, what AI can prepare, and which checks belong in your software workflow.

Book a 1:1 call with me