ROI small business accounting software, tax accounting, payroll software,

 

Accounting Software

 

Self Employed Accounts

Sole Trader Basic Accounts

Taxi Driver Accounts

Company Accounts

Payroll Software

 

 

Questions & Answers

About Us

Whats New

Order Page Taxi Receipts Taxi Expenses Cash and Bank Cab Accounts Tax Return Income Tax Vat

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

 

Total for Month

0.00

 

Purchase Date

Supplier

Purchase Reference / Invoice Number

 Enter Expense Code Letter

Total Purchase Value incl Vat

 
 
 
 

 

 

 

 

 

 

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.

 

How Paid

0.00

0.00

26-Sep-09

 

Payments Made to Creditors

Cash

Actual  Amount   Paid

Purchases waiting payment

Purchases number of days outstanding

Bank

Credit Card

 

 

 

 

 

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.

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

 

Taxi Vehicle Running Cost

0%

Sub contractors

Staff costs Salaries Wages

Taxi license & Professional Fees

Travel & Subsistence

Office Repairs and Renewals

Office Premises Rent Rates

 

Personal Use

 

Motor Expenses

 

M

C

E

L

T

R

P

 

 

 

 

 

 

 

 

 

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. 

Date Asset Purchased EXISTING FIXED ASSETS at  31-Dec-08 0.00 0.00 Deprn Rate %
Asset Description Purchase Reference Original Cost Accumulated Depreciation
31-Dec-08
             
  TAXIS bought         20.0%
          20.0%

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
Last modified: 10/03/09