Skip Headers
Oracle® Retail Point-of-Service User Guide
Release 14.1
E54472-02
  Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
 
Next
Next
 

A Appendix: Summary Reports

Summary reports are used to determine financial information pertaining to a till, register, or store.

Overview

Oracle Retail Point-of-Service summary reports are generated in two ways:

  • When closing a store, register, or till, a summary report automatically prints:

    • At the completion of reconciling a till, the Till Summary Report prints.

    • At the completion of closing a register, the Register Summary Report prints. This report only includes till information for those transactions that were rung up on the register.

    • At the completion of end of day processing, the Store Summary Report prints. This report shows summary information for the entire store for the business day.

  • You select a report through Manager Options, which is described in Chapter 7.

    • A report can be printed for any prior day or the current day.

    • A report can be printed any time during the business day.

Information presented in a summary report is categorized into the following sections. These sections are the same for all summary reports.

  • The Store Safe and Float section shows information on the store safe and till floats. The opening amount, closing amount, and over or short amount are shown for each. The store safe is only shown on the Store Summary Report.

  • The Tender Summary section shows information on the tenders used during the business day. For each tender, the expected amounts taken in and out, the actual amount counted at reconciliation, and any count that is over or under the expected amount are shown.

  • The Transaction Summary section shows the taxable and non-taxable transaction totals. It also displays information on transactions associated with tills, house accounts, layaways, orders, and bill payments. The total amount for each type of transaction is shown.

  • The House Account Enrollment Summary section shows information on applications for house accounts. The counts of the approved applications and declined applications are shown.

  • The Statistical Summary section shows statistics for Gift Cards, Gift Certificates, and Store Credits. It also includes information on discounts and fees applied during the business day. For each entry, the total amount is shown.

  • The Count Summary section shows the number of transactions that had price changes or price overrides applied and transactions that were cancelled, post-voided, or no-sale.

  • The Tax Summary section shows information on taxable and non-taxable sales. The total amount of sales tax for each tax jurisdiction and the total amount for all jurisdictions are shown.

    In a VAT environment, the total VAT for each tax jurisdiction and the total VAT for the business day are shown instead of the sales tax.


Note:

Some of the information in the reports depends on the values set for parameters and system settings. For information on the parameters and system settings, see the Oracle Retail POS Suite Configuration Guide.

Value Added Tax

Value added tax (VAT) is a tax added at various stages of production based on the value added to the product at that stage.

Report Header

The report header contains the following information:

  • Title of the report

  • Store number

  • Register number for the Register and Till Summary Reports

  • Date and time the report was generated

  • Identifier of the cashier who closed the store, register, or till

  • Business date when the store was opened

  • The store, register, or till number covered in the report

Report Example

Figure A-1 Summary Report - Part 1

Surrounding text describes Figure A-1 .

Figure A-2 Summary Report - Part 2

Surrounding text describes Figure A-2 .

Figure A-3 Summary Report - Part 3

Surrounding text describes Figure A-3 .

Report Content

Summary reports show information for the base currency plus one alternate currency. In addition to one base currency and one alternate currency, Oracle Retail Point-of-Service can also take in Store Credits and Gift Certificates from additional supported currencies. If any of these Store Credits or Gift Certificates are taken in during a business day, they are shown in the Tender Summary section.

When shown in the report, an alternate currency includes an alternate currency label. For example, if Canadian currency is the alternate currency, a till pickup in Canadian currency would be shown as Till Pickup (CAD).

Table A-1 lists the currencies supported for the base and alternate currencies:

Table A-1 Supported Currencies

Currency Alternate Currency Label

Canadian Dollars

CAD

European Union Euros

EUR

Japanese Yen

JPY

Mexican Pesos

MXN

United Kingdom Pounds

GBP

United States Dollars

USD


