Knowledge Base
 
   

Daily Sales Report Explained

Article ID: 29
Last updated: 05 Mar, 2018
Revision: 9
print  Print
comment  Add comment
Views: 1566
Comments: 0

Understanding the Daily Sales Report


Explanation of the Daily Sales Report

The Daily Sales report can be daunting to look at and with this article we aim to assist you in better understanding the information within it, where it comes from, and how to utilize it as best as you can.

At the bottom of this article you will find a PDF version of this article that is available to download.


Table of Contents

Sales Analysis
Deposit Analysis
Equipment
Employee Sales
Containers
Misc.
Non-Split Account Ledger
Split (Not Linked) Account Ledger
Split-Linked Account Ledger
Customers
Sales Analysis Detail
Info - Promotion Categories
Additional Information


Sales Analysis

The Sales Analysis is derived by totaling the product sales plus the service sales for the specified day for the salon.

  • These values are retrieved from the Transactions table in the database
  • The report includes service and retail purchases including the following items paid at POS:
    • Walk-In Tans
    • Packages
    • Memberships
    • Products
    • Container fees
    • Freeze fees, unfreeze fees, and cancelation fees
  • Promotions are NOT included in the total sales; if a customer bought a $10 tan and used a $3.00 promotion only $7.00 will be added to the sales amount in the report
  • Gift Certificates sold and redeemed will appear in this section as they are income from POS and they have already been purchased.
    • If a customer redeems a Gift Certificate, the amount will show up in the respective category in which it was used to redeem
  • Points packages purchased will be displayed in the Sales Analysis under its own respective category
    • Points redeemed will ONLY be displayed in the Sales Analysis if they are categorized as a payment type and not as a discount

Deposit Analysis

The Deposit Analysis Value represents how much money was taken in by the salon from the POS including Sales Tax and Tan Tax.

  • These values are retrieved from the Payments table in the database.
  • This report includes the total of revenue collected by the following default payment types:
    • Visa, Discover, American Express or MasterCard
    • Check or Cash
    • Any other Payment Type that has been configured in Store Parameters > Payment Types with the “Show in Drawer” option checked
      • If “Show in Drawer” is unchecked for a particular Payment Type, the revenue associated with that Payment Type will not display in the Deposits section of the Daily Sales, potentially distorting your figures
  • Gift Certificates sold will appear in this section as they are income from POS and they have already been purchased.
    • Someone using an already purchased gift certificate will not show up in the daily sales as income because that income has already been counted in your totals when they originally purchased the Gift Card.
  • Refunds against a payment type will show as a negative amount to denote that the income was returned.

Equipment

Equipment Usage displays the equipment used by customers, the number of tans on the equipment and also the income minus the taxes. This will include walk-in tans, tan on services and tans on equipment upgrades.

  • $0 Tans, or service tans, will not show an amount but are still included in this sections statistics

Employee Sales

Employee Sales shows a breakdown of the total sales per employee during the time period the report was run.

  • Receipts is a count of how many transactions the employee performed
  • Tans is a count of how many tans were performed using the Walk-In selection under the Active Memberships/Packages/Courtesy Tans on the POS screen
  • Products is the total value of all retail items that the employee has sold
  • Services is the total value of all the tans that the employee has sold
  • The Product/Services total is the sum of Products and Services that have been sold
  • PRA is the average amount of revenue  that has been generated by the employee in relation to the amount of receipts the employee has processed
  • PTA is the average amount of revenue made in relation to the amount of tans that employee has sold

Containers

This portion of the report shows what types of containers have been sold and how many have been returned and those values. This is broken up under three headings; each with the quantity sold and the value of the bottle deposit.

  • Sold is the count of how many bottles you have sold and how much money you have taken in for bottle deposits
  • Returned is the count of how many bottles have been brought back to you and the value of the deposit returns that you have paid out to your customers
  • Total is the variance between Sold and Returned

Misc.

The Miscellaneous section of the report shows the money generated from using the “Misc” button in the POS; Charge on Account, Paid on Account, Points, etc.  Depending on how each of the following items affect the Deposit or Sales Analysis sections of the Daily Sales Report, it will be displayed as either a positive or negative value to balance the Sales and Deposit Analysis.

  • Charge on Accounts are transactions where the customer(s) did not pay for an item at POS, in terms of credit card or cash, but instead had the charge (Debit) applied to their General Ledger.
    • These values are included in the Sales Analysis section of the Daily Sales Report but not the Deposit Analysis
    • These values will be displayed as a positive value
  • Paid on Accounts are payments on a pre-existing or future receivables and applies a credit to the EFT or General Ledger.
    • These values are included in the Deposit Analysis section of the Daily Sales Report but not the Sales Analysis
    • These values will be displayed as a negative value
  • Points Redeemed displays the cash value of the points that your customers have redeemed for purchases at POS.
  • Gift Certificates Redeemed displays the amount of money that has been redeemed from gift cards that had been previously sold at POS.
  • Payouts shows how much money has been paid out at POS by using the Pay Out option
  • Container Returns displays the amount of money that you have paid out for bottles that have been returned to your salon
    • These values are deducted from the Deposit Analysis section of the Daily Sales Report but not the Sales Analysis
    • These values will be displayed as a positive value

