Equal Figures Bookkeeping

Business & Accounting Spreadsheets

Accounting System (Excel not required) - Instructions for Use

Accounting Set Up

Initial Set Up Page

  1. Business Split - if you use your vehicle, telephone or use of home for both business and personal use, you can enter a percentage split in the relevant cell on row 9. This will then apply only the business element for calculations on the P&L and Self Assessment draft.

Accounting Summary

Monthly input sheet.

  1. Date - enter day number of month
  2. Category - select category from drop down list
  3. Paid from/to - ie Tom Baxter, Halfords, Esso
  4. Amount - enter amount of sale or purchase
  5. VAT Rate - enter rate as applicable, ie enter 20 for 20% rate.
  6. Accounting Summary

    P&L Summary Sheet

    1. ALL cells are protected on this sheet - no entries can be made on here
    2. Following each entry you make the P&L Summary Sheet is updated
    Accounting Summary

    Self Assessment

    This figures on this sheet are automated following entries on the monthly input sheets. The box numbers relate to the relevant boxes on your self assessment form.