The Payment Distribution Report is used to list all the amounts received as payments by charge type and its proportion of your revenue collected (accepted payments divided by payment method). By filtering the report criteria, you can see the details and transactions for each charge type that customers paid with during a selected date (excluding gift cards and packages that were redeemed), as well as their transaction information, items purchased, and their receipts.
Prerequisites: This feature is available for all Vagaro businesses. At least one customer transaction must have been processed on the Checkout screen.
Running this report on a phone shows a separate card for each payment type that customers paid with during the date range. Selecting a card will list the transaction details for each charge type in their own cards, and you can view and reprint receipts if necessary.
To run the Payment Distribution report:
-
Go to → → → .
-
At the top of the screen, select the Date Range of the report.
-
Optionally, select the Filters
button in the top-right corner of the screen to filter the contents of the report, then select Run Report:
-
Employees: Select the employees whose transactions to include, or select All Employees.
-
Customer: Select the customers to include in the report, or select All Customers.
-
Business Location: If your business has multiple locations, select the multi-location businesses or all locations in a group you want to review.
-
Include Past Employees: Whether to include transactions of past employees in the report.
-
Appts. From-To: Select the start and end dates of transactions that were paid for during the selected date range.
-
-
Optionally, select the card of a charge type to see the list transactions that customers paid for with that charge type.
Within that list, you can select a transaction's card to view its details.
Selecting each card will show the customer's receipt, which you can Print or Export (to download the receipt to be emailed to the customer) in the receipt's Action
menu.
-
Optionally, at any time after running the report, select the Action
-
Star or Remove Star: Add or remove a bookmark to this report in the Starred at the top of the → menu.
-
Print: Print your report if your device is connected to a printer.
-
Export PDF or Export Excel: Save the report to a PDF or Excel file.
-
Running this report on the web, tablet, Pay Desk, or PayPro lists the payment types that customers have paid with during the date range. Selecting a charge type will list the transaction details for each charge type in a sale summary, and you can view and reprint each of their receipts if needed.
To run the Payment Distribution report:
-
Go to → → .
-
At the top of the screen, set the filters for your report, then select Run Report.
-
Transaction Date: Select the start and end dates of the report, then select Submit.
-
Employees: Select any or all employees to include in the report.
-
Customer: Select the customers to include in the report, or select All Customers.
-
Advanced Filters: Optionally, select any additional filters to further refine the report.
-
Business Location: If your business has multiple locations, select the multi-location businesses or all locations in a group you want to review.
-
Prices Shown Include Point Deduction: Whether to show prices adjusted with point values already deducted.
-
Include Past Employees: Whether to include employees who no longer work at your business.
-
-
-
At the bottom of the screen, you can select:
-
Print: Get a hard copy of the report.
-
Export: Save the report to an Excel or PDF file (web version only).
-
-
To view a list of all the transactions and their receipts for a specific payment type, select its link in the Charge Type column.
In the charge type's summary report, you can also:
-
Sort the transactions by selecting the column headers.
-
Search for specific transactions by date, customer name, item sold, or transaction type in the Search bar in the top-left corner of the report.
-
Export
or Print
the employee's transactions.
-
Select Receipt at the end of a transaction's row to view, reprint, or send the receipt to the customer via email.
-
The following information is shown for each charge type:
-
Charge Type: Payment method customers paid with.
-
Amount: How much money was collected from customers who used this payment method.
-
Refunds: How much money was refunded to customers using this payment method.
-
Total: The net amount of money collected after refunds are subtracted from the amount.
-
Percentage: The portion of revenue collected from customers using this payment method.
Selecting a charge type in this report lists the transactions completed using that charge type in a Payment Distribution Summary report. Receipts can also be viewed, reprinted, and emailed, if available, by selecting the Receipts button.
When viewing the drill-through information about a service's or class's transactions, the report will show the following information for each sale, even if customers did not use all payment methods:
-
Transaction ID: The unique identification number of the transaction.
-
Business Name: The name of the business that the transaction was performed at.
-
Checkout Date: The date when the customer paid for the service or class. This date may differ from the Appointment Date.
-
Checkout By: The employee who performed the transaction. This employee may differ from the one listed for Sold By.
-
Appointment Date: The date of the customer's appointment or class.
-
Customer: The name of the customer.
-
Item Sold: The service or class that a customer paid for and the employee who performed it and will get a commission for it, if applicable.
-
Sold By: The employee who will get the commission for the sale, if applicable.
-
Quantity: The number of services or classes that the customer paid for.
-
Business Cost: How much it cost the business to perform the service or class. The amount is calculated as the (amount paid by business) minus the (amount customer paid).
-
Price: The amount that the business charges to perform the service or class.
-
Sales Tax(es) (if any have been set up): The amount of tax charged on top of the price.
-
Tip: The tip amount given to the employee by the customer.
-
Discount: The price reduction given to the customer when paying for the service or class. Some customers may have redeemed points, applied a promotional code, or paid with a package, membership, or Daily Deal.
-
Amount Paid: The total amount paid by the customer, after taxes and discounts, and including tips.
-
Shipping & Handling: The amount charged to the customer to ship items to the customer for the service or class, if applicable.
-
Cash: The amount that the customer paid with cash.
-
Check: The amount that the customer paid by check.
-
Gift Card: The amount that the customer redeemed with gift cards.
-
Package: The amount redeemed by the customer from a package.
-
Memberships: The amount the customer redeemed by the customer from a membership.
-
Credit Card: The amount the customer paid by credit card.
-
Bank Account: The amount that the customer paid from their bank account.
-
Venmo: The amount that the customer paid using Venmo.
-
Vagaro Pay Later: The amount that the customer paid with Vagaro Pay Later.
-
IOU/Invoice: The amount that the customer was issued an IOU for or invoiced.
-
Points: The number of points that the customer redeemed.
-
Net Sale: The revenue earned after discounts, points, packages, and memberships.
-
Merchant Account: The amount deposited into the employee's merchant account.
-
Change Due: The amount owed back to the customer after payment.
When viewing the drill-through information about a service's or class's transactions, the report will show the following information in a table for each sale, even if customers did not use all payment methods:
-
Business Name: The name of the business that the transaction was performed at.
-
Checkout Date, Checkout By, Transaction ID: When the transaction was performed, the employee who checked out the customer, and the identifying transaction number.
-
App. Date, Customer: The date of the customer's appointment or class, and the customer it was for.
-
Item Sold, Sold By: The service or class that a customer paid for and the employee who will get the commission, if applicable.
-
Qty: The number of services or classes that the customer paid for.
-
Business Cost: How much it cost the business to perform the service or class. The amount is calculated as the (amount paid by business) minus the (amount customer paid).
-
Price: The amount that the business charges to perform the service or class.
-
Sales Tax: The amount of tax charged on top of the price.
-
Tip: The tip amount given to the employee by the customer.
-
Disc: The price reduction given to the customer when paying for the service or class. Some customers may have redeemed points, applied a promotional code, or paid with a package, membership, or Daily Deal.
-
Amt Paid: The total amount paid by the customer, after taxes and discounts, and including tips.
-
Shipping & Handling: The amount charged to the customer to ship items to the customer for the service or class, if applicable.
-
Cash: The amount that the customer paid with cash.
-
Check: The amount that the customer paid by check.
-
GC: The amount that the customer redeemed with gift cards.
-
Pkg: The amount redeemed by the customer from a package.
-
Mbsp: The amount the customer redeemed by the customer from a membership.
-
Bank Account: The amount that the customer paid from their bank account.
-
Venmo: The amount that the customer paid using Venmo.
-
Vagaro Pay Later: The amount that the customer paid with Vagaro Pay Later.
-
IOU/Invoice: The amount that the customer was issued an IOU for or invoiced.
-
Points: The number of points that the customer redeemed.
-
Net Sale: The revenue earned after discounts, points, packages, and memberships.
-
Merchant Account: The amount deposited into the employee's merchant account.
-
Change Due: The amount owed back to the customer after payment.
Comments
1 comment
The payment distribution report does not add up correctly if a refund is included. It adds the tax on the refund and doesn't subtract it on the report. The totals also do not add up on the bottom if a refund is involved. Also as a side note you can not refund the tip if you refund an on-line appointment that is paid in advance.
Please sign in to leave a comment.