Non-Split Account Ledger

The Non-Split Account Ledger is the default state for the SunLync database, unless you have previously chosen to split your account ledger or to split and link your account ledger this is how your account ledger is setup.

  • You can easily tell if your ledger is non-split by looking at the daily sales report Misc. section of the report and if does not display EFT Ledger and General Ledger then you are using a Non-Split Ledger.

Split (Not Linked) Account Ledger

A split account ledger separates your single account ledger into two separate ledgers. The General Ledger which is used for the tracking of pay on accounts that are intended to make purchases at POS in the future and the EFT Ledger which is used to track EFT pre-payments and payments made toward accrued EFT dues and EFT fees (ie:  rejection, processing, supplemental fees, etc.).  The Misc. section of the Daily Sales Report is changed by the process of splitting and linking your ledgers. It will now display some additional fields that it did not before which are outlined below.

  • Paid on Account – General Ledger will display how much money was added to the General Account Ledger to either pay off an over-the-counter debit (charge on account) or to add a credit to their General Ledger for later use, at point of sale.
  • Paid on Account – EFT Ledger will display how much money a customer has paid toward their EFT Ledger.  This will include pay on accounts for prepaid EFT dues and payments toward rejected EFT dues and fees, that customers owe and have paid over-the-counter.

Split-Linked Account Ledger

A split and linked account ledger replaces the single account ledger type with two as with the Split (not linked) Account Ledger but also breaks out the Paid on Account – EFT Ledger into 3 different groups of revenue and displays the revenue accrued during the EFT submission process.

  • The Misc. section of the Daily Sales Report is changed by the process of splitting and linking your EFT Ledger.   The report will now display break out revenue, for the Paid on Account – EFT Ledger section, in the Misc. section which are outlined below.
    • Paid on Account – General Ledger shows how much money was added to the account ledger by customers paying on account at point of sale.
      • POA – EFT Rejects (Before Conv.) is the tracking of any over-the-counter payments made toward rejected EFT dues and fees accrued before the EFT AL linking conversion was complete.
      • POA – EFT Rejects (After Conv.) is the tracking of any over-the-counter payments made toward rejected EFT dues and fees accrued after the EFT AL linking conversion was complete.  This section will itemize the total amount of payments in the following categories.
        • Dues – Monthly dues of the membership
        • Taxes – Service tax applicable to the membership dues
        • Tax Tax – Tan tax application to the membership dues
        • Processing Fees – Fees applicable to the submission of the membership.   This will include Credit Card processing fees as well as supplemental fees for EFT memberships.
      • POA – Pre Payments displays how much money has been brought in for pre-payments toward an EFT membership.
  • EFT Batch Revenue is a new addition to the Daily Sales Report after converting to the split-linked ledger
    • Here you will be able to find a summary of what revenue has been generated in EFT monthly dues, resubmit dues, and other associated EFT revenue.

Customers

  • Unique Customer represents the number of customers who are already in the database and have visited the salon within the time frame specified in the report and have made a sales transaction.
    • Each customer is only counted once.  Multiple transactions by a single customer still represent only a single unique customer
  • New Customer represents the number of customers that have been added into the database within the specified timeframe.
  • Receipts is the number of transactions that were processed within the specified timeframe.
    • The receipt is counted even if it was not printed.
  • Tans is the number of tans that were done within the specified timeframe.
    • This total is tans from all available methods for tanning (walk-in, packages, memberships, etc.)
  • Check-Ins is the number of check-in services that were done within the specified timeframe.
    • Check-ins are for packages and memberships in which the service Category that has Check-In required checked in back office.

Sales Analysis Detail

The sales analysis detail portion of the daily sales report provides a breakdown of the information in Sales Analysis summary portion of the report.


Info - Promotion Categories

Info-Promotion Categories gives you a list of what promotions were used for the selected time range, how many times each promotion was used, and the individual total value of each promotions used as well as a grand total for the value of all the promotions used.

  • The Promo Amount is the amount of money that customers have saved by using that promotion.

Additional Information

  • Product Total is the sum of all inventory items sold.
  • Services Total includes the totals for all memberships, packages, custom services, and upgrades sold.
  • Tanning is the total for walk-in tans only.
  • Employee Sales provides a quick overview of an employee’s sales numbers.
    • This total is derived from Product, Services, and Walk-In Sales as well as total sales for each employee.
  • Equipment Usage is an overview of the equipment used by customers. This includes the number of tans on equipment as well as gross income minus tan taxes. These values are determined by walk-in tans, tan on services (packages, memberships, custom services, upgrades, etc.)
  • $0 tans which would be a result of tanning on a service.
    • This will not have any bearing on total dollar amount but will be represented through this section of the report.
This article was:   Report an issue


Attached files
item Understanding the Daily Sales Report .pdf (540 kb) Download