DIY accounting and payroll
software limited company formation UK
|
|
|
|
DIY Accounting Sales Excel Accounting 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 green shaded column contains a formula to automatically calculate the vat on gross sales values entered. Flexibility built in as by changing the 17.5 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
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.
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 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 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 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.
"Small business bookkeeping software for self employed using simple excel accounting spreadsheets to record business sales invoices and income" | |||||||||||||||||||||||||||||||||||||||||||
|
[ Payroll Software ] [ Self Employed Accounting Software ] [ Limited Company Accounting Software ] [ Taxi Driver Accounts ] [ Company Formation ] [ Home ] [ Bookkeeping Register ] [ Questions & Answers ] [ Affiliate Program ] [ Articles ] [ About us ] Copyright © 2006 2007
DIY Accounting
|
