Daily Reconciliation

Daily Reconciliation

Daily Reconciliation Overview

Reconciliation is the process of closing out a shift and recording the physical number (amount) of tenders on hand against the tender amounts recorded by the system. This allows for tracking of any discrepancies between system totals and on-hand tenders. Reconciliation takes place in two phases:
  1. Shift Reconciliation: Shift reconciliation compares the cash, card, and other payment types received during a shift to the sales records in the POS system to identify and resolve discrepancies. Each cashier, an employee of the store, performs this reconciliation at the end of their shift.
  2. Daily Reconciliation: The store manager performs daily reconciliation at the end of the day (or at the beginning of the next day) and verifies all shift reconciliations (Register Zs) performed during the day. 
Daily Reconciliation in FTx Cloud POS: After the cashiers complete and finalize the Shift Reconciliation, the store manager or administrator will carry out the daily reconciliation by consolidating all the shifts via the POS system. The Daily Reconciliation is then performed on the POS and marked as "Reconcile Is Final." 

This article includes information about:
  1. How to perform daily reconciliation. 

1. Reaching "Daily Reconciliation"  

  1. Step 1: Log into POS
  2. Step 2: Choose Action

Figure 1.1
  1. Step 3: Choose Reconciliation 

Figure 1.2
  1. Step 4: Choose Add Daily Reconciliation

Figure 1.3

2. Performing Daily Reconciliation from POS

Performing shift reconciliation includes two steps: 
  1. Step 1: Generating "Daily Reconciliation":
    1. Clicking the "Add Daily Reconciliation." (The system will generate the daily reconciliation data in the background.)
  1. Step 2: Performing daily reconciliation: 
    1. Clicking "Edit Daily Reconciliation" to open the daily reconciliation data.
    2. Verifying the shift reconciliation and $ amount values 
    3. Finalizing the reconciliation. 

If you are the store manager or administrator, please follow the steps below to perform daily reconciliation:
  1. Ensure that all shift reconciliations are performed. 
  2. Click "Add Daily Reconciliation."  (The system will generate the daily reconciliation data in the background.)
  3. Click "Edit Daily Reconciliation." The Recon | Daily Reconciliation screen will appear, as Figure 2.1 shows. Please refer to the figure below and descriptions of the buttons and fields to understand the layout of "Daily Reconciliation." 

Figure 2.1
  1. Table and Column Titles: The table shows daily reconciliation records. Each column title indicates the type of information in the column.
  2. Footer: 
    1. Delete: Use this button to refresh the screen when you change the date or tick or untick the Include Unreconciled checkbox. 
    2. Cancel: Use this button to the Recon | Daily Reconciliation screen. 
    3. Select: Use this button to select the shift you want to verify. You must click on the desired shift and then click this button to select the shift. 
  1. Click on a daily reconciliation record to select it and click the "Select" button.
  2. The manager can verify and check the cashier values as per all the shifts.

Figure 1.2
-> When the manager clicks the "Show Manager Values" radio button, the manager will not get any data unless the shift has been verified.

Figure 1.3

-> The manager needs to verify all the shifts by clicking the "Verify Shifts" button.
-> By clicking the "Verify Shifts" button, a "Shift Reconciliation" pop-up will appear with a listing of the shift reconciliations for the day. The manager can select a shift and verify it.

Figure 1.4

-> When all the shift reconciliations are verified, the manager needs to select "Reconciliation Is Final.
-> Once all the values are verified, Save the daily reconciliation.

Figure 1.5

2. Reaching the Daily Reconciliation

To reach the "Daily Reconciliation" module, follow the steps below: 
  1. Step 1: Log into Control Center
  2. Step 2: Choose Point of Sale
  3. Step 3: Choose Reconciliation
  4. Step 4: Choose Daily Reconciliation
By clicking the "Reconciliation" menu, you can see "Shift Reconciliation" by default. Click "Daily Reconciliation.

Figure 2.1

When the manager has added "Daily Reconciliation," that daily recon record will be synced into Control Center.

Figure 2.2

