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.

There is a copy of the spreadsheet at [www.mysteryshopforum.com] you can download.

Edited 1 time(s). Last edit at 01/07/2017 05:09PM by Flash.

Hi Flash, can you send me the spread also? Much appreciated

Hey Flash! Hook up a gal from Miami!

Flash Wrote:
-------------------------------------------------------
> PM me your email and I would be pleased to send
> along an Excel file to get you started.

What does PM mean? How do I e-mail you individually?

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!

That must make it a whole lot of laughs at tax time :-)

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

Could I get a copy of the spreadsheet please?

Thanks

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.

Hi There,
Please can you send me a copy of excel to0.
Thanks Kindly,
Sharon S. sharonshaw20@yahoo.co.uk

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]

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!

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~

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 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!!

@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.

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.

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

I would like a copy also if someone could tell me how to get it ty
candas