DIY accounting and payroll
software limited company formation UK
|
|
|
|
Limited Company small business accounting Purchases Spreadsheet Designed to provide a simple small business bookkeeping solution to make financial transactions fast, easy to enter and understand. Entering the data in this small business accounts software is no more complicated than entering your supplier purchase invoices on an excel spreadsheet template. Formula driven so that minimum data is entered with automated analysis producing from the book keeping system all the financial analysis required of the expenses without previous bookkeeping experience. Accountancy software reduced to its simplest form of single entry. PURCHASES EXCEL BOOK KEEPING SPREADSHEET Part 1
Book keeping entries are only required in the above columns of this simple bookkeeping system which consists basically of making a list of purchases each month The vat column automatically calculates vat input on purchase invoices at the current vat rate of 17.5%. If any purchases are at different vat rates, e.g. zero or 5% for power bills then simply overwrite the vat with the actual vat amount. 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. PURCHASE CREDITORS 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 purchases are paid for to maintain good supplier relations which are useful to driving lowest prices and achieving highest discounts. The blue shaded area of the purchase spreadsheet above controls the amount still due to suppliers Enter the payment type such as cheque, direct debit etc., and the amount paid. The formulae calculate any outstanding amounts yet to be paid and the number of days that purchase has been outstanding. A simple click of the mouse offers a visual appreciation of just how much money is still outstanding to creditors PURCHASES EXCEL BOOK KEEPING SPREADSHEET Part 2
This area of the book keeping software is fully automated by entering a single letter in the column headed "Enter Expense Code Letter". The book keeping software then uses that code letter to determine which column to place the expenditure, totals that expenditure and also transfers that total to the profit and loss account. The accounting heading form a comprehensive summary of all the main business expense elements that directors of a limited company will wish to review and control to maximise profits. A solution for a simple bookkeeping and analysis system with notes in the book keeping system user guide as to what items should be analysed to which columns. 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 each quarter and monthly profit and loss account. Accountancy software designed to save many times the cost of buying it. A simple bookkeeping system so clients can spend time saving money, not wasting it on unnecessarily complex accountancy software. FIXED ASSETS AND CAPITAL TAX ALLOWANCES Fixed items are physical items used by the business over a period of more than one year.
Depreciation spreads the financial effect on profits over the life of the fixed asset but does not have an effect on the business tax as depreciation is disallowed as an expense. Instead the business receives a capital tax allowance on the cost of fixed assets to set against its profit. When the fixed asset schedule is completed the capital allowances are automatically calculated and also update the profit and loss account in the depreciation column. 50% of the cost of the fixed asset can be set off against profits in the year purchased which is called First Year Allowance. The remaining value of the asset is then written off against future years profits at 25% of the book value remaining. The accountancy software has these percentages already written into the book keeping system.
DIY Accounting "Small business book keeping software, simple limited company 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
|
