Excel Spreadsheet Templates

Spreadsheets for VAT

Business Partner Supplied

Excel spreadsheets for recording VAT-registered business sales and purchase transactions, and calculating figures for various VAT schemes:

VAT Scheme Requirements Price
Flat Rate You do NOT make sales to or purchases from outside the UK POA Contact Us
Flat Rate You DO make sales to and/or purchases from outside the UK POA Contact Us
Accrual Based Retail (7 Schemes) POA Contact Us
Accrual Based Normal (Invoice In & Invoice Out) POA Contact Us
Accrual Based Margin POA Contact Us
Cash Based Retail (7 Schemes) POA Contact Us
Cash Based Normal (Invoice In & Invoice Out) POA Contact Us

Spreadsheets are available from VAT specialist, Richard Pape, who provides VAT consultancy to businesses and institutions throughout the UK and Europe.

Easy MTD Supplied

A simple Excel spreadsheet created by the Easy MTD team for recording VAT-registered business sales and purchase transactions, and calculating VAT figures:

  • VAT Registered Business - Ledgers and VAT Calculation

Download

This spreadsheet is unsuitable for certain VAT schemes and it is advised you use one of the scheme-specific spreadsheets listed above.

Spreadsheets for Income Tax (Quarterly Updates) and VAT

Business Partner Supplied

Coming Soon!

Excel spreadsheets for recording VAT-registered self-employment and property income/sales and expense/purchase transactions, and calculating quarterly update figures and VAT figures for various VAT schemes, will be available soon.

Spreadsheets are available from VAT specialist, Richard Pape, who provides VAT consultancy to businesses and institutions throughout the UK and Europe.

Easy MTD Supplied

A simple Excel spreadsheet created by the Easy MTD team for recording VAT-registered self-employment income/sales and expense/purchase transactions, and calculating quarterly update and VAT figures:

  • VAT Registered Self-Employment Business - Ledgers, Quarterly Update and VAT Calculation

Download

This spreadsheet is unsuitable for certain VAT schemes and it is advised you use one of the scheme-specific spreadsheets soon to be listed above.

Spreadsheets for Income Tax (Quarterly Updates)

Easy MTD Supplied

Excel spreadsheets created by the Easy MTD team for recording self-employment, UK property and foreign property income and expense transactions, and calculating quarterly update figures:

  • Foreign Property Business - Ledgers and Quarterly Update
  • Self-Employment Business - Ledgers and Quarterly Update
  • UK Property Business - Ledgers and Quarterly Update

Download

Using with Easy MTD

Unlike many other Making Tax Digital bridging solutions, you can use any Excel spreadsheet with !Easy MTD. The only stipulation is that the spreadsheet is in the xlsx, xls or xlsm format.

Disclaimer

This disclaimer applies to all spreadsheets supplied by Easy MTD and its business partner, Richard Pape:

  • An accountant or tax agent should be consulted before using any spreadsheet as part of your Making Tax Digital process.
  • Fly Software and its employees, and Richard Pape are not responsible for any errors or omissions that may occur as a result of using any spreadsheet.
  • Use of any spreadsheet is governed by the Fly Software Terms & Conditions.