|
|
|
|
DIY Accounting Expenses Excel Spreadsheet Self employed taxi & van driver book keeping & expenses accounts software UK Entering the data in this self employed taxis & van driver book keeping 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 taxi expenses 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, taxi self assessment tax returns. Reducing taxi business book keeping software to its simplest form of single entry. Taxi driver accounts made easy, written specifically for taxi business, taxi book keeping software at its best.. TAXI DRIVER BOOK KEEPING SPREADSHEET Transactions to be recorded are from 1 January 2009 to 31 December 2009. The purchases file is arranged in 12 monthly sheets. Basically click the first month and entre the first month’s purchases on that sheet. You can record purchases from different periods in different months the only difference this makes to your accounts is which month those amounts appear in your profit and loss account. So for example if you’re financial year is not January to December you can record more than one month’s purchases in one month’s purchases sheet.
One frequently asked question is where PRSI and health contributions and income tax are entered. In fact these are personal expenses and are not record in purchases at all. You would only enter these a mounts in the cash and bank payments as they only effort the balance sheet ad not your net taxable profit.
Data Entry The columns for entering details of your sales are A – H
Column A – Enter the date of the purchase transaction Column B – Enter the supplier’s name or source of purchase Column C – Enter your reference number of the transaction or purchase invoice number. Column D – Enter a single letter to identify the type of expenditure in the expense code column to automatically update the expense analysis. Eligible letters and definitions of column headings are shown in glossary of column headings. Entry of this expense code is mandatory, Column E – Enter the gross purchase value of the transaction including Vat.
Actual amount paid Use the blue shaded columns to record the money paid. Entry does not affect accounts so is optional for your information only.
Column F – Enter the method of payment used to pay the supplier for the goods or service. Complete this column only when the transaction is paid for. Column G – Enter the Actual Amount Paid Column H – Automatically shows unpaid purchases Column I – Automatically calculates the number of days the purchase has been outstanding. Formulae driven automated columns No entries required in these columns Columns K– AA The letters entered in column D automatically update the expense analysis.
Book keeping entries are only required in the blue shaded columns of this simple taxi business bookkeeping system What happens to the bookkeeping information entered? The above excel book keeping spreadsheet totals each column for each book keeping month. The taxi expenses totals of each sheet are then collected by the taxi driver accounts software to complete the simple taxi driver book keeping software by automatically producing the monthly profit and loss account and taxi self assessment tax return completing the self employed book keeping software for taxis and van drivers. The purchase mileage, if recorded - it is optional - is also automatically adds in the sales mileage to the purchase mileage and calculates the mileage allowance. The user guide that accompanies this self employed book keeping system has notes on mileage allowances and other tax tips to help save taxi & van drivers money including household expenses that can be claimed and dealing with partner costs , tax saving tips that will be lost unless you follow the revenue ground rules carefully but will save the self employed taxi driver and van driver money. Taxi driver accounts designed to save many times the cost of buying it. A simple self employed bookkeeping system designed specifically for taxis and van drivers so clients can spend time saving money, not wasting it on unnecessarily complex accountancy software.
The expense headings used in the taxi book keeping software purchase excel spreadsheet have not been arbitrarily selected. This self employed taxi driver book keeping software uses the headings for the taxi expenses analysis as the inland revenue taxi self assessment tax return. A solution for a simple book keeping system with notes in the book keeping system user guide as to what items should be analysed to which columns. 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, taxis to set against 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. While depreciation is then disallowed in the self assessment tax return the same amount is then added back to the expenses as capital allowances. Capital allowances on taxis are automatically reduced by the personal use %.
DIY Accounting ""Self employed taxi & van driver book keeping & expenses accounts software UK" | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
[ Accounting Software ] [ Sole Trader ] [ Self Employed ] [ Company Accounts ] [ Taxi Driver Accounts ] [ Payroll Software ] [ Questions & Answers ] [ About us ] Copyright © 2006 2009
DIY Accounting Limited
|