Cost of Goods Sold Beta Report

The Cost of Goods Sold Beta Report is a sales report that displays a list of all transactions for products sold by your business, including the wholesale prices for those products and the gross profit made for each transaction. This report can be used to track your costs against your retail prices, to measure the profitability of each of your products. The summary cards at the top of the page provide an overview of the key information in the report.

This article describes how to view the Cost of Goods Sold Beta Report and provides details of the columns that appear in the report. To learn how to customize and filter the report, see Viewing a report.

In this article:

    To view the Cost of Goods Sold Beta Report:

    1. Click the App Drawer button .
    2. In the App Drawer, click Reports.
    3. On the Reports menu, click Sales.
    4. On the Sales menu, click the Cost of Goods Sold Beta Report. The Cost of Goods Sold Beta Report is displayed.

    Summary cards in the Cost of Goods Sold Beta Report

    Summary cardDescription
    Number of TransactionsThe total number of transactions that took place during the selected date range.
    Total Net SalesThe sum of all Net Sales amounts (after discounts but before taxes) for transactions that took place during the selected date range.
    Total CostThe total wholesale price for all products sold or returned during the selected date range.
    Total Gross ProfitThe total gross profit for all transactions that took place during the selected date range.
    Gross Profit %The Total Gross Profit amount divided by the Total Net Sales amount multiplied by 100, expressed as a percentage.

    Headings in the Cost of Goods Sold Beta Report

    HeadingDescription
    Transaction IDThe unique transaction identification number.
    Client NameThe name of the client who made the transaction.
    Transaction TimeThe date and time at which the transaction took place.
    LocationThe location at which the transaction was made.
    Revenue CategoryIf you use revenue categories to organize your online store, the category (or categories) set for the item sold or returned.
    QuantityThe number of items sold to the client or returned by the client.
    ItemThe name of the product that is sold to the client or returned by the client.
    Product OptionThe product option selected. For more information on setting product options, see Product general information settings.
    AmountThe sale price for one unit of the item sold to the client or returned by the client.
    Total SalesThe sale price for all items sold to the client or returned by the client. This is the price before applied discounts.
    Groupon CodeThe Groupon code used for the transaction, if any.
    Discount CodeThe discount code used for the transaction, if any.
    Discount AmountThe amount of discount applied to the transaction, if any.
    Total Net SalesThe total transaction amount after applying discounts, but before applying taxes.
    CostThe wholesale price of one unit of the product sold to the client or returned by the client.
    Total Cost of SalesThe total wholesale price for all units of the product sold to the client or returned by the client.
    Total Gross ProfitThe total gross profit from the transaction, calculated by subtracting the Total Cost of Sales amount from the Total Net Sales amount.
    Total Gross Profit %The Total Gross Profit amount divided by the Total Net Sales amount multiplied by 100, expressed as a percentage.
    Sales Tax XOne or more tax columns will be generated based on the taxes that you have set up for your business. Each column will list the amount of tax charged for the sale.
    Total TaxesThe total amount of taxes applied to the transaction.
    Total Sale AmountThe total amount of the transaction after applied taxes.
    Total TipsThe total amount of tips associated with the transaction.
    Total AmountThe total amount of the transaction after applying discounts, taxes, and tips.
    Total PaidThe total amount paid with the payment methods specified in the Payment Method column.
    Total ReceiptsThe total amount paid with non-Account payment methods.
    Payment MethodThe payment method used by the client to complete the transaction. If the client used multiple payment methods to complete the transaction, each payment method will be listed in this column.
    Transaction OriginThe source of the transaction (e.g., scheduled payment, installment plan).
    Transaction BalanceThe Total Amount minus the Total Receipts. Any amounts greater than zero in this column indicate one of the following:

    • The transaction is a purchase that was paid for by gift card, and the gift card redemption amount was greater than the Total Amount for the transaction
    • The transaction is an installment payment against the balance of a payment plan
    • The transaction was paid for with multiple methods, and one of the methods was Account

    Advanced filters in the Cost of Goods Sold Beta Report

    FilterDescription
    Display sales with discountsUse this filter to determine whether to include discounted sales in the report.
    Discount CodesUse this filter to determine which sales to include in the report based on which discount codes were applied to the sale.
    Introductory OfferUse this filter to determine whether to include introductory offers in the report.
    GroupsUse this filter to determine which clients to include in the report based on their client group.
    NoteThis filter will pull any relevant information from the available fields. For example, if you filter for groups A, B, and C, the filter will find clients from group A, group B, group C, and any combination thereof, as opposed to only finding clients who belong to all three groups.
    Payment MethodUse this filter to determine which sales to include in the report based on the payment methods used.
    Accounting MethodUse this filter to determine whether transactions in the report are displayed using an accrual accounting method or a cash-based accounting method. For more information, see FAQ: What is the difference between accrual and cash-based accounting?
    LocationsUse this filter to determine which locations to include in the report.
    Purchase or Money OwnerUse this filter to determine which items to include in the report based on who made the purchase; the client who received the item or the client who paid for the item.
    Point of SaleUse this filter to determine which transactions to include in the report based on their point of sale.
    Revenue CategoriesUse this filter to determine which transactions to include in the report based on their revenue categories.
    Charged TaxesUse this filter to determine which sales to include in the report based on whether the client was or was not charged taxes.
    TaxesUse this filter to determine which sales to include in the report based on which tax types were applied to them. The options available in this filter are dependent on the taxes you have set up in your store. Selecting a tax filter will display all sales to which that tax was applied. Selecting the No taxes filter will filter for sales that do not have taxes applied to them.
    NoteIf the tax amount of a sale is manually changed to zero when the sale is made, the sale will still be considered taxed and can be filtered for using the appropriate tax filter.
    ProductsUse this filter to determine which product(s) to include in the report.
    Was this article helpful?
    (25 out of 25 people found this article helpful)
    Cancel