This is the same method that I developed and have been using for 3 years. The only difference is that I have two more sheets. One sheet is sorted by MSC and the other sheet is sorted by Month. ONLY when a shop is completed, it is cut from the "open" shops and pasted to the MSC sheet and also pasted to the monthly shops. That way I have a total that I have completed for each MSC and a total I have completed (paid) by month. My main sheet shows all open sheets. This allows me to also follow up on shops that I have not received payment for.@Jk1nole wrote:
I use one of the spreadsheets from the new shopper area and it works great... It tracks shops by month, fees, payment dates, and lots of other details. I tried to keep a calendar too, but that lasted a week. I highlight my upcoming shops as blue, completed as yellow, and paid as white / no color.
@shaynes5 wrote:
How do you all keep track of your upcoming shops? Currently I'm printing them all off and putting them in date order in a pile but I'm wondering if there is a more effective process that you use?
With all of the different companies and shops out there it's hard to keep track of them all!
@JASFLALMT wrote:
The cloud is a wonderful thing. You definitely can have access to spreadsheets and other documents on the go with OneDrive.
@shaynes5 wrote:
That would be great! I have an iPad and I would love to take it with and have the spreadsheet with me. I think the iPad can open my spreadsheets now though...not sure I'll have to look.
@Wassim wrote:
Everything in the World can be done in multiple different ways. But there is ONE correct way and many other semi-correct ways. I tend to like that SINGULAR correct way.
is this guy for real? maybe hs kid on summer vacation. other end of spectrum is old guy not willing to learn new & more efficient ways of doing things. still "smell of arrogance and your condescending attitude" is good description.@JASFLALMT wrote:
The smell of arrogance and your condescending attitude in the forum is very off-putting, Wassim. I have been a mystery shopper for over 16 years and you are trying to tell me that I am "semi-correct" in my methodology? And Lisa has been a shopper for about a decade I believe, though she is a much more serious shopper than I am and really does consider it a business, whereas it's more of just a sideline business for me as I have other means of income as well. That being said, I have done at least 8,000 shops since becoming a shopper, maybe more, but I would have to go through my records to get an exact count.
Let me give you a piece of advice: being patronizing and condescending to long-time forum members with years and years of experience is beyond rude.
Edited to add: I was "alluding" to the fact that you should stop said behavior while you are NOT ahead. You will not win any hero citations with your attitude.
@indianyooper wrote:
I made a slreadsheet with 12 tabs, its named mystery shopping xxxx(year). Each tab has date, name of shop, shop fee, reimbursement, roind trip miles , msp, paid(y/n). Each tab also has a total taxable fees and total reimbursemnt and total mileage spots. I also set up a cover sheet that totals up total taxable shop fees , total reimbursemenrs and miles.
I fill each line and then sort by date walla...
Oh i do this on google sheets so it syncs to everywhere when a change is made anywhere.
Each year i just open the master and save it with that year and im glod to go.
If anyone wants it let me know, id have ro figure out how to send it and take my info out of it.