Reporting Explained: Sales By Day

Reporting Explained: Sales By Day

Business Need:  This report is helpful for users who want a summary of sales by location over a period.

How it Works:  A Sales>By Item report shows a summary of sales for your stores in Yellow Dog.

Generating the Report:


Go to the Standard Reports section in Yellow Dog:

  1. Select Standard Reports
  2. Open the folder titled ‘Sales’
  3. Open the folder titled ‘By Day’
  4. Select the date or date range that you would like to run the report for and choose any filters that you would like to add
  5. Generate report

Reading the Report:


  1. Shows the filters used to produce the report’s data, including the date selected for the report.
  2. Change columns, sorting, and grouping:  This allows users to add or remove data columns to this report as well as organize and group the data.
  3. Store Name: Shows the store that the item on hand is assigned to.
  4. Period:  Shows the date for the sales on this line.
  5. Quantity Sold:  Shows the total quantity sold for items on this date.
  6. Total Cost: Shows the total cost of items sold on this date (Quantity Sold x Calculated Cost at the time of sale).
  7. Total Retail:  Shows the total sold for items in this store multiplied by the retail price as of that selected date and time (Quantity Sold x Actual Retail as recorded on sales ticket)
  8. Total Discount:  Shows the total for discounts applied to the sale (Quantity Sold x Item Discount as recorded on a sales ticket).
  9. Net Retail:  Shows the total retail after any discounts applied to the sales (Total Retail – Total Discount).
  10. This row allows you to save, export, print, or close the current report.





    • Related Articles

    • Reporting Explained Sale By Hour of Day

      Business Need: This report is helpful for users who want a report to show sales organized by hour of day that the sale occurred. How it Works: A Sales>By Hour of Day report shows a summary of sales organized by the hour that the sale occurred. This ...
    • Reporting Explained: ReOrder

      Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...
    • Reporting Explained: Summary By Period

      Business Need:  A user would like to see a summary of all activity for items between two dates.  How it Works:  This report will show all movement between two selected dates. This report can filter to as broad as by store, or as granular as by item. ...
    • Reporting Explained: Inventory History Calculated Cost By Day

      Reporting Explained: Inventory History Calculated Cost by Day Business Need:  This report is helpful for users who want a report to show the calculated costs for items over a period. How it Works:  An Inventory>History>Calculated Cost>By Day report ...
    • Reporting Explained: Invoice Records: By Invoice

      Business Need:  This report will provide users a summarized list of all invoices, and their status’ over a period. How it Works: This report displays the dollar value, and quantity count for every invoice for the selected period. This report will ...
    • Recent Articles

    • How To: Import Interfaces by Level using Balto

      This document will review how to import interface settings for a level using the Balto import tool. Prerequisites Items are required to exist in YD already Items cannot be marked as removed. The stores must also exist in YD Yellow Dog user with ...
    • How To: Update Par & Re-Order Points via the Balto Import Tool

      This document will review how to update Par & Re-Order Points via the Balto import tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
    • How To: Update Items Store Availability via the Balto Import Tool

      This article will review how to update items store availability with the Balto Import Tool With all Balto imports, be sure not to change any of the column headers in the template. Unused columns can be removed, but the headers should not be edited in ...
    • Yellow Dog/Jonas File Exchange Overview

      This document will provide an overview of the Yellow Dog Jonas File Exchange Integration Integration Approach This is a 2Way integration – pull sales and push items • Sales – pulled from a file • Items – pushed to .csv file • Codes – Inserted into ...
    • Yellow Dog/Jonas API Overview

      This document will provide an overview of the Yellow Dog Jonas API Integration Integration Approach This can be set up as a 2Way – Items are pulled from us, and sales are pushed or 1Way sales are pushed. NOTE: Jonas controls the flow of sales and ...