DIY accounting and payroll software limited company formation UK

 

Accounting Software Overview

Payroll Software

Self Employed Accounts

Self Employed Accts + Payroll

Sole Trader Basic Accounts

Taxi Driver Accounts

Company Accounting Software

Company Accounts + Payroll

Limited Company Formation

Bookkeeping

Trade Accounts Enquiries

Financial Services

Financial & Accounting Articles

Affiliate Program

What's New At DIY Accounting

Questions & Answers

About Us

 

Order FormSales spreadsheetPurchases SpreadsheetVatProfit & LossSelf assessmentSelf employed TaxPayroll

DIY Accounting Advanced Sales Excel Spreadsheet

Self employed small business book keeping software UK

Entering the data in this small business accounts software is no more complicated than entering your financial information in 2 lists:

Simple Book keeping UK System:  Enter sales receipts on the sales excel book keeping spreadsheet

Simple Book keeping UK System:  Enter purchases on the purchase excel book keeping spreadsheet

The excel book keeping spreadsheets were designed from the simple small business bookkeeping software used for existing clients to make financial transactions fast, easy to enter and understand. Formula driven so that minimum data is entered with automated analysis producing from the book keeping system monthly profit & loss accounts, live debtor and creditor reports, self-assessment tax returns and vat returns. Accountancy software reduced to its simplest form of single entry.

SALES EXCEL BOOK KEEPING SPREADSHEET

The cream shaded column contains a formula to automatically calculate the vat on gross sales values entered.

The orange shaded columns of the sales excel spreadsheet are automated and triggered by simply entering the type of receipt used to pay you. Automated small business book keeping software.

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

What happens to the bookkeeping information entered? 

The above excel book keeping 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 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 40p 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 40p and change to 25p when applicable, users only have to enter the mileage covered.

The 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.

Sales Month Sales not yet received

Apr-08

 

May-08

 

Jun-08

 

Jul-08

 

Aug-08

 

Sep-08

 

Oct-08

 

Nov-08

 

Dec-08

 

Jan-09

 

Feb-09

 

Mar-09

 
Amount owed by customers 0.00

  SALES DEBTORS

No entries are required to this excel spreadsheet showing the total amount of money due to you that has not yet been received.

All entries on this spreadsheet being automated  within the self employed business book keeping software system.

To delete items from this list enter the method of receipt on the sales excel spreadsheet and it will disappear. Accountancy software working for you.

 

 

DIY Accounting  "Small business book keeping software, simple self employed book keeping system on excel spreadsheets"

 

[ Payroll Software ] [ Self Employed Accounting Software ] [ Limited Company Accounting Software ] [ Taxi Driver Accounts ] [ Company Formation ]

 [ Home ] [ Trade Accounts ] [ Questions & Answers ] [ Affiliate Program ] [ Articles ] [ About us ]

Copyright © 2006 2007 DIY Accounting
Last modified: 03/14/08