Track regular and overtime hours worked on a weekly, monthly, quarterly, or yearly basis with this accessible employee timesheet template. This Excel timesheet template is sleek, professional, and makes ideal time cards for employees. Totals are calculated automatically. If Truck or any vehicle driven by two different drivers, then split this sheet for both drivers. Just like driver duty roster template you must maintain this sheet for best work. Truck Drivers Hours log book Sheet (How it Works) Here is some detail of creating this sheet, so do not forget. Drivers Name/Age/Gender; Operations Duties.
2021 Driver Accounting Software Program Spreadsheet(easy expense-tracking and trucker accounting spreadsheets)
(NOTE: if you pay IFTA, try the Accounting PLUS IFTA using the menu above)
Click the first image below for 'Equipment View' and the second one for 'Personnel View' examples:
Driver Hours Spreadsheet Form
This is the truck driver accounting spreadsheet program. It is simple, inexpensive, and it saves you hours of headaches trying to 'tally up' all of your deductible, and other expenses for accounting and tax purposes.
(there is a free sample of this spreadsheet here: trial accounting. This is a zipped file so you will need to extract it somewhere on your computer to try it)IMPORTANT NOTE! You must have the full version (not trial version) of Microsoft Excel™ 2007 or higher and WINDOWS on your computer to operate this form. It does not work on phones.
You enter:
- Add your categories: up to 3 items of income and up to 25 expense categories
- Trip pay miles (loaded and empty)
- Your fuel costs
- Truck maintenance and other expenses
- Business deductions.
- Virtually any category of expenses that you want. It is customizable so that you can enter your own categories also!
The spreadsheet then gives you:
- The completed summaries for your Monthly, Quarterly, and Annual Pay
- The completed summaries for your Monthly, Quarterly, and Annual Expenses
- An easy summary page which can be printed or mailed to your accountant easily!
- THIS PROGRAM IS BASED ON THE CALANDER YEAR.Last entry is Dec 31st of the year.