Note the following about summary reports:

  • Traveler's checks are counted by the quantity of traveler's checks taken in. The total amount is the total face value of the traveler's checks.

  • Queued transaction information is not reported when a till is reconciled or a register or store is closed.

  • The totals in the Till Summary Report are reported on the register where the till was closed.

  • Kits are counted at the component item level for all reporting.

  • Any of the amounts in the reports can be negative numbers. If an amount is negative, it is shown in parentheses.

  • The exchange rate used for reports is the rate in place at the time each transaction was performed.

  • E-checks are counted separately from deposited checks during till reconciliation.

  • If a transaction is deleted from the queue, the transaction and financial information is included in the report automatically generated when a till, register, or store is closed. This information is not included in the report printed through Manager Options.

  • If the till is not reconciled and a Till Summary Report is generated through Manager Options, OPEN is shown for the Closing Float and any Counted or Over/Short amounts.

  • If the register is not closed and a Register Summary Report is generated through Manager Options, OPEN is shown for the Closing Float and any Counted or Over/Short amounts.

  • If the store is not closed and a Store Summary Report is generated through Manager Options, OPEN is shown for the Closing Safe, Closing Float, and any Counted or Over/Short amounts.

  • When Register accountability is used, the same information is shown in the Register Summary and Till Summary reports.

  • All currency values equal to zero are shown as 0.00.

  • All counts equal to zero are shown as 0.

Each section of the summary report is described in a table. For each report line, a description is provided of how each value is calculated.

Store Safe and Float Summary

The first section of the report covers the store safe and till float. Note the following about this section:

  • The safe and float amounts are always in base currency.

  • The store safe information only appears in the Store Summary Report.

  • If the Count Float at Open or Count Float at Close system setting is set to No, the reported amount is determined by the value set for the Float Amount system setting.

Table A-2 describes the information.

Table A-2 Store Safe and Float Summary

Report Line Description

Open Safe

Store safe amount entered when the store was opened.

This line only appears on the Store Summary report.

Closing Safe

Store safe amount entered when the store was closed.

This line only appears on the Store Summary report.

Over/Short

Closing Safe minus Open Safe.

This line only appears on the Store Summary report.

Open Float

Float amount entered when the till was opened. If the Till Count Float at Open system setting is set to No, the amount in the Float Amount system setting is used.

For the Store Summary report, this is the sum of the Open Float counts for all tills opened in the store.

For the Register Summary report, this is the sum of the Open Float counts for all tills opened at the register.

Closing Float

Float amount entered when the till was closed.

For the Store Summary report, this is the sum of the Close Float counts for all tills closed in the store.

For the Register Summary report, this is the sum of all Close Float amounts for all tills closed at the register.

Over/Short

Closing Float minus Open Float.


Tender Summary

Note the following about this section:

  • Tenders are shown only if the tender was actually used during the business day.

  • The amounts in this section are based on gross tender amounts and include tax.

  • The tenders are listed in the following order:

    • Tenders for the base currency.

    • Tenders for the alternate currency.

    • Any Gift Certificates or Store Credits for currencies other than the base and alternate currencies.

      If any of these Gift Certificates or Store Credits are taken in during a business day, they are shown in the following order—USD, CAD, MXN, GBP, EUR, and JPY.

    • Totals for the base currency and then any alternate currencies.

  • For tenders other than Cash, a count and amount is shown for the In and Out lines.

  • When the Count Till at Reconcile system setting is set to No, the net amount and counted amount will be the same. The Counted amount is shown as N/A and the Over/Short amount is zero.

Table A-3 describes the content of the Tender Summary section.

Table A-3 Tender Summary

Tender Report Line Description

Cash

In

Total of the following amounts:

  • Gross cash

  • Till loans

  • Till pay-ins

Out

Total of the following amounts:

  • Gross cash out

  • Change

  • Till pickups

  • Till payouts

  • Debit cards post-voided to cash (Void Debit to Cash parameter is set to Yes)

  • e-Checks post-voided

  • Money orders post-voided

  • Cash refunds

  • e-Checks returned

Net

Cash In minus Cash Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

e-Check

In

  • Total number of e-Check tenders.

  • Total amount of e-Check tenders.

Out

  • Total number of e-Checks post-voided.

  • Total amount of e-Checks post-voided.

Net

e-Check In minus e-Check Out.

Counted

N/A

