Breakdown of the first page of the DPR – Single Store
Overview
The Daily Performance Report (DPR) is used to view a summary of sales activity for a particular date, date range, week to date, or month to date. HungerRush highly recommends that owners and/or managers run this report daily, as it provides a perfect snapshot of all the information required for each business day. View daily sales & revenue, a labor summary, a payment summary, daily statistics, sales by order counts and totals by order type, sales by category, paid-ins, and paid-outs. We’ll be reviewing each segment of the DPR one at a time.
Daily Sales & Revenue
NAME | DESCRIPTION | CONFIGURATION/EXAMPLES | TECH SPECS | |
|---|---|---|---|---|
| 1 | Total Sales | The total amount collected for services/products sold during the defined reporting period. This could be considered the maximum amount of income before taxes and other income affecting numbers come into calculation | Total Sales is based on Orders, OrderGiftCards and OrderAdjustments tables. TotalSales = ActiveTotal + Adjustments + Coupons - DelvyFee - GiftCard - Grat ActiveTotal and Grat i.e., Gratuity are derived from Orders table. Adjustments is the difference between OrderAdjustment and ItemAdjustment. OrderAdjustment is AdjAmt from Orders table and ItemAdjustment is ActiveValue from OrderAdjustments when AdjType is 1. Adjustments = OrdAdjAmt – ItemAdjAmt Coupons is CpnAmt from Orders table. DelvyFee is Delivery Fee from Orders table. GiftCard is ActiveTotal from OrderGiftCards when IsCanceled is false. Grat is Gratuity and is derived from Orders table. | |
| 2 | Adjustments | Adjustments come from any price changes done through the Manager Function. | Adjustments is the difference between OrderAdjustment and ItemAdjustment. OrderAdjustment is AdjAmt from Orders table and ItemAdjustment is ActiveValue from OrderAdjustments when AdjType is 1. Adjustments = OrdAdjAmt – ItemAdjAmt | |
| 3 | Coupons | Coupons total comes from any price changes done through the use of the Coupons button located on the order screen. | Coupons is CpnAmt from Orders table. | |
| 4 | Gross Sales | The total amount of money received before deducting any taxes, production costs or overhead expenses. | Gross Sales completely rely on Orders and SystemConfigurations tables. Gross Sales = Total Sales - Adjustments - Coupons GrossSales = ActiveTotal – DeliveryFee – GiftCard - Grat ActiveTotal and Grat i.e., Gratuity are derived from Orders table. DeliveryFee is derived from DlvyFee of Orders table when Include Del Fee (IncDelFee) from SystemConfigurations is false. GiftCard is ActiveTotal from OrderGiftCards when IsCanceled is false. | |
| 5 | Tax | Displays the total Taxes that have been charged for products or services | Tax is the combination of Tax from Orders table and TaxAmt from OrderTaxes table. Tax = OrdTax + NonTax | |
| 6 | Net Sales | The total amount of money you received before deducting, production costs, overhead expenses, but after deducting taxes | Net Sales is Gross Sales without Tax. NetSales = ActiveTotal - DeliveryFee – GiftCard - Grat – Tax NetSales = GrossSales - Tax | |
| 7 | Tax | Section 7 through 13 are different areas that can affect the total take home amount. | ||
| 8 | Gift Cards | Adds in the gift card(s) sold | Gift Cards is GiftCardAmt and is based on ActiveTotal field from OrderGiftCards table only when IsGameCard is set to false. | |
| 9 | Delivery Fees | Adds in the additional Delivery fees collected | Delivery Fees is computed from DelvyFee from Orders table. | |
| 10 | Delivery Comps | Removes the amount taken out to pay for a driver’s delivery compensation. | Delivery Comps or Deliv Comp is DelComp comes from the CashDrawers table. | |
| 11 | Cash Receipts | Additional money paid in. Usually due to drivers’ returning their starting banks or account holders paying off their account balances. | Cash Receipts is also called Cash PaidIns and is based out of Amt field of CashPayRec table when TransType is 1. | |
| 12 | Cash Paidouts | Money removed from your total receipts for the day. This could be paid outs for driver banks or buying additional items using the cash draw’s starting amounts. | Cash Paid Outs is difference of Amt field of CashPayRec table when TransType is 0 and DelComp from CashDrawers when EmpCashoutToDwr from SystemConfiguration is true. Cash Paid Out = CashPayOuts – EmpDelComp CashPayOuts is Amt field of CashPayRec table when TransType is 0. EmpDelComp is DelComp from CashDrawers when EmpCashoutToDwr from SystemConfiguration is true. | |
| 13 | Other Income | Some companies payout their tips on payroll so this section helps tracks the income form tips that will be later distributed to an employee’s paycheck | Other Income is an aggregation of Grat from Orders table when GartPayroll from SysConfiguration is true, Tip and PreAuthTip from OrderPayments when CCTipsPayroll from SysConfiguration is true, and Contractor Tips when the Employee Type = Contractor (1) & CC Tips on Payroll = False Other Income = Grat + Tip + PreAuthTip + Contractor Tips | |
| 14 | Total Receipts | Total Receipts include all sales of your main product and additional income from other sources. | Total Receipts is a combination of various components and computed as shown below. TotalReceipts = NetSales + CashReceipts + GiftCardAmt + GameCardAmt - CashPayOuts + Tax + TipGrat + DeliveryFee + EmpDrvDelComp + Contractor Tips CashReceipts is also called Cash Paid Ins and is Amt field of CashPayRec table when TransType is 1. GiftCardAmt is ActiveTotal from OrderGiftCards table only when both IsCanceled and IsGameCard are false. GameCardAmt is ActiveTotal from OrderGiftCards table when IsCanceled is false and IsGameCard is set to true. CashPayOuts is Amt field of CashPayRec table when TransType is 0. Tax is the combination of Tax from Orders table and TaxAmt from OrderTaxes table. Tax = OrdTax + NonTax TipGrat is also called Other Income. DeliveryFee is derived from DlvyFee of Orders table when Include Del Fee (IncDelFee) from SystemConfigurations is false. EmpDrvDelComp is Employee Driver Del Comp is based on DelComp from CashDrawers table when both EmpCashoutToDwr and DrvCompPayroll from SystemConfigurations table is true. Or -DelComp from CashDrawers table when both EmpCashoutToDwr and DrvCompPayroll from SystemConfigurations table is false. Contractor Tips is when the Employee Type = Contractor (1) & CC Tips on Payroll = False |
Labor Totals
This section compares labor cost to Net and Gross sales and provides a percentage.
NAME | DESCRIPTION | TECH SPECS | |
|---|---|---|---|
| 1 | Labor Type | The Labor types that have clocked in for that day | This is a sub report and details are available in Payroll Detail Report. |
| 2 | Cost | The cost of that labor cost for each job type | |
| 3 | Net Labor% | Net Labor compares your Net Sales versus Labor Cost | |
| 4 | Gross Labor% | Gross Labor compares your Gross Sales versus Labor Cost |
Payment Summary
Above # | NAME | DESCRIPTION | CONFIGURATION/EXAMPLES | TECH SPECS | |
|---|---|---|---|---|---|
| 1 | 1 | Gross Cash | Gross cash represents all the cash receipts acquired in business. | Gross Cash is a combination of various components and computed as shown below. Gross Cash = CashActual + PayrollTips + PayrollGrats - DriverStartAmt + CashDrop CashActual is from CashDrawers table when CashoutToDwr is 0. PayrollTips is Tips from Orders table when CCTipsPayroll from SystemConfigurations is false. PayrollGrats is Grats from Orders table when GratPayroll from SystemConfigurations is false. DriverStartAmt is StartingAmt from CashDrawers table when CDType is 1 CashDrop is Cash field from CashDrawerDrops when ToCDKey is 0. | |
| 2 | 2 | Tips Paid Out | Tips that are debited towards your cash on hand. Usually from credit card tips. | Tips Paid Out is Tip from Orders table. | |
| 3 | 3 | Grats Paid Out | Gratuities that are debited towards your cash on hand. Only pulls tips created through the gratuity function. | Grats Paid Out is Grat from Orders table. | |
| 4 | 4 | Net Cash | The amount of cash-on-hand claimed after subtracting current liabilities. | Net Cash is an aggregation of two components i.e., CashActual and CashDrop. NetCash = CashActual + CashDrop CashActual is from CashDrawers table when CashoutToDwr is 0. CashDrop is Cash field from CashDrawerDrops when ToCDKey is 0. | |
| 5 | 5 | Created Payments | Other additional payment types collected. This is commonly from checks and other non-standard froms of payments that the establishment collects. | ||
| 6 | 6 | Cash & Other / Cash & Checks | The total amount of cash and other forms of payment | This is Net Cash plus either Tendered or Amount from OrderPayments table depends on which one is greater when PaymentTypeCategory is Check. Cash & Other / Cash & Checks = NetCash + Tendered/Amount | |
| 7 | 7 | Other | Other is defined by ChecksActual from CashDrawers when CashoutToDwr is 0. | ||
| 8 | 8 | Credit Card Totals | This section list Credit Card Totals and the totals are also broken down into their respective card types. | Credit or Credit Card Total is Amount from OrderPayments when PaymentTypeCategory is Credit. | |
| 9 | 9 | Gift | Active Gift Cards that were used to purchase your products. | Gifts is GiftCertActual from CashDrawers table when CashoutToDwr is 0. | |
| 10 | 10 | Customer Acct | Customers with active accounts that have purchased products and charged it to their account as their payment method. | Customer Acct or Acct is AcctActual from CashDrawers table when CashoutToDwr is 0. | |
| 11 | 11 | Total Payments | Total payments is the cumulation all payment methods collected to Revention POS through out the selected reporting period. | Total Payments or Total is combination of components as shown below. Total = CashActual + ChecksActual + Credit + GiftCertActual + AcctActual + CashDrop - ChecksOver CashActual is from CashDrawers table when CashoutToDwr is 0. ChecksActual is from CashDrawers table when CashoutToDwr is 0. Credit is Amount from OrderPayments when PaymentTypeCategory is Credit. GiftCertActual comes from CashDrawers table when CashoutToDwr is 0. AcctActual also comes from CashDrawers table when CashoutToDwr is 0. CashDrop is Cash field from CashDrawerDrops when ToCDKey is 0. ChecksOver is difference of AmountPaid and ActiveTotal from Orders table PaymentTypeCategory from OrderPayments is Check and count of check is less than 2. | |
| 12 | 12 | Total Receipts | Total amount collected from all money sources. This is the cumulation all cashouts and reconciled drawers. | Total Receipts is a combination of various components and computed as shown below. TotalReceipts = NetSales + CashReceipts + GiftCardAmt + GameCardAmt - CashPayOuts + Tax + TipGrat + DeliveryFee + EmpDrvDelComp + Contractor Tips CashReceipts is also called Cash Paid Ins and is Amt field of CashPayRec table when TransType is 1. GiftCardAmt is ActiveTotal from OrderGiftCards table only when both IsCanceled and IsGameCard are false. GameCardAmt is ActiveTotal from OrderGiftCards table when IsCanceled is false and IsGameCard is set to true. CashPayOuts is Amt field of CashPayRec table when TransType is 0. TipGrat is also called OtherIncome. DeliveryFee is derived from DlvyFee of Orders table when Include Del Fee (IncDelFee) from SystemConfigurations is false. EmpDrvDelComp is Employee Driver Del Comp is based on DelComp from CashDrawers table when both EmpCashoutToDwr and DrvCompPayroll from SystemConfigurations table is true. Or -DelComp from CashDrawers table when both EmpCashoutToDwr and DrvCompPayroll from SystemConfigurations table is false. Contractor Tips is when the Employee Type = Contractor (1) & CC Tips on Payroll = False | |
| 13 | 13 | Over/Short | The discrepancy between Total Payments and Total Receipts. Usually caused by an overage or shortage in one or more cash drawers. | Over/Short is defined by difference of Total Payments and Total Receipts. | |
| 14 | 14 | Dep.Cash | Section 13 to 24 are optional and not standard on all Daily Performance Reports. This section is only displayed when a deposit is created. Deposits are important to ensure the amount being deposited is the same as amount recorded by your staff members using Revention. Dep Cash refers to the total amount of cash that was declared after all the cash reconciles were completed and then added together | Dep Cash is based on Deposits and Orders tables. It is the difference between CashAct from Deposits table and ActiveTotal from Orders table. Dep Cash = CashAct - ActiveTotal | |
| 15 | 15 | Dep. Other | Dep Other refers to the total amount of alternate form of payments that was declared after all the payment reconciles were completed and then added together | Dep Other is called Dep Check. It is derived from ChecksAct field of Deposits table. | |
| 16 | 16 | Cash & Other | Combination of both Dep. Cash and Dep. Other | Cash & Other is sum of Dep Cash and Dep Other. | |
| 17 | 17 | Dep. Credit | Dep Credit refers to the total amount of Credit Cards that was declared after all the payment reconciles were completed and then added together | Dep Credit is CreditAct from Deposits table. | |
| 18 | 18 | Gift | Gift refers to the total amount of Gift Card of payments that was declared after all the payment reconciles were completed and then added together | Gift is also called Dep Gift and is GiftAct from Deposits table. | |
| 19 | 19 | Customer Acct | Customer Acct refers to the total amount of Account payments that was declared after all the payment reconciles were completed and then added together | Customer Acct is also known as Dep Acct and is AcctAct from Deposits table. | |
| 20 | 20 | Total Deposits | Total of all deposited payments added together.. | Total Deposits or Dep Total is the difference of TotalAct from Deposits table and ActiveTotal from Orders table. | |
| 21 | 21 | Total Payments | This total comes directly from the Total Receipts above and is the cumulation of each drawers close out totals | Total Payments / Total is a combination of individual components as shown below. Total = CashActual + ChecksActual + Credit + GiftCertActual + AcctActual + CashDrop - ChecksOver CashActual is CashActual field from CashDrawers when CashoutToDwr is 0. ChecksActual is from CashDrawers when CashoutToDwr is 0. Credit is Amount from OrderPayments when PaymentTypeCategory is Credit. GiftCertActual is from CashDrawers when CashoutToDwr is 0. AcctActual is from CashDrawers when CashoutToDwr is 0. CashDrop is Cash from CashDrawerDrops when ToCDKey is 0. ChecksOver is difference of AmountPaid and ActiveTotal from Orders table PaymentTypeCategory from OrderPayments is Check and count of check is less than 2. | |
| 22 | 22 | Over/Short | Displays the difference between the Total Deposits ad Payments. | Over/Short is difference between DepTotal and Total. Over/Short = DepTotal - Total | |
| 23 | 23 | Payments O/S | Compares between Total Payments (What a users told Revention POS was collected) to the Total Receipts (What was actually in the cash drawers after being reconciled) | Payment O/S is difference of Total and TotalReceipts. Payment O/S = Total - TotalReceipts | |
| 24 | 24 | Effective O/S | Takes Payment O/S and the Over/Short to dislay the total differences . | Effective O/S is an aggregation of Payment O/S and Over/Short. Effective O/S = Payment O/S + Over/Short Effective O/S = DeptTotal - TotalReceipts |
Daily Stats and Order Types
This section gives a quick rundown of orders and important key performance indicators.
NAME | DESCRIPTION | TECH SPECS | |
|---|---|---|---|
| 1 | Total Orders | Tracks the total amount of orders take for this reporting period | Total Orders is count of orders from Orders table, subtracting the voided orders from OrderAdjustments table. Total Orders = OrdCnt - Voids |
| 2 | Lowest Order | The lowest ticketed amount for this reporting period | Lowest Order is lowest ActiveTotal from Orders table excluding Adjustment Orders or Voided Orders (i.e., ActiveTotal is greater than 0). |
| 3 | Highest Order | The highest ticketed amount for this reporting period | Highest Order is highest ActiveTotal from Orders table. |
| 4 | Average$/Ord | The average amount spent per order | Average Order is Net Sales divided by Total Orders. |
| 5 | Voided Orders / Voids | The amount of orders that contained voided items | Voided Orders or Voids is count of voided orders from OrderAdjustments table when both AdjType and AdjScope is 1. |
| 6 | Guest Count | The guest count for the selected reporting period | Guest Count is GuestCount field from Orders table. |
| 7 | Ord # | The order number associated with the lowest order | Lowest Order is the Order Number associated to lowest ActiveTotal from Orders table excluding Adjustment Orders or Voided Orders (i.e., ActiveTotal is greater than 0). |
| 8 | Ord # | The order number associated with the highest order | Highest Order is the Order Number associated to highest ActiveTotal from Orders table. |
| 9 | PPA | Per Person Average takes the amount of Guest and divides it by your total sales. Gives an idea of what an average customer spends at your business | PPA is defined by Net Sales divided by Guest Count. |
NAME | DESCRIPTON | TECH SPECS | |
|---|---|---|---|
| 1 | Order Type | List of each order types that were order | Order Type is OrderType field from OrderTypes table. |
| 2 | Count / Cnt | This column displays the count of order types sold | Count or Cnt is the count of orders for each OrderType from Orders table. |
| 3 | Total | The net amount of collected via this order type and displays the totals in ascending order. | Total is NetSales by each OrderType. |
| 4 | % | The percentage this order type makes up of the total net sales | % is also called NetSales % for each Order Type and is defined by the NetSales of individual Order Type upon sum of NetSales of all order types. |
Sales by Category
NAME | DESCRIPTION | TECH SPECS | |
|---|---|---|---|
| 1 | Category | The sold item’s report groups are displayed here followed by the number of times the report group was ordered from. | Category is ReportCatName from ReportCategories table. |
| 2 | Qty | Qty is the count of each individual Report Category or ReportCatName. | |
| 3 | Total | The Gross sale amount of the report group. | Total is also called TotalSales and is summation of Coupon from OrderItems, O and Tax Excluded Price. Total / Total Sales = Coupon + Tax Excluded Price Coupon is an aggregation of Adj Amt and Cpn Amt fields from OrderItems, OrderItemModifiers and OrderItemPreferenceMembers. Coupon is also ActiveValue from OrderCoupons when CpnScope is 1 or 3. Coupon=Adj Amt + Cpn Amt + ActiveValue Tax Excluded Price = Tax Excluded Price (OrderItems) + Tax Excluded Price (OrderItemModifiers) + Tax Excluded Price (OrderItemPreferenceMembers) + Tax Excluded Price (OrderCoupons) Tax Excluded Price (OrderItems) is difference of ActivePrice from OrderItems and TaxRate from MenuTaxType times ActivePrice from OrderItems (TaxRate x ActivePrice) when both TaxIncluded and TaxFullPrice is true. Otherwise, Tax Excluded Price can be ActivePrice from OrderItems upon TaxRate from MenuTaxType plus 1 (1 + TaxRate ) when TaxIncluded is true and TaxFullPrice is false. Else it is ActivePrice from OrderItems. Tax Excluded Price = (ActivePrice - TaxRate x ActivePrice) OR ActivePrice / (TaxRate + 1) OR ActivePrice Similarly, Tax Excluded Price from OrderItemModifiers and Tax Excluded Price from OrderItemPreferenceMembers are calculated. |
| 4 | Disc | The discounted amount attributed to the report group. | Disc is Discount or Coupon and is represented as an aggregation of Adj Amt and Cpn Amt fields from OrderItems, OrderItemModifiers and OrderItemPreferenceMembers; Plus, ActiveValue from OrderCoupons when CpnScope is 1 or 3. Coupon=Adj Amt + Cpn Amt + ActiveValue |
| 5 | Net | The Net sale amount of the report group | Net is simply a Tax Excluded Price. |
| 6 | % | The percent this report group makes up of the total net sales. | % is defined as Total or TotalSales for an Individual Category upon Total of All Categories. % = (TotalSales for an Individual Category / TotalSales of All Categories) * 100 |
Paid-Outs/Paid-Ins
NAME | DESCRIPTION | TECH SPECS | |
|---|---|---|---|
| 1 | Acct Cat | Account Categories are user created labels that helps staff quickly identify a paid out/in’s specific purpose. | Acct Cat is Name field from AccountingCategories table when AcctCatKey is not 0, otherwise None when Description is not “DRIVER Bank” and not “DRIVER Comp%”. |
| 2 | Description | Once a paid out/in is created, Revention provides a field to input a brief description of the event. | Description comes from CashPayRec. |
| 3 | Amt | Amount attributed to the corresponding paid out/in | Amt is defined by negative of Amt field of CashPayRec table when TransType is 0 else Amt field from CashPayRec. |
| 4 | By | Employee responsible for issuing the paid out/in | By is CreatedBy field from CashPayRec table. |
| 5 | Time | Timestamp of when the transaction occurred | Time is CreateTime from CashPayRec. |
Calculations
Total Sales is a backwards calculation of the 4 below values
Adjustments (NOT VOID) = sum of comps + percent off
Coupons = sum of Ord.Cpn
Delivery fee = sum of Ord.DlvyFee
tax = sum of Ord.tax
Gross Sales = sum of Ord.ActiveTotal - sum of OrdGC.activeTotal
Gift Cards = sum of OrdGC.activeTotal
Delivery Comp = sum of CashDrawer.delComp
Tax = sum of Ord.tax
Cash Receipts = sum of CashPayRec.Amt where CashPayRec.TransType = 1
Cash Paidouts = sum of CashPayRec.Amt where CashPayRec.TransType = 0
Other Income = CC tips thru payroll
Comments
0 comments
Article is closed for comments.