The sheet also contains a monthly analysis of the total mileage, business travel % and number of business trips over a three month period.įorm - this sheet contains a form which can be printed and supplied to all drivers in order to record all business & private trip details. The calculations on this sheet can be used to calculate the business & private mileage of each vehicle based on any user defined date range & client selection. Vehicles - add vehicle registration numbers for all vehicles on this sheet and enter a vehicle description. The sheet also contains calculations which can be used to analyse the travel that is charged to clients on a monthly basis. The calculations on this sheet can be used to calculate the amounts that need to be charged to clients based on any user defined date range & vehicle selection. The travel distance is calculated based on the opening & closing odometer readings and is compared to the standard distance for the selected client which is defined on the Clients sheet.Ĭlients - create client codes for all clients on this sheet and enter a client name & standard travel distance. The vehicle registration number and client code selections are based on the contents of the Vehicles and Clients sheets. Logbook - this sheet can be used to compile a comprehensive vehicle logbook for multiple vehicles. The template includes the following sheets: The template is suitable for individuals who need to compile a vehicle logbook for income tax purposes and for businesses that need to manage a fleet of vehicles, calculate amounts that need to be charged to clients, manage pool cars and analyse business & private use of vehicles. The template accommodates multiple vehicles and can also be used to calculate travel charges for invoicing to clients.
This unique template enables users to compile a complete vehicle logbook for all business and private travel.
0 kommentar(er)
