Ok, please bear with me while I try to explain this.
I use Excel/Mystery Shopping Bible to track all of my shops, payments, reimbursements, mileage, etc. I performed a hotel shop on April 24, 2014. I charged the room charge to my credit card (per shop guidelines) which was promptly reversed on May 2, 2014. The shop fee of $30.00 and my cash food and bar expenses ($38.80) are later paid by check.
I have already documented the reversed hotel cc charge in Excel on May 2 leaving a balance owed to me of $68.80. I received the check over the weekend but now I am trying to update it in Excel and for some reason the figures are not zeroing out in Excel. It is only accepting $8.80 for some reason.
I put the shop fee of $30.00 in the shop fee column and I combined the room charge ($154.29 reversed on my cc) and the cash outlay ($38.80 in cash) and put that in the reimbursement column. I am not an Excel expert or a math wizard so for the life of me, I can not figure out what the problem is. I have already wasted a lot of time on this. Does anyone know how to fix this issue?
You PM me if you do not want to respond here.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
“I'm the one that's got to die when it's time for me to die, so let me live my life the way I want to.”
~ Jimi Hendrix
“The fear of death follows from the fear of life. A man who lives fully is prepared to die at any time.” ~ Mark Twain
“To the well-organized mind, death is but the next great adventure.” ~ J.K. Rowling, Harry Potter and the Sorcerer's Stone