We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Mystery Shopping thread - VII
Comments
-
She is - mentally!0
-
the latest phone job states that a photo must be taken, but you can't use a mobile phone to do it - how can you tell what a photo was taken with???
You CAN tell what device a photo was taken with as it is hard-coded into the properties of the image file (known as the exif data).
My phone even has Geo-tagging on it, so my photos are hard-coded with the lattitude and logitude of where the images were taken. I sure hope RE email me someday to dispute a photo of a branch, saying it's the wrong location, I really hope this happens, just so I can prove to them that their MSers aren't liars, as they seem to think all too often it seems...
EDIT: I see nads beat me to it!0 -
Right, I'm thinking about making a spreadsheet that we can all use to log our jobs, if you want to! To helpw ith tax etc.
What information should be in it?
So far my list is:
Date Job Completed
MS Company
Client
Job Ref #
Required Purchase Amount
Actual Purchase Amount
Reimbursement
Fee
Milage
Costs incurred on visit (e.g car parking)
Number of sheets printed
Date Payment Due
Payment Received?
Profit/Loss (+/-)
Anything I'm missing? I'll edit this list with people's suggestions.0 -
I've got a column of date paid, too. Also, profit per job, so I know where I ought to be driving further or printing more off0
-
What about actual expenditure as well...?
Parking costs?0 -
I used to have a seperate spread sheet for every compnay primarily because TNS used to pay you as an employee but not they pay you as a contractor which makes it easier, strangely! But you have to adjust what each companyc alles a fee etc to fit into the headings
So I have one sheet for all my work with the following headings -
Date
MS Company
Client
Location
Job Ref
Spend Limit
Job Price
ActualPayment
Pay Date
Mileage
I also have one sheet with a mileage ready reckoner which I sat and made up one evening with all my local jobs so I fill the miles out as I go along. At the bottom of the spreadhseet I have a little table with this
Miles at 40p
Miles at 26p
Job Fees
Job Spends
Total Mileage
Income
Expenses
Profit
So all I need to do at the end of the tax year is add in my expenses such as Flights, Broadband etc and it takes under 30 minutes to get the figures sorted as they auto fill - I never claim for sheets of paper but you could add a column in for that too.0 -
I used to have a seperate spread sheet for every compnay primarily because TNS used to pay you as an employee but not they pay you as a contractor which makes it easier, strangely! But you have to adjust what each companyc alles a fee etc to fit into the headings
So I have one sheet for all my work with the following headings -
Date
MS Company
Client
Location
Job Ref
Spend Limit
Job Price
ActualPayment
Pay Date
Mileage
I also have one sheet with a mileage ready reckoner which I sat and made up one evening with all my local jobs so I fill the miles out as I go along. At the bottom of the spreadhseet I have a little table with this
Miles at 40p
Miles at 26p
Job Fees
Job Spends
Total Mileage
Income
Expenses
Profit
So all I need to do at the end of the tax year is add in my expenses such as Flights, Broadband etc and it takes under 30 minutes to get the figures sorted as they auto fill - I never claim for sheets of paper but you could add a column in for that too.
Well I'm hoping to put together something that is all-signing, all-dancing based on another spreadsheet that I use for something else.
Why do you have too different rates for mileage? And why would you be claiming flights as expenses?!?!0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 351.3K Banking & Borrowing
- 253.2K Reduce Debt & Boost Income
- 453.8K Spending & Discounts
- 244.3K Work, Benefits & Business
- 599.5K Mortgages, Homes & Bills
- 177.1K Life & Family
- 257.8K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.6K Read-Only Boards