Equal Figures Bookkeeping

Business & Accounting Spreadsheets

 

Important dates for completing Self Assessment Tax Return

31 October - last date for HMRC to receive your paper tax return.

30 December - deadline for online return if you want the HMRC to collect any tax you owe through your tax code (if the amount you owe is less than £3,000)

31 January - your online tax return must be received by the HMRC

For other information for completing your self assessment go to

www.hmrc.gov.uk/sa/complete-self-emp.htm

Help for using the Self Employed Accounting Spreadsheet system

Frequently Asked Questions

Instructions for Excel Version

Instructions for Open Source Version

Instructions for Tablet Version

Self Employed Accounts/Bookkeeping for Tablets


Immediate download Pay securely via

PayPal

£12.95

As a self employed Driving Instructor, you are required to keep up to date and accurate financial records relating to your business.

This very easy to use accounting spreadsheet system will help you to keep control of your income and expenses.

VERY easy to use. Can be used on iPod/android tablets or PCs.

Those who are VAT registered can use the VAT version with a VAT calculator, providing relevant figures for your VAT return.

Using the accounting/bookkeeping system will make life much easier when completing your own Self Assessment. It produces an Annual P&L and also calculates the figures you need in order to complete your Self Assessment Tax Return, whether on-line or paper form.

Income, expenses and P&L are all on one file which makes life easier for you and less time consuming and allowing you to keep an accurate record of:

This system can be used year after year.


The system comprises

  • Accounts spreadsheets for business income and expenses
  • Annual P&L Sheet
  • Draft Self Assessment

Although this accounting and bookkeeping spreadsheet system has been set up in Excel 2007 it is a system that can be used with suitable tablet Apps such as Documents to Go by Dataviz.com or Numbers from Apple for iPads/android tablets. If you wish to use it on a PC you can use it with Excel or any open source spreadsheet systems, such as OpenOffice.org

This accounting system can be used year after year and therefore you do not need to repurchase a new system each year.

Benefits of using the system

  • Created specifically for self employed Driving Instructor
  • No experience required
  • Very easy to use - simply enter income and expenses
  • Produces the relevant figures to enable you to complete your own Self Assessment Tax Return
  • Keep a track of your business finances
  • Save money on accountants/bookkeeper
  • Reduce the time you spend on record keeping
  • Monthly spreadsheets for income and expenses
  • Profit and Loss spreadsheet (automatically updates)
  • Enter a % split for costs of vehicle, phone and home use where you use partly for business and partly for personal use
  • Use year after year - no need to update

Income/Expenses Sheet

There is one sheet per month.  You simply add the date, select the reason from a drop down list, (ie fees, fuel, telephone)

Each sheet has a running total of income and expenses for the month.

The amounts are then transposed both to the P&L Summary Sheet and the Draft Self Assessment Sheet and will help you to keep a track of your annual expense

Annual P&L Sheet

The amounts on this P&L sheet will be automatically following any entries made in the monthly sheets. You will be able to clearly see running totals per month and also for the whole year for each category, as well as total income and total expenses per month and for the whole year. 

All cells are password protected to prevent accidental deletion of formula. Minus figures are shown in red.

Self Assessment

Because the categories on the Summary sheet have been set up to match the self assessment tax return(either paper or on-line), you simply transpose the total figures over to your tax return, ie vehicle costs (which can include fuel), MOT, etc.

The vehicle and phone costs are multiplied by the relevant % for business v personal use, which you can enter in the business set up sheet

Allowable Expenses

Allowable expenses are the running costs relating to your business, eg office costs, travel costs, stock purchased, costs of your business premises - costs that you pay out in the course of earning business profits.

Non Allowable Expenses

You cannot claim for non-business or personal items, such as entertaining. You can still enter these on the spreadsheets under the category of Misc, however, the costs will not be added to the draft assessment.

Capital Expenses

Capital expenditure is an allowance on the cost of purchasing assets that you will keep for your business and that are necessary in order for you to make a profit. The limits are subject to change each year.