Daily Reconciliation

Daily Reconciliation

Daily Reconciliation Overview 

In retail business, there are two types of reconciliation processes: 
  1. Shift Reconciliation: Each cashier, an employee of the store, performs this reconciliation at the end of their shift.
  2. Daily Reconciliation: The store's manager performs this reconciliation at the end of the day (or at the beginning of the next day).  
The Daily Reconciliation function in FTx Cloud POS refers to ensuring that the transactions recorded in the POS system match the actual financial activity for a given day. This is a critical practice for maintaining accurate financial records, preventing theft, and identifying errors. It can significantly help you to:    
  1. Ensure accurate financial records and identify discrepancies. Start by generating the end-of-day report, summarizing sales, payments (cash, card, and others), discounts, and taxes. Count the physical cash in the register and verify it against the POS cash sales report. Match card payments with the payment processor’s settlements and validate other payment methods.
  2. Identify discrepancies by investigating errors such as double charges or missing receipts. Confirm discounts and refunds are accurately applied and check transaction logs for unauthorized voids or unusual activity. Document any discrepancies and save reconciliation reports for audits.
Daily Reconciliation in FTx Cloud POS:  Once all cashiers perform and finalize the Shift Reconciliation, the store manager or admin will perform the Daily Reconciliation by adding all the shifts through POS. Once the Daily Reconciliation is performed from the POS and marked as "Reconcile Is Final," the corporate employee can audit the reconciliation from Control Center. 

This article includes information about:
  1. How the store manager can perform the 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 the Daily Reconciliation

The Daily Reconciliation process involves verifying all the shift reconciliations performed during the day, finding discrepancies between system totals and on-hand tenders, if any, and finalizing the Daily Reconciliation for the corporate employee to review. It involves the following steps: 
  1. All cashiers perform Shift Reconciliations for their respective shifts. 
  2. The manager generates Daily Reconciliation using "Add Daily Reconciliation." The manager can also use the "Register X" button on POS to generate the Daily Reconciliation. 
  3. The manager clicks "Edit Daily Reconciliation," opens the generated Daily Reconciliation, verifies all Shift Reconciliations, and finalizes the Daily Reconciliation. 
  4. The corporate employee can audit the daily reconciliation from Control Center. 
If you are authorized to perform a Daily Reconciliation, please follow the steps below to process the Daily Reconciliation:  
  1. Ensure all cashiers who worked during the day have performed Shift Reconciliation for their shifts and marked "Reconciliation Is Final."
  2. Click "Action."
  3. Click "Reconciliation."
  4. Click "Add Daily Reconciliation." The system will show a warning message, as Figure 2.1 shows. 

Figure 2.1
  1. If you choose "Include Today," the system will include today's shifts in the reconciliation process. If you click "Don't Include Today," it will include unreconciled from past days (in a real scenario, yesterday). This feature is for stores where the Daily Reconciliation is performed in the morning. Click the appropriate option. 
  2. The system will generate the Daily Reconciliation and show a Success message. 

Figure 2.2
  1. Click "Edit Daily Reconciliation.

Figure 2.3
  1. The Daily Reconciliation screen will appear, listing all Daily Reconciliations, as Figure 2.4 shows. Click on the reconciliation record you want to verify and click "Select.
    1. Click the "Only Show Past 7 Days" checkbox to view the records of only the past seven days. 

Figure 2.4
  1. The Daily Entry screen will appear, displaying the total of all cashiers' values, system values, and the difference between the cashiers' values and the system values, as Figure 2.5 shows. Check the values.

Figure 2.5
  1. Footer Buttons/Options:
    1. Show Cashier Values: This option lets you view the total of all cashiers' values, system values, and the difference between the cashiers' values and the system values. The system selects this option by default, when you click "Edit Reconciliation."
    2. Show Manager Values: This option lets the manager enter and then view the values. 
    3. Reconciliation Is Final: This checkbox lets you finalize the reconciliation.
    4. Refresh Sys: Use this button to refresh the system.
    5. Cancel: Use this button to cancel the Daily Reconciliation processing or the changes made at any point. 
    6. Verify Shifts: This button lets you verify the cashiers' shifts. 
    7. Print: This button lets you print the reconciliation data. This button will be functional when the reconciliation is finalized. 
    8. Save: This button lets you save the changes you have made at any point.
  1. Click the "Show Manager Values" option shown at the bottom. 
  2. Click "Verify Shifts." The Shift Reconciliation screen will appear, as Figure 2.6 shows. Select the shifts to verify and click "Verify Shifts.You can count the cash, perform other required calculations, and enter the values in the fields available in the Verified Amounts column.
    1. You must verify all shifts. Select the shifts one by one, verify them, and click the "Save" button for each shift.

Figure 2.6
  1. When all the shift reconciliations are verified, select "Reconciliation Is Final.Once all the values are verified, click the "Save" button to save the Daily Reconciliation. 
  2. Once you tick the Reconciliation Is Final checkbox and click the "Save" button, the system will activate the "Print" button, as Figure 2.7 shows. When you click the "Print" button, the system will show the Print dialog so you can print the document. 

Figure 2.7
  1. 1: Print: Click this icon to print the report using the attached printer.
  2. 2: Pages: Use these Next and Back icons to change the report's pages. 
  3. 3: View Options: You can use these options to change the report's layout in Page Mode, Two-Page Mode, and Scroll Mode or to zoom in and zoom out on the report pages. 

3. Control Center Side Information 

After the Daily Reconciliation is generated, it will sync with Control Center but will not be finalized.
  1. To complete the Daily Reconciliation from the POS, the manager must verify the sales values, tick the "Reconciliation Is Final" checkbox, and click the "Save" button. Once the manager finalizes the Daily Reconciliation, it will also be marked as finalized in Control Center.
  2. The corporate employee can view, print, reset, unlock, and audit the Daily Reconciliation from Control Center.  

 Figure 3.1

3.1 Required Control Center Settings 

POS functions based on the settings predefined in Control Center.   
The store manager, administrator, or other designated person may find the following articles helpful to understand more about the Shift Reconciliation settings:
  1. Lottery Reconciliation Settings

    • Related Articles

    • 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 ...
    • 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 ...