Over/Short

Always 0.00

Deposited Check

In

Total of the following counts:

  • Number of deposited checks

  • Number of Mall Gift Certificates, used as checks, collected for payment

Total of the following amounts:

  • Deposited checks

  • Mall Gift Certificates, used as checks, collected for payment

Out

Total of the following counts:

  • Number of deposited checks post-voided

  • Number of refunds

  • Number of till pickups

Total of the following amounts:

  • Deposited checks post-voided

  • Refunds

  • Till pickups

Mail Bank Checks and Money Orders are not included.

Net

Deposited Check In minus Deposited Check Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Mail Bank Check

Out

  • Total number of Mail Bank Checks issued.

  • Total amount of Mail Bank Checks issued.

Net

Equal to Mail Bank Check Out.

Visa

In

  • Total number of Visa credit card tenders collected for payment.

  • Total amount of Visa credit card tenders.

Out

  • Total number of Visa credit card tenders credited on returns and post-voids.

  • Total amount of Visa credit card tenders credited on returns and post-voids.

Net

Visa In minus Visa Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

MasterCard

In

  • Total number of MasterCard credit card tenders collected for payment.

  • Total amount of MasterCard credit card tenders.

Out

  • Total number of MasterCard credit card tenders credited on returns and post-voids.

  • Total amount of MasterCard credit card tenders credited on returns and post-voids.

Net

MasterCard In minus MasterCard Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

AMEX

In

  • Total number of AMEX credit card tenders collected for payment.

  • Total amount of AMEX credit card tenders.

Out

  • Total number of AMEX credit card tenders credited on returns and post-voids.

  • Total amount of AMEX credit card tenders credited on returns and post-voids.

Net

AMEX In minus AMEX Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Discover

In

  • Total number of Discover credit card tenders collected for payment.

  • Total amount of Discover credit card tenders.

Out

  • Total number of Discover credit card tenders credited on returns and post-voids.

  • Total amount of Discover credit card tenders credited on returns and post-voids.

Net

Discover In minus Discover Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Diners

In

  • Total number of Diners credit card tenders collected for payment.

  • Total amount of Diners credit card tenders.

Out

  • Total number of Diners credit card tenders credited on returns and post-voids.

  • Total amount of Diners credit card tenders credited on returns and post-voids.

Net

Diners In minus Diners Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

JCB

In

  • Total number of JCB credit card tenders collected for payment.

  • Total amount of JCB credit card tenders.

Out

  • Total number of JCB credit card tenders credited on returns and post-voids.

  • Total amount of JCB credit card tenders credited on returns and post-voids.

Net

JCB In minus JCB Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

House Card

In

  • Total number of House Card tenders collected for payment.

  • Total amount of House Card tenders.

Out

  • Total number of House Card tenders credited on returns and post-voids.

  • Total amount of House Card tenders credited on returns and post-voids.

Net

House Card In minus House Card Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Debit

In

  • Total number of Debit card tenders collected for payment.

  • Total amount of Debit tender.

Out

  • Total number of Debit card tenders reversed on post-voids.

  • Total amount of Debit reversed on post-voids (Void Debit to Cash parameter is set to No).

Net

Debit In minus Debit Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Gift Card

In

  • Total number of Gift Cards tendered or redeemed.

  • Total amount of Gift Cards tendered or redeemed.

Out

Total of the following counts:

  • Number of Gift Cards post-voided

  • Number of Gift Cards issued as change

  • Number of Gift Cards issued as refunds

  • Number of post-voided Gift Card redeems

Total of the following amounts:

  • Gift Cards post-voided

  • Gift Cards issued as change

  • Gift Cards issued as refunds

  • Post-voided Gift Card redeems

Net

Gift Card In minus Gift Card Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Gift Certificate

In

  • Total number of Gift Certificates tendered or redeemed.

  • Total amount of Gift Certificates tendered or redeemed.

Out

Total of the following counts:

  • Number of Gift Certificates post-voided

  • Number of Gift Certificates issued as change

  • Number of post-voided Gift Certificate redeems

