Accounting Template for Accounts with Standard VAT - PLUS


Free Delivery

Immediate Download


Accounting Template for small businesses - the PLUS Range - For Accounts with Standard VAT

 - Our Advanced Accounting Program for experienced bookkeepers -

This version is suitable for VAT Registered Sole Traders, Partnerships, Clubs, 'Not for Profit Organisations' and Limited Companies.
To help you make your mind up please review the system notes and screen shots below. 
We believe that there is no comparable Excel based small business software that offers so much at this price.
To use this software you must have the full Microsoft Excel Software Version 2003, 2007, 2010, 2013 [Not the Starter Editions or Open Office equivalent] installed. 
 This product is sold on an Annual Licensing Agreement
If you are in any doubt about the suitability of the software for your business, or if you have any other questions,
then please email us at
This Spreadsheet is NOT suitable for Mac users

Software Design and Features
Small Business Accounts Software is designed in Monthly format.

Starting at Month 1 you have 12 identical worksheets covering your Accounting Year. Each worksheet records ALL your business transactions for that month.

This is what your Monthly worksheet looks like.

It is separated into a Header Section, followed by the Data Section and ends with a Monthly Summary Section.

The Monthly Worksheet

The system uses a combination of Drop Down boxes to make data entry simple and error proof.
Each monthly worksheet caters for ALL your transactions; the software allocates one line to each entry.
You select the appropriate transaction type from the Drop Down Box and then complete the line. 
Your data is coded to conform to HM Revenue & Customs formats, you select the appropriate analysis from another Drop Down Box and the software completes the posting. Thus eliminating the potential for errors.
VAT is calculated automatically based on the VAT Rate selected. You have the ability to overwrite the automatic calculation if necessary.
It's that simple !
The following four screenshots show this process.
1. Select your Transaction Type

2. Select your Customer or Supplier

3.  Select your Analysis
4.  Select your VAT Rate

On each Monthly worksheet you can perform selective Sort routines and use Excels 'Filtering' tool to perform advanced analysis of your data.
Once each line has been completed the software uses Excels powerful formulae to update the following :
  • 12 Month Profit & Loss Report
  • Balance Sheet
  • Monthly Profitability & Sales Summaries
  • VAT Returns
  • Bank, Cash and Credit Card balances
  • Business Tax Returns
  • Customers & Suppliers balances
      (see screenshots below)
Thus ensuring that your accounts are both accurate and up to date.
The software also automatically completes other tasks which provide the following:
  • A Consolidated Year's Data worksheet
  • A separate worksheet that shows ALL of the years transactions on ONE worksheet
  • A special report for your accountants which will allow them to easily upload your data into their systems

Finally the system provides you with additional worksheets for you to record other financial data for 'Year End' purposes.
  • Fixed Assets Schedule
  • Year End Stock Schedule
  • Year End Debtors
  • Year End Creditors
     (see screenshots below)

12 Month Profit & Loss Report and Graph
with Graph

Customers and Suppliers Overview
The Balance Sheet
The VAT Returns
Self Employed Tax Return
Partnership Tax Return
Fixed Assets

Year End Stock
Year End Debtors

Year End Creditors


Set Up, Year End and Backups

Many people are worried about how to Set Up accounting software and are concerned about how to complete the Accounting Year End procedures.

The Small Business Accounts Software manages this with ease.

To Set Up your accounts you just follow the Step by Step guide and fill in the relevant information in the various worksheets. It should take you no more than 15 minutes and then you are ready to go.

At the Year End you need to supply your accountant with additional information, the system notes will guide you effortlessly through providing details of Assets, Year End Debtors and Creditors, Bad Debts and Depreciation.

We have not forgotten the importance of data security; the User Guide provides comprehensive details on how to take regular backups of both the software and your data.
Additional information and small print
Mr.Spreadsheet is a registered trading name and division of Heron Accounting Services, Poole, Dorset.
This software is protected by international copyright and is sold on a single-user annual licence agreement for the use by the licensee or licensees business only. Unlawful decoding, copying and distribution will result in prosecution.
We make no warranty or representation, either express or implied, with respect to this software and documentation, their quality, performance, merchantability, or fitness for purpose. This software is licensed ' as is ', and you, the licensee, by making use thereof, are assuming the entire risk as to their quality and performance. In no circumstances will we be held liable for direct, indirect, special, incidental or consequential damages arising out of the use or inability to use the software or documentation.  

Please Choose:

Excel Spreadsheet

Excel Download