This report lists the variance of cash counted to expected cash collected based on the vending machine Cash Meters, and also the calculated quantity of products sold based on Fills and Ending Quantities.
The cash variance reported is dependant on how each Asset is configured to report variance:
- the internal DEX meters - Coins to Cash Box and Bills to Bill Stacker values ("DX")
- the machine Sales meter ("SM")
- no cash variance reported as no meter is available ("No")
These variance types are set in the Asset form for each asset in the field labeled "Report Cash Variance on :". Where the cash variance reconciliation is to be made to meters, the report will look back from the current collect to the last good meter reading for this Asset for the purposes of reporting metered values, and then sum all cash items for this range. The comparison will be made between these values and hence avoid meter "blow outs" where cash has been collect but the meters were not.
In the Cash Variance report form, chose the Region, Warehouse Route and date range to report on.
You also choose to report on Vending machine only, Bill Changers only or both.
Click Load to load report.
In the report viewer all the "Collect" Service cards that are within the selection criteria are listed. They are listed by Account, by Asset by Date Serviced, with subtotals on the Account.
Columns listed are:
Collect Service data
Service Card# - the Collect being reported
Date - the Date the Collect was serviced
Asset# - the Asset Number
Type - the Model Category of the Asset
Cash Values
These are the values that were entered against the Collect service in the Enter Service Cards or Enter Cash forms
- Coins - coin counted
- Bills - Bills counted
- Card Sales - cashless sales recorded by the machine and loaded against the Service
- Rfnd - Refunds that were given back to the Account for mis-vending
- Test Vends - value of vends that were made by the driver or technician at the machine where by they vended product using cash taken from the machine. These vends will have incremented the vending machines meters but are not real vends. This value should not be used if the machine has a "Test mode" whereby vends can be made without incrementing the meters.
- Comm - Cash commission paid to the account by the Driver at the time the machine is serviced
- C-C. This is the value of coin that was taken from the Coin Box and placed in the Coin Changer to replenish the coin tubes
- B-C. This was the value of bills taken from the Bill stacker and used to "buy" coin from a changer fund carried by the Driver
MT("Meter Type")
This the Cash reconciliation type that is maintained in the Asset form. It will one of three selections:
DX - reconcile cash to the meters "Bills to Stacker" and "Cons to Coin Box"
SM - reconcile to the Sales meter that may have been read manually from the machine or read in as part of the DEX report
No - there is no meters to reconcile to.
Exp Sales ("Expected Sales")
This is the value of sales based on the calculated sales of product through the machine from the last collect to this collect. VendSys is tracking machine inventory levels of each product and the Fills and Waste. By calculation it is determining what the calculated sales of product must have been These sales quantities are multiplied out by the vend prices to get Expected Sales
Non Rds ("Non-Reads")
The number of collects that did not have a meter read between this collect and the last collect that did have a meter reading.
Metered Values
Metered Sales - the difference in the reported or recorded Sales Meters
Coins to Box - the difference in the reported "Coins to Box" meters
Bills in - the difference in the reported "Bills to Stacker" meters
Variances
Cash +/- . Where the Asset reporting type is to Sales Meter (SM), this will be:
Coins + Bills + Card Sales + Rfnd + Test Vends + Comm + CC + BC - Metered Sales
Coins +/- . When the Asset Reporting type is DX, this will be:
Coins + CC - Coin to Box
Bills +/- . When the Asset reporting type is DX this will be:
Bills + BC - Bills In
Product +/- . This will be Expected Sales - Metered Sales
Note
This will indicate various detected conditions:
First Collect - no variances will be calculated
Missing meter - no variances will be calculated
Missing DEX - no variances will be calculated
Copyright © 2011 Synectic Software Solutions Inc.