Free MTD Spreadsheet Template (Download)

If you need a spreadsheet to track your income and expenses for Making Tax Digital, you can download our free simple template. It is designed for a straightforward sole-trader business or UK-property source with annual turnover below £90,000, and it also works as a standalone record-keeping spreadsheet.

What's in the template

The template includes:

• Income sheet, log each payment you receive with date, description, and amount
• Expenses sheet, log each expense with date, description, category, and amount
• flo tab, two cells (Turnover and Expenses) that automatically sum the figures used by flonancial's current quarterly format. When you upload to flonancial, these are read instantly, no cell-picking needed.

Download

Flonancial provides one official template: an .xlsx file that opens in Microsoft Excel, free Excel for the web, Google Sheets, LibreOffice Calc and Apple Numbers. Keep, download or export it as .xlsx before uploading so the flo tab remains available. It is not intended for businesses at or above £90,000 turnover, where HMRC expects expenses split by category.

Download MTD template

Flonancial provides one official template: this .xlsx file. It opens in Microsoft Excel, free Excel for the web, Google Sheets, LibreOffice Calc and Apple Numbers. Keep, download or export it as .xlsx before uploading so the flo tab remains available. It is for a straightforward sole-trader business or UK-property source with annual turnover below £90,000, using one income total and one total for expenses. Landlords record mortgage interest with the residential finance costs category; the template keeps it out of expenses and totals it separately for HMRC.

Using your own spreadsheet

You don't have to use our template. Flonancial's current quarterly format works with any spreadsheet that contains one income total and one ordinary expenses total for a supported source below £90,000. The template just makes the simple route faster by providing a flo tab that flonancial reads automatically. If the annual turnover for the business or property source is £90,000 or more, do not use this simple format. Landlords with mortgage interest keep a separate residential finance costs total and pick that cell when submitting.

Tips for keeping MTD-ready records

• Record every transaction, date, amount, and a brief description. HMRC requires you to keep records of each individual transaction, even though you only submit totals.
• Keep it current, update your spreadsheet weekly or after each transaction. Quarterly submissions are quick when your records are already up to date.
• Separate business and personal, if you use one bank account for everything, make sure your spreadsheet clearly distinguishes business transactions.
• Back it up, keep copies in cloud storage (OneDrive, Google Drive, Dropbox). You need to retain records for at least 5 years after the filing deadline.

What HMRC expects from your records

Your digital records must include:

• The date of each transaction
• The amount
• A brief description or categorisation

A well-maintained spreadsheet meets all of these requirements.