Skip Headers
Oracle® Retail Back Office User Guide
Release 14.1
E54470-01
  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

The summary report that is displayed is dependent on the processing that was completed:

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

  • At the completion of closing a register, the Register Summary Report is displayed. 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 is displayed. This report shows summary information for the entire store for 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.

When VAT is enabled, there is no sales tax. The Sales Tax line in the Transaction Summary section is blank. In the Tax Summary section, a summary of the VAT is shown instead of sales tax. The following figure shows an example.

Figure A-1 Tax Summary Section with VAT Enabled

VAT summary section example

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

The following two figures show an example of a summary report. The Till Summary Report is used as the example.

Figure A-2 Till Summary Report - First Part


Figure A-3 Till Summary Report - Second Part


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 displayed in the Tender Summary section.

When displayed 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 displayed 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 displayed and printed 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.

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

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

  • All counts equal to zero are displayed 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. If N/A appears in the description of a line, N/A will be displayed for the amount for that line when the summary report is generated.

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:

  • All the possible tenders are displayed regardless of whether 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 displayed in the following order—USD, CAD, MXN, GBP, EUR, and JPY.

    • Totals for the base currency and then any alternate currencies

  • 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 displayed 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 amount of e-Checks.

Out

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 amounts:

  • Deposited checks

  • Mall Gift Certificates used as checks collected for payment

Out

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

In

Always 0.00

Out

Total amount of Mail Bank Checks issued.

Net

Equal to Mail Bank Check Out.

Counted

N/A

Over/Short

Always 0.00

Visa

In

Total amount of Visa tender.

Out

Total amount of Visa tender 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 amount of MasterCard tender.

Out

Total amount of MasterCard tender 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 amount of AMEX tender.

Out

Total amount of AMEX tender 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 amount of Discover tender.

Out

Total amount of Discover tender 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 amount of Diners tender.

Out

Total amount of Diners tender 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 amount of JCB tender.

Out

Total amount of JCB tender 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 amount of House Card tender.

Out

Total amount of House Card tender 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 amount of Debit tender.

Out

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 amount of Gift Cards tendered or redeemed.

Out

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 amount of Gift Certificates tendered or redeemed.

Out

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.

Traveler's Checks

In

Total amount of Traveler's Checks tendered.

Out

Total amount of Traveler's Checks post-voided.

Net

Traveler's Checks In minus Traveler's Checks Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Non-Store Coupon

In

Total face value of Non-Store Coupons tendered.

Out

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 face value of Store Credits tendered or redeemed.

Out

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 amount of Mall Gift Certificates tendered or redeemed.

Out

Total amount 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 amount of purchase order tenders and Mall Gift Certificates, used as purchase order tenders, collected for payment.

Out

Total amount of purchase order tenders post-voided and Mall Gift Certificates, used as purchase order tenders, 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 amount of Money Orders collected for payment.

Out

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 amount of the alternate currency e-Checks.

Out

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 amount of the alternate currency check tender.

Out

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 amount of alternate currency Gift Certificates tendered or redeemed.

Out

This amount is always 0.00 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 face value of alternate currency Store Credits tendered or redeemed.

Out

This amount is always 0.00 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.

Traveler's Checks (alternate currency label)

In

Total amount of alternate currency Traveler's Checks tendered.

Out

This amount is always 0.00 because post-voided alternate currency Traveler's Checks cannot be reflected financially.

Net

Traveler's Checks (alternate currency label) In minus Traveler's Checks (alternate currency label) Out.

Counted

Count entered by the cashier.

Over/Short

Counted minus Net.

Gift Certificate (USD)

In

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

Out

This amount is always 0.00 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 face value of Store Credits in United States Dollars tendered or redeemed when United States Dollars is not the base or alternate currency.

Out

This amount is always 0.00 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 amount of Gift Certificates in Canadian Dollars tendered or redeemed when Canadian dollars is not the base or alternate currency.

Out

This amount is always 0.00 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 face value of Store Credits in Canadian Dollars tendered or redeemed when Canadian Dollars is not the base or alternate currency.

Out

This amount is always 0.00 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 amount of Gift Certificates in Mexican Pesos tendered or redeemed when Mexican Pesos is not the base or alternate currency.

Out

This amount is always 0.00 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 face value of Store Credits in Mexican Pesos tendered or redeemed when Mexican Pesos is not the base or alternate currency.

Out

This amount is always 0.00 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 amount of Gift Certificates in United Kingdom Pounds tendered or redeemed when United Kingdom Pounds is not the base or alternate currency.

Out

This amount is always 0.00 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 face value of Store Credits in United Kingdom Pounds tendered or redeemed when United Kingdom Pounds is not the base or alternate currency.

Out

This amount is always 0.00 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 amount of Gift Certificates in Euros tendered or redeemed when Euros is not the base or alternate currency.

Out

This amount is always 0.00 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 face value of Store Credits in Euros tendered or redeemed when Euros is not the base or alternate currency.

Out

This amount is always 0.00 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 amount of Gift Certificates in Japanese Yen tendered or redeemed when Japanese Yen is not the base or alternate currency.

Out

This amount is always 0.00 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 face value of Store Credits in Japanese Yen tendered or redeemed when Japanese Yen is not the base or alternate currency.

Out

This amount is always 0.00 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 of all tenders in the base currency for this column.

Out

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

Net

Totals In minus Totals Out.

Counted

Total count 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 of all tenders in the alternate currency for this column.

Out

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

  • Net Transaction Taxable does not include money from an order pickup unless the payment is made during the order pickup. The money is accounted for when the payment is made. If the order is paid in full during order creation, it is included as a sale during that transaction and not counted when the order is picked up and completed.

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

Table A-4 Transaction Summary

Report Line Description

Net Transaction Taxable

Amount of sale taxable transactions minus returns and post-voids. Includes taxable layaway completions. Order pickups are included only if the balance is paid with the order pickup.

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

Net Transaction Non-Taxable

Amount of sale non-taxable transactions minus returns and post-voids. Includes non-taxable layaway completions. Order pickups are included only if the balance is paid with the order pickup.

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 Account 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 Employee Disc.

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

Trans. Employee Disc.

Total amount of transaction-level employee discounts.

Transaction Discount

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 Discount

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 Transaction

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 special order cancels with items that include restocking fees.

Restocking Fee Non-Taxable

Total amount of restocking fees on non-taxable items minus post-voids.

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 only when a layaway or order is picked up and any money is paid.

Sales Nontaxable

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

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