Cashbooks

The cash book spreadsheet called Cash book taxi has been designed to cater for taxi drivers.

Taxi drivers are required to be registered for GST.  This spreadsheet can assist them to record their daily takings and account for their expenses.  It will automatically calculate the GST and will produce figures to enable them to complete their Business Activity Statement.

This cash book can also assist them to determine their income tax obligations.

Sales

Drivers can enter their daily sales incorporating their cab charge vouchers and other dockets, their EFTPOS sales and their cash sales.

Purchases

The rent or bailment that the driver pays to their owner is calculated automatically, all the driver has to do is enter the percentage amount they give to the owner.

There are 6 other categories they can use to account for their other regular expenses, these expenses are set up from the "Setup" tab in the workbook. There is one column set up to account for any GST-free expenses a driver my incur such as bank fees.

The cash book will then work out the GST

Income tax

The workbook also contains a tab to assist a driver determine their potential income tax obligations.  They can either obtain the actual amount of income tax payable from a link to tax tables or they can guesstimate a percentage and put that away each month.

Download

Download Cash book for taxis by clicking on this link.  This version is compatible with microsoft excel 2007+

Download Cash book for taxis for excel version 2003 by clicking on this link.