For many small or part-time businesses, accounting software can tend to be unnecessarily complex and overblown.  Provided it is well structured, a spreadsheet will often prove perfectly adequate to meet the business bookkeeping needs.  Data entry is quick and easy and the whole file can be given to the accountant at the end of the year for preparing accounts and tax returns.

The Simple Accounts Workbook is one such spreadsheet solution.  It enables a Microsoft Excel user to enter the minimum transactional details necessary to maintain a proper set of accounting records whilst utilising Excel’s range of tools to provide a summary and analysis of the data entered.

At the core of the workbook is a user-defined account codes worksheet.  Initially pre-populated with account codes based on the self-employment pages of a Self Assessment tax return, it can be amended or extended as desired.  Alternative account code sets are also available to freely download from the Payexcel website to cover, for example, property letting or personal finance.

The workbook contains separate worksheets for recording income and expenditure, linked to summary and reconciliation worksheets.  Excel’s integrated autofilter, sort and forms facilities allow further analysis and VAT recording is available for the VAT registered trader.

To allow maximum flexibility of use, the full retail version has no password protection and the licence allows the file to be transferred between and used by both the business proprietor and their accountant.

An evaluation version of the Simple Accounts Workbook is available to download by right-clicking the link below.  The evaluation version is identical to the full retail version, apart from having password protection and restrictions on the number of available input cells.

saweval.xls file (160kb)

If  you would like to purchase a licence for the unrestricted version of the Simple Accounts Workbook (priced at £25), please order via the PAYExcel Online Store at http://shop.payexcel.co.uk

The following additional account code sets are currently available to download (for the full retail version only):

Property letting	letting.xls file (32kb)
Personal finance	persfin.xls file (29kb)

e-mail enquiries@payexcel.co.uk
 

Correspondence address: Payexcel Limited PO Box 404 Ashford TN25 5WD

Registered Office: Payexcel Limited 20 - 22 Bedford Row London WC1R 4JS

Registered in England No. 4100526
Copyright © 2001-2008  Payexcel Limited. All rights reserved.