jagomart
digital resources
picture1_Spreadsheet For Bills 41097 | Daily Cash Reconciliation Worksheet


 215x       Filetype XLSX       File size 0.07 MB       Source: buyers.mbsbooks.com


File: Spreadsheet For Bills 41097 | Daily Cash Reconciliation Worksheet
sheet 1 print for handentry daily cash reconciliation worksheet buyback money bundles quot quick count quot always doublecheck the count this form for handentry only for digital form select the ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Print for Hand-Entry
DAILY CASH RECONCILIATION WORKSHEET BUYBACK MONEY BUNDLES: "QUICK COUNT"































ALWAYS DOUBLE-CHECK THE COUNT!
This form for hand-entry only; for digital form, select the second tab below. BUYBACK LOCATION






BUYBACK #

Bills Small Bundle or "Clip" Large Bundle or "Strap" (always 100 bills) Poly Bag or "Brick" (from bank)
CUSTOMER

Denomination # of Bills Amount # of Small Bundles Amount # of Large Bundles Amount

















$ 50.00 20 $ 1,000.00 5 $ 5,000.00 10 $ 50,000.00
TOTAL BOOKS PURCHASED FILL-IN DATE FILL-IN DATE FILL-IN DATE FILL-IN DATE FILL-IN DATE TOTALS $ 20.00 25 $ 500.00 4 $ 2,000.00 10 $ 20,000.00
A. Retail purchases





$ 10.00 25 $ 250.00 4 $ 1,000.00 10 $ 10,000.00
B. Wholesale purchases





$ 5.00 20 $ 100.00 5 $ 500.00 10 $ 5,000.00
C. Total purchases [ A + B ]





$ 1.00 25 $ 25.00 4 $ 100.00 10 $ 1,000.00












Coins

Roll Box

TOTAL CASH SPENT




TOTALS Denomination

# of Coins Amount # of Rolls Amount
D. Beginning cash [ J, from below]




Quarter ($0.25) - - 40 $ 10.00 50 $ 500.00
E. Cash addtions (if any)












F. Remaining cash [ K, from below ]












G. Total Spent [ D + E - F ]




























































CASH LONG/SHORT




TOTALS






H. Today's long/short [ G - C ]
















I. Long/short to date [ H1 + H2 + … ]






















Recheck any long/short difference greater than $100 and initial to verify


















































REMAINING CASH WORKSHEET SUGGESTED STANDARD DENOMINATIONS







































DAY 1 STARTING CASH DENOM.




TOTALS

NOTE: This is the new standard denomination breakdown that will appear on the remittance of checks*; if a rep needs a different breakdown for a specific buy, they must list it in the money notes on the setup. (*For US buys only, there is no standard for Canadian buys.)


ALWAYS CONFIRM CASH FROM BANK!
$100's











$50's











$20's











$10's











$5's











$1's







$ 20.00 75.0%



Quarters







$ 10.00 15.0%

J. TOTAL













$ 5.00 6.0%

K. DAILY TOTAL CASH REMAINING







$ 1.00 3.5%










































$ 0.25 0.5%






















(Up to a maximum of $1,000.00 in Quarters)










Buyer's Initials Buyer's Initials Buyer's Initials Buyer's Initials Buyer's Initials














































Date Date Date Date Date
























































































































































The words contained in this file might help you see if this file matches what you are looking for:

...Sheet print for handentry daily cash reconciliation worksheet buyback money bundles quot quick count always doublecheck the this form only digital select second tab below location bills small bundle or clip large strap poly bag brick from bank customer denomination of amount total books purchased fillin date totals a retail purchases b wholesale c coins roll box spent rolls d beginning quarter e addtions if any f remaining g longshort h today s i to recheck difference greater than and initial verify suggested standard denominations day starting denom note is new breakdown that will appear on remittance checks rep needs different specific buy they must list it in notes setup us buys there no canadian confirm quarters j k up maximum buyer initials...

no reviews yet
Please Login to review.