Over the past several years my wife and I have been refining an Open Office spreadsheet to keep track of load pay, fuel, time on the road, and expenses. Everything has it's own tab. The tabs are at the bottom of the document. Lower left.
If you are not familiar with Open Office it is a free office suite like Microsoft office. You can read about it or download it here.
OpenOffice.org - The Free and Open Productivity Suite
I will do not know if it will correctly convert into an MS Office Excel format. I'd rather use free software then paid.
As for my spreadsheet it is set up for me as an O/O that gets paid based on percentage of the load. (72%....you'll see it in the equations)
There is a summary page that my wife uses when she files taxes. Everything sorts by month and it is very easy to use. The expenses tab has drop downs that are sorted like the schedule C.
Don't ask me to make changes for you....I'm too busy...mostly tarping and strapping.
My favorite part is the fuel tab. In Column M Pd Total is what I actually paid when it shows up on my paycheck. This way I can track the difference between what the pump says and what I actually paid when it showed up on my paycheck. So far this year I have saved over $8000 dollars off of the pump price.
If you have any questions email me at
[email protected]
The doc is hosted at google.
https://docs.google.com/open?id=0B1B...ZlYmZkMGY2YmM5
Good luck in the new year.
Keith
__________________
TMC Texas Dedicated Owner Operator
http://www.flickr.com/photos/shadowsknight
You are a rumor, recognizable only as deja vu, and dismissed just as quickly. You don't exist. You were never even born. Anonymity is your name, silence is your native tongue. You are no longer part of the system. You are above the system, over it, beyond it. We are "them." We are "they." We are the Men in Black.
We either hang together or we will be hanged seperately. -Benjamin Franklin 1767