Total of the following amounts:

  • Gift Certificates post-voided

  • Gift Certificates issued as change

  • Post-voided Gift Certificate redeems

Net

Gift Certificate In minus Gift Certificate Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Travelers Checks

In

  • Total number of Traveler's Checks tendered.

  • Total amount of Traveler's Checks tendered.

Out

  • Total number of Traveler's Checks post-voided.

  • Total amount of Traveler's Checks post-voided.

Net

Travelers Checks In minus Travelers Checks Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Non-Store Coupon

In

  • Total number of Non-Store Coupons tendered.

  • Total face value of Non-Store Coupons tendered.

Out

  • Total number of Non-Store Coupons post-voided.

  • Total face value of Non-Store Coupons post-voided.

Net

Non-Store Coupons In minus Non-Store Coupons Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Store Credit

In

  • Total number of Store Credits tendered or redeemed.

  • Total face value of Store Credits tendered or redeemed.

Out

Total of the following counts:

  • Number of Store Credits issued as change

  • Number of Store Credits issued as refunds

  • Number of Store Credits post-voided

  • Number of post-voided Store Credits redeemed

Total face value of the following amounts:

  • Store Credits issued as change

  • Store Credits issued as refunds

  • Store Credits post-voided

  • Post-voided Store Credits redeemed

Net

Store Credit In minus Store Credit Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Mall Gift Certificate

In

  • Total number of Mall Gift Certificates tendered or redeemed.

  • Total amount of Mall Gift Certificates tendered or redeemed.

Out

Total of the following counts:

  • Number of Mall Gift Certificates post-voided

  • Number of Mall Gift Certificates redeemed and then post-voided

Total of the following amounts:

  • Mall Gift Certificates post-voided

  • Mall Gift Certificates redeemed and then post-voided

Net

Mall Gift Certificate In minus Mall Gift Certificate Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

PO Tender

In

Total of the following counts:

  • Number of purchase order tenders

  • Number of Mall Gift Certificates, used as purchase orders, collected for payment

Total of the following amounts:

  • Purchase order tenders

  • Mall Gift Certificates, used as purchase orders, collected for payment

Out

Total of the following counts:

  • Number of purchase order tenders post-voided

  • Number of Mall Gift Certificates, used as purchase orders, post-voided

Total of the following amounts:

  • Purchase order tenders post-voided

  • Mall Gift Certificates, used as purchase orders, post-voided

Net

PO Tender In minus PO Tender Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Money Order

In

  • Total number of Money Orders collected for payment.

  • Total amount of Money Orders collected for payment.

Out

  • Total number of Money Orders post-voided.

  • Total amount of Money Orders post-voided.

Net

Money Order In minus Money Order Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Cash (alternate currency label)

In

Total amount of the alternate currency cash tendered.

Out

Total amount of the alternate currency cash picked up and post-voided.

Net

Cash (alternate currency label) In minus Cash (alternate currency label) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

e-Check (alternate currency label)

In

  • Total number of alternate currency e-Checks.

  • Total amount of alternate currency e-Checks.

Out

  • Total number of alternate currency e-Checks post-voided and picked up.

  • Total amount of alternate currency e-Checks post-voided and picked up.

Net

e-Check (alternate currency label) In minus e-Check (alternate currency label) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Check (alternate currency label)

In

  • Total number of the alternate currency checks.

  • Total amount of the alternate currency checks.

Out

  • Total number of alternate currency checks post-voided and picked up.

  • Total amount of alternate currency checks post-voided and picked up.

Net

Check (alternate currency label) In minus Check (alternate currency label) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Gift Certificate (alternate currency label)

In

  • Total number of alternate currency Gift Certificates tendered or redeemed.

  • Total amount of alternate currency Gift Certificates tendered or redeemed.

Out

The count and amount are always zero because post-voided alternate currency Gift Certificates cannot be reflected financially.

Net

Gift Certificate (alternate currency label) In minus Gift Certificate (alternate currency label) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Store Credit (alternate currency label)

In

  • Total number of alternate currency Store Credits tendered or redeemed.

  • Total face value of alternate currency Store Credits tendered or redeemed.

Out

