1. Forums
  2. Mystery Shopping Discussion

Spreadsheet Users

December 28, 2019 02:50AM
Don't forget to start a new one for 2020!

"I told myself to quit you; but I don't listen to drunks." -Chris Stapleton
Reply
Log In
x

Create an Account or Log In

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

Already a member? Log In.

More About Excel & Spreadsheets
December 28, 2019 03:00AM
Now if IRS would only get on the ball and announce the business mileage rate for 2020. Speculation is that it will be the same as for 2019, but that is pure speculation. It is only what IRS announces that counts.
Reply
December 28, 2019 01:38PM
Mine is ready and waiting. Also an 'alarm' on my phone to check my odometer Jan 1.
Reply
December 28, 2019 04:24PM
@HonnyBrown wrote:

Don't forget to start a new one for 2020!
I just did mine last nite...had to, when I realized I have some shops for January that needed to go somewhere!! Thanks for the reminder!
Reply
December 28, 2019 04:27PM
I do a new one every quarter. It's easier for me that way. I am spending my day today getting my spreadsheets all up to date.
Reply
December 28, 2019 06:25PM
Oh, hey, let me bring mine over...lol

@CoffeeQueen wrote:


I am spending my day today getting my spreadsheets all up to date.

Kim
Reply
December 29, 2019 05:42AM
Anybody willing to post a template? smiling smiley

Shopping domestic and international locations since 2003.
Reply
December 29, 2019 05:56AM
There is another spreadsheet thread in this section. A shopper said he will post one. I don't know how.

"I told myself to quit you; but I don't listen to drunks." -Chris Stapleton
Reply
December 29, 2019 01:06PM
@pambam wrote:

Anybody willing to post a template? smiling smiley

Mine is simple. Date, job, fee, reimbursement, milage, non-reimbursable expenses, notes.
I have another page where I track my business receipts.

______________________________________________________________________
Seriously, nobody cares that you're offended.
Reply
December 29, 2019 05:23PM
Mine is filled with conditional formatting and links in addition to all of the basics. Even if I could post it, no one would know how to use it.

"I told myself to quit you; but I don't listen to drunks." -Chris Stapleton
Reply
December 29, 2019 05:25PM
Conditional formatting for what?

______________________________________________________________________
Seriously, nobody cares that you're offended.
Reply
December 29, 2019 06:54PM
Conditional formatting automatically lets me know (by changing the color of the font) when I have gone over reimbursement or when a payment is late.

The links put my MSC totals on a summary sheet that goes to Tax Dude.

"I told myself to quit you; but I don't listen to drunks." -Chris Stapleton


Edited 1 time(s). Last edit at 12/29/2019 06:55PM by HonnyBrown.
Reply
December 30, 2019 03:51PM
Honny, you need to do a seminar at one of the conferences and teach us how to do that. smiling smiley

Shopping domestic and international locations since 2003.
Reply
December 30, 2019 04:31PM
Or a Webinar/Youtube video!
Reply
December 30, 2019 04:31PM
LOL

Excel is a very powerful tool.

"I told myself to quit you; but I don't listen to drunks." -Chris Stapleton
Reply
Sorry, only registered users may post in this forum.

Click here to login