DIY accounting software, tax accounting, payroll software, limited company formation UK

 

Accounting Software

Payroll Software

Self Employed Accounts

Self Employed Accts + Payroll

Sole Trader Basic Accounts

Taxi Driver Accounts

Company Accounts

Company Accounts + Payroll

Company Formation

Bookkeeping

Financial Services

Financial & Accounting Articles

Affiliate Program

What's New At DIY Accounting

Questions & Answers

About Us

 

Order FormSales spreadsheetPurchase spreadsheetVATProfit & LossSelf assessmentSelf employed Tax

DIY Accounting 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. Accountancy software reduced to its simplest form of single entry.

SCREENSHOT SALES EXCEL BOOKKEEPING SPREADSHEET

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-06

 

May-06

 

Jun-06

 

Jul-06

 

Aug-06

 

Sep-06

 

Oct-06

 

Nov-06

 

Dec-06

 

Jan-07

 

Feb-07

 

Mar-07

 
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"

 

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

[ Company Formation ] [ Bookkeeping Register ] [ Questions & Answers ] [ Affiliate Program ] [ Articles ] [ About us ]

Copyright © 2006 2008 DIY Accounting
Last modified: 09/16/08