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 template. It's designed to work seamlessly with Flonancial's upload — but you can also use it standalone.

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 your totals. When you upload to Flonancial, these are read instantly — no cell-picking needed.

Download

The template is available as an .xlsx file (compatible with Excel, Google Sheets, and LibreOffice).

Download the free MTD spreadsheet template

Using your own spreadsheet

You don't have to use our template. Flonancial works with any spreadsheet. When you upload, you simply click the cells containing your turnover and expenses totals. The template just makes it faster by providing a Flo tab that Flonancial reads automatically.

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.