ROI small business accounting software, tax accounting, payroll software,

Sole trader accounting spreadsheets small business accounting tool

Sales Accounting Spreadsheet

The sales accounting spreadsheet is the prime entry document and is the small business accounting tool used to record the sole trader sales income. The sales bookkeeping file consists of 12 monthly sales accounting spreadsheets, one for each month of the year. Designed using excel 2003 the accounting spreadsheets work using all excel programs from 1998 to 2007 and also the open source spreadsheet program.

The sole trader accounts package is designed to be as simple and uncomplicated as possible and basically consists of making a list of the sales each month. The bookkeeping is really as easy as making a list as it is based upon single entry bookkeeping and not double entry bookkeeping..

The sales accounting spreadsheets template has the following columns to record the business sales:

Column A Sales date  - This is the date the sale was made or sales invoice date

Column B Customer name - simply enter the name of the customer  or source of the income

Column C Sales invoice number - this column is provided to enter a reference for the sale which would normally be the sales invoice number but could be anything the sole trader finds helpful to be able to trace the sale

Column D Gross Sales Receipt record- this column is where the customers type of payment method was used when the outstanding sales invoice was actually paid  e.g. enter the payment method cheque, cash or debit debit etc.,

Column E Receipts Government agencies

Column F Tax Exempt Income

The final columns which are driven by pre formatted formulae to show the sales values still not paid, the debtors, and the number of days that sales invoice has remained unpaid for credit control purposes.

What happens to the bookkeeping information entered? 

Each column of the sales spreadsheet is automatically totalled  The totals of each accounting spreadsheet is then collected by the accountancy software to produce the sales turnover and complete the simple bookkeeping system by automatically producing the monthly profit and loss account and self employed tax return in thefinancial Tax accounts file.

The sole trader accounting user guide that accompanies this self employed bookkeeping system to help save you money

Simple accountancy software designed to save many times the cost of buying it.

"Sales accounting spreadsheets for sole traders with preset columns to record the small business sales income for accounting purposes"

[ Accounting Software ] [ Sole Trader ] [ Self Employed ] [ Company Accounts ] [ Taxi Driver Accounts ] [ Payroll Software ] 

 [ Questions & Answers ]  [ About us ]

Copyright © 2006 2009 DIY Accounting Limited
Last modified: 10/03/09