The count and amount are always zero because post-voided alternate currency Store Credits cannot be reflected financially.

Net

Store Credit (alternate currency label) In minus Store Credit (alternate currency label) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Trav Checks (alternate currency label)

In

  • Total number of alternate currency Traveler's Checks tendered.

  • Total amount of alternate currency Traveler's Checks tendered.

Out

The count and amount are always zero because post-voided alternate currency Traveler's Checks cannot be reflected financially.

Net

Trav Checks (alternate currency label) In minus Trav Checks (alternate currency label) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Gift Certificate (USD)

In

  • Total number of Gift Certificates in United States Dollars tendered or redeemed when United States Dollars is not the base or alternate currency.

  • Total amount of Gift Certificates in United States Dollars tendered or redeemed when United States Dollars is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Gift Certificates, which are not in the base currency, cannot be reflected financially.

Net

Gift Certificate (USD) In minus Gift Certificate (USD) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Store Credit (USD)

In

  • Total number of Store Credits in United States Dollars tendered or redeemed when United States Dollars is not the base or alternate currency.

  • Total face value of Store Credits in United States Dollars tendered or redeemed when United States Dollars is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Store Credits, which are not in the base currency, cannot be reflected financially.

Net

Store Credit (USD) In minus Store Credit (USD) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Gift Certificate (CAD)

In

  • Total number of Gift Certificates in Canadian Dollars tendered or redeemed when Canadian dollars is not the base or alternate currency.

  • Total amount of Gift Certificates in Canadian Dollars tendered or redeemed when Canadian dollars is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Gift Certificates, which are not in the base currency, cannot be reflected financially.

Net

Gift Certificate (CAD) In minus Gift Certificate (CAD) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Store Credit (CAD)

In

  • Total number of Store Credits in Canadian Dollars tendered or redeemed when Canadian Dollars is not the base or alternate currency.

  • Total face value of Store Credits in Canadian Dollars tendered or redeemed when Canadian Dollars is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Store Credits, which are not in the base currency, cannot be reflected financially.

Net

Store Credit (CAD) In minus Store Credit (CAD) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Gift Certificate (MXN)

In

  • Total number of Gift Certificates in Mexican Pesos tendered or redeemed when Mexican Pesos is not the base or alternate currency.

  • Total amount of Gift Certificates in Mexican Pesos tendered or redeemed when Mexican Pesos is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Gift Certificates, which are not in the base currency, cannot be reflected financially.

Net

Gift Certificate (MXN) In minus Gift Certificate (MXN) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Store Credit (MXN)

In

  • Total number of Store Credits in Mexican Pesos tendered or redeemed when Mexican Pesos is not the base or alternate currency.

  • Total face value of Store Credits in Mexican Pesos tendered or redeemed when Mexican Pesos is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Store Credits, which are not in the base currency, cannot be reflected financially.

Net

Store Credit (MXN) In minus Store Credit (MXN) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Gift Certificate (GBP)

In

  • Total number of Gift Certificates in United Kingdom Pounds tendered or redeemed when United Kingdom Pounds is not the base or alternate currency.

  • Total amount of Gift Certificates in United Kingdom Pounds tendered or redeemed when United Kingdom Pounds is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Gift Certificates, which are not in the base currency, cannot be reflected financially.

Net

Gift Certificate (GBP) In minus Gift Certificate (GBP) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Store Credit (GBP)

In

  • Total number of Store Credits in United Kingdom Pounds tendered or redeemed when United Kingdom Pounds is not the base or alternate currency.

  • Total face value of Store Credits in United Kingdom Pounds tendered or redeemed when United Kingdom Pounds is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Store Credits, which are not in the base currency, cannot be reflected financially.

Net

Store Credit (GBP) In minus Store Credit (GBP) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Gift Certificate (EUR)

In

  • Total number of Gift Certificates in Euros tendered or redeemed when Euros is not the base or alternate currency.

  • Total amount of Gift Certificates in Euros tendered or redeemed when Euros is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Gift Certificates, which are not in the base currency, cannot be reflected financially.

Net

