A lease calculator for revised FRS 102 Section 20. Change any input and the figures recalculate in your browser.
Initial lease liability £98,860.25. Right-of-use asset £104,860.25.
Office, 2nd floor
Commences 1 January 2026. 60 months. 20 quarterly payments of £6,000.00 in advance.
Initial measurement at 1 January 2026
| Lease liability | 98,860.25 |
|---|---|
| Payments made at or before commencement | 6,000.00 |
| Initial direct costs | nil |
| Lease incentives received | nil |
| Right-of-use asset | 104,860.25 |
Discounted at 6% a year (incremental borrowing rate), which is 1.4674% a quarter.
| Quarter | Starts | Opening | Interest | Payment | Closing |
|---|---|---|---|---|---|
| 1 | 1 Jan 2026 | 98,860.25 | 1,450.66 | nil | 100,310.91 |
| 2 | 1 Apr 2026 | 100,310.91 | 1,383.90 | 6,000.00 | 95,694.81 |
| 3 | 1 Jul 2026 | 95,694.81 | 1,316.17 | 6,000.00 | 91,010.98 |
| 4 | 1 Oct 2026 | 91,010.98 | 1,247.44 | 6,000.00 | 86,258.42 |
| 5 | 1 Jan 2027 | 86,258.42 | 1,177.70 | 6,000.00 | 81,436.12 |
| 6 | 1 Apr 2027 | 81,436.12 | 1,106.94 | 6,000.00 | 76,543.06 |
| 7 | 1 Jul 2027 | 76,543.06 | 1,035.14 | 6,000.00 | 71,578.20 |
| 8 | 1 Oct 2027 | 71,578.20 | 962.28 | 6,000.00 | 66,540.48 |
| 9 | 1 Jan 2028 | 66,540.48 | 888.36 | 6,000.00 | 61,428.84 |
| 10 | 1 Apr 2028 | 61,428.84 | 813.35 | 6,000.00 | 56,242.19 |
| 11 | 1 Jul 2028 | 56,242.19 | 737.25 | 6,000.00 | 50,979.44 |
| 12 | 1 Oct 2028 | 50,979.44 | 660.02 | 6,000.00 | 45,639.46 |
| 13 | 1 Jan 2029 | 45,639.46 | 581.66 | 6,000.00 | 40,221.12 |
| 14 | 1 Apr 2029 | 40,221.12 | 502.16 | 6,000.00 | 34,723.28 |
| 15 | 1 Jul 2029 | 34,723.28 | 421.48 | 6,000.00 | 29,144.76 |
| 16 | 1 Oct 2029 | 29,144.76 | 339.62 | 6,000.00 | 23,484.38 |
| 17 | 1 Jan 2030 | 23,484.38 | 256.56 | 6,000.00 | 17,740.94 |
| 18 | 1 Apr 2030 | 17,740.94 | 172.28 | 6,000.00 | 11,913.22 |
| 19 | 1 Jul 2030 | 11,913.22 | 86.77 | 6,000.00 | 5,999.99 |
| 20 | 1 Oct 2030 | 5,999.99 | 0.01 | 6,000.00 | nil |
| Total | 15,139.75 | 114,000.00 | |||
Payments are made at the start of each quarter, and interest is charged on the balance after the payment. The first payment, made at commencement, is part of the cost of the right-of-use asset, so it is not in this schedule.
| Year ended | Interest | Depreciation | Lease liability | Due within one year | Right-of-use asset |
|---|---|---|---|---|---|
| 31 Dec 2026 | 5,398.17 | 20,972.04 | 86,258.42 | 19,717.94 | 83,888.21 |
| 31 Dec 2027 | 4,282.06 | 20,972.04 | 66,540.48 | 20,901.02 | 62,916.17 |
| 31 Dec 2028 | 3,098.98 | 20,972.04 | 45,639.46 | 22,155.08 | 41,944.13 |
| 31 Dec 2029 | 1,844.92 | 20,972.04 | 23,484.38 | 23,484.38 | 20,972.09 |
| 31 Dec 2030 | 515.62 | 20,972.09 | nil | nil | nil |
| Total | 15,139.75 | 104,860.25 | |||
| Account | Debit | Credit |
|---|---|---|
| 11 Jan 2026. Recognise the lease liability and right-of-use asset at commencement | ||
| Right-of-use asset: cost | 98,860.25 | |
| Lease liability | 98,860.25 | |
| 21 Jan 2026. Payment made at commencement, added to the cost of the right-of-use asset | ||
| Right-of-use asset: cost | 6,000.00 | |
| Bank | 6,000.00 | |
| 331 Dec 2026. Interest on the lease liability for the period | ||
| Interest on lease liabilities | 5,398.17 | |
| Lease liability | 5,398.17 | |
| 431 Dec 2026. Lease payments made in the period | ||
| Lease liability | 18,000.00 | |
| Bank | 18,000.00 | |
| 531 Dec 2026. Depreciation of the right-of-use asset for the period | ||
| Depreciation: right-of-use assets | 20,972.04 | |
| Right-of-use asset: accumulated depreciation | 20,972.04 | |
| Total | 149,230.46 | 149,230.46 |
Checks
- Passes: Closing lease liability is nilClosing liability at the end of the lease: £0.00.
- Passes: Total interest equals total payments less the initial liability£114,000.00 less £98,860.25 is £15,139.75; schedule interest is £15,139.75.
- Passes: Initial liability agrees to the annuity formulaAnnuity formula gives £98,860.25; schedule uses £98,860.25.
- Passes: Rounding taken to the final period is within toleranceFinal period adjusted by £0.01. Tolerance is one penny a period, £0.20.
- Passes: Right-of-use asset is fully depreciated over the lease termTotal depreciation £104,860.25 against cost £104,860.25.
Judgements recorded
- Not yet confirmedThe contract is, or contains, a lease
- Not yet confirmedLease term of 60 months
- Not yet confirmedDiscount rate of 6% a year, incremental borrowing rate
Plumbline does the calculations. You make the judgements and remain responsible for the accounts.
Need many leases, Excel workings, the Section 1A note and journals for every client? Pre-order the full version.
The full version
The calculator above takes one lease at a time. The full version is for every lease of every client, with the workings and the note you need for the file.
- Every lease, every client
- All of a client's leases in one place, for as many client companies as you have. Your work is saved as a file on your own computer.
- Excel workbook with live formulas
- Each schedule is built from formulas, not pasted values, so a reviewer can follow every figure back to the inputs.
- Section 1A note in Word
- The lease disclosure note for a small company, ready to edit and put in the accounts.
- Journals ready to post
- Journals for every client and every year, as a CSV file for your bookkeeping software.
- Transition
- The figures at the date the revised Section 20 first applies, for leases already running on that date.
- Corporation tax working
- A working for the tax computation of each client.
Sample Trading Limited
3 leases. Year ended 31 December 2026.
| Lease | Right-of-use asset | Lease liability | Due within one year | Due after one year |
|---|---|---|---|---|
| Office, 2nd floor | 83,888.21 | 86,258.42 | 19,717.94 | 66,540.48 |
| Delivery van | 15,488.65 | 15,687.20 | 4,440.39 | 11,246.81 |
| Storage unit | 12,677.85 | 18,050.71 | 8,742.07 | 9,308.64 |
| Total | 112,054.71 | 119,996.33 | 32,900.40 | 87,095.93 |
| Account | Debit | Credit |
|---|---|---|
| Right-of-use asset: cost | 123,923.25 | |
| Lease liability | 93,737.85 | |
| Bank | 37,900.00 | |
| Interest on lease liabilities | 7,714.60 | |
| Depreciation: right-of-use assets | 33,021.51 | |
| Right-of-use asset: accumulated depreciation | 33,021.51 | |
| Total | 164,659.36 | 164,659.36 |
Calculated by the same engine as the calculator above, for an invented company. The full version produces these for each client, with the workbook, the note and the journals file.
Price
Founding practice licence
£149 for the first 12 monthsthen £249 a year
- Unlimited client companies.
- Delivered by 31 January 2027.
- A full refund if we miss that date.
- A full refund if you ask within 30 days of delivery.
Card payment through Stripe.
Questions
- Who is it for?
- Small UK accounting practices, with one to five partners, that prepare accounts for small companies under FRS 102, including those applying Section 1A.
- Where does my client data go?
- Nowhere. Every calculation runs in your browser, and the page is set up so it cannot send what you type to any server. In the full version, your work is saved as a file on your own computer. We never see it.
- What is included?
- Every lease for every client, an Excel workbook with live formulas, the Section 1A note in Word, journals as a CSV file, transition figures and a corporation tax working.
- Can I get a refund?
- Yes. If the full version is not delivered by 31 January 2027, you get a full refund. After delivery, you can ask for a full refund within 30 days, for any reason.
- Does it cover Section 1A?
- Yes. The full version produces the lease disclosure note for a small company applying Section 1A, in Word, for you to review and edit.
- Is this advice?
- No. Plumbline does the calculations. You make the judgements and remain responsible for the accounts.