Sales Spreadsheet

The sales bookkeeping spreadsheet is used to record the self employed income. The format of the accounts spreadsheet has columns to enter the sales date, customer name, description of the type of sale which is optional, the sales invoice number if applicable and the total amount invoice.

Self employed Sales Receipts Analysis Accounting Spreadsheets

The sales bookkeeping spreadsheet is used to record the self employed income. The format of the accounts spreadsheet has columns to enter the sales date, customer name, description of the type of sale which is optional, the sales invoice number if applicable and the total amount invoiced.
For vat registered businesses the vat output tax on sales is calculated and automatically entered in the vat column. If the vat rate changes simply change the vat percentage at the top of the vat column. For non vat registered business simply change the vat rate to zero and no vat calculation is performed.

SALES EXCEL BOOK KEEPING SPREADSHEET

The green shaded column contains a formula to automatically calculate the vat on gross sales values entered. Flexibility built in as by changing the standard rate (20% in 2013) to zero the vat is disabled enabling the Accounting Software to be suitable for both vat registered and non vat registered businesses.

SALES DEBTORS

An optional feature but nevertheless very important aspect of any business is maintaining strong financial control, a major element of that financial control ensuring all sales are paid for. The sales spreadsheet contains the following table to enable that control to be precise and accurate

Image here

Enter the method of payment and the amount received. The formulae calculate any outstanding amounts yet to be paid and automatically calculate the number of days that sale has been outstanding and being written on excel spreadsheets a simple click of the mouse offers a visual appreciation of just how much money has still to be collected Accountancy software working for you.

SALES ANALYSIS

The sales analysis is automated from entering the single sales letter code triggering the collection of the total amount received under each heading. Automated small business book keeping software.

Image here

The final two columns of the sales excel spreadsheet are for sub-contractors use only to record the amount of CIS tax deducted and the certificate reference number and can be ignored by sole traders who are not sub-contractors.

What happens to the sales and income received entered?

The sales accounting spreadsheet totals each column for each book keeping month. The totals of each sheet are then collected by the accountancy software to complete the simple book keeping system by automatically producing the vat returns, monthly profit and loss account and self assessment tax return to complete the self employed book keeping system. The sales mileage, if recorded - it is optional - is also automatically transferred to the purchases excel spreadsheet which adds the sales mileage to the purchase mileage and calculates the mileage allowance. Mileage allowances are 45p for the first 10,000 miles and 25p thereafter and an alternative to claiming vehicle running costs including vehicle capital allowances on the fixed asset spreadsheet. This accountancy software will automatically claim 45p and change to 25p when applicable, users only have to enter the mileage covered.

The self employed user guide that accompanies this self employed book keeping system has notes on mileage allowances and other tax tips to help save you money including travel and subsistence allowances that can be claimed by a self employed sole trader while are working away.

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

 

"Small business accounting software for self employed using simple excel accounting spreadsheets to record business sales invoices and income"