Close Day Reports
Setup
- For details on setting up customized reports – please see Volante Reports
Usage
Reports Run
- Close Day - Details
- Close Day - Summary
- Close Day: Forced Close Transactions Details from Auto close Day
- Sales Reports: Sales Report Summary
- Media Reports: Media Overview Summary
- Media Reports: Media Collected - Debit Card
- Sales Reports: Sales Report Listed by Employees
- Media Reports: Media Report Paid In / Paid Out Details Breakdown
- Void Reports: Void Detailed Listing - Total with Tax
- Media Reports: Item Discount Breakdown
- Media Reports: Bill Discount Breakdown
- Media Reports: Media Report Currency Breakdown
- Media Reports: Discounts as Payment Method Breakdown
- Media Reports: Discounts as Payment Method Details Breakdown
- Customer Database: Account Payment Summary Report
- Customer Database: Account Payment By Customer-Type Report
- Statistical Reports: Average Check
- Sales Reports: Sales Summary Grouped by Categories and Groups with Options (Setup with Advanced Options > Additional Options> Show Options as Separate Entry...)
- Audit: Cash Drawer Open Report
Close Day Details
The following is an example of a Close Day summary report (click to enlarge):
Further descriptors to assist in reading the report:
# | Close Day Details -- Report Details | ||
---|---|---|---|
1 | Field Name | How to calculate value? | Numbered guide |
1 | Current Reading (Z-Total) | Accumulated Gross Sales + Taxes (Daily Z + Previously Accumulated Z Total) | 3 + |
2 | Previous Reading | Accumulated Gross Sales + Taxes as posted in previous reading | |
Gross + Taxes (Z-Reading) | Daily Gross Sales + Taxes | Difference of 1 and 2 | |
3 | |||
4 | Net Sales | Completed Transaction before Voids, Removes and Discounts | |
5 | |||
6 | Manager Voids | Voids that were executed by Managers | |
7 | |||
8 | Cashier Voids | Voids that were executed by Cashiers | |
9 | Cashier Removes | Removes that were executed by Cashiers (Removing being items removed from an open transaction) This is an optional area on the report and dependent on the Close Day setup -- for more information please see Close Day - Setup | |
10 | Manual Voids (Discounts) | Item Discounts Given | |
11 | Item and Bill Discounts | Item and Bill Discounts (discount types accessed from POS) | |
12 | TAX | Applicable taxes for transaction. Covers all variations of site taxes (i.e. state specific taxes) | |
Media Listing | Media Payment Amounts Collected - Credit or Debit Cards, Cash, Gift or Loyalty Cards etc. | ||
13 | Cash | Transactions made with cash. | |
14 | On Account | Customer Database Accounts | |
15 | Payment Method Discount | Transactions made using Payment Method at POS. Includes PAU / Voucher transactions. | |
16 | Gift Card | Transactions made using Gift Cards. | |
17 | MASTER (MasterCard) | Transactions made on MasterCard. | |
18 | AMEX | Transactions made on AMEX cards. | |
19 | Discover | Transactions made on Discover cards. | |
20 | VISA | Transactions made on VISA cards. | |
21 | |||
22 | Load Gift Card | Transactions for gift card loads (adding funds). | |
23 | Cash from Sale | Total of cash made in transactions. | |
24 | + Paid Ins | Amounts paid in. | |
25 | - Paid Outs | Amounts paid out to staff or customers. | |
NET CASH | Total of cash in Transactions Cash from Sale + Paid Ins – Paid Outs | ||
26 | |||
27 | Transaction Count | Head Count per day | |
28 | Cash FX Variance | Foreign Currency variance. For example, collected $25 USD which amounted to $30 CDN and the variance would be reported here as $5. |
Close Day Summary
The following is an example of a close day summary report:
Further descriptors to assist in reading the report:
# | Close Day Summary -- Report Description | |
---|---|---|
1 | StoreName | Store Name -- setup during the install process |
2 | StoreId | Store ID -- setup during the install process |
3 | CloseOutDate | Day that is being closed |
4 | dttm | the date that the day (from previous column) was closed |
5 | AutoClose | 0 - Close Day function executed by ServerName |
6 | ServerName | Name of the individual whom executed this task. |
7 | Gross Sales | Net Sales + Discounts + Voids + Removes (if flag has been set) |
8 | Net Sales | Completed Transaction before Voids, Removes and Discounts |
9 | Z (Gross + Taxes) | Daily Gross Sales + Taxes |
10 | Z Total | Accumulated Gross Sales + Taxes (Daily Z + Previously Accumulated Z Total) In summary, the Z-Total is calculated by summarizing accumulated sales for a closed day. |
11 | Z Counter | A counter that goes up based on the number of closed terminals at a particular site. i.e. If there are 5 terminals at a site, and they close each day, the counter goes up by 5. |
Gross Sales on the close day report does not match Gross sales on the other reports: |
---|
This is caused by the Cashier Removes or Cashier Voids being used. If the HeadOffice is adding these numbers to the Gross Sales total on the Close Day Report, then this will inflate the gross Sales, whereas other reports do not include this number. You can add cashier Voids / Removes to the sales report by adding a column of. [Remove Amt] and or [Remove Qty] Removes are TransitemTypeID 17, and 18 for the options. |