| Oracle® Retail Xstore Point of Service Reports Guide Release 19.0 F21535-03 |
|
 Previous |
 Next |
This chapter contains information about the following reports:
This report shows the amount declared by the cashier for each tender at the time of reconciliation, the amount expected by the system at the time of reconciliation, the over/short amounts in a cash drawer/till for each tender, and a signature line for the associate and the manager. The report data contains the most recent register close count.
Navigate: Till Reports > Cash Drawer Reconciliation Report.
Table 5-1 Cash Drawer Reconciliation Report Parameters
| Parameter | Description |
|---|---|
|
Date |
Date of the reconciliation. |
|
Till |
Name of the till. |
|
Tender |
The tender type. |
|
Register Count |
The amount declared by the cashier for each tender. |
|
System Count |
The amount expected by the system for each tender. |
|
Over / Short |
The calculated difference between the declared amount and the expected amount. |
Select an option or make entries in any of the following fields to determine report output:
Start Date: Select Today (current day) or Yesterday (previous day) from the drop-down list or enter a start date.´
Register Number: Enter the register number for the cash drawer whose reconciliation report will be generated.
|
Note: Leave the Register Number field blank to run the report for all cash drawers. |
This report is based on the date range and associate ID (or range of associate IDs) that are selected. For each tender type in the drawer, it shows the associate's count, the system count, and the over/short amount in the drawer. It also includes a signature line for the associate and the manager. The report data is based on the most recent register close count.
Navigate: Till Reports >Associate Reconciliation Report.
Table 5-2 Associate Reconciliation Report Parameters
| Parameter | Description |
|---|---|
|
Tender Summary |
The tender type. |
|
Quantity |
The tender quantity, when applicable. |
|
Associate Count |
The amount declared by the cashier for each tender, and the total amount for all tenders. |
|
System Count |
The amount expected by the system for each tender, and the total amount for all tenders. |
|
Over / Short |
The calculated amount difference between the declared amount and the expected amount, and the total over/short amount for all tenders. |
|
Total |
Associate and System Count totals. |
Select an option or make entries in any of the following fields to determine report output:
Start Date: Enter a specific date, or select Today (current day) or Yesterday (previous day) from the drop-down list.
Start Associate ID: Enter the first associate ID that you want to include.
End Associate ID: Enter the last associate ID that you want to include.
|
Note: Leave the Start Associate ID and End Associate ID fields blank to run the report for all associates. |
This report provides the current status of all registers, drawers, and tills. It indicates whether a register is open or closed, the associate at the register, the current cash balance and any amount that may exceed the maximum cash amount allowed in the cash drawer/till.
Navigate: Till Reports > Cash Drawers Audit Report.
There are no selection criteria for this report because all registers are included.
Table 5-3 Cash Drawer Audit Report
| Parameter | Description |
|---|---|
|
Register data |
ID: The register identifier. Status: Status of the register. |
|
Drawer |
The cash drawer identifier. |
|
Till |
The till identifier. |
|
Register Status |
The current status of the register. |
|
Associate data |
ID: The associate's identifier assigned to the register/drawer/till. Name: The associate's name assigned to the register/drawer/till. |
|
Currency |
Name of the currency |
|
Cash Balance |
The current cash balance in the register/drawer/till. |
|
Amount Over Threshold |
The amount that exceeds the allowed threshold. |
The Cash Drawer Report shows the current value of every tender in the cash drawer and the total value of all tenders for each register, till, and session. This report may include one register, or a range of register IDs.
To access the report in base, from the Back Office select the following menu buttons:
Navigate: Till Reports > Cash Drawer Report.
Table 5-4 Cash Drawer Report Parameters
| Parameter | Description |
|---|---|
|
Opening Balance |
The total opening balance. |
|
Tender Summary |
The current value of every tender in the cash drawer/till and the total tender amount. |
|
Petty Cash |
Shows the petty cash amounts such as cash pickup amount, paid out amount, and so on, as well as the total petty cash amount, if applicable. |
Select an option or make entries in any of the following fields to determine report output:
Register: Enter the register ID to be included in the report. If this is blank, and End Register has a register number then it is assumed this is a zero and a range will be used.
End Register: If more than one register will be included, enter the last register ID you want to include with the starting register ID in Register.
The Paid In/Paid Out Report shows all of the details related to Paid In and Paid Out transactions that meet the selection criteria. The report may be restricted to a specific register, employee, date, or reason code, or it may include all data for those fields.
Navigate: Till Reports > Paid In/Paid Out Report.
Table 5-5 Paid In/Paid Out Report Parameters
| Parameter | Description |
|---|---|
|
Totals |
Paid In, Paid Out, Net Amount |
|
Total Paid In |
The total amount for all paid in transactions. |
|
Total Paid Out |
The total amount for all paid out transactions |
|
Transaction |
The transaction number. |
|
Date & Time |
Date and time the transaction took place. |
|
ID |
The associate's identifier number. |
|
Name |
The associate's name. |
|
Reg |
The register identifier. |
|
Till |
The till identifier. |
|
Type |
Transaction type; Paid In or Paid Out. |
|
Reason |
The paid in or paid out reason code and text description. |
|
Description |
The reason description. |
|
Amount |
The amount for each paid in/paid out transaction. |
Select an option or make entries in any of the following fields to determine report output:
Date Range: Enter a single fixed date, a date range (begin and end dates) or select a relative date option (Yesterday, Last Week, and so on) from the drop-down list.
Register: Enter a specific register ID that will be included on the report. All registers will be included on the report if no entry is made in the Register field.
Reason Code: Select a reason code from the drop-down list.
Transaction Type: Select Paid In, Paid Out, or All transactions.
Employee ID: Enter a specific employee ID to be included on the report. If no employee ID is entered, all employees will be included on the report.
Sort Order: Select the order in which the data will be arranged on the report. Sort by Register, Transaction, or Employee.
The No Sale Report lists all of the No Sale transactions (opening the cash drawer outside a sale transaction) that occurred within the date range specified. The report also includes the name of the employee who performed the No Sale transaction, the reason for the transaction, the date and time, and the register on which it occurred.
This report includes transactions that were triggered by manually opening a cash drawer with a key as well as No Sale transactions that were initiated using the No Sale transaction menu option.
Navigate: Sales Reports > No Sale Report.
Table 5-6 No Sale Report Parameters
| Parameter | Description |
|---|---|
|
Associate |
The associate's identifier and name. |
|
Register |
The register identifier. |
|
Transaction |
The transaction number. |
|
Date |
Date the transaction took place. |
|
Time |
Time the transaction took place. |
|
Reason |
The No Sale reason code and text description. |
The Credit Card Report lists all credit card transactions that occurred within the range of dates supplied by the user. The report shows the date and time the transaction occurred, credit card type, authorization number, and the amount.
Table 5-7 Credit Card Report Parameters
| Parameter | Description |
|---|---|
|
Date & Time |
Date and time the transaction took place. |
|
Reg |
The register identifier. |
|
Cashier |
The cashier's identifier number. |
|
Transaction |
The transaction number. |
|
Card |
The masked credit card number. |
|
Type |
The type of credit card. |
|
Auth |
The authorization number received from the processor. |
|
Tender |
The amount charged to the credit card in the transaction. |
|
Total |
The total amount of the transaction including the credit card and any other tenders used. |
Select an option or make entries in any of the following fields to determine report output:
Date Range: Enter a single fixed date, a date range (begin and end dates) or select a relative date option (Yesterday, Last Week, and so on) from the drop-down list.
The Gift Certificate Report lists all gift certificates sold and redeemed within the date range specified. Each certificate listed includes its serial number, the transaction number of the sale and employee ID who sold it, the date on which it was sold, and the denomination of the certificate.
A summary line indicates the total number of certificates sold and their cumulative value. A signature line for authorizing the report also appears at the bottom of the last page.
Table 5-8 Gift Certificate Report Parameters
| Parameter | Description |
|---|---|
|
Serial |
The gift certificate identifier number. |
|
Sold data: |
|
|
Transaction |
The selling transaction number. |
|
ID |
The selling cashier's identifier. |
|
Date |
The date the gift certificate was purchased. |
|
Denomination |
The denomination amount for the gift certificate. |
|
Redeemed data: |
|
|
Transaction |
The redeem transaction number. |
|
ID |
The redeeming associate's identifier. |
|
Date |
The date the gift certificate was redeemed. |
|
Amount |
The amount applied to the gift certificate in the transaction. |
|
Totals |
|
|
Denomination Sold |
Total amount of all gift certificates sold within the date range specified and for the employee selected. |
|
Amount Redeemed |
Total amount of all gift certificates redeemed within the date range specified and for the employee selected. |
Select an option or make entries in any of the following fields to determine report output:
Date Range: Enter a single fixed date, a date range (begin and end dates), or select a relative date option (Yesterday, Last Week, and so on) from the drop-down list.
Start Employee: Enter an employee ID if you want to restrict the report to a single employee, or a range of employee IDs.
End Employee: Enter the last employee ID in the range of employees or enter the same employee ID as the Start Employee if you want to restrict the report to only one employee.
