Excel & Spreadsheets

Join The MysteryShopForum Community

We are a community of shoppers helping shoppers. Join to get full access to all the discussions.

Discussions About Excel & Spreadsheets

Here's my profit and loss spreadsheet for my January work for those interested in seeing what you can make

The goal of this route was to make a fair bit of cash but spread it out over the month. Everything we did in this route could have been done at least one week faster, probably as many as 10 days sooner. Feel free to ask questions if... Continue Reading

Spreadsheet Users

Don't forget to start a new one for 2020!... Continue Reading

Does anyone use a spreadsheet to track activity and payment details?

Thinking that an Excel spreadsheet might help me track details for upcoming, "in process", and completed shops. A place to consolidate dates, times, MSC, fee, reimbursement, bonus, when submitted, when paid, special notes. etcetera. I'm willing to collaborate with a couple of other people on creation of a prototype. [ Even have this... Continue Reading

Excel Spreadsheet

Does anyone have a spreadsheet that they have created and are willing to share? I am having a hard time keeping track of things because I have signed up to so many different companies in order to try this out and see which company works best.... Continue Reading

Shop/finance tracking/spreadsheets opinions and advice?

Hey y'all. I currently use one spreadsheet with different pages for each month to track all my shops. Once I've done the shop I move it into completed status in the section below, then put an X in the paid column when it's done. That being said, I need a... Continue Reading

Shopper Resource: Spreadsheet for Video shop companies, contact info, and allowed devices.

Hey everyone, I've been working on this spreadsheet to give out to shoppers. It's a list of all the known video shopping companies, scheduler emails, and what devices they approve for their shops. Everything else is just the normal site for the company. We carry all of... Continue Reading

Mystery Shopper Spreadsheet

How can I get a copy? Thanks.... Continue Reading

Alternatives to excel?

I started mystery shopping in June, and have quickly realized how lucrative it can be. I have been signing up for more companies and getting more assignments. I realize that I need to record everything, and I am very excel savvy, however my laptop does not have it. I'm not... Continue Reading

Excel Spreadsheet for Shopping expenses

Has anyone developed a spreadsheet for keeping a record of shops and expenses?... Continue Reading

Need some advice to set up spreadsheets for 2017, please

I'm trying to set my spreadsheets for individual companies so I can copy and paste into the main spreadsheet or vice versa. I would like date, location, scheduler, fee, reimbursement, expenses, how I'm paid (DD, PP, check), mileage and date I'm supposed to be paid. I'm not sure if this... Continue Reading

Taxes and the spreadsheet

I'm starting a new thread about keeping track of expenses for taxes. If the mods need to move it to the original thread, please do so. I called my accountant about what we can or cannot take as expenses on our schedule C for the tax year of 2016. Meals may... Continue Reading


How are your spreadsheets developed or organized? My spreadsheet is for the current year. The first tab is a summary with a list of the MSCs I contract with and links for mileage, shopper fees, and the amount I was paid. Following spreadsheets are categorized by MSC and have... Continue Reading

Spreadsheet for keeping track of mystery shops

Anyone have a spreadsheet that will help me keep track of my shops for income tax purposes? Doing taxes drives us crazy. I have got to find a better and easier way to do this.... Continue Reading

Seeking spreadsheet

Does anyone have a spreadsheet that they can share? I am a newbie and need some examples.... Continue Reading

Someone willing to share their excel spreadsheet?

Salutations, I've been mystery shopping for years, but recently decided to turn it up. This forum is awesome and I appreciate the abundance of knowledge being shared. I am hoping someone is able to share a basic spreadsheet I can use to enter MSC notes and information. It... Continue Reading

Mystery spreadsheet

I am a 'New-Bee" at this. Does anyone have a spreadsheet to track shops, payment, and when I am paid that they could share with me? I would be forever be grateful.... Continue Reading

Spreadsheet(s) Help Needed

I would like some help from some of the pros in this forum on some detailed info about how to keep track of the assignments (shops) that I have accepted and then completed and then awaiting payment for. I have been doing all this by hand by setting up weekly log... Continue Reading

Printing long survey -or- creating short spreadsheet?

I have a MSC that has a grocery store audit that is really simple to do once you read the 32 page book the first time and know what they are looking for. They also have an audit form for this shop that is 20 pages long and are repeating... Continue Reading

EXCEL help

So I'm finally getting around to my 2013 taxes and I want to simplify my life a little late. I downloaded transactions from Paypal in CSV. The problem I have is I would like to SUM the Gross column but I would like to be able to exclude items. For example... Continue Reading

Excel Shopping and Consulting

Hi, I am considering signing up with this company. Any experiences (good, bad or ugly)? TIA... Continue Reading

Price Audits.. 12000 items on an exel spreadsheet, get prices from given grocery store without getting caught.

How would one go about this? 12 000 items, recording the prices without getting caught? (Instructions explicitly say not to get caught.) The assignment is worth $450, and there are two of them, each about two hours from my home. Would it be worth spending a night in that city... Continue Reading


