Shift Reconciliation Variance Report

Shift Reconciliation Variance Report

Shift Reconciliation Variance Report

The Shift Reconciliation Variance Report will display the list of products showing variance after the completion of a shift reconciliation.
The system will display the products with variance, which took place only during a specifically entered date range. Multiple different types of filters can also be configured, depending on your requirements. The system will display the records of products with variance, only according to the selected filter options. The system will also display several other related fields, with detailed and automatically calculated information on the products with variance.

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 Report
See Figure A. 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 A

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 B

1. 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 item returns 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 C.


                                                                                                     Figure C
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 PayIN, PayOUT, Cash, Store Coupon, Credit Card, Debit Card, etc.
  7. Cashier: This column displays the cashier detail values displayed at the POS needed at 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.
Specific Register:  Choosing this option will display the report of the specific register or the selected register in the Register Number field as highlighted in Figure D below.

                                                                                              Figure D 
Fields:
The fields of the reports are almost the same as "All Within Date Range," except for the "register number," which is the same as selected.

2. 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 E.
  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 D.
  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 E.

                                                                                                         Figure E

3. Date Range:

You can filter your Shift Reconciliation Variance Report by selecting a date in the Date field.
Start Date:
                                                                                                   Figure F
End Date:

                                                                                                       Figure G
Presets:
The Presets label is provided to select the specific duration/interval to generate the reports with that.

                                                                                     Figure H

Group By:

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

                                                                                  Figure I

You will see a "Group By Location" drop-down from which you can select either "Location" or "Location Group" for grouping the invoice summary data. By default, "None" will be selected, which implies the report data will be displayed without any grouping.
  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 J.

                                                                                    Figure J
  1. By Location & Register Number: When you select "Location & Register Number," the data in the report is displayed according to the location group and register number. 
See Figure K.

                                                                                       Figure K

    • Related Articles

    • Shift Reconciliation

      Shift Reconciliation Point of Sale -> Reconciliation -> "Shift Reconciliation" About Reconciliation under FTx POS "Reconciliation" is the process of closing out a shift and recording the physical number (amount) of tenders on hand against the tender ...

    • Lottery Reconciliation Summary Report

      Lottery Reconciliation Summary Report The Lottery Reconciliation Summary Report lists lottery reconciliation details, listing the games with their starting/ending numbers and any variances for locations based on the filter and date range. 1. Reaching ...

    • Daily Reconciliation

      Daily Reconciliation Point of Sale -> Reconciliation -> "Daily Reconciliation." About Reconciliation under FTx POS "Reconciliation" is the process of closing out a shift and recording the physical number (amount) of tenders on hand against the tender ...

    • Lottery Reconciliation Settings

      Lottery Reconciliation Settings These setting options are account-level settings that will help you configure settings related to lottery reconciliation, options for employees, and how the system should function overall. Reaching "Lottery ...

    • Deposits Report

      Deposits Report Overview Reports -> Sales Reports -> "Deposits" There is always huge traffic in the store during weekends, holidays, or festivals. At that time, many customers paid the bill in cash for their purchases. So, the physical case in the ...