Difference between revisions of "User:RfS/Cashiering Issues"

From FreekiWiki
Jump to navigation Jump to search
 
(24 intermediate revisions by the same user not shown)
Line 1: Line 1:
<graphviz>
+
== Counting issues ==
  digraph  {
+
# Store miscounted nickels by one and was actually over 5 cents. NBD.
    node [fontname="Helvetica", fontsize="11"]
+
# count on dimes off by 1
    edge [fontname="Helvetica"]
+
# mis-counted pennies
 +
# mis-counted nickels
  
    store          [label="Thrift Store", shape="box", fontsize="11", style="bold"]
+
== Missing paperwork issues ==
    frontdesk      [label="Front Desk", shape="box", fontsize="11", style="bold"]
+
# front desk did not produce an income report (but the store one worked fine)
    mail            [label="Mail", shape="box", fontsize="11", style="bold"]
+
# one credit card slip from the front desk was not printed out. these can be printed after the fact (even though that wouldn't have a signature on it).
    paypal          [label="PayPal", shape="box", fontsize="11", style="bold"]
+
#* Yes, the credit card jammed when printing receipt #4, Michael fixed it and receipt #5 IS the reprint of #4.  It is noted on the receipt.
    other          [label="Other", shape="box", fontsize="11", style="bold"]
+
#** I believe this is a mistake. On the credit card report #4 is for $5.00 and #5 is for $10.00.
 +
#** It looks like:
 +
#** #4 = 116718
 +
#** #5 = 116722
 +
#** When you re-print a credit card receipt, it uses the same number and says "DUPLICATE" on it. So we are still missing receipt #4. (I don't think this can be retrieved the next day either.)
 +
# The credit card slip #24 from store is missing ($35)
 +
# 3/26 -- Neither the store nor the front desk included an income report from the database.
 +
# multiple missing credit card receipts = #1, #12, & #13.
 +
# missing credit card receipt #13 for $40.00
 +
# credit card report not in till
  
    till            [label="Till", shape="box", fontsize="11", style="bold"]
+
== Incomplete information on paperwork issues ==
    safe            [label="Safe", shape="box", fontsize="11", style="bold"]
+
# several mileage related reimbursement forms were submitted without any kind of receipt. we should settle how these should get handled. i think we need a simple form drivers can fill out to report mileage. i think auditors would tell us this as well, but maybe it requires a little research?
    bank            [label="Bank", shape="box", fontsize="11", style="bold"]
+
#* Ali is creating a form we will stock at the desk.  Jacob now knows all reimbursement forms must be accompanied by a receipt.
    bills          [label="Bills", shape="box", fontsize="11", style="bold"]
+
# The store was missing a single credit card receipt for $6.
    payroll        [label="Payroll", shape="box", fontsize="11", style="bold"]
+
# The front desk was short by $50.  There were two receipts in the till, totalling $50.  Were these supposed to be invoices?  If they were invoices and wrongly coded in the database that would correct the shortfall.  If they were invoices, there was no indication of that on the copies and no indication of whether we needed to send (or had sent) a copy of the invoice through the mail.  This is all very confusing.  I asked Jacob if he knew anything about it and he did not. 
 +
# They forgot to record the date on the end of shift form. Short 50 cents.
 +
# front desk had a $20 receipt for "pick up" (dave) but no receipt.
 +
# front desk had a $20 receipt for "delivery - dave" but no receipt.
 +
# We should find out how much $$ accumulates in the cup, I guess. I noticed a few dollars in there this morning.
 +
# Front desk was $8 over as reported. Only issue was an unstamped check.
 +
# no name or date on till-worksheet
 +
# 3 checks not stamped
 +
# forgot TS# on one credit receipt
 +
# forgot to stamp one check
 +
# forgot to itemize money receipts and reimbursements
 +
# morning count not signed (was it counted?)
 +
# there was one check, unstamped and with no TS number on it
 +
# credit card amount left off of beancounting worksheet
 +
# mileage note not listed on beancounters worksheet
 +
# morning count not signed (was it counted?)
 +
# two checks unstamped
 +
# credit card receipt #9 missing, #10 is a void of #9.
  
    store -> till
+
== Confusing information on paperwork issues ==
    frontdesk -> till
+
# The store wrote down the wrong number of ones, but somehow got the right total.
    till -> bookkeeper
+
# 3/27 -- store didn't fill in the total real from db spot, but otherwise fine.
    mail -> bookkeeper
+
# 3/28 -- store recorded wrong date and didn't fill in the total real from db spot, but otherwise fine.
    paypal -> bookkeeper
+
# credit receipt #117342 = credit for $12 on credit card machine entered as $10 in database, MKW changed to $12 in database, so there is now a $2 shortage in the till total for the night.
    other -> bookkeeper
+
# still plugging number into "money receipt" and not doing math correctly.  Talked to her about this last night and created cheat sheet for her, color coded, showing which number go where in either till worksheet.
    bookkeeper -> safe -> bank
+
# $57.93 overage! The note says "$57.93 over was from cup money that didn't "create".
    bank -> bills
+
# $7.25 in reimbursements was reported in money receipts, making a $14.50 error. We were not $14.49 short as reported, but $0.01 over.
    bank -> payroll
+
# $0.15 found at register when hunting for credit card report
 +
# beancounting worksheet signed by Luiz, but income report printed by Jessica. (wrong person was probably logged into the system. luiz was scheduled to close. jessica would've likely left at 6:30 pm.)
 +
# wrong total used on beancounting worksheet
 +
# $2.15 over. (closer had calculated $2.00 plus $0.15 from the found coins)
 +
# included reimbursement? receipt from Parr lumber for 9.00 or 13.99? No reimbursement slip filled out.
 +
# mis-entered total real from database on beancounting worksheet (wrote 1037.25, should have wrote 1307.25 -- off by 270.
 +
# can't figure out how far off the till was due to reimbursement issue, but it is somewhere under $34
 +
# probable duplicate not removed from db
 +
# unexplained note. says "97214, 1 key 3, 1 mouse 5, 1 dup 8" ???
 +
# till worksheet incorrect:
 +
#* put credit/debit total into "money receipts" resulting in incorrect shortage of $781.87 on automated till worksheet
 +
#* "unfound credit receipt of $19.50" noted on handwritten worksheet, I did not find this to be true
 +
#* credit of $26.50 #217778 in database does not exist in credit machine report, and till was exactly $26.50 short.  Credit would have had to occur between sales receipt #3 & #4 on credit machine, so logically seemed to be duplicate of #217775 and deleted record #217778
  
</graphviz>
+
== Scheduling issues ==
 +
# i counted the till i closed last night
 +
 
 +
== Other issues ==
 +
# the store credit card machine really needs a new ink cartridge in it. our copies are unreadable.
 +
#* Luiz had one hidden and MK submitted a supply request to Liane for more.
 +
#** Kathie thinks the ones we had were tossed out. When we get more, we should mark the box as FREE GEEK CREDIT CARD MACHINES or some such.
 +
#** Luiz later said he thought they'd sold them in the store, not knowing they were infrastructure
 +
# The ink in the store machine is still out and still needs replacing in spite of reports that that was taken care of.
 +
# First off, the ink in the store credit card machine is completely used up and must be replaced.
 +
 
 +
== Notes, suggestions, ways forward ==
 +
So until then, we ask the store cashiers to empty the cup often during the day, recording misc transactions in the database. We also ask them to empty it before they count the till at the end of the day.
 +
 
 +
If we still find ourselves with change, this is what we should do (as beancounters):
 +
 
 +
Each morning, before opening, grab the cup and put the money in the store till from the night before. If we do this, the till will typically be over when it's counted, so we'll correct the paperwork from the night before (since the money will no longer match), and we will register the overage in the books.
 +
 
 +
I just did this with last night's cup ($13.26). When I put the cup back (just now) there was a new coffee stained mug in place with a quarter in it.

Latest revision as of 18:38, 26 April 2008

Counting issues

  1. Store miscounted nickels by one and was actually over 5 cents. NBD.
  2. count on dimes off by 1
  3. mis-counted pennies
  4. mis-counted nickels

Missing paperwork issues

  1. front desk did not produce an income report (but the store one worked fine)
  2. one credit card slip from the front desk was not printed out. these can be printed after the fact (even though that wouldn't have a signature on it).
    • Yes, the credit card jammed when printing receipt #4, Michael fixed it and receipt #5 IS the reprint of #4. It is noted on the receipt.
      • I believe this is a mistake. On the credit card report #4 is for $5.00 and #5 is for $10.00.
      • It looks like:
      • #4 = 116718
      • #5 = 116722
      • When you re-print a credit card receipt, it uses the same number and says "DUPLICATE" on it. So we are still missing receipt #4. (I don't think this can be retrieved the next day either.)
  3. The credit card slip #24 from store is missing ($35)
  4. 3/26 -- Neither the store nor the front desk included an income report from the database.
  5. multiple missing credit card receipts = #1, #12, & #13.
  6. missing credit card receipt #13 for $40.00
  7. credit card report not in till

Incomplete information on paperwork issues

  1. several mileage related reimbursement forms were submitted without any kind of receipt. we should settle how these should get handled. i think we need a simple form drivers can fill out to report mileage. i think auditors would tell us this as well, but maybe it requires a little research?
    • Ali is creating a form we will stock at the desk. Jacob now knows all reimbursement forms must be accompanied by a receipt.
  2. The store was missing a single credit card receipt for $6.
  3. The front desk was short by $50. There were two receipts in the till, totalling $50. Were these supposed to be invoices? If they were invoices and wrongly coded in the database that would correct the shortfall. If they were invoices, there was no indication of that on the copies and no indication of whether we needed to send (or had sent) a copy of the invoice through the mail. This is all very confusing. I asked Jacob if he knew anything about it and he did not.
  4. They forgot to record the date on the end of shift form. Short 50 cents.
  5. front desk had a $20 receipt for "pick up" (dave) but no receipt.
  6. front desk had a $20 receipt for "delivery - dave" but no receipt.
  7. We should find out how much $$ accumulates in the cup, I guess. I noticed a few dollars in there this morning.
  8. Front desk was $8 over as reported. Only issue was an unstamped check.
  9. no name or date on till-worksheet
  10. 3 checks not stamped
  11. forgot TS# on one credit receipt
  12. forgot to stamp one check
  13. forgot to itemize money receipts and reimbursements
  14. morning count not signed (was it counted?)
  15. there was one check, unstamped and with no TS number on it
  16. credit card amount left off of beancounting worksheet
  17. mileage note not listed on beancounters worksheet
  18. morning count not signed (was it counted?)
  19. two checks unstamped
  20. credit card receipt #9 missing, #10 is a void of #9.

Confusing information on paperwork issues

  1. The store wrote down the wrong number of ones, but somehow got the right total.
  2. 3/27 -- store didn't fill in the total real from db spot, but otherwise fine.
  3. 3/28 -- store recorded wrong date and didn't fill in the total real from db spot, but otherwise fine.
  4. credit receipt #117342 = credit for $12 on credit card machine entered as $10 in database, MKW changed to $12 in database, so there is now a $2 shortage in the till total for the night.
  5. still plugging number into "money receipt" and not doing math correctly. Talked to her about this last night and created cheat sheet for her, color coded, showing which number go where in either till worksheet.
  6. $57.93 overage! The note says "$57.93 over was from cup money that didn't "create".
  7. $7.25 in reimbursements was reported in money receipts, making a $14.50 error. We were not $14.49 short as reported, but $0.01 over.
  8. $0.15 found at register when hunting for credit card report
  9. beancounting worksheet signed by Luiz, but income report printed by Jessica. (wrong person was probably logged into the system. luiz was scheduled to close. jessica would've likely left at 6:30 pm.)
  10. wrong total used on beancounting worksheet
  11. $2.15 over. (closer had calculated $2.00 plus $0.15 from the found coins)
  12. included reimbursement? receipt from Parr lumber for 9.00 or 13.99? No reimbursement slip filled out.
  13. mis-entered total real from database on beancounting worksheet (wrote 1037.25, should have wrote 1307.25 -- off by 270.
  14. can't figure out how far off the till was due to reimbursement issue, but it is somewhere under $34
  15. probable duplicate not removed from db
  16. unexplained note. says "97214, 1 key 3, 1 mouse 5, 1 dup 8" ???
  17. till worksheet incorrect:
    • put credit/debit total into "money receipts" resulting in incorrect shortage of $781.87 on automated till worksheet
    • "unfound credit receipt of $19.50" noted on handwritten worksheet, I did not find this to be true
    • credit of $26.50 #217778 in database does not exist in credit machine report, and till was exactly $26.50 short. Credit would have had to occur between sales receipt #3 & #4 on credit machine, so logically seemed to be duplicate of #217775 and deleted record #217778

Scheduling issues

  1. i counted the till i closed last night

Other issues

  1. the store credit card machine really needs a new ink cartridge in it. our copies are unreadable.
    • Luiz had one hidden and MK submitted a supply request to Liane for more.
      • Kathie thinks the ones we had were tossed out. When we get more, we should mark the box as FREE GEEK CREDIT CARD MACHINES or some such.
      • Luiz later said he thought they'd sold them in the store, not knowing they were infrastructure
  2. The ink in the store machine is still out and still needs replacing in spite of reports that that was taken care of.
  3. First off, the ink in the store credit card machine is completely used up and must be replaced.

Notes, suggestions, ways forward

So until then, we ask the store cashiers to empty the cup often during the day, recording misc transactions in the database. We also ask them to empty it before they count the till at the end of the day.

If we still find ourselves with change, this is what we should do (as beancounters):

Each morning, before opening, grab the cup and put the money in the store till from the night before. If we do this, the till will typically be over when it's counted, so we'll correct the paperwork from the night before (since the money will no longer match), and we will register the overage in the books.

I just did this with last night's cup ($13.26). When I put the cup back (just now) there was a new coffee stained mug in place with a quarter in it.