ROI
small business
accounting software, tax accounting, payroll software,
|
|
|
|
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 SPREADSHEET Record income from all sources, except bank interest received, in the Sales workbook using the separate spreadsheet provided for each month. The analysis to separate different types of income received is achieved by entering a single letter in Column E which automates the analysis. Sales turnover includes all money earned by the business before deduction of business expenses and includes monies for goods sold, fees and commissions receivable. Investment grants and proceeds from the sale of fixed assets are also recorded on the sales spreadsheets and analysed separately through the Code Letter System and subsequently accounted for separately. Enter sales credit notes and bad debts written off as negative amounts Data Entry
Column A – Enter the date of the sales transaction Column B – Enter the customer name or source of sale e.g. a retail business with 2 shops might wish to simply record Shop A or Shop B Column C – Enter your reference number of the transaction or sales invoice number. Column D – Optional column for recording a description of the monies receivable. Column E – Enter a code letter to analyse the type of monies receivable: Row 5 shows the only permissible letters that can be used to analyse the transaction – Enter EU if Value of Goods Sent to other EU Countries Column G – Enter total amount receivable including any Vat chargeable on the sales value. Column H – No Entry required. Column H contains formulae to automatically calculate the Vat output tax. The Vat calculation can be disabled by changing Cell H2. This change will then be carried forward to each subsequent month. Non vat registered business see Vat Returns section of this guide Column I – No Entry required Column I contains formulae to automatically calculate the net sales value.
Sales receipts
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. Opening Debtors The Opening Debtors worksheet as explained in “Preparing to get started” is to maintain continuity of financial control to assist the collection of all amounts due to the business. Closing Debtors Part of the year end accounting procedure after all receipts have been entered from Cash and Bank to the Sales workbook copy and paste items still outstanding from each month to this worksheet. 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. 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" | ||||||||||||||||||||||||||||||||||||||||||||||||||||
|
[ Accounting Software ] [ Sole Trader ] [ Self Employed ] [ Company Accounts ] [ Taxi Driver Accounts ] [ Payroll Software ] [ Questions & Answers ] [ About us ] Copyright © 2006 2009
DIY Accounting Limited
|