You can see the following data for the daily reconciliation in the tabular format:
- Recon Date: It displays when the daily reconciliation was performed by the cashier.
- Employee: It displays the name of the employee who performed the daily recon on the POS.
- Employee #: It displays the employee number of the person who performed the daily recon on the POS.
- Location: It displays the name of the store (location) where the daily recon was performed.
- Finalized: As per the highlighted record above (Figure 2.2), daily recon has been verified and finalized from the POS, but it is pending to be audited.
- Audit: Once the daily recon is audited from the control center side, a completed icon will appear.
- Variance Amount: It displayed the difference in the $ amount of the system vs. the $ amount in the cash drawer, if any.
- Cashier: It displays the cashier's amount in the daily reconciliation.  
- System: It displays the system's amount in the daily reconciliation.   
- Manager: It displays the manager's cashier amount in the daily reconciliation. 
- Actions: View | Remove | Print | Audit Recon | Unfinalized
Notes
Note: Once the store manager finalizes the daily reconciliation from the POS, only then will two additional actions appear. ("Audit Recon" and "Unfinalized")
Filter Date Range: You can also get the daily reconciliation information by filtering the date range.

2.1 View Daily Reconciliation

Click the View icon to check the reconciliation data for the specific shift.

Figure 2.1.1

By clicking the View icon, you will be redirected to the View Daily Reconciliation page. Here, you can see the cashier and system values and any differences. 

 Figure 2.1.2

If you click "Z#," a pop-up screen will open showing two options, as Figure 2.1.3 shows. 

 Figure 2.1.3
  1. Click "View Shift Recon" to open the respective shift reconciliation. 
  2. Click "Print Shift Recon" to print the respective shift reconciliation. 

2.2 Remove Reconciliation


Figure 2.2.1

2.3 Print Daily Reconciliation

Download and print the recorded details of the specific shift reconciliation by clicking the PDF icon. By clicking that icon, a PDF will be downloaded, and you can print it out for your reference.

2.4 Audit

When the store manager has verified the shifts and finalized the Daily Reconciliation from the POS, you can see the "Finalized" column as a green tick mark, but the auditing from the Control Center side is still pending.
Click the Audit icon from the listing or click the "Audit Daily Reconciliation" button from the View Daily Reconciliation page.


Figure 2.4.1

Now, by clicking "Audit Daily Reconciliation," a Daily Reconciliation Audit screen will appear. You can scroll down to view all the details. 


Figure 2.4.3

1: Show Details: You can choose to view Manager Details or System Details using this toggle button.
  1. If you choose "Manager" on the toggle, you will see the manager's details, as Figure 2.4.3 shows.   
  2. If you choose "System" on the toggle, you will see the system's details, as Figure 2.4.4 shows. 

Figure 2.4.4
2: Audit Finalized: If all the values are corrected and proper, tick the "Audit Finalized" checkbox and click the "Save" button to save the finalized audit.

2.5 Unfinalized

If the store manager has finalized the daily shift but you find some amount $ values are mismatched or miscalculated, you can unfinalize the daily reconciliation using "Unfinalize Daily Reconciliation.

 Figure 2.5.1

By clicking "Unfinalized Daily Recon" from the listing or from the view daily reconciliation page, a pop-up will appear to confirm the unfinalization of the daily reconciliation.


Figure 2.5.2

If you click the "Yes" button, a store manager needs to re-verify the cashier and manager values. Once the values are updated, the store manager needs to finalize the daily recon.

    • Related Articles

    • Daily Reconciliation

      Daily Reconciliation Overview In retail business, there are two types of reconciliation processes: Shift Reconciliation: Each cashier, an employee of the store, performs this reconciliation at the end of their shift. Daily Reconciliation: The store's ...
    • 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 ...
    • Shift Reconciliation

      Shift Reconciliation Overview Reconciliation is the process of closing out a shift and recording the physical tender amounts on hand against the tender amounts recorded by the system. This allows for tracking of any discrepancies between system ...
    • Unaudited Daily Reconciliations Report

      Unaudited Daily Reconciliations Report The "Unaudited Daily Reconciliations Report" displays the daily reconciliation data that has gone unaudited (not checked for any discrepancy by the corporate user) within the selected date range. The report ...
    • Daily Sales Report

      Daily Sales Report Overview Various types of sales reports provide the most critical statistics for running a business efficiently. A daily sales report summarizes all sales made during the day at a company. FTx Cloud POS includes the "Daily Sales ...