A shop log is a personal record where you track your completed mystery shops, earnings, expenses, and key details. It’s your own tracking system that gives you the full picture across every company you work with.
Mystery shopping companies track your shops on their platforms, but no single system shows everything. If you work with five companies, that’s five separate dashboards with five separate payment records. A shop log pulls it all together in one place.
Keeping a good log pays off in two ways — it helps you make smarter decisions about which shops to take, and it makes tax time far less painful.
What to Track in Your Shop Log
A useful shop log doesn’t need to be complex. At minimum, record these details for each completed shop:
Date and location. When you did the shop and where. This helps you track shop rotation windows so you know when a location opens back up.
Company. Which mystery shopping company assigned the job. Essential for tracking payments across multiple providers.
Shop fee and reimbursement. Record both amounts separately. The fee is your taxable income. The reimbursement replaces what you spent. Keeping them distinct makes tax reporting accurate.
Mileage. Track the round-trip distance for every shop. Mileage is one of your biggest tax deductions as an independent contractor. The IRS standard mileage rate turns those miles into real savings at tax time.
Payment status. Note whether payment is pending, approved, or received. This tells you what to expect and flags any late payments that need follow-up.
Time spent. Record total time including drive, visit, and report writing. This lets you calculate your true hourly rate and decide if certain shop types are worth repeating.
Why a Shop Log Matters
Tax preparation. As an independent contractor, you file a W-9 and report all mystery shopping income. A well-kept log gives you exact income totals and deductible expenses without digging through five different platforms and your email.
Earnings analysis. After a few months, your log reveals patterns. You’ll see which companies pay best, which shop types give the highest hourly rate, and which locations eat too much drive time. Data beats guessing.
Rotation tracking. Noting the date and location of each shop tells you exactly when each spot becomes available again. This puts you ahead of shoppers who just check the platform and hope.
Payment disputes. If a payment doesn’t arrive on schedule, your log gives you the exact details to reference when contacting the scheduler. Having dates, amounts, and report numbers on hand speeds up resolution.
Key Warning: Without a shop log, you’re guessing at tax time. The IRS expects independent contractors to report all income and track deductible expenses. “I don’t remember” isn’t a defense. Keep records from day one.
How to Set Up Your Shop Log
Spreadsheet. The most common method. A simple Google Sheet or Excel file with columns for each data point works well. You can add formulas to auto-calculate totals, mileage deductions, and hourly rates.
Note-taking app. If you prefer mobile, apps like Google Keep or Apple Notes work in a pinch. Less structured than a spreadsheet, but better than nothing — especially for logging right after a shop.
Dedicated tracking app. A few apps are built for gig workers and freelancers. They often include mileage tracking, expense categories, and income totals. More overhead to set up, but powerful if you do high volume.
Whatever you’ll actually use. The best system is the one you’ll keep up with. A perfect spreadsheet you never update is worse than a simple list in your phone that you fill in after every shop.
Pro Tip: Update your shop log the same day you complete each shop. A two-minute entry while details are fresh saves you hours of reconstruction later. Waiting until the end of the month means forgotten mileage, missing details, and inaccurate records.
Common Questions
Do I really need a separate log if the companies track everything?
Yes. Company platforms only show your activity with that one provider. A log gives you the cross-company view — total income, total mileage, overall time invested. It’s also your backup if a company’s records have errors.
How detailed should my mileage tracking be?
The IRS wants the date, destination, purpose, and total miles for each trip. Your shop log handles most of this naturally. Just make sure you record mileage for every shop trip — not just the ones with long drives.
Should I track shops that got canceled or rejected?
Yes. Record them with a note about what happened. Canceled shops still cost you drive time and mileage. Rejected shops help you spot patterns — maybe a certain company’s reports are too picky for the pay they offer.
Explore our calculators and tracking tools in the tools and resources section.