Home » Finance » Accounting

How To Produce Taxi Driver Accounts Plus Tax Returns In Less Than 2 Hours

Nov 18, 2007
Since the majority of taxi drivers, but certainly not all, have little accounting or bookkeeping knowledge the lower the level of expertise required the more suitable such an accounts package will be. Data entry basically consists of just 3 records, being an excel spreadsheet for taxi receipts; another for taxi expenses plus a further worksheet in which assets such as a vehicle can be recorded.

Taxi receipts are entered on a series of excel worksheets within the taxi income work book preset with each day of the financial year. Weekly and monthly totals are added and transferred through the linking system from the taxi bookkeeping sheets to the taxi financial accounts sheet.

Taxi expenses are listed on a series of twelve monthly spreadsheets which have preset columns with appropriate headings for taxi drivers to record office and rental costs, fuel bills, other vehicle costs and licence fees. The total of each expense is entered on each row and a single letter used to then analyse the taxi expense to the column required. As with the taxi income sheet the columns are then automatically added which includes a check on data entry accuracy before being transferred to the taxi driver accounts sheet.

Cash and bank spreadsheets are not provided as not required by taxi drivers as taxi drivers do not need to produce a balance sheet.

In addition to entering purchases on the taxi expense sheet the only other entries required from the taxi driver to produce a set of taxi driver accounts is to also enter vehicle and any other assets purchased on the fixed asset spreadsheet. The fixed asset spreadsheet having already been preset with both depreciation rates and the capital allowances that taxi drivers can claim. The taxi accounts software is then complete.

The financial accounts file contains formulae to produce a monthly profit and loss account that includes the taxi capital allowances from the fixed asset schedule.

A unique feature is that both mileages covered and vehicle running costs can be entered. The tax rules in the UK state that drivers cannot claim both mileage allowances and vehicle running costs. It has to be one or the other and only at the end of the financial year when it becomes clear which is the most tax efficient.

This taxi accounts package compares both the mileage cost and the vehicle running cost and automatically selects the most expensive. This ensures the highest costs are selected into the calculation of the net taxable profits and highest cost equals lowest tax bill.

Also in the taxi accounts file is an excel spreadsheet designed with the same layout, colour codes and box numbers as the inland revenue self assessment tax return. The taxi self assessment tax return is completed automatically by the cabsmart taxi accounts software. No entries are required leaving the taxi driver only to click print to produce the self assessment tax return.

Finally having calculated the net taxable profit for the year the accounting package also has a tax calculator that calculates the amount of income tax and national insurance to be paid.

The taxi driver accounts package has been tested many times and the annual receipts and expenses for a full year take approximately 2 to 3 hours to enter, and have been completed in less than 2 hours. The end product is a full set of taxi driver accounts including the self assessment tax return.

Both couriers and van drivers have similar businesses to taxi drivers in that they move items from one place to another in a similar way in which taxi drivers move people from one location to another. And because of the similarity in business activity then this taxi accounting package would be equally suitable for couriers and van drivers.
About the Author
Terry Cartwright, a qualified accountant in the UK, designs Taxi Accounts software on excel spreadsheets specifically for the Taxi Driver wishing to save money and prepare the Taxi Driver Accounts and produce the self assessment tax return in the process.
Rating:
Please Rate:
(Average: Not rated)
Views: 248
Print Email Report Share
Article Categories
    • Artists
    • Gambling
    • Humanities
    • Humor
    • Movies
    • Music
    • Photography
    • Tattoos
    • Television
    • Classic Cars
    • Motorcycles
    • Recreational Vehicles
    • SUVs
    • Trucks
    • Vans
    • Branding
    • Business Opportunities
    • Careers and Jobs
    • Corporate
    • Customer Service
    • Direct Mail
    • Entrepreneurship
    • Ethics
    • Financing
    • Franchising
    • Home-Based Business
    • Human Resources
    • Import and Export
    • Leadership
    • Management
    • Market Research
    • Marketing and Advertising
    • Negotiation
    • Network Marketing
    • Networking
    • Organizational
    • Presentation
    • Project Management
    • Public Relations
    • Small Business
    • Strategic Planning
    • Team Building
    • Telemarketing
    • Training
    • Data Recovery
    • Databases
    • Games
    • Hardware
    • Networks
    • Operating Systems
    • Programming
    • Security
    • Software
    • Spyware and Viruses
    • Ask an Expert
    • College and University
    • Home Schooling
    • K-12
    • Languages
    • Online Education
    • Psychology
    • Coffee
    • Cooking
    • Gourmet
    • Recipes
    • Wine and Spirits
    • Acne
    • Aerobics
    • Alternative Medicine
    • Beauty
    • Cancer
    • Cosmetics
    • Depression
    • Diabetes
    • Diseases and Conditions
    • Fitness Equipment
    • Fitness
    • Hair Loss
    • Heart Disease
    • Medicine
    • Men's Health
    • Muscle Building
    • Nutrition
    • Skin Care
    • Supplements and Vitamins
    • Weight Loss
    • Women's Health
    • Yoga
    • Arts and Crafts
    • Babies
    • Collecting
    • Elderly Care
    • Genealogy
    • Hobbies
    • Parenting
    • Pets
    • Pregnancy
    • Woodworking
    • Feng Shui
    • Gardening
    • Home Appliances
    • Home Security
    • Interior Design
    • Landscaping
    • Affiliate Programs
    • Article Marketing
    • Auctions
    • Audio
    • Banner Advertising
    • Blogging
    • Broadband
    • Domain Names
    • E-Books
    • E-Commerce
    • Email Marketing
    • Ezines and Newsletters
    • Forums
    • Internet Marketing
    • Link Popularity
    • Pay-Per-Click
    • Podcasting
    • RSS
    • Search Engine Marketing
    • Search Engine Optimization
    • Security
    • Social Media
    • Spam
    • Video
    • Viral Marketing
    • Web Design
    • Web Development
    • Web Hosting
    • Copyright
    • Cyber Law
    • Intellectual Property
    • National, State, Local
    • Patents
    • Regulatory Compliance
    • Trademarks
    • Buying
    • Selling
    • Baseball
    • Basketball
    • Boating
    • Cycling
    • Extreme Sports
    • Fishing
    • Football
    • Golf
    • Hockey
    • Hunting
    • Martial Arts
    • Running
    • Scuba Diving
    • Soccer
    • Swimming
    • Tennis
    • Dating
    • Divorce
    • Marriage
    • Weddings
    • Astrology
    • Buddhism
    • Christianity
    • Faith
    • Hinduism
    • Islam
    • Judaism
    • Meditation
    • Metaphysical
    • New Age
    • Cable and Satellite TV
    • Cell Phones
    • Communication
    • Gadgets and Gizmos
    • GPS
    • Satellite Radio
    • Video Conferencing
    • VoIP
    • Addictions
    • Coaching
    • Goal Setting
    • Motivational
    • Stress Management
    • Time Management
    • Clothing
    • Electronics
    • Fashion
    • Gifts
    • Jewelry
    • Causes and Organizations
    • Environment
    • History
    • Holidays
    • Men's Issues
    • Nature
    • Philosophy
    • Politics
    • Women's Issues
    • World Affairs
    • Air Travel
    • Camping
    • Cruises
    • Destinations
    • Outdoors
    • Article Writing
    • Book Reviews
    • Copywriting
    • Fiction
    • Non-Fiction
    • Poetry
    • Quotes
    • Screenplay
    • Tools and Resources