Thoughtful templates. Instant downloads.
RizqtekStudio.
Launch gift: 4 of 5 free template claims remainUse STUDIOFIRST5 →

UK Sole Trader Self-Assessment & MTD Bookkeeping

EXCEL + GOOGLE SHEETS · BUSINESS

UK Sole Trader Self-Assessment & MTD Bookkeeping — Excel & Google Sheets Template

Track Apr–Mar MTD quarterly turnover, HMRC SA103 allowable expenses, Class 4 NIC & Payments on Account.

Tailored for UK sole traders, freelancers, and contractors preparing Self-Assessment and Making Tax Digital (MTD) quarterly updates. Organize turnover by UK tax quarters (Apr–Mar), log HMRC SA103 allowable expenses with private-use adjustments, and model Personal Allowance (£12,570), Income Tax (20%/40%), Class 4 NIC (6%/2%), and 31 January Payments on Account.

$19.99 USD · ONE-TIME PURCHASE

Digital download · No physical item

Refunds & download support · Template licence

Software requirementsWorks in Microsoft Excel (Windows & Mac, 2019/2021/365) and Google Sheets. Verified in Desktop Excel 16.0 build 20527.0 with 100% macro-free universal formulas (SUMIFS, COUNTIFS, INDEX/MATCH) and includes a dedicated Google_Sheets_Edition.xlsx for one-click Google Drive import. Minor font or print-page scaling differences may appear in browser sheets.

Try the free budget starter · Read practical guides

  • 500-row turnover register tagged by UK MTD quarters (Apr–Jun to Jan–Mar)
  • 500-row expense register aligned to HMRC SA103 allowable cost categories
  • SA103 & Tax Reserve modeling £12,570 Personal Allowance, IT & Class 4 NIC

From the people who use it.

No published customer reviews yet.

Purchased this product? Sign in to review it. Link guest orders from your private receipt first.

Consider the details.

What’s inside

6 worksheets, thoughtfully organized.

  • 500-row turnover register tagged by UK MTD quarters (Apr–Jun to Jan–Mar)
  • 500-row expense register aligned to HMRC SA103 allowable cost categories
  • SA103 & Tax Reserve modeling £12,570 Personal Allowance, IT & Class 4 NIC
  • 31 January balancing payment + 50% Payment on Account calculator
  • Includes Excel master, Google Sheets edition, sample copy & PDF guide

Template.xlsx (Excel master), Google_Sheets_Edition.xlsx (Google Drive/Sheets ready), Example.xlsx (populated sample), Quick_Start.txt, User_Guide.txt, and illustrated User_Guide.pdf.

Software & capacity

Works in Microsoft Excel (Windows & Mac, 2019/2021/365) and Google Sheets. Verified in Desktop Excel 16.0 build 20527.0 with 100% macro-free universal formulas (SUMIFS, COUNTIFS, INDEX/MATCH) and includes a dedicated Google_Sheets_Edition.xlsx for one-click Google Drive import. Minor font or print-page scaling differences may appear in browser sheets.

  • Management bookkeeping & estimator; uses England/Wales/NI 20%/40% bands (adjust thresholds in SA103 sheet if needed). Not MTD bridging submission software or tax advice.
  • Personal Allowance taper above £100,000 is not automatically phased out in the simplified estimator.
Download & getting started
After captured payment is verified, the order page provides your download links. Save your private order access link. Extract the ZIP, read Quick_Start.txt, and save a working copy of the clean workbook. Read the download guide
Licence & product support
One purchaser may use this digital workbook internally within one household or one business (up to five internal team members). Personal working copies and cloud backups in your own Microsoft or Google account are permitted. Resale, redistribution, public sharing, or client-template delivery of the spreadsheet file itself is prohibited. Completed reports, quotes, and PDFs may be shared freely. Copyright 2026 RizqtekStudio. All rights reserved. Read the licence

Questions about this template

What is included with UK Sole Trader Self-Assessment & MTD Bookkeeping?

Template.xlsx (Excel master), Google_Sheets_Edition.xlsx (Google Drive/Sheets ready), Example.xlsx (populated sample), Quick_Start.txt, User_Guide.txt, and illustrated User_Guide.pdf.

What software is required to use UK Sole Trader Self-Assessment & MTD Bookkeeping?

Works in Microsoft Excel (Windows & Mac, 2019/2021/365) and Google Sheets. Verified in Desktop Excel 16.0 build 20527.0 with 100% macro-free universal formulas (SUMIFS, COUNTIFS, INDEX/MATCH) and includes a dedicated Google_Sheets_Edition.xlsx for one-click Google Drive import. Minor font or print-page scaling differences may appear in browser sheets.

How do I receive UK Sole Trader Self-Assessment & MTD Bookkeeping after purchasing?

After captured payment is verified, your private order page provides download links and a receipt is emailed. A valid complimentary claim also provides access without payment.

What licence applies to this template?

One purchaser may use this digital workbook internally within one household or one business (up to five internal team members). Personal working copies and cloud backups in your own Microsoft or Google account are permitted. Resale, redistribution, public sharing, or client-template delivery of the spreadsheet file itself is prohibited. Completed reports, quotes, and PDFs may be shared freely. Copyright 2026 RizqtekStudio. All rights reserved.

A little more possibility.

All templates