Hi, I downloaded the spreadsheet that was mentioned on here. When I opened it, it appears to be duplicated on itself. The cells are on top of each other and I cannot fix it. Example G1 is for the year, so I put in 2013 and then lower about three inches... Continue Reading

Trying to locate the "Mystery Shopping Bible" spreadsheet

Nothing shows up in the results of my searched for this... Looking for a spreadsheet to help organize my shops! :) Can anyone help?... Continue Reading

Need a spreadsheet asap

Hi all. I'm new to shopping, but so far everything is going smoothly. I would like to know if anyone can PM me a spreadsheet or something useful to keep track of my shops. I'm already on jobslinger plus, but that only keeps track of Sassie shops. Thank you all in advance! Leedah... Continue Reading

Excel Spreadsheet

Can anyone assist me. I am looking for a spreadsheet to keep track of my shopping assignments, track mileage and expenses. Robert Woods... Continue Reading

Excel spreadsheet problem

Since most of use Excel for keeping track of shops/expenses etc., and use different colors to help with that, I was wondering if anyone has had this problem. I have Excel 2003 and previously worked just great. Now every time I try to change the color of a... Continue Reading

Excel and a calendar?

Is there a free, or minimally priced, online software that imports from Excel? I enter assignments on Excel. If the dates and locations could segue to an online calendar, it would save me from duplicating my efforts. Also, it would give me online access, while on the... Continue Reading

Tips for Organizing my MSC's Spreadsheet?!

So I'm signed up with 138 MSC's thus far. About 15-20 of them are those notorious "We'll Email you when we have jobs". It's been 8 months since I compiled my list so it's 8 months old and hasn't been cleaned out or updated. I really only work for... Continue Reading

Microsoft Excel needed for a shop! Yikes!

I'm thinking about signing up for a shop, but it requires I know how to use Microsoft Excel. Is it hard to learn? I've not had a company require this, and thought it was just for their hotels. Sigh! Any thoughts floating around on the forum about this... Continue Reading

what does your excel spreadsheet look like for shops? what do you title each of your columns?

what does your excel spreadsheet look like for shops? what do you title each of your columns? what things do you list? like date? client name? address? payment? reimbursement? mileage? etc? i want to get everything perfect on paper for each day/week/month/year. what's... Continue Reading

Confessions of a spreadsheet junkie

By now, if you have been reading this forum for any period of time, you know I am a huge fan of Excel spreadsheets. I love making ‘workbooks’ where all of my information is at my fingertips. I was putting together one as sort of a genealogy of... Continue Reading

Help Please -- Using Open Office with Excel Documents

I just booked my first Buckalew hotel shop. I downloaded Open Office but don't know if I downloaded the correct thing and not sure how to use the programs. Also, would Google docs work as well? Thanks.... Continue Reading

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.... Continue Reading

Spreadsheet for keeping track of shops

I need some way to track a shop from its receipt to completion to payment. How do you do this?... Continue Reading

Technical question about Excel

Not sure where to post this. I recently upgraded my phone to a HTC Touch pro with Windows Mobile Office. I love it so much it's a wonderful phone. I went to school for computer applications from 96-98, but everything I learned is obsolete. The excel on my phone is... Continue Reading

Payment tracking and excel sheets

Flash and others have shared a great deal about record keeping. Somewhere I saw a PayPal account sheet that someone posted to reveal how much they made doing on line surveys. In the past, I've seen great shared comments. Do any of you have a great spreadsheet that you could... Continue Reading

Discussions of Excel & Spreadsheets

Servimer is an excellent MSC to work with. (Source). February 16, 2020

If you use Sprint, they often have excellent offers on iPhones. (Source). February 16, 2020

Also, why would they bother with a spreadsheet to see if they are making a profit if they received a large check? (Source). February 15, 2020

Congratulations! Keep up the good work! I don't know if you started tracking this, but I have a separate spreadsheet with a list of all of the Mystery Shopping Companies (MSC) I am signed up with, their website address (in case I lose my favorites) the clients they have, how they pay (Paypal, direct (Source). February 15, 2020

I'm so glad I took the advice in the newbie guide about keeping track of everything in a spreadsheet. (Source). February 15, 2020

Pleasure trip to bookstore. Accepted an assignment (and will disrupt this most excellent hiatus for a few moments of work). (Source). February 13, 2020

Our client uses this information to ensure that employees are providing excellent customer service in person and on the phone. (Source). February 10, 2020

The receipt and any collateral materials are scanned to jpg and saved in the XYZ folder. Everything else is handled on my spreadsheet, which records date the job was done, what, for whom, mileage, fee, bonus, reimbursement, date paid and the amount paid. (Source). February 09, 2020

have a college send a late 1099 to me one year, and the IRS would have billed me for the full amount, except I was able to instantly produce my spreadsheet showing every judge payment, thus reducing my tax burden to nothing, since I had already reported my fee from that tournament. (Source). February 07, 2020

Not everyone is, and it’s a moot point - it isn’t reported anywhere.[/quote] YES! That is exactly right, Mousegal! That's why I'm glad I keep my own records on a spreadsheet. (Source). February 07, 2020