Originally Posted by Tommy77
Yep I use open office calc and keep all my info with me at all times on my iphone using google drive in case I need to add / remove / modify a customers info on the go. I have it set up to automatically figure out price / sales tax / and material used based on just the square footage . All I do is enter the name/ address / sqft. I keep tabs on about 250 customer this way for lawncare / bed weed control / aerations etc. i just keep a different spreadsheet fir each service .best part is both programs are free. A little learning will save you a lot if money while all the stubborn guys pay $2000 a year for software.
I'v used both. Microsoft is defiantly better, however this is a big subjective. as mentioned above formatting can be change when opening different files. but the biggest difference is going to be when you get into more advanced things. graphs and that sort of thing. now, its been a while so i'm sure open office has gotten better about that stuff since my last time. for the most part they work exactly the same and i'm surprised someone opened a file and the formulas didnt work.
Another option is using google calc (drive.google.com, docs.google.com). The thing that i like about it is that you can share sheets with other people and watch them as they edit it, even edit it at the same time. I plan on using it this winter with my subs. ill share a route sheet with them and they check off the work they did on what date.
tommy, is there any chance you would be willing to share your sheet? i'v been wanting to do the same but it takes time to measure out the sqft for different types of jobs and figure out what costs and profit margins are for different services. I would appreciate it.
In return i would be able to share a sheet i made for my mowing route. You list your customers, pricing, address, notes and a few other things on each line. then at the end of the day all you have to do is put a check next to each line/customer you mowed that day. At the end of the week or month all you do is go to the past page in the sheet, export it, and import it into quick books. all of the data then gets put into quick books in a matter of seconds. All of your data entry for the month done in just a few moments.