I keep 4 sets of books/papers.
A binder in the office with the originals.
These are also scanned into the computer and put in a secondary location stored outside of my house.
A copy of these are also on my computer.
the fourth set is kept in the truck binder. Pretty much only that which is needed on the road in this set.
I have a packet of all my company stuff on the computer that I send in when I fill out carrier packets; profile, W9, Authority letter.
I use Home & Business because it tracks both my house and company checkbooks in one package. I have learned how to use text files to transfer data from inside quicken into a spreadsheet or a database if I want to. Some times I do that to do financial planning. I can take my invoices and export them into a text file as well and get them into Excel.
I have created my own Access database as well for loads etc. Has shipper, receiver and broker etc in the them as well as route and fuel tables. Just been something I have been toying with. The thought process for it all was to create an interface to put stuff into Quicken.
I bored with it and after awhile figured I would just use the individual files to do what I want out of it all.
spreadsheets I have:
one for loads. I enter all my load cities and mileage into along with rates. This also has a copy of a pro forma statement of cashflow. I use this kind of as a gage to tell me if the load is worth hauling.
Trip sheets. This is where I enter the data in for my trips by week and also fuel stops and state mileage beginning and ending. Basically this is a "driver duty" sheet for the IFTA stuff.
IFTA sheet. A new sheet for each quarter. I fill this out each week when I do my trip sheets. More a copy and paste task really. I can track what I am doing for my IFTA report and if I have a refund or owe that quarter. The goal with this is to be within $20 of break-even. Currently, I am owed like $80 by the state of MN on my IFTA account.
Fuel sheet. I didn't create this until LATE 2013. I use this to track the historical fuel mileage by month on the truck and to give me an annual average as well. Think long term trends here. I can see if I am having a mechanical issue or what not with the truck. It's showing me that the truck is tracking fuel mileage pretty even since I got the truck. When I say it's a 6.2 mpg truck, that's my average economy now since I got the truck. Winter I go down to about 5.8 and summer I am closer to 6.8-7 MPG. Even running 75-80K gross most of the time. The reality here is, weather temps and wind ARE the biggest contributors to good or bad fuel mileage. I have had days kill my mileage on a run as low as 4.8 mpg with a 20+ head wind and -10 temps and the same run has given me 6.8 MPG with a 20+ tailwind and +10*F. Same load, same road same direction. (Yes, I have been running the SAME load every day M-F since about 1 Oct 13)
What I like in my accounting package I have not found ANY PLACE else. Namely the ability to track all of my account; fuel, personal & business bank accounts, fleetone, invoices. That's the beauty of Home & Business.
|