I use excel and print out pages every week. Over 100 jobs listed vertically in the order I do them not alphabetically. Nothing fancy. That book looks simpler.
Excel is the best program to keep your storefronts in
Not much to know , all ya jace to do is set up rows
One row will have name
Another will jace adresss
Another row will jace town
Another will jace price
Another will jace how often
An so on.
Then just start filling in everything underneath into the cells
Oh yo start it you’ll open up a soreadhesett. Name it an save it. Save everything after done typing in So you don’t lose it
My daily work sheet gets folded up and carried inside the receipt book. I can see the names of whose getting done and check them off without opening the sheet. The less important data is folded under the receipt book flap.
I realized that people could enlarge the page to read my customer list. Oops. Now I got some pictures up differently. I’ve got about five pages like that. It’s an excel sheet with page breaks so I get five little pages I can fold up and carry inside my invoice book in my back pocket, a days worth of work. I’m strictly storefronts now.
There’s a master sheet on my laptop at home with 3 four week periods layed out so I can see the next 12 weeks, a quarter, with totals all added up for me in excel at a glance. All the individual jobs in columns layed out. A column from the master gets pasted into the weekly spread sheet each week. Of course the master changes when the weeklies don’t go as scheduled.
Does that make sense?
But it’s pritty simple. Just start the spreadsheet by naming it. Save as then type a name. Now you have your spreadsheet. Them fill in top rows with all the headlines. Which will be the store name
The addresss. The price ect…
There is s lit more to learn like deleting rows An making a cell bigger making your headlines bold An bigger. Just play with it. An hit save after you type in a lot so you don’t lose what you typed.
I[quote=“Dee, post:4, topic:43191”]
Sooner or later I’ll want to pass it off to an employee.
[/quote]
If I had employees they’d get one small page to fold and put in the invoice book. I’d probably fill out the invoices in advance, in the order they get done.
I don’t put a lot of info on my weekly sheet. Not enough room on that little piece of paper. It’s just a list of whose getting done this week with a price.
I’ll probably stick with the calender unless/until and if I ever expand to more than one truck on the road. Otherwise just seems like more work. Plus I’m just not real technical.
BostonMike, in the picture you have up now, ‘R’ = ? ‘3R’ = ? ‘W’ = ?
I can see the 2 week and 4 week pattern. And, I think I can see the Outside Only and the Inside&Outside pattern.
The Blue indicates the current route day?
This spreadsheet is based on a 30 day period, correct?
That’s a good layout, thank you.
I know what you are saying, I had my phone stolen before. What a pain it would be to have my book come up missing.
You mention a mileage chart, I’ve been writing my miles down in my notebook. Where’d you get you mileage chart from?
That’s something to think about. Thank you.
Thank Majestic66, I use to use excel years ago, but it has been many years ago. Thanks for the starter list of the column headlines. It makes it easier.
The mobile printer idea sounds great. But, for now it will have to be pre-printed invoices or carbon paper…good thing I’m cleaning Office Depot at 7am tomorrow.
Thanks everyone and thanks to someone who emailed me.
We keep our account list in excell and we keep a paper copy for quick reference in the truck. Like @Majestic66 said very basic name,address,price ect. We run 3 account lists in excell weekly, bi weekly and monthly customers. We use google calendar for scheduling.