Column Dictionary
|
Column Name |
Description |
Example |
|
Cart Discounts |
Discounts that apply to the entire order. When broken down by item, the total amount is proportionally applied to each item. |
10% off entire order (10% off each item). $10 off $20 order (50% off each item). |
|
Exclusive Tax |
Tax applied after the price of the item is calculated. |
|
|
Fees |
Convenience/Service fees applied after totals are calculated. This includes custom fee totals. |
|
|
Inclusive Tax |
Value-added tax that is included in the price of the item. This is often used to reclaim value-added taxes on costs/expenses from supplies. |
|
|
Item Discounts |
Discounts that apply to specific items. |
$5 off hamburger |
|
Item Quantity |
Total quantity of parent items sold. This does not include modifiers. |
|
|
Modifier Quantity |
Total quantity of modifiers sold. This does not include parent items. |
|
|
Orders |
Total number of unique orders/transactions. |
|
|
Refunds |
Total amount refunded. |
|
|
Subtotal |
The original price of the item (times) the quantity purchased. This total includes inclusive tax. |
|
|
Tips |
Total amount of tips added to orders. |
|
|
Total |
Subtotal (plus) exclusive tax (plus) tips (plus) fees (minus) refunds (minus) discounts. |
|
|
Total (No Tax) |
Subtotal (plus) tips (plus) fees (minus) refunds (minus) discounts. |
|
|
Total Discounts |
Cart-level discounts (plus) item-level discounts. |
|
|
Total Quantity |
item quantity (plus) modifier quantity |
|
|
Total Tax |
Inclusive tax (plus) exclusive tax |
|
Revenue
All Orders
The All Orders report displays all orders submitted for the selected date range..
This report is most often used to validate order-level details or used to validate against other reports.
- Subtotal
- Quantity
- Discounts
- Refunds
- Total (No Tax)
- Fees
- Tips
- Exclusive Tax
- Total
Discounts
The Discounts report displays a detailed breakdown of discounts by discount name, vendor name, category, item name, user name, and terminal ID. Total discounts is calculated by item-level discounts (plus) cart-level discounts.
This report is most often used to review total discounts by user or item at end-of-day.
Export to: Excel, CSV, PDF
Filters
- Start Date
- End Date
- Discount Name
- Venue ID
- Venue Name
- Vendor Name
- Category Name
- Item Name
- User Name
- Terminal ID
Sections
- Discount Name
- Vendor Name
- Primary Category
- Item Name
- User Name
- Terminal ID
Columns
- Number of Discounts
- Item Discounts
- Cart Discounts
- Total Discounts
Revenue
The Revenue report displays a detailed breakdown of payments by method of tender, vendor name, user name, and terminal ID. The total represents the total amount paid and should correlate with the total found on Sales by Item.
This report is most often used to review payment types, tips and fees, or collected taxes by vendor or user at end-of-day.
Export to: Excel, CSV, PDF
Filters
- Start Date
- End Date
- Venue ID
- Venue Name
- Vendor Name
- Method of Tender
- User Name
- Terminal ID
Sections
- Method of Tender
- Vendor Name
- User Name
- Terminal ID
Columns
- Orders
- Item Price
- Subtotal
- Refunds
- Discounts
- Total (No Tax)
- Exclusive Tax
- Fees
- Tips
- Total
Sales by Hour
The Sales by Hour report displays a detailed breakdown of sales by hour by primary category, item name, vendor name, user name, and terminal ID. Total is calculated by subtotal (plus) exclusive tax (plus) tips (plus) fees (minus) refunds (minus) discounts.
This report is most often used to review totals sales by item or vendor at end-of-day.
Export to: Excel, CSV, PDF
Filters
- Start Date
- End Date
- Venue ID
- Venue Name
- Vendor Name
- Primary Category
- Item Name
- User Name
- Terminal ID
Sections
- Hour
- Primary Category
- Item Name
- Vendor Name
- User Name
- Terminal ID
Columns
- Orders
- Item Price
- Item Quantity
- Subtotal
- Refunds
- Discounts
- Total (No Tax)
- Exclusive Tax
- Fees
- Tips
- Total
Sales by Item
The Sales by Item report displays a detailed breakdown of sales by primary category, item name, vendor name, user name, and terminal ID. Total sales is calculated by subtotal (plus) exclusive tax (plus) tips (plus) fees (minus) refunds (minus) discounts.
This report is most often used to review totals sales by item or vendor at end-of-day.
Export to: Excel, CSV, PDF
Filters
- Start Date
- End Date
- Venue ID
- Venue Name
- Vendor Name
- Primary Category
- Item Name
- User Name
- Terminal ID
Sections
- Primary Category
- Item Name
- Vendor Name
- User Name
- Terminal ID
Columns
- Orders
- Item Price
- Item Quantity
- Subtotal
- Refunds
- Discounts
- Total (No Tax)
- Exclusive Tax
- Fees
- Tips
- Total