Welcome.
This is the UK Landlord M T D-Ready Bookkeeping Ledger, version one point zero point one.
It is a local-first Microsoft Excel workbook for organising property income and expenses,
checking the records, and preparing cumulative figures for compatible bridging software.
It does not submit directly to H M R C or calculate your tax bill.
The workbook follows one clear routine.
Start here, complete Setup, record transactions, correct any
warnings, and then review the summaries and M T D Export.
White cells are for your input.
Protected areas contain formulas.
The aim is to keep every reported figure traceable to the transaction that created it.
On Setup, choose the tax year, Standard or Calendar update periods, and Simple or Full reporting detail.
Then give each property a clear nickname and leave properties you currently use marked Active.
For jointly owned property, enter transaction amounts that already represent your share.
The ownership percentage does not adjust figures automatically.
Simple and Full modes control the categories available in the transaction dropdown.
Simple Mode uses a smaller group of income and expense categories.
Full Mode provides more detailed reporting categories.
Select the approach appropriate to your circumstances.
The workbook provides the structure, but it does not
decide whether a reporting option is suitable for you.
Your update-period choice controls the valid dates.
Standard periods begin on the sixth of April, July, October and January.
Calendar periods begin on the first of April, July, October and January.
Once selected, the workbook validates each transaction date
and assigns it to the correct one of the four periods.
Use Transactions for the source records.
Enter the date, an active property, Income or Expense, a
permitted category, a useful description, and a positive amount.
Add a receipt reference when it helps connect the row to supporting evidence.
Expenses are entered as positive values and are kept separate from income.
Do not type over the protected system columns.
Warnings tell you that a source row needs attention.
Missing amounts, dates outside the selected range, inactive properties,
or invalid types and categories can block export readiness.
Return to the original row, correct it, and check again.
Duplicate receipt references are review warnings, but they
do not by themselves prevent the export from becoming ready.
The quarterly summary shows standalone activity for each period,
including income, expenses, transaction counts and invalid records.
The annual summary gives a full-year bookkeeping overview, together with category and property totals.
Use both pages to spot values that look unexpected.
These are bookkeeping checks, not calculations of taxable profit or tax due.
M T D Export presents cumulative figures.
Update one contains period one.
Update two includes periods one and two.
Update three includes the first three periods, and update four covers the full selected update year.
Confirm that readiness shows ready, review the setup and totals, then
follow the process provided by your compatible bridging software.
Keep a backup first.
Version one supports one thousand preformatted transaction rows.
Automatic expansion beyond that is not supported.
Version one point zero point one has been tested in Microsoft 365 Excel for Windows.
Compatibility with Excel for Mac and Excel 2021 is not
claimed until those environments have been tested.
The workbook is local-first.
It contains no macros, telemetry, analytics, hidden web requests or built-in
cloud synchronisation, and no monthly software account is required.
You decide where the file is stored, how it is backed up, and when information
is transmitted to another service, including cloud storage or bridging software.
That is the complete workflow.
Set it up, record transactions consistently, correct warnings,
review the summaries, and check M T D Export before bridging.
Keep within the documented one thousand rows and use Microsoft 365 Excel for Windows.
The result is a calmer bookkeeping process with clear boundaries and figures that remain easy to trace.