Establishment Payments Report

By Kelsey | Updated

Follow

Note: this article refers in part to features in our latest software version, which you may not be using yet. Not to worry, though—your Management Console will automatically upgrade to the newest version over the next few weeks.

Want a sneak peek at the new version? Sign up for our beta program today!

Overview

This report is used mainly by business owners with multiple establishments to view a condensed version of the Sales Summary report for each establishment. It's also used for chain or franchise owners who collect a percentage of payments for royalties.


Contents


Locate and Filter Establishment Payments Report

Locate

  1. Log into your Management Console (yourdomain.revelup.com and click the Reports link from the menu at the top of the page.
  2. Hover your mouse over the Other Reports link on the right-hand side of the page and select Establishment Payments from the menu that appears.

Filter

  • Date Range: Click the date section in the report and select the date range you want to view the report from and click Apply to view the report:
  • Filters button: Click this to choose Inclusions settings:
  • icon: Click this to export your report in various formats:
  • Aggregate View: By default, the report will show in Aggregate view. This shows the totals of all days within the date range you selected:
  • By Day View: Click the Aggregate View button and select By Day View from the menu. This will show all fields separated by the day the transaction was completed:

Establishment Payments Report Tour

There are two ways to view your Establishment Payments Report, the Basic view that shows a limited amount of fields and the All view that shows all available fields for the report.


Basic View Details

By default, the report will show the Basic View details. This shows the most often used columns of the report.

Basic Columns Drop-Down: Use this drop-down menu to view your report by basic columns or all columns:

  • % of Total Payments: Use this to select the percentage of total payments you'd like to view:
  • Establishment: The specific establishment.
  • Gross Sales: Total discounts applied. Includes item discounts, order discounts, and exchange discounts.
  • Total Discounts: Total amount of discounts.
  • Net Sales: Total sales less discounts. Pre-tax.
  • Total Taxes: Total taxes.
  • Total Liabilities: Total activity affecting liabilities. Both activities that increase liabilities (including the sale of gift cards or the taking of a deposit on an invoice) and activities that decrease liabilities (including the use of gift cards or payments against house accounts).
  • Total Payments: Total of all payments, including refunds and excluding tips.
  • % of Total Payments: The percent of total payments based on the amount entered in the above filter.
  • Total Transactions: The number of orders opened during the reporting period.
  • Total Invoices: The number of invoices opened during the reporting period

All View Details

To view all columns, click the Basic Columns link and select All from the drop-down menu. This will generate additional columns for the report. Scroll to the right to view the additional columns:

All Columns drop down: Use the drop-down menu to select All.

  • Taxable Sales: The total amount of sales subject to tax.
  • Non-Taxable Sales: The total amount of sales not subject to tax.
  • Taxable Service Fees: Total amount of service fees subject to tax.
  • Non-Taxable Service Fees: Total non-taxable service fees.
  • Shipping and Handling: The total amount of shipping and handling fees charged.
  • CRV Charges: Total CRV (California Redemption Value) charges.
  • Average Check: Average per order.
  • Gross Sales: Total discounts applied. Includes item discounts, order discounts, and exchange discounts.
  • Item Discounts: Discounts applied to products.
  • Order Discounts: Discounts applied to orders.
  • Coupons: Total coupons applied.
  • Total Discounts: Total discounts applied. Includes item discounts, order discounts, and exchange discounts.
  • Net Sales: Total sales less discounts. Pre-tax.
  • Surcharges: Total surcharges collected. Reflects voids/ returns and all discounts.
  • Taxes: Total taxes.
  • CRV Charges (included to sales): Total CRV (California Redemption Value) charges.
  • Total Taxes: Total taxes.
  • Payments Against House Accounts: All payments, including refunds, made against house accounts.
  • Gift Cards: Total of gift cards sold.
  • Gift Cards Redeemed: Total of gift cards redeemed.
  • Store Credit Accrued: Total of store credit given.
  • Store Credit Redeemed: Total of store credit redeemed.
  • Deposits: Total deposits made to invoices.
  • Applied Deposits: Total deposits applied to invoices.
  • Donations: Total donations.
  • Total Liabilities: Total activity affecting liabilities. Both activities that increase liabilities (including the sale of gift cards or the taking of a deposit on an invoice) and activities that decrease liabilities (including the use of gift cards or payments against house accounts).
  • Net To Account For: Total of Net Sales + Taxes + Liabilities.
  • Payments: Total payments collected.
  • Refunds: Total value of all refunded payments.
  • Cash: Total amount of cash payments.
  • Debit: Total debits.
  • Total Payments: Total payments collected.
  • % of Total Payments: Use this to select the percentage of total payments you'd like to view:
  • Payins Number: Total number of payins.
  • Payouts Number: Total number of payouts.
  • Payins Total: Total number and value of payins to the till.
  • Payouts Total: Total number and value of payouts to the till.
  • Actual Total Cash to Business: All cash payments made to the business.
  • Total Invoices: The number of invoices opened during the reporting period.

For more information on payments reporting, check out our article Payment Summary Report.



Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request
Want to request a new feature? Click here!
Still have questions? Contact our friendly Support team