How to Read the Summarized End of Day Report

Modified on Thu, 25 Jul, 2024 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:

Go to your back office and then navigate to Reports --> Summarized End of Day Report
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.