Equal Figures Bookkeeping

Business & Accounting Spreadsheets

Driving Instructor Accounts (Excel)

Monthly input sheet (Excel)

This is a bookkeeping spreadsheet accounting/bookkeeping system set up for self employed driving instructor to help you keep your financial records in order.

There is no need to repurchase each year as the system can be used year after year.

The category names can be changed to suit your own business.

The system has a pupil record sheet where you can log pupil payments to see how many lessons each pupil has had (and also to see how much money each one has paid you). This is not linked to the input or summary sheet but is merely for your information only.

Immediately after purchase you will be taken to a download page where there will be links to the following files:-

  • Self Employed Accounting File
  • Mileage Calculator
  • Instructions for using Accounting spreadsheets
  • Instructions for using Mileage Calculator

The system is set up in Excel and some knowledge of Excel would be beneficial. This version contains macros and requires Microsoft Excel 2003 onwards to work to its full ability. Other versions are available for non-Excel systems - see our other Accounting Systems for open source or Google Sheets, and also for iPad/android tablets.





Income & Expenses Sheet

The system has a sheet per month for entering data. You simply add the date, select the reason from a drop down list, (categories can be customised to your own requirements, ie pupil fees, fuel, advertising, up to a maximum of 3 income and 30 expense categories) and also where the payment will be paid to or from, ie, current account, reserve account, petty cash or credit card.

There is a running total on each sheet to show total income and expenses for the month, as well as cumulative figures.


Annual P&L Sheet

The P&L sheet will be automatically updated following any entries made in the monthly sheets. It shows running totals, both per month and cumulative, by category, as well as grand totals for all expenses, again by month and cumulative. The sheet will also show your profit.

All cells are password protected to prevent accidental deletion of formula.

Minus figures are shown in red.


Self Assessment

The self assessment sheet automatically updates when entries are made in the monthly expenses and income sheet.

The figures on this sheet will show the figures you need when you to complete your own annual tax return, whether you use the paper HMRC form or complete on-line.


Bank Balancing

The balancing section of each sheet can be used to give you an indication of how each transaction will affect your bank/petty cash/credit card balance. Providing you enter the balances in the set up sheet at the beginning of the year, the banking balances on each monthly sheet will alter accordingly as you enter new income or expenses. Overdrawn figures are shown in red.

Because you can choose your own categories you can track your personal bank accounts and use a category such as 'personal' for costs not relating to the business.


Mileage Calculator

The separate mileage calculator/fuel recorder, which is included in the purchase, can be used by those who prefer to claim for vehicle costs by the amount of mileage you actually cover.

The sums are based on the rates set by HMRC, currently 45p/mile for the first 10,000 miles and 25p/mile for subsequent miles. It also gives a rough idea of mpg for fuel use.


Allowable Expenses

Allowable expenses are the costs of any outgoings relating to your business that you pay out in the course of earning business profits.

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


Capital Allowances

Capital expenditure is another allowance on the cost of purchasing assets that you will keep for your business and that would be necessary in order for you to make a profit. (...read more)