Wiki

    Contact support:

    Email: support@erply.com

    15 Oct, 2021
    Permalink:
    Also available in:EstonianFinnish

    Erply Reports explained

    Erply Reports explained

    This guide explains the data values in each of Erply’s reports.

    Sales reports

    Sales Summary report

    Sales Summary

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Net sales total ($): The sum amount of your sales before tax.

    Net sales total 0%: The total amount of sales that were tendered with 0% tax.

    Net sales total 7%: The total amount of sales that were tendered with 7% tax.

    tax 7%: The tax amount of items taxed 7%. This is only the tax, not the cost.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

     

    By Day

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Date: The date the transaction took place.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount total: The total cash amount of discounts given.

    Net Discount Percentage: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Average units per transaction: The average amount of items sold that day. This is calculated by adding the total amount of sales together, and dividing it by the amount of registers used. Because of this, there can be a decimal point in the amount.

    Average Value sold: The average value sold field is the sum of all transactions for a given day, divided by the number of sales for that day.

    Number of Sales: Total amount of sales made that day. 

     

    Day Overview

    Date: The day the report is getting information from.

    Date: The date the transaction took place.

    By wire transfer: Payments made by Wire Transfer.

    In cash: Payments made in cash.

    By card: Payments made by credit or debit card.

    By card – Miscellaneous: Payments made by a card through an external device.

    By credit invoice: Payments made with a credit invoice.    

    With gift card: Payments made using a gift card.

    With check: Payments made using a check.

    Total: Total tendered amount of all payment types.

     

    By Weekdays

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Day of week: Which day of the week the filtered period is gathering information from. For example, it will show the total amount of items sold on Wednesdays that month under ‘Wednesday’ rather than creating four separate Wednesday columns.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Graph: This graph shows sales trends by weekdays.

     

    By Hours

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Hour: What hour the following information is gathered from. If no sales were made in that hour, a row will not be created.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Graph: This graph shows sales trends by hour.

    Sales by Customer report

    Sales By Customer

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: The Customer the following information is associated with.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    Sales by Customer Account Manager

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: The Account Manager associated with the customer.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    Sales By Customer Group

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: The name of the customer group associated with the following information.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.    

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    Sales by Business Area

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name:  

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.    

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales By Location report

    Sales by Location

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Location: Location of sales made. This includes sales information from all registers at that location.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.    

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    Sales By Register

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Register: The register that the following sales information applies to.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.    

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Item Sales report

    Sales by Product

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: Name of the product.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Unit: The unit identifier for the product, such as lbs or pcs.

    Net sales total ($): The sum amount of your sales before tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Matrix Product

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: Name of the product.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Unit: The unit identifier for the product, such as lbs or pcs.

    Net sales total ($): The sum amount of your sales before tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Product Group

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the product group.

    Sold Quantity: The total amount of item(s) sold in the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Product Group, with Drill Down

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: Name of the product and product group.

    Sold Quantity: The total amount of item(s) sold in the set filter.

    Unit: The unit identifier for the product, such as lbs or pcs.

    Net sales total ($): The sum amount of your sales before tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Department

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the product group.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Department, with Drill Down

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the product and product group.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Supplier

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the supplier the items were purchased from.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Supplier, with Drill Down

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: Name of the supplier the items were purchased from.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Category

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the category the sold items belong to.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Category, Level 2

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the products, category, and subcategories the sold items belong to.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Category, Level 1

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the products, category, and subcategories the sold items belong to.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Category with Drill Down

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: Name of the products, category, and subcategories the sold items belong to.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Unit: The unit identifier for the product, such as lbs or pcs.

    Net total sales: The total tender amount of sales that day, not including tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Brand

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the brand the sold products are associated with.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    Master List

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: The name of the product.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Unit: The unit identifier for the product, such as lbs or pcs.

    Stock (Total): Total amount of a product in all locations specified by filter.

    Stock (Layaway): Amount of  products on layaway in all locations specified by filter.

    Stock (Available): Amount of a product in all locations specified by filter.

    Supplier: Supplier the product was purchased from.

    Net Sales Total: The total tender amount of sales that day, not including tax.

    Sales Total with Tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Cashier Sales report

    By Cashier

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the cashier that made the sales.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net Sales Total: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Average Units per Transaction: The average amount of products sold across all transactions

    Average value sold $: The average tender amount of all transactions made.

    # of Sales: How many sales that specific cashier made.

    Detailed Sales report

    Invoices

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Date: Date the transaction took place.

    Sales Invoice (cust manager): Invoice, receipt, and waybill number. Clicking on this information will open the invoice in the Back Office for a more detailed review.

    Customer: The customer associated with the invoice.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net Sales Total: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    Invoice Rows

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Date: Date the transaction took place.

    Sales Invoice: Invoice, receipt, and waybill number. Clicking on this information will open the invoice in the Back Office for a more detailed review.

    Code: The user entered product code that was associated with the product.

    Product: The name of the product. Clicking this field will open the products Product Card.

    Customer: The customer associated with the invoice.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net Sales Total: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Accounts Receivable report

    Unpaid invoices and balance statements

    Date

    Currency

    Balance Statements cover the period

    Customer

    Ship to

    Invoice

    Date

    Deadline

    Total

    Paid

    Unpaid

    Total

     

    Customer’s invoices in selected period

    Document

    Ship to

    Date

    Sum $

    Payment Date

    Payment Sum $

    Total paid $

    Credited $

    Amount Due $

     

    Balance report

    As on: 

    Currency

    Customer

    Loyalty Card

    Balance

    Cost of Goods Sold

    Cost of Goods Sold Summary report

    Calculates cost based on warehouse value.

     

    Sales Summary

    Period

    Currency

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

     

    Sales by Day

    Period

    Currency

    Date:

    Sold Quantity:

    Purchase Value:

    Warehouse Value:

    Net discount total ($):

    Net Discount %:

    Sales profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

    Average units per transaction:

    Average value sold ($):

    # of Sales:

     

    Day Overview

    Date

    ---Sales Summary

    Purchase Value:

    Warehouse Value:

    Net Sales Total:

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

    Payments by Date

    ---Sales by Employee

    Date: The day the report is getting information from.

    Date: The date the transaction took place.

    By wire transfer: Payments made by Wire Transfer.

    In cash: Payments made in cash.

    By card: Payments made by credit or debit card.

    By card – Miscellaneous: Payments made by a card through an external device.

    By credit invoice: Payments made with a credit invoice.    

    ---Sales by Employee

    File #:

    Name:

    Services Total:

    Products Total:

    Returns:

    Total:

    Total Units:

     

    Sales by Weekdays

    Day of Week: Which day of the week the filtered period is gathering information from. For example, it will show the total amount of items sold on Wednesdays that month under ‘Wednesday’ rather than creating four separate Wednesday columns.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

    Graph: This graph shows sales trends by weekdays.

     

    Sales By Hours

    Hour: What hour the following information is gathered from. If no sales were made in that hour, a row will not be created.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

    Graph: This graph shows sales trends by hour.

    COGS by Customer report

    Sales By Customer

    Name: The Customer the following information is associated with.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

     

    Sales by Customer Account Manager

    Name: The Account Manager associated with the customer.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

     

    Sales by Customer Group

    Name: The name of the customer group associated with the following information.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    Purchase Value:

    Warehouse Value:

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

     

    Sales by Business Area

    Name:  

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net sales total ($): The sum amount of your sales before tax.

    Purchase Value:

    Warehouse Value:

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

    COGS by Location report

    Sales by Location

    Location: Location of sales made. This includes sales information from all registers at that location.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

     

    Sales by Register

    Register: The register that the following sales information applies to.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

    COGS by Item report

    By Product

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: Name of the product.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Unit: The unit identifier for the product, such as lbs or pcs.

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

     

    By Matrix Product

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: Name of the product.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Unit: The unit identifier for the product, such as lbs or pcs.

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

     

    By Product Group

    Name: Name of the product group.

    Sold Quantity: The total amount of item(s) sold in the set filter.

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

     

    By Product Group, with Drill Down

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: Name of the product and product group.

    Sold Quantity: The total amount of item(s) sold in the set filter.

    Unit: The unit identifier for the product, such as lbs or pcs.

    Purchase Value:

    Warehouse Value:

    Net sales total ($): The sum amount of your sales before tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

     

    By Department

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the product group.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Purchase Value:

    Warehouse Value:

    Net total sales: The total tender amount of sales that day, not including tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a % of warehouse value):

     

    By Department, with Drill Down

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the product and product group.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Supplier

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the supplier the items were purchased from.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Supplier, with Drill Down

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: Name of the supplier the items were purchased from.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Category

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the category the sold items belong to.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Category, Level 2

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the products, category, and subcategories the sold items belong to.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Category, Level 1

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the products, category, and subcategories the sold items belong to.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Category with Drill Down

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: Name of the products, category, and subcategories the sold items belong to.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Unit: The unit identifier for the product, such as lbs or pcs.

    Net total sales: The total tender amount of sales that day, not including tax.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    By Brand

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Name: Name of the brand the sold products are associated with.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Net total sales: The total tender amount of sales that day, not including tax.

    TAX RATES: The following will show your specific tax rates and if they were applied. This may be more than one column. Each column is titled with the name of the tax rate you created.

    Sales total with tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

     

    Master List

    Period: The dates from which the information is gathered. This can be a single date or a range.

    Gift Cards: Shows if the information shown includes or excludes gift cards.

    Currency: the currency the sales are shown in. 

    Code: The user entered product code that was associated with the product.

    UPC Code: The barcode on the product.

    Name: The name of the product.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Unit: The unit identifier for the product, such as lbs or pcs.

    Stock (Total): Total amount of a product in all locations specified by filter.

    Stock (Layaway): Amount of  products on layaway in all locations specified by filter.

    Stock (Available): Amount of a product in all locations specified by filter.

    Supplier: Supplier the product was purchased from.

    Net Sales Total: The total tender amount of sales that day, not including tax.

    Sales Total with Tax: The total amount of sales include all tax rates that were applied.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’

    Cashier Sales report

    By Cashier

    Name: Name of the cashier that made the sales.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Purchase Value:

    Warehouse Value:

    Net Sales Total: The total tender amount of sales that day, not including tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a & of warehouse value):

    Average Units per Transaction: The average amount of products sold across all transactions

    Average value sold $: The average tender amount of all transactions made.

    # of Sales: How many sales that specific cashier made.

    Detailed COGS report

    Invoices

    Date: Date the transaction took place.

    Sales Invoice (cust manager): Invoice, receipt, and waybill number. Clicking on this information will open the invoice in the Back Office for a more detailed review.

    Customer: The customer associated with the invoice.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Purchase Value:

    Warehouse Value:

    Net Sales Total: The total tender amount of sales that day, not including tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’ 

    Sales Profit:

    Profit (a % of revenue):

    Markup (a & of warehouse value):

     

    Invoice Rows

    Date: Date the transaction took place.

    Sales Invoice: Invoice, receipt, and waybill number. Clicking on this information will open the invoice in the Back Office for a more detailed review.

    Code: The user entered product code that was associated with the product.

    Product: The name of the product. Clicking this field will open the products Product Card.

    Customer: The customer associated with the invoice.

    Sold Quantity: The total amount of item(s) sold during the set filter.

    Purchase Value: The cost of all of your products in the warehouse, based on product cost at the time of its purchase.

    Warehouse Value: 

    Net Sales Total: The total tender amount of sales that day, not including tax.

    Net Discount Total ($): The total cash amount of discounts given.

    Net Discount %: The percentage of discounts given. This is calculated by dividing the ‘Net Discount Total’ by ‘Sales Total with Tax.’

    Sales Profit:

    Profit (a % of revenue):

    Markup (a & of warehouse value)