At the top of the Transaction List report, you can expand the Money Earned / Drawer Balance heading to display a panel. This panel shows you a quick summary of how much money you've earned for the current day and all of the transactions your business has processed so far. The panel will always show Today's Cash Drawer Balance, but the amounts for Money Earned, Redeemed, and Sales will be updated if you run this report to show the amounts for the date range selected.
The Transaction Summary panel is divided into four sections:
-
Today's Cash Drawer Balance: The total amount of cash, including bills and coins, that are currently in the cash drawer. These amounts will always show only what's in the till for today.
-
Money Earned: How much your business has earned from in-house or online sales transactions, excluding redemptions using a membership, package, or gift cards.
-
Redeemed: The amount of payments customers have made using memberships, packages, and gift cards towards the Amount Due total, excluding points and gift cards.
-
Sales: This total amount of sales made in-house or online, excluding points redeemed and redemptions using a membership, package, or gift cards.
Prerequisites: This feature is available for all Vagaro businesses.
To view the Transaction List summary:
-
Go to → → → . The system automatically runs the report for today's transactions.
-
Expand the Money Earned / Drawer Balance heading to view a summary of today's amounts.
-
Optionally, run the Transaction List report to view your Money Earned for a selected date range.
To view the Transaction List summary:
-
Go to → → . The system automatically runs the report for today's transactions.
-
Expand the Money Earned / Drawer Balance heading to view a summary of today's amounts.
-
Optionally, run the Transaction List report to view your Money Earned for a selected date range.
Each section in the Transaction Summary panel is always visible when the panel is displayed.
Today's Cash Drawer Balance breaks down the total value of bills and coins currently in your cash drawer, including the opening balance if it was entered, the total amount of cash collected, how much was refunded, and how much was given back in change.
For example, if the customer's service cost $18 and pays with a a $20 bill, $2 in change will be given back. Cash Collected will include $20, and Change Given will include $2.
The following amounts are listed in this section:
|
Description |
Calculation |
|
|---|---|---|
|
Set by the business each day |
Entered at the beginning of the day |
|
|
Total legal tender collected, including taxes, tips, and fees |
Gross cash total |
|
|
Cash Refunds |
Total refunds given as cash (displayed as a negative value) |
Total cash refunded |
|
Change Due |
Total legal tender given as change during cash transactions (displayed as a negative value) |
Change given from cash drawer |
|
Current Balance |
Current total amount of money is in the cash drawer |
(opening balance + cash collected) - (cash refunds + change given) |
This overview shows how much revenue was earned from in-house or online sales transactions. The totals include refunds and change given in cash transactions, and exclude redemptions using a membership, package, or gift cards.
The following amounts are listed in this section:
|
Payment Type |
Description |
Calculation |
|---|---|---|
|
Money earned from cash transactions, including taxes, tips, and fees |
(Total Cash) - (Cash Refunds) + (Cash Change Due) |
|
|
Money earned from credit card transactions, including taxes, tips, and fees |
(Total Credit Card payments) - (Credit Card Refunds) |
|
|
Money earned from check transactions, including taxes, tips, and fees |
Total check amounts paid |
|
|
Rent collection via ACH payments |
Total rent collected by ACH |
|
|
Money earned from VPL transactions, including taxes, tips, and fees |
(Total VPL Payments) - (VPL Refunds) |
|
|
Money earned from other payment method transactions, including taxes, tips, and fees |
(Total Other Payments) - (Other Payment Refunds) |
|
|
Total |
Total value of all payments collected |
Total of all categories |
For example, if the customer's service costs $30, plus $5 tax and a $5 tip, for a total amount of $40:
-
Scenario 1: The customer pays $50 in cash and receives $10 back in change. In the Money Earned section, Cash will include $40 for the service, tax, and tip.
-
Scenario 2: The customer pays $50 using a Credit Card, Check, or Other Payment Method, and receives $10 change in cash. In the Money Earned section, Payment Method will include the full $40 payment, but Cash will show ($10) because it was given back as change.
This section shows the total amount of payments using memberships, packages, and gift cards towards the Amount Due total. Redeemed totals do not count towards the totals in the Sales section, and gift cards issued as a refund will be deducted from the Gift Cards total in the Sales section.
The following amounts are listed in this section:
|
Redemption Method |
Description |
Calculation |
|---|---|---|
|
Amount discounted or value of the visits allowed by memberships to pay an Amount Due, including refunds; excludes taxes, tips, fees, and shipping |
(membership visits or discount amount) - minus the (refunded amounts for items paid for with a membership) |
|
|
Value of the visits that were redeemed using a package to pay an Amount Due |
(total package visits) - (refunded amounts for items paid using package visits) |
|
|
Includes:
|
(total of gift cards redeemed) - (refunds issued as a gift card) |
|
|
Total |
Total amount of payments redeemed using memberships, packages, and gift cards |
Total of all categories |
For example, if the customer's service costs $30, plus $5 tax and a $5 tip, for a total amount of $40:
-
Scenario 1: The customer pays with a membership or package. In the Redeemed section, Membership or Package will include $30, and in the Money Earned section, $10 (tax and tip) will be included in the line for the corresponding payment method. If the customer receives a refund, $30 will be subtracted from Membership or Package in the Redeemed section.
-
Scenario 2: The customer pays with a membership that grants a 50% discount for the service, In the Redeemed section, Membership will include $15 (which is 50% of $30), and in the Money Earned section, $10 (tax and tip) will be included in the line for the corresponding payment method. If the customer receives a refund, only $15 will be subtracted from Membership from the Redeemed section.
-
Scenario 3: The customer pays with a $20 gift card and $20 with cash. In the Redeemed section, Gift Card will include $20, and in the Money Earned section, Cash Collected will include $20.
-
Scenario 4: The customer pays with a service-based gift card. In the Redeemed section, Gift Card will include $30, and in the Money Earned section, $10 (tax and tip) will be included in the line for the corresponding payment method.
-
Scenario 5: The customer receives a $30 gift card as a refund. In the Redeemed section, Gift Cards will include ($30).
This section lists the amounts made for sales items both in-house or online. These totals do not include points redeemed for products, business costs, or redemptions using a membership, package, or gift cards.
The following amounts are listed in this section:
|
Sales Item |
Description |
Calculation |
|---|---|---|
|
Total from sales of services and service add-ons; excludes business costs, taxes, tips, and fees |
||
|
Total from sales of classes and class add-ons; excludes business costs, taxes, tips, and fees |
||
|
Total from sales of products, including discounts and refunds; excludes business costs, taxes, tips, and fees |
(Online product sales + In-House product sales) - (Tax + Tip + Fees + Membership discount + product discount + product refunds) |
|
|
Total from sales of gift cards, including discounts and refunds; excludes costs, taxes, tips, and fees |
(Gift Card sales) - (Tax + Tip + Fees + discounts + gift card refunds) |
|
|
Total from sale of memberships, including discounts and refunds; excludes business costs, taxes, tips, and fees |
(Membership sales) + (Tax + Tip + Fees + discounts + membership purchase refunds) |
|
|
Total from sale of packages, including discounts and refunds; excludes business costs, taxes, tips, and fees |
(Package sales) + (Tax + Tip + Fees + discounts + membership purchase refunds) |
|
|
Total rent collected |
||
|
Commission (deducted from rent) |
Commission total from services, classes, and products; based on payroll (displayed as a negative number) |
Commission based on payroll total |
|
All taxes collected, including refunded taxes |
(Taxes collected) - (Refunded taxes) |
|
|
All fees collected, including refunded fees |
(Fees collected) - (Refunded fees) |
|
|
All tips collected, including refunded tips |
(Tips collected) - (Refunded tips) |
|
|
All IOUs issued (displayed as a negative number) |
||
|
All outstanding IOUs that were paid |
||
|
Total |
Total of all amounts in this section. |
Total of all categories |
For example, if the customer's service costs $30, plus $5 tax and a $5 tip, for a total amount of $40:
-
Scenario 1: In the Sales section, Sales & Add-ons will include $30, Tips will include $5, and Tax will include $5.
-
Scenario 2: The customer receives a $10 discount, so in the Sales section, Sales & Add-ons will include $only 30; Tips will include $5, and Tax will be adjusted accordingly to the business's tax settings.
Each section in the Transaction Summary panel is always visible when the panel is displayed.
Today's Cash Drawer Balance breaks down the total value of bills and coins currently in your cash drawer, including the opening balance if it was entered, the total amount of cash collected, how much was refunded, and how much was given back in change.
For example, if the customer's service cost $18 and pays with a a $20 bill, $2 in change will be given back. Cash Collected will include $20, and Change Given will include $2.
The following amounts are listed in this section:
|
Description |
Calculation |
|
|---|---|---|
|
Set by the business each day |
Entered at the beginning of the day |
|
|
Total legal tender collected, including taxes, tips, and fees |
Gross cash total |
|
|
Cash Refunds |
Total refunds given as cash (displayed as a negative value) |
Total cash refunded |
|
Change Given |
Total legal tender given as change during cash transactions (displayed as a negative value) |
Change given from cash drawer |
|
Current Balance |
Current total amount of money is in the cash drawer |
(opening balance + cash collected) - (cash refunds + change given) |
This overview shows how much revenue was earned from in-house or online sales transactions. The totals include refunds and change given in cash transactions, and exclude redemptions using a membership, package, or gift cards.
The following amounts are listed in this section:
|
Payment Type |
Description |
Calculation |
|---|---|---|
|
Money earned from cash transactions, including taxes, tips, and fees |
(Total Cash) - (Cash Refunds) + (Cash Change Due) |
|
|
Money earned from credit card transactions, including taxes, tips, and fees |
(Total Credit Card payments) - (Credit Card Refunds) |
|
|
Money earned from check transactions, including taxes, tips, and fees |
Total check amounts paid |
|
|
Rent collection via ACH payments |
Total rent collected by ACH |
|
|
Money earned from VPL transactions, including taxes, tips, and fees |
(Total VPL Payments) - (VPL Refunds) |
|
|
Money earned from other payment method transactions, including taxes, tips, and fees |
(Total Other Payments) - (Other Payment Refunds) |
|
|
Total |
Total value of all payments collected |
Total of all categories |
For example, if the customer's service costs $30, plus $5 tax and a $5 tip, for a total amount of $40:
-
Scenario 1: The customer pays $50 in cash and receives $10 back in change. In the Money Earned section, Cash will include $40 for the service, tax, and tip.
-
Scenario 2: The customer pays $50 using a Credit Card, Check, or Other Payment Method, and receives $10 change in cash. In the Money Earned section, Payment Method will include the full $40 payment, but Cash will show ($10) because it was given back as change.
This section shows the total amount of payments using memberships, packages, and gift cards towards the Amount Due total. Redeemed totals do not count towards the totals in the Sales section, and gift cards issued as a refund will be deducted from the Gift Cards total in the Sales section.
The following amounts are listed in this section:
|
Redemption Method |
Description |
Calculation |
|---|---|---|
|
Amount discounted or value of the visits allowed by memberships to pay an Amount Due, including refunds; excludes taxes, tips, fees, and shipping |
(membership visits or discount amount) - minus the (refunded amounts for items paid for with a membership) |
|
|
Value of the visits that were redeemed using a package to pay an Amount Due |
(total package visits) - (refunded amounts for items paid using package visits) |
|
|
Includes:
|
(total of gift cards redeemed) - (refunds issued as a gift card) |
|
|
Total |
Total amount of payments redeemed using memberships, packages, and gift cards |
Total of all categories |
For example, if the customer's service costs $30, plus $5 tax and a $5 tip, for a total amount of $40:
-
Scenario 1: The customer pays with a membership or package. In the Redeemed section, Membership or Package will include $30, and in the Money Earned section, $10 (tax and tip) will be included in the line for the corresponding payment method. If the customer receives a refund, $30 will be subtracted from Membership or Package in the Redeemed section.
-
Scenario 2: The customer pays with a membership that grants a 50% discount for the service, In the Redeemed section, Membership will include $15 (which is 50% of $30), and in the Money Earned section, $10 (tax and tip) will be included in the line for the corresponding payment method. If the customer receives a refund, only $15 will be subtracted from Membership from the Redeemed section.
-
Scenario 3: The customer pays with a $20 gift card and $20 with cash. In the Redeemed section, Gift Card will include $20, and in the Money Earned section, Cash Collected will include $20.
-
Scenario 4: The customer pays with a service-based gift card. In the Redeemed section, Gift Card will include $30, and in the Money Earned section, $10 (tax and tip) will be included in the line for the corresponding payment method.
-
Scenario 5: The customer receives a $30 gift card as a refund. In the Redeemed section, Gift Cards will include ($30).
This section lists the amounts made for sales items both in-house or online. These totals do not include points redeemed for products, business costs, or redemptions using a membership, package, or gift cards.
The following amounts are listed in this section:
|
Sales Item |
Description |
Calculation |
|---|---|---|
|
Total from sales of services and service add-ons; excludes business costs, taxes, tips, and fees |
||
|
Total from sales of classes and class add-ons; excludes business costs, taxes, tips, and fees. |
||
|
Total from sales of products, including discounts and refunds; excludes business costs, taxes, tips, and fees. |
(Online product sales + In-House product sales) - (Tax + Tip + Fees + Membership discount + product discount + product refunds) |
|
|
Total from sales of gift cards, including discounts and refunds; excludes costs, taxes, tips, and fees. |
(Gift Card sales) - (Tax + Tip + Fees + discounts + gift card refunds) |
|
|
Total from sale of memberships, including discounts and refunds; excludes business costs, taxes, tips, and fees |
(Membership sales) + (Tax + Tip + Fees + discounts + membership purchase refunds) |
|
|
Total from sale of packages, including discounts and refunds; excludes business costs, taxes, tips, and fees |
(Package sales) + (Tax + Tip + Fees + discounts + membership purchase refunds) |
|
|
Total rent collected |
||
|
Commission (deducted from rent) |
Commission total from services, classes, and products; based on payroll (displayed as a negative number) |
Commission based on payroll total |
|
All taxes collected, including refunded taxes. |
(Taxes collected) - (Refunded taxes) |
|
|
All fees collected, including refunded fees |
(Fees collected) - (Refunded fees) |
|
|
All tips collected, including refunded tips. |
(Tips collected) - (Refunded tips) |
|
|
All IOUs issued (displayed as a negative number) |
||
|
All outstanding IOUs that were paid |
||
|
Total |
Total amount of all categories |
Total of all categories |
For example, if the customer's service costs $30, plus $5 tax and a $5 tip, for a total amount of $40:
-
Scenario 1: In the Sales section, Sales & Add-ons will include $30, Tips will include $5, and Tax will include $5.
-
Scenario 2: The customer receives a $10 discount, so in the Sales section, Sales & Add-ons will include $only 30; Tips will include $5, and Tax will be adjusted accordingly to the business's tax settings.
Comments
0 comments
Please sign in to leave a comment.