Excel Spreadsheet for mystery shoppers

Hi! I am new to this mystery shoppers forum, but I have been dong mystery shopping forb several months and enjoy it. I, too, would like to get a copy of Flash's Excel worksheet for organizing everything in a more efficient way.
x

Create an Account

"We are a community of shoppers helping shoppers."

Membership is free. Simply choose your username, type in your email address, and choose a password. You immediately get full access to the forum.

Username: 
Email: 
Password: 
  (again)
 
Flash Wrote:
-------------------------------------------------------
> PM me your email and I would be pleased to send
> along an Excel file to get you started.
Private Message. Click on my name in blue and a screen will open which will allow you to send me a message privately through the board.
Flash Wrote:
-------------------------------------------------------
> PM me your email and I would be pleased to send
> along an Excel file to get you started.


FLASH WOULD YOU BE WILLING TO SEND ME THAT SPREADSHEET YOU HAVE? THANK YOU!!!
OOOOOOOOOOOOOOOOO Mine is on the way too please and thank you! What a blessing. I just love being organized. lol
Hi Flash. I have an Excel Spreadsheet template that I have used for years. I created it myself based on the kinds of shops I do. I would like to see yours also, and compare it to mine.
Hi Flash;

Being new to this arena, I think the spreadsheet would help me track my progress immensely! Can I get a copy? My email address is mojo101057@gmail.com.

Thanks!

Mojo
Hi Flash,

I'm just starting too and was about to try to set up my own Excel spreadsheet. I'd love a copy of yours. Thanks! email: sksweeps@earthlink.net

Thanks!

Suzanne
Being organized is not as exciting as going "seat of the pants" and see what pops up.

Actually I do a "cheat Sheet" and carry my trusty digital recorder. That is about as organized as I get!
Hi, new here! Great information on this MSF! I am shopping for the first time as a MS and I feel that after only one month and 25 jobs later, I need to be better organized. Does anyone know of any software out there which I can download and use to keep track of my shopping?
Help!
Thanks, Lizzie
zester,

Flash has been otherwise occupied lately. However, if you PM me I could share what she sends out with you.

I've made a few modifications to track expenses, net profit, and tithe paid / owed.

AndrewTX
Certifiable
Here's a public link to Flash's spreadsheet in my dropbox.

I trust I'm not violating Flash's trust as she happily emailed this to all who asked.

[dl.dropbox.com]

AndrewTX
Certifiable
Good job, Andrew! You win the prize for the Super Shopper of the Day! (except the prize is just adoration from the rest of us....)
AustinMom Wrote:
-------------------------------------------------------
> Good job, Andrew! You win the prize for the Super
> Shopper of the Day! (except the prize is just
> adoration from the rest of us....)

Thanks! I'm honored!

AndrewTX
Certifiable
Flash,

Is it true? Does such a spreadsheet exist as they say. Enough dramatics, seriously why has not ANYONE develped software for the shopper?

BYW, you still handing out copies of your sheet? Would love to get my hands on one.

Thanks
AndrewTX Wrote:
-------------------------------------------------------
> Here's a public link to Flash's spreadsheet in my
> dropbox.
>
> I trust I'm not violating Flash's trust as she
> happily emailed this to all who asked.
>
> [dl.dropbox.com]
> e%20Shopping%20Sheet.xls


Thanks Andrew, if there has been 'any' updating could u pass on the suggestions or formatting? Thanks~

"For whatever a man sows that will he also reap"
readytoworknow Wrote:
-------------------------------------------------------
> Thanks Andrew, if there has been 'any' updating
> could u pass on the suggestions or formatting?
> Thanks~

Here's a short list of the minor mods I've made to simplify and suit my own needs:
-I got rid of the bonus column and include it in with the fees as I don't see any advantage in differentiating between the two.
-I added a simple formula to the expense column to automatically equal what I enter in the reimbursement column by default. It saves me an extra step on full reimbursement shops.
-I added a formula to the "unreimbursed expenses" column to automatically calculate expense - reimbursement. I manually change this field if that formula doesn't properly reflect the unreimbursed expenses of a particular shop.
-I've narrowed the dates (start,due,complete,report) down to two (due,complete).
-I don't use the address column, but I do record location under "client name" (ex. Exxon #12345, Anytown, Main St.)
-I've deleted the "invoice required" and "invoice date" fields.
-I've created a "net profit" field above "date paid" in the top row to track profit after expenses (mileage not calculated in expenses).
-I've created "tithe due", "tithe paid" and "tithe date" columns. I tithe based on the net profit formula.

I don't claim that any of these mods are "improvements" over Flash's excellent template (for which I am eternally grateful). The changes are simply things that help ME, in how I do MS'ing, reporting, record keeping, and giving.

AndrewTX
Certifiable
AndrewTX Wrote:
-------------------------------------------------------
> readytoworknow Wrote:
> --------------------------------------------------
> -----
> > Thanks Andrew, if there has been 'any' updating
> > could u pass on the suggestions or formatting?
> > Thanks~
>
> Here's a short list of the minor mods I've made to
> simplify and suit my own needs:
> -I got rid of the bonus column and include it in
> with the fees as I don't see any advantage in
> differentiating between the two.
> -I added a simple formula to the expense column to
> automatically equal what I enter in the
> reimbursement column by default. It saves me an
> extra step on full reimbursement shops.
> -I added a formula to the "unreimbursed expenses"
> column to automatically calculate expense -
> reimbursement. I manually change this field if
> that formula doesn't properly reflect the
> unreimbursed expenses of a particular shop.
> -I've narrowed the dates
> (start,due,complete,report) down to two
> (due,complete).
> -I don't use the address column, but I do record
> location under "client name" (ex. Exxon #12345,
> Anytown, Main St.)
> -I've deleted the "invoice required" and "invoice
> date" fields.
> -I've created a "net profit" field above "date
> paid" in the top row to track profit after
> expenses (mileage not calculated in expenses).
> -I've created "tithe due", "tithe paid" and "tithe
> date" columns. I tithe based on the net profit
> formula.
>
> I don't claim that any of these mods are
> "improvements" over Flash's excellent template
> (for which I am eternally grateful). The changes
> are simply things that help ME, in how I do
> MS'ing, reporting, record keeping, and giving.

Again, thanks so much for your support!!

"For whatever a man sows that will he also reap"
@AndrewTx
I downloaded your spreadsheet thanks for this information as I did my first shop the other day and only recorded a few of the items you listed. didn't even think about mileage. this question may sound crazy but what's the difference between bonus and fee. I understand reimbursements. thanks
Fee is the regular base for an assignment. Bonus is anything additional.

Gandhi's Seven Sins: Wealth w/o work; Pleasure w/o conscience; Knowledge w/o character; Commerce w/o morality; Science w/o humanity; Worship w/o sacrifice; Politics w/o principle.
I've eliminated the bonus column on mine and just lump it in with the fee since they are the same thing for tax and income purposes.

AndrewTX
Certifiable
To answer gr8mystrysh0p, there is a site that offers a system to track your shops, mileage, schedules, payments etc. They have a free version, standard, and premium.
I just came across this today and it might be something that could interest you.

www.myshoptracker.com
Sorry, only registered users may post in this forum.

Click here to login