WEBVTT

1
00:00:00.000 --> 00:00:00.393 line:88% position:50% size:74% align:center
Welcome.

2
00:00:00.393 --> 00:00:06.679 line:88% position:50% size:74% align:center
This is the UK Landlord M T D-Ready Bookkeeping
Ledger, version one point zero point one.

3
00:00:06.679 --> 00:00:11.420 line:88% position:50% size:74% align:center
It is a local-first Microsoft Excel workbook
for organising property income and expenses,

4
00:00:11.420 --> 00:00:16.107 line:88% position:50% size:74% align:center
checking the records, and preparing cumulative
figures for compatible bridging software.

5
00:00:16.107 --> 00:00:22.000 line:88% position:50% size:74% align:center
It does not submit directly to H
M R C or calculate your tax bill.

6
00:00:24.000 --> 00:00:26.520 line:88% position:50% size:74% align:center
The workbook follows one clear routine.

7
00:00:26.520 --> 00:00:30.612 line:88% position:50% size:74% align:center
Start here, complete Setup,
record transactions, correct any

8
00:00:30.612 --> 00:00:34.500 line:88% position:50% size:74% align:center
warnings, and then review the summaries and M T D Export.

9
00:00:34.500 --> 00:00:37.020 line:88% position:50% size:74% align:center
White cells are for your input.

10
00:00:37.020 --> 00:00:38.700 line:88% position:50% size:74% align:center
Protected areas contain formulas.

11
00:00:38.700 --> 00:00:45.000 line:88% position:50% size:74% align:center
The aim is to keep every reported figure
traceable to the transaction that created it.

12
00:00:47.000 --> 00:00:54.192 line:88% position:50% size:74% align:center
On Setup, choose the tax year, Standard or Calendar
update periods, and Simple or Full reporting detail.

13
00:00:54.192 --> 00:01:00.538 line:88% position:50% size:74% align:center
Then give each property a clear nickname and
leave properties you currently use marked Active.

14
00:01:00.538 --> 00:01:05.615 line:88% position:50% size:74% align:center
For jointly owned property, enter transaction
amounts that already represent your share.

15
00:01:05.615 --> 00:01:09.000 line:88% position:50% size:74% align:center
The ownership percentage does
not adjust figures automatically.

16
00:01:11.000 --> 00:01:16.018 line:88% position:50% size:74% align:center
Simple and Full modes control the categories
available in the transaction dropdown.

17
00:01:16.018 --> 00:01:20.618 line:88% position:50% size:74% align:center
Simple Mode uses a smaller group
of income and expense categories.

18
00:01:20.618 --> 00:01:23.545 line:88% position:50% size:74% align:center
Full Mode provides more detailed reporting categories.

19
00:01:23.545 --> 00:01:26.473 line:88% position:50% size:74% align:center
Select the approach appropriate to your circumstances.

20
00:01:26.473 --> 00:01:30.165 line:88% position:50% size:74% align:center
The workbook provides the structure, but it does not

21
00:01:30.165 --> 00:01:34.000 line:88% position:50% size:74% align:center
decide whether a reporting option is suitable for you.

22
00:01:36.000 --> 00:01:38.940 line:88% position:50% size:74% align:center
Your update-period choice controls the valid dates.

23
00:01:38.940 --> 00:01:43.980 line:88% position:50% size:74% align:center
Standard periods begin on the sixth
of April, July, October and January.

24
00:01:43.980 --> 00:01:49.020 line:88% position:50% size:74% align:center
Calendar periods begin on the first
of April, July, October and January.

25
00:01:49.020 --> 00:01:53.187 line:88% position:50% size:74% align:center
Once selected, the workbook
validates each transaction date

26
00:01:53.187 --> 00:01:57.000 line:88% position:50% size:74% align:center
and assigns it to the correct one of the four periods.

27
00:01:59.000 --> 00:02:01.379 line:88% position:50% size:74% align:center
Use Transactions for the source records.

28
00:02:01.379 --> 00:02:04.895 line:88% position:50% size:74% align:center
Enter the date, an active property, Income or Expense, a

29
00:02:04.895 --> 00:02:08.914 line:88% position:50% size:74% align:center
permitted category, a useful
description, and a positive amount.

30
00:02:08.914 --> 00:02:14.069 line:88% position:50% size:74% align:center
Add a receipt reference when it helps
connect the row to supporting evidence.

31
00:02:14.069 --> 00:02:18.828 line:88% position:50% size:74% align:center
Expenses are entered as positive values
and are kept separate from income.

32
00:02:18.828 --> 00:02:22.000 line:88% position:50% size:74% align:center
Do not type over the protected system columns.

