Enterprise Beta Reports for Appetize

Last updated
Save as PDF

Description: Learn about various Enterprise Beta Reports for Appetize systems.

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 is applied after the price of the item is calculated.
Fees	Convenience/Service fees are 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 are 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, and 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, and 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 total 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 are calculated by subtotal (plus) exclusive tax (plus) tips (plus) fees (minus) refunds (minus) discounts.

This report is most often used to review total sales by item or vendor at end-of-day.

Export to: Excel, CSV, and 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