Negative Cashier Report
Reports -> Sales Reports -> "Negative Cashier"
Once the customers are done picking out the products that they want to buy in the retail store/shop/mall, they need to reach the counter to check out all the products and make the payment for their purchase. Many times, it happens that the customer wants to remove a product from the purchase list because of a shortage of cash or changes his/her mind and asks to remove the product that he/she would not buy. So, the cashier needs to remove that product from the list and take that physical product out. Now, the total amount will be reduced, and the customer will be able to complete the payment.
In another case, the customer changes his/her mind and asks to cancel the entire purchase. The cashier needs to clear the scanned products by performing a couple of actions from the POS.
In the first case, canceling (voiding) a product from the purchase while in the second case, canceling the entire purchase. Both cases will be noted as “Negative Transactions” in the FTx POS System. FTx Cloud POS provides a detailed "Negative Cashier" report that provides the data for the void sales, cancel sales or return of the items that occurred at POS by the cashier.
> What are Negative Transactions?
When the cashiers perform the following actions at POS during a customer's checkout, that's called Negative Transactions:
Void Item/Sales | Cancel Sales | Return Item | No Sales
If any conspiracy occurs such as item theft or cash in the pocket by the cashier during the sales transaction, this report will be helpful to track the transactions.
In this technical document, you will see:
- How to check the negative sales report for the specific cashiers and using the 'custom filter' option
- Different filter options i.e., store-wise, for the specific Reg Z, and many other bifurcate options
- How to check receipt details in which the negative transaction occurred
1. Reaching the Negative Cashier Report
To reach the Negative Cashier Report, follow the below steps:
- Step 1: Log into Control Center
- Step 2: Choose Point of Sale
Figure 1.1
- Step 3: Choose Reports
- Step 4: Choose Sales Reports
Figure 1.2
- Step 5: Choose the Negative Cashier
By clicking "Negative Cashier," you will be redirected to the "Negative Cashier Report" page with relevant filter options.
Figure 1.4
By selecting the “Negative Cashier” report type, the users can see the custom filter and bifurcation (checkbox) options. You will see the "Report data is empty..." message initially.
2. Generating Negative Sales Report
When you navigate to the "Negative Cashier Report" page, you will get some of the options pre-selected by default. By clicking the "Generate Report" button, the report data will display the negative transactions that occurred at the POS by the cashier as per the selection of the date range and filter options.
Figure 2.2
After generating the report, you will see the negative sales transactions data in the report for the selected store where the cashiers were working.
1. Total negative transactions by the cashier:
You can see the summary details on the top (as title) that displays overall negative transaction details for the specific cashier as per the selection of the store. You can see the number of total negative transactions along with the $ amount value individually.
Figure 2.3
2. Receipt-wise negative transactions
You will see the receipt-wise negative transaction details in tabular format. You can see the Register Number, Reg. Z No., and period on the header.
The following transaction details can be seen in tabular format:
- Item Name: An item on which the cashier has performed a negative transaction as customer asked to void/cancel/return.
- Quantity: Number of quantities that was voided/cancelled/returned.
- Total Retail: Total retail amount as per the retail price of the item and multiply with quantity.
- Transaction Type: A type of the negative transaction whether an item was voided/cancelled/returned at the POS during checkout.
- Reason: If a cashier added a reason for performing the negative transaction, it can be seen here.
By scrolling down, you can see the negative transaction data in the report for all the cashiers who work for the selected store.
Figure 2.4
3. Report Filter Options
Now, let's see how to set up the report filter options to generate the negative cashier report with specific data.
3.1 Filter By Cashier
You can check the negative transaction data in the report for the specific cashier.
Figure 3.1.1
By clicking the "Filter By Cashiers", a popup will appear with the list of the cashier.
1. You can select more than one cashier by ticking the checkbox of the cashier's name. You can also search for the cashier's name.
2. You must click on the green arrow icon to move the selected cashier(s) under the "Selected List".
Figure 3.1.2
3. You can remove any selected cashier name by clicking the 'remove' icon or remove all the selected cashiers from the list by clicking the "Clear Selection" button.
4. Once the cashier(s) selection is done, click the "Apply" button to get the negative sales transaction for the selected cashier(s).
After selecting the cashier(s) from the filter list, click the Generate Report to get the negative sales transactions in the report.
Figure 3.1.3
You can see the list of the selected cashiers and their negative sales transaction details.
3.2 Custom Filter
You can filter the data by selecting specific parameters to check the negative sales transactions in the report. You will see the "Filter Items" drop-down option, from which you can select the specific data (parameters) to generate the report according to them.
Figure 3.2.1
You will find the two options from the "Filter Items" drop-down selection:
- Show All: By default, this option will be pre-selected. It considers all the data (parameters) to generate the report. The "Manage" button will be disabled for this option.
- Custom Filter: To customize and get the specific data for the report, you need to select the "Custom Filter" option. Once you select it, the "Manage" button will be enabled to set up the filters.
By clicking the "Manage" button, a "Manage Filters" window will pop up. You will see the following details:
1. You can select the saved custom filter from the drop-down selection (if any). The "Manage Filters" button will open the list of the saved custom filters. You will see the different tabs to filter the data (parameters) to select the records for the negative transactions. You can select the required data by navigating the other tabs individually.
2.
- You can see the list of records for the selected tab (i.e., UPC). You can also search any record from the list by entering the text in the "Search" edit box.
- You will find the checkbox along with all the product names (UPC). You need to select the record by ticking the checkbox.
3. After selecting the record(s), move to the "Selected List" area on the right side by clicking the green right-side arrow (>>) button.
Figure 3.2.2
4. You will have one flag to decide whether you want to "Include" or "Exclude" the selected records when the report is generated.
- Include: If the flag is selected to "Include," it means the top sellers report will be generated by applying the selected records.
- Exclude: If the flag is selected to "Exclude," it means the top sellers report will be generated but ignore the selected records. It will consider the selected records that need to be excluded and consider the left-side records for reports.
5. If you want to remove the whole selection, click the "Clear Selection" button. You can remove any record from the list by clicking the "Remove" (x) icon.
6. You can generate the report by clicking the "Apply" button, or you can click the "Save Filters" button to save the custom filter for future use.
In this way, the "Custom Filter" options (tabs) help to customize the records and set up the parameters to get only the required data for the report. Similarly, you can filter and set up the records for other tabs (parameters).
3.3 Select Store
You can browse a store list to check the negative transaction data in the report by selecting the specific store.
Figure 3.3.1
Select the store and by clicking the "Generate Report" button, the negative transaction data for the cashier(s) will be generated in the report.
Figure 3.3.2
You can select the store from the list and check the negative transaction that was performed by the cashiers who work there.
3.4 Range Type
There are two options provided to check the negative sales report by "Range Type":
By Date Range | By RegZ Range
Figure 3.4.1
3.4.1 By Date Range
When you redirect to the "Negatvie Cashiers Report" page, the Date Range will be selected by default.
By clicking the edit box of the date, you will get a tiny calendar to select the specific date range. You can also enter the date manually as per mm/dd/yyyy format.
Figure 3.4.1.2
If you want to get Register Z details for the specific time duration (till morning/evening), you can also select the particular time (hour & minutes) from the date selection. After selecting the date & time, click the "Done" button.
The "Presets" option is also provided to check the report for a specific duration.
Figure 3.4.1.2
In this way, you can get the negative transactions in the report by selecting a specific date range.
3.4. By RegZ Range
When you select the "Reg Z Range", the Register # (number) and the Z # (Register Z Number) drop-down selections will be visible.
- Register #: Register Numbers are the POS system at the specific stores. Based on the store selection, the register number record(s) will be populated in the Register # list.
- Z # (Register Z Number): As per the selection of the store and Regster #, the Z # records will appear in the drop-down list that was performed at POS by the cashier before closing the shift.
Figure 3.4.1.1
You will get the "Register #" list as per the selection of the store. You can check the negative transaction for the specific register of the store.
Figure 3.4.1.2
You will get the "Z #" list as per the selection of Register # where the RegZ was generated. You must select the RegZ (shift) record from the list to check the negative transaction data for that specific shift (Reg. Z).
Figure 3.4.1.3
Now, by generating the report, you will see the negative transaction for the cashier as per the "Register #" and the "Z#" (shift) under that Register #.
Figure 3.4.1.3
In short, if you want to check the negative transaction data for the specific shift by the cashier, you can select the "By RegZ Range". you will see negative transactions for the specific shift (Z#).
3.5 Bifurcation (Checkbox) Options
You can generate the negative cashier report by checking/unchecking the checkboxes if you want to bifurcate the negative transaction data.
By default, the following checkboxes will be checked when you navigate to the report page:
- Show Details: If checked, you will see the summary with the number of negative transactions, discount details, the value of the negative transaction in $ amount, and the individual receipt details. If you are unchecked, you will just get the number of negative transactions & $ the amount of that transaction in tabular format.
- Show Voids: If checked, you can see the voided items during the checkout.
- Show Cancels: If checked, you can see the entire canceled sales during the checkout.
- Show Returns: If checked, you can see the returned item details during the checkout.
- Show No Sales: If checked, you can see the no sales details when the cashier opened the drawer without a sale. If any note is added performing the "No Sale", it can also be seen in the Reason column.
Note: As per the permission, cashier can open the drawer even without sales transaction from the POS panel.
Opens the cash drawer without a sale. Requires cashier to have 'No Sale' permission.
4. Show Pre/Post Receipts
You can also check the receipt details individually just by clicking on the “Show Pre/Post Receipts” hyperlink from the negative cashier report itself.
Figure 4.1
By clicking that hyperlink, the users will be redirected to the new browser tab that displays receipt details (E-Journal Report). From here, the users can see the negative sales in the receipt details to check what happened at that time.
Figure 4.2
“Pre/Post Receipt” shows the transaction details with all the necessary details such as cashier name, Register, Receipt No., and others.
In this way, you can easily check negative sales such as canceled, voided, and returned sales from the “Negative Cashier Report” by applying multiple custom filter options at the same time to get the required negative cashier report.