Data Definition of Sales Reports

Table of Contents

Sales by Date

No Item Name Description
A Period date collection period.
B Gross Sales Total sales before discounts, refunds, gratuity and tax,
C Refunds Amount refunded to customers before discounts, refunds, gratuity and tax.
D Discounts Total discounts on all sales minus total discounts on refund transactions.
E Net Sales Gross sales(B) plus Refunds(C) and Discounts(D).
F Tax Total tax collected on sales minus total tax refunded on refund transactions.
G Gratuity Credit card tips accrued at the register minus refunded gratuity.
H No of Payments number of payment transactions
I Average Unit Price Average unit price which calculated by:
Net Sales(E) divided by No of Payments(H)

 

Sales Details

No Category name Item name Description
A1 SUMMARY       Gross Sales Total sales before discounts, refunds, gratuity and tax,
A2 Refunds Amount refunded to customers before discounts, refunds, gratuity and tax.
  *This amount is usually a minus value.
A3 Discounts Total discounts on all sales minus total discounts on refund transactions.
  *This amount is usually a minus value.
A4   ∟Discount name breakdown of each type of Discounts(A3).
A5 Net Sales Gross sales(A1) plus Refunds(A2) and Discounts(A3).
A6 Tax Total tax collected on sales minus total tax refunded on refund transactions.
A7 Net Sales + Tax Net Sales(A5) plus Tax(A6)
B1 GRATUITY Gratuity(Credit/Debit) Credit card tips accrued at the register minus refunded gratuity.
C1

TENDER STATS        

Cash Payments Total amount(including tax) given to you by customers by cash before refunds.
C2 Cash Refunds Total amount(including tax and credit card gratuity) refunded to customers by cash.
C3 Cash Net Cash Payments(C1) plus Cash Refunds(C2)
C4 Credit/Debit Payments Total amount(including tax and credit card gratuity) given to you by customers by Credit/Debit before refunds.
C5  ∟Company name of Credit/Debit Payments

Breakdown of tendered amount by each Credit/Debit issued companies.

C6

 ∟Amount of each company's Credit/Debit Payments

C7

Credit/Debit Refunds

Total amount(including tax and credit card gratuity) refunded to customers by Credit/Debit.
C8 Credit/Debit Net Credit/Debit Payments(C4) plus Credit/Debit Redunds(C7)
C9 Other Payments Total amount(including tax) given to you by customers by other payment methods such as gift card before refunds.
D1 NUMBER OF PAYMENTS  Payments number of payment transactions
D2 Refunds number of refund transactions
E1  ANALYTICAL DATA  Payment Average Unit Price Average unit price which calculated by:
Net Sales(A5) divided by Payments(D1)
E2 Items Number of purchased items minus number of refunded items
F1 CATEGORY      Name of Item Category Name of Item Category
F2 Total number of Item sold Total number of Item sold
F3 Total sales of each categories Total sales of each categories except modifier sales
*Modifier sales are not included.
F4    ∟Item name Item name
F5    ∟Total number of Item sold in each categories Total number of Item sold in each categories
F6    ∟Total sales of Item sold in each categories Total sales of Item sold in each categories

Other terms on CSV(Payment Details)

No Item Name Description
A Transaction No. The number set to each transaction
B Payment Date The date the payment is settled
C Payment Time The time the payment is settled
D Payment Status The status of the payment
E Cash Register ID The ID of the cash register
F Cashier Name The name of the cashier
G Modifier The Modifier used
H Price The price of the payment
I Quantity The number of the items

Sales By Item

No Item Name Description
A Category Category name
B Item Item name
C Detail1 Option name
D Detail2 modifier name
E Gross Sales

Total sales on each items except modifiers before discounts, gratuity and tax minusTotal refunded amount except modifiers on each items before discounts, gratuity and tax.

*Modifier sales are not included.

F Gross Sales Distribution ratio % Distribution ratio of each items in all gross sales.
G Item Sold Number of purchased items minus number of refunded items.
H Item Sold Distribution ratio % Distribution ratio of each items in all number of sold items.

TOP

No Item Name Description
A Net Sales/Payments Total Net Sales of the day
(sum of (C )Net Sales)
B Period date collection period (by hour)
C Net Sales Gross sales plus Refunds and Discounts on each hours
D No of Payments number of payment transactions
E  Average Unit Price Average unit price which calculated by:
Net Sales(C) divided by No of Payments(D)