33
00:02:24.000 --> 00:02:27.600 line:88% position:50% size:74% align:center
Warnings tell you that a source row needs attention.

34
00:02:27.600 --> 00:02:31.532 line:88% position:50% size:74% align:center
Missing amounts, dates outside the
selected range, inactive properties,

35
00:02:31.532 --> 00:02:34.800 line:88% position:50% size:74% align:center
or invalid types and categories
can block export readiness.

36
00:02:34.800 --> 00:02:38.800 line:88% position:50% size:74% align:center
Return to the original row, correct it, and check again.

37
00:02:38.800 --> 00:02:42.339 line:88% position:50% size:74% align:center
Duplicate receipt references are review warnings, but they

38
00:02:42.339 --> 00:02:46.000 line:88% position:50% size:74% align:center
do not by themselves prevent
the export from becoming ready.

39
00:02:48.000 --> 00:02:51.833 line:88% position:50% size:74% align:center
The quarterly summary shows
standalone activity for each period,

40
00:02:51.833 --> 00:02:55.846 line:88% position:50% size:74% align:center
including income, expenses,
transaction counts and invalid records.

41
00:02:55.846 --> 00:03:02.308 line:88% position:50% size:74% align:center
The annual summary gives a full-year bookkeeping
overview, together with category and property totals.

42
00:03:02.308 --> 00:03:06.462 line:88% position:50% size:74% align:center
Use both pages to spot values that look unexpected.

43
00:03:06.462 --> 00:03:12.000 line:88% position:50% size:74% align:center
These are bookkeeping checks, not
calculations of taxable profit or tax due.

44
00:03:14.000 --> 00:03:16.966 line:88% position:50% size:74% align:center
M T D Export presents cumulative figures.

45
00:03:16.966 --> 00:03:19.085 line:88% position:50% size:74% align:center
Update one contains period one.

46
00:03:19.085 --> 00:03:22.051 line:88% position:50% size:74% align:center
Update two includes periods one and two.

47
00:03:22.051 --> 00:03:28.831 line:88% position:50% size:74% align:center
Update three includes the first three periods, and
update four covers the full selected update year.

48
00:03:28.831 --> 00:03:33.194 line:88% position:50% size:74% align:center
Confirm that readiness shows ready,
review the setup and totals, then

49
00:03:33.194 --> 00:03:37.305 line:88% position:50% size:74% align:center
follow the process provided by
your compatible bridging software.

50
00:03:37.305 --> 00:03:39.000 line:88% position:50% size:74% align:center
Keep a backup first.

51
00:03:41.000 --> 00:03:44.574 line:88% position:50% size:74% align:center
Version one supports one thousand
preformatted transaction rows.

52
00:03:44.574 --> 00:03:47.702 line:88% position:50% size:74% align:center
Automatic expansion beyond that is not supported.

53
00:03:47.702 --> 00:03:54.404 line:88% position:50% size:74% align:center
Version one point zero point one has been
tested in Microsoft 365 Excel for Windows.

54
00:03:54.404 --> 00:03:58.348 line:88% position:50% size:74% align:center
Compatibility with Excel for Mac and Excel 2021 is not

55
00:03:58.348 --> 00:04:02.000 line:88% position:50% size:74% align:center
claimed until those environments have been tested.

56
00:04:04.000 --> 00:04:05.680 line:88% position:50% size:74% align:center
The workbook is local-first.

57
00:04:05.680 --> 00:04:10.144 line:88% position:50% size:74% align:center
It contains no macros, telemetry,
analytics, hidden web requests or built-in

58
00:04:10.144 --> 00:04:14.080 line:88% position:50% size:74% align:center
cloud synchronisation, and no
monthly software account is required.

59
00:04:14.080 --> 00:04:19.471 line:88% position:50% size:74% align:center
You decide where the file is stored, how
it is backed up, and when information

60
00:04:19.471 --> 00:04:25.000 line:88% position:50% size:74% align:center
is transmitted to another service, including
cloud storage or bridging software.

61
00:04:27.000 --> 00:04:29.091 line:88% position:50% size:74% align:center
That is the complete workflow.

62
00:04:29.091 --> 00:04:33.096 line:88% position:50% size:74% align:center
Set it up, record transactions
consistently, correct warnings,

63
00:04:33.096 --> 00:04:37.036 line:88% position:50% size:74% align:center
review the summaries, and check
M T D Export before bridging.

64
00:04:37.036 --> 00:04:42.891 line:88% position:50% size:74% align:center
Keep within the documented one thousand rows
and use Microsoft 365 Excel for Windows.

65
00:04:42.891 --> 00:04:50.000 line:88% position:50% size:74% align:center
The result is a calmer bookkeeping process with clear
boundaries and figures that remain easy to trace.