Gift Certificate (EUR) In minus Gift Certificate (EUR) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Store Credit (EUR)

In

  • Total number of Store Credits in Euros tendered or redeemed when Euros is not the base or alternate currency.

  • Total face value of Store Credits in Euros tendered or redeemed when Euros is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Store Credits, which are not in the base currency, cannot be reflected financially.

Net

Store Credit (EUR) In minus Store Credit (EUR) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Gift Certificate (JPY)

In

  • Total number of Gift Certificates in Japanese Yen tendered or redeemed when Japanese Yen is not the base or alternate currency.

  • Total amount of Gift Certificates in Japanese Yen tendered or redeemed when Japanese Yen is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Gift Certificates, which are not in the base currency, cannot be reflected financially.

Net

Gift Certificate (JPY) In minus Gift Certificate (JPY) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Store Credit (JPY)

In

  • Total number of Store Credits in Japanese Yen tendered or redeemed when Japanese Yen is not the base or alternate currency.

  • Total face value of Store Credits in Japanese Yen tendered or redeemed when Japanese Yen is not the base or alternate currency.

Out

The count and amount are always zero because post-voided Store Credits, which are not in the base currency, cannot be reflected financially.

Net

Store Credit (JPY) In minus Store Credit (JPY) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Totals

In

Total amount of all tenders in the base currency for this column.

Out

Total amount of all tenders in the base currency for this column.

Net

Totals In minus Totals Out.

Counted

Total count entered by the cashier of all tenders in the base currency entered by the cashier.

Over/Short

Counted minus Net.

Totals (alternate currency label)

Note: A Totals line is included for each alternate currency collected.

In

Total amount of all tenders in the alternate currency for this column.

Out

Total amount of all tenders in the alternate currency for this column.

Net

Totals (alternate currency label) In minus Totals (alternate currency label) Out.

Counted

Total count entered by the cashier of all tenders in the alternate currency entered by the cashier.

Over/Short

Counted minus Net.


Transaction Summary

Note the following about this section:

  • The amounts in this section are based on transaction information and not item information.

  • With the exception of the Sales Tax line, the amounts are based on the net amount and do not include tax.

  • Float is not included in any amounts.

  • Sales Tax is not included in the Net Transaction Taxable or Net Transaction Non-Taxable lines.

  • Taxable transactions with non-taxable items are included in the Net Transaction Taxable line. Items with tax overridden to zero are considered non-taxable items.

  • Tax-exempt transactions are considered non-taxable transactions and are included in the Net Transaction Non-Taxable line.

  • The till pickup of an alternate currency includes any of the following tenders that are accepted for that alternate currency—cash, check, and Traveler's Check. For example, for Canadian currency, Canadian cash, Canadian checks, and Canadian Traveler's Checks are included in a till pickup.

  • For any report lines other than Till Pickup, the amount for an alternate currency is converted to local currency and included in the amount shown.

Table A-4 describes the content of the Transaction Summary section.

Table A-4 Transaction Summary

Report Line Description

Net Trans. Taxable

Amount of sale taxable transactions minus returns and post-voids. Includes taxable layaway completions and order pickups.

Note: In a VAT environment, this calculation includes VAT, but does not include shipping charges and shipping charge VAT.

Net Trans. Non-Taxable

Amount of sale non-taxable transactions minus returns and post-voids. Includes non-taxable layaway completions and order pickups.

Note: In a VAT environment, this calculation does not include shipping charges and shipping charge VAT.

Sales Tax

Note: In a VAT environment, this line is blank.

Total tax collected minus returns and post-voids.

Till Pickup

Total amount of till pickups in the base currency.

Till Pickup (alternate currency label)

Total amount of till pickups for each alternate currency where till pickups occurred.

Till Loan

Total amount of till loans.

Till Pay In

Total amount of till pay ins.

Till Pay Out

Total amount of till pay outs.

House Acct. Payment

Total amount of house account payments.

Layaway New

Total amount of new layaway deposits and new layaway fees minus post-voids.

Layaway Pickup

Total amount of layaway completions minus post-voids.

Layaway Payment

