Shift Reconciliation Variance Report

1. Reaching the "Shift Reconciliation Variance Report"

To reach the "Shift Reconciliation Variance Report," follow the below steps:

1. Step 1: Log into Control Center
2. Step 2: Choose Point of Sale
3. Step 3: Choose Reports
4. Step 4: Choose Inventory Reports
5. Step 5: Choose Shift Reconciliation Variance 

See Figure 1.1. You will see many types of sales reports that will be useful to your retail business. By clicking the "Choose Report" drop-down selection, you will see the different types of sales reports.

Figure 1.1

You will see the "Report Data is Empty" message initially. You need to select the date range to check the summarized sales data in the report.

Figure 1.2

2. Generating the "Shift Reconciliation Variance Report"

When you navigate to the page, you will see the options pre-selected by default. You can generate the report for the selected date range.

Report Type:

1. All Within Date Range: Choosing this option will display the reconciliation report details within the selected date range.
   

See Figure 2.1.

Figure 2.1

Fields:

1. Store: This column will display the name of the location.
   
2. Employee: The name of the employee handling shift reconciliation at that time is mentioned in this column.
   
3. Register Number: This column displays the register number that was used in the transactions.
   
4. Reg Z Counter: This column gives the reg Z counter value, which is the Z number/shift number that is unique for that particular store and register number combination. All transactions that occurred on this shift will always be tied to that Z counter. It is an easy way to keep track of the employees and their accountability for sales. So, if there is any variance in cash during shift reconciliation, the shift person can be held responsible for that.
   
5. Date/Time: This column displays the date and time of shift reconciliation.
   
6. Type: This column describes the reconciliation type, such as Pay In, Pay Out, Cash, Store Coupon, Credit Card, Debit Card, etc.
   
7. Cashier: This column displays the cashier on duty who completed the shift reconciliation.
   
8. System: This column is for displaying system details. 
   
9. Over/Short: This column displays the variance that is over or short.

Fields:

The fields are almost the same as "All Within Date Range." See Figure 2.1.

3. Filter By Employee

This filter will display the shift reconciliation variance report as per the selected employee in the "Filter By Employee" field. See Figure 3.1.

1. Show All: Choosing this option will display the data related to all employees in the shift reconciliation variance report. See the second column in Figure 2.2.
   

1. Filter by Cashier: Choosing this option will display the data related to the selected employee in the shift reconciliation variance report. See the second column in Figure 3.1.
   

Figure 3.1

4. Date Range

You can filter your Shift Reconciliation Variance Report by selecting a date in the Date field.

Start Date:

Figure 4.1

End Date:

Figure 4.2

4.1 Presets

The Presets label is provided to select the specific standard duration/interval to generate the report.

Figure 4.1.1

5. Group By

Let's see how to check the shift reconciliation variance data by grouping it into locations or location groups.

1. By Locations: If you select "Location," the buydown sales data will be displayed in the grouping according to the locations (stores) individually. Once the location-specific report is generated, you can check the invoice summary separated as per the locations. See Figure 5.2.

Figure 5.2

Figure 5.3