How to Read the Summarized End of Day Report

Modified on Thu, 25 Jul at 4:18 PM

Overview

The Summarized End of Day Report (EOD Report) is the most important and useful report in Cloud Retailer. This report provides a consolidated view of many useful reports to give you insight into how your business is doing. You can access the Summarized End of Day Report in two ways:

  1. Go to your back office and then navigate to Reports --> Summarized End of Day Report
  2. Go to your back office and then navigate to Tools --> End of day reconciliation



Cash In

The Cash In section of the EOD Report breaks down the flow of all money in and out of the register. Some of the totals are broken down into positive (money coming in) and negative (money going out). Others are a net total of all positive and negative values.


Here is what each line represents:

  • Sales
    This is the total positive sales for all products with the Standard or Non-inventory product type.

  • Total Rounding Difference
    This is the sum of calculation discrepancies due to rounding sales.

  • Not Contrib. To Sales
    This is a net total of all positive and negative transactions for products with the Not Contributing To Sales product type.

  • Cash Drop
    This is a net total amount of cash removed from the register using the Cash Drop feature.

  • Cash Payout
    The net total amount of cash removed from the cash drawer using the Cash Payout feature.

  • Voucher/Gift Cards
    This is a net total of all positive and negative transactions for products with the Voucher/Gift cards product type.

  • Negative Sales
    This is the total negative sales for all products with the Standard or Non-inventory product type.

  • Tax
    This is the net total of all tax collected or returned for all sales.

  • Deposits On Orders
    This is the net total of deposits collected on orders. This is only used if you require a deposit to be made on orders/holds.

  • Paid To Account
    This is the net total amount paid towards paying off a customer account balance. This is only used if you use the On Account payment method, meaning you allow customers to hold an account balance with you. (This is also sometimes referred to as a "customer tab" or "credit allowance / credit account")

  • Total
    This is the net total of all categories listed above.


Sales KPI Data

A Key Performance Indicator (KPI) is a quantitative value used for performance evaluation. Our Sales KPI Data highlights whether your organization is on track to achieve its desired goals.



Here is what each line represents:

  • Total Sales
    This is a net total of positive and negative transactions not including tax collected.

  • Total Rounding Difference
    This is the sum of calculation discrepancies due to rounding sales.

  • Cost of Goods
    The net total cost of products sold.

  • Profit
    The net total profit of products sold.

  • Sales Transaction Count
    The total number of sales transactions. This only includes transactions in which a product or service was sold. This would also be the number of customers for the selected time period and location(s).

  • Trans w/ Customer
    The number of sales transactions that have a customer associated with items.

  • Avg Trans w/ Customer
    The total amount of sales with customers divided by the total count of transactions with customers.

  • Avg Trans w/o Cust
    The total amount of sales without customers divided by the total count of transactions without customers.

  • Product Count
    The total number of products sold.

  • Avg Unit Per Trans
    The total product count divided by the total sale transaction count.

  • Largest Transaction
    The transaction with the highest total, including tax.


Audit KPI Data

A Key Performance Indicator (KPI) is a quantitative value used for performance evaluation. Our Audit KPI Data highlights whether your organization is on track to achieve its desired goals.



Here is a breakdown of what our audit KPI contains.

  • No Sale Count
    The number of times the cash drawer was opened.

  • Canceled Transaction Count
    The number of times a transaction was canceled

  • Item Corrections
    The number of times a product was added to a transaction with a quantity of zero.

  • Discount Quantity
    The number of times a product was sold at a discounted price.

  • Negative Dollar Items
    The number of times a product was sold at a negative price, and it is the sum of the total amount of Detailed Sales report filtered by Total < 0 and Qty. Sold > 0 and total amount of Not Contributing to Sale report filtered by Sold Price <= 0 


  • Unique Customers
    The number of unique customers. These have to be customers attached to the transaction at the time of the sale. You should expect this number to be low if you do not record your customers in the system.

  • Negative Quantity Items
    The number of times a product was sold at a negative quantity.
    This is often used for product exchanges. This is not considered a return.

  • Returns
    The number of times when a previous transaction was recalled and partially returned while using the "Partially Return" button.

  • Post Voids
    The number of times a transaction was recalled and all products were returned while using the "Void Transaction" button.

  • Manual Inventory Adjustments
    The number of times a product's inventory was adjusted manually.

  • Over / Short
    The total dollar quantity that the registers have reported as over or short.


Payment Info

The Payment Info displays the net total for each payment method used between the selected Start Time and End Time on the EOD report. If a payment method is NOT used during the selected time, the payment method will not show up in the list.



Here is a breakdown of what our audit KPI contains.

  • Payment Method
    Each payment method that is used during the selected date/time range will have the net total amount shown. In the image above, we have totals for Card, Cash, Check, and Gift Card.

  • Total
    This is the cumulative net total for all payment methods used during the selected date/time range.


  • Total Payments
    This is the total amount received for all payment methods, prior to issuing any change due. The Total Payments minus the Total Change should equal the Total for all payment methods in this section.

  • Total Change
    This is the total amount issued to customers for all payment methods in the form of change due. The Total Payments minus the Total Change should equal the Total for all payment methods in this section.


References



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article