Total amount of layaway payments minus post-voids.

Layaway Delete

Total amount of layaway deletes minus post-voids. This amount displays as a negative value.

Layaway Delete includes layaway payments that are refunded minus the creation and deletion fees.

Special Order New

Total amount of order deposits minus order cancels and post-voids.

Special Order Complete

Total amount of order completions minus order cancels and post-voids.

Special Order Cancel

Total amount of order cancels minus post-voids.

Special Order Partial

Total amount of order partials minus order cancels and post-voids.

Bill Payment

Total amount of bill payments collected minus post-voids.


House Account Enrollment Summary

This section contains the count of house account enrollments. Table A-5 describes the content.

Table A-5 House Account Enrollment Summary

Report Line Description

Approved

Number of house account applications that were approved.

Declined

Number of house account applications that were declined.


Statistical Summary

Note the following about this section:

  • With the exception of the post-voids, the amounts are based on item information and not transaction information.

  • With the exception of the Post Void Transaction line, the amounts are based on net dollars and do not include tax.

  • Returns include Mail Bank Check data.

  • Only the Line Item Delete and Item Discount lines include returns.

  • On all amounts, post-voids net out but returns might not if the transaction is a partial return or if there is a fee associated with the item being returned.

  • Alterations are included in the Non-merchandise amount.

Table A-6 describes the content of the Statistical Summary section.

Table A-6 Statistical Summary

Report Line Description

Gift Cards Issued

Total amount of Gift Cards issued minus post-voids.

Gift Cards Reloaded

Total amount of Gift Cards reloaded minus post-voids.

Gift Cards Credit

Total amount of Gift Cards credited minus post-voids.

Gift Cards Redeemed

Total amount of Gift Cards redeemed minus post-voids.

Gift Certs. Issued

Total amount of Gift Certificates issued minus post-voids.

Gift Certs. Redeemed

Total amount of Gift Certificates redeemed minus post-voids.

Store Credits Issued

Total amount of Store Credits issued minus post-voids.

Store Credits Redeemed

Total amount of Store Credits redeemed minus post-voids.

Item Empl. Disc.

Total amount of item-level employee discounts applied to sale items minus discounted employee returned items and post-voids.

Trans. Empl. Disc.

Total amount of transaction-level employee discounts.

Trans. Disc.

Total amount of transaction-level discounts applied to sale items minus discounted return items and post-voids.

Note: Employee discounts are not included in this amount.

Item Disc.

Total amount of item-level discounts.

Note: Employee discounts are not included in this amount.

Item Markdown

Total amount of markdowns minus post-voids.

Post Void Trans.

Total amount of post-voided transactions.

Non-Merchandise

Total amount of non-merchandise items minus post-voids.

Line Item Delete

Total amount of deleted items.

The amount does not include items deleted from a cancelled transaction.

Layaway Fee

Total amount of layaway fees minus post-voids.

Layaway Delete Fee

Total amount of layaway delete fees minus post-voids.

Restocking Fee

Total amount of restocking fees minus post-voids. This amount includes restocking fees for non-taxable items and order cancels with items that include restocking fees.

Shipping Charges

Total amount of shipping charges minus post-voids.

Note: In a VAT environment, this amount includes VAT.

Cash Rounding Adjustment

Total amount of rounding adjustments made for transactions involving cash given for change and refunds.


Count Summary

Note the following about this section:

  • This section contains only counts. It is based on transaction and item counts.

  • The counts are always positive.

  • On all counts, post-voids net out but returns might not if a transaction is a partial return or if there is a fee associated with the item being returned.

Table A-7 describes the content of the Count Summary section.

Table A-7 Count Summary

Report Line Description

Price Overrides

Total number of items with price overrides.

Price Adjustments

Total number of items with price adjustments. This is a return and sale of the same item.

Cancelled Trans.

Total number of cancelled transactions.

No Sales

Total number of no-sale transactions.

Post Voids

Total number of post-void transactions.


Tax Summary

Note the following about this section:

  • Several tax jurisdictions and tax rates under those jurisdictions may apply to a store, but only those jurisdictions and rates that have been applied during the dates covered in the report appear in this section.

  • The amounts in this section are based on item information and not transaction information.

  • For the taxable and nontaxable sales amounts, post-voids net out but returns might not if the transaction is a partial return or if there is a fee associated with the item being returned.

  • All tax information is for the current till, register, or store for the current business day.

  • The sale of a Gift Card or Gift Certificate is not a sale, but is an exchange of tender. Therefore, these transactions are not included in the non-sales taxable amount.

Table A-8 describes the content of the Tax Summary section. Table A-9 describes the content in a VAT environment. The jurisdictions and tax names shown in these tables within the <> signs are replaced with the actual jurisdiction and tax names when the report is generated.

Table A-8 Tax Summary

Report Line Description

Sales Taxable

Total amount of taxable items sold minus post-voids, restocking fees, and returns (tax not included). The amount includes the extended prices of items when a layaway or order is picked up.

Sales Nontaxable

Total amount of nontaxable items sold minus returns, restocking fees, and post-voids. The amount includes the extended prices of items when a layaway or order is picked up. Items sold does not include the sale of Gift Cards and Gift Certificates.

Manual Tax

Total amount of tax applied using tax override.

<Jurisdiction 1>

Name of the first local tax jurisdiction.

<Tax 1>

Total amount of locale currency <Tax 1> under locale <Jurisdiction 1>. <Tax 1> is the name of the tax.

<Tax 2>

Total amount of locale currency <Tax 2> under locale <Jurisdiction 1>. <Tax 2> is the name of the tax.

<Jurisdiction 2>

Name of the second local tax jurisdiction.

<Tax 1>

Total amount of locale currency <Tax 1> under locale <Jurisdiction 2>. <Tax 1> is the name of the tax.

<Tax 2>

Total amount of locale currency <Tax 2> under locale <Jurisdiction 2>. <Tax 2> is the name of the tax.

<Tax 3>

Total amount of locale currency <Tax 3> under locale <Jurisdiction 2>. <Tax 3> is the name of the tax.

Total Sales Tax

Total amount of locale tax collected minus returns and post-voids.

Total Shipping Tax

Total amount of locale shipping tax collected minus returns and post-voids. If this value is zero, this line does not appear in the report.


Table A-9 Tax Summary in a VAT Environment

Report Line Description

Sales Taxable

Total amount of taxable items sold minus post-voids, restocking fees, and returns (tax not included). The amount includes the extended prices of items when a layaway or order is picked up. This calculation includes VAT.

Sales Nontaxable

Total amount of nontaxable items sold minus returns, restocking fees, and post-voids. The amount includes the extended prices of items when a layaway or order is picked up. Items sold does not include the sale of Gift Cards and Gift Certificates.

<Jurisdiction 1>

Name of the first local tax jurisdiction.

<VAT A>

Total amount of locale currency <VAT A> under locale <Jurisdiction 1>. <VAT A> is the name of the VAT. The amount includes Shipping Charge VAT, if applicable.

<VAT B>

Total amount of locale currency <VAT B> under locale <Jurisdiction 1>. <VAT B> is the name of the VAT. The amount includes Shipping Charge VAT, if applicable.

<Jurisdiction 2>

Name of the second local tax jurisdiction.

<VAT A>

Total amount of locale currency <VAT A> under locale <Jurisdiction 2>. <VAT A> is the name of the VAT. The amount includes Shipping Charge VAT, if applicable.

<VAT B>

Total amount of locale currency <VAT B> under locale <Jurisdiction 2>. <VAT B> is the name of the VAT. The amount includes Shipping Charge VAT, if applicable.

<VAT C>

Total amount of locale currency <VAT C> under locale <Jurisdiction 2>. <VAT C> is the name of the VAT. The amount includes Shipping Charge VAT, if applicable.

Total VAT

Total amount of VAT collected minus returns and post-voids. The amount includes Shipping Charge VAT.



Note:

The Total Shipping Tax line is not included in a VAT environment. This tax is included in the amount for the Shipping Charges line in the Statistical Summary section.