Cost of Goods Sold Report

The Cost of Goods Sold 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 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 Report:

    1. Click the App Drawer button .
    2. In the App Drawer, click View All.
    3. In the list, click Reports. You can filter the list by entering Reports into the Search field.
    4. On the Reports menu, click Sales.
    5. On the Sales menu, click the Cost of Goods Sold. The Cost of Goods Sold Report is displayed.

    Summary cards in the Cost of Goods Sold Report

    Summary cardDescription
    Number ItemsThe total number of items purchased during the selected date range. Purchases that were refunded or voided aren’t included in the total.
    Total Net SalesThe total sales during the selected date range, after the deduction of refunds and voids. Any discounts applied to transactions are included in this value, but any taxes, surcharges, and tips applied to transactions aren’t included. Additionally, failed transactions aren’t included in this value.
    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.
    Custom Tax/Total TaxesThe total amount of taxes applied to the items sold during the selected date range. If there is only one type of tax set up in your store settings, this summary card will be named after the tax you have created. If you have two or more taxes set up in your store settings, this summary card will appear as Total Taxes.
    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 Report

    HeadingDescription
    Purchase IDThe Purchase ID for the sale. The Purchase ID can also be found next to the Purchase Number on the receipt.
    Client NameThe name of the client who made the transaction.

    If a guest completed the transaction, Guest appears in this column. You can click Guest to open their guest profile.

    DateThe 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.
    SubtotalThe value of all items sold to the client or returned by the client. This value doesn’t include discounts, taxes, tips, or surcharges applied to the items sold.
    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.
    Custom Tax/Total TaxesThe total amount of taxes applied to the item sold. If there is only one type of tax set up in your store settings, this column will be named after the tax you have created. If you have two or more taxes set up in your store settings, this column will appear as Total Taxes.
    TipsThe total amount of tips associated with the transaction.
    SurchargesThe total amount of surcharges associated with the items sold.
    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.
    Point of SaleThe platform through which the items were purchased.
    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 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?

    NoteIf you select the Accrual & Cash option for this filter, transactions may appear more than once on this page, which will cause an inaccurate value to be displayed in the Total Net Sales summary card.
    LocationsUse this filter to determine which locations to include in the report.

    This filter is only available if your business has multiple locations.

    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.
    Product OptionsUse this filter to determine which product options to include in the report. Product options are products with different variations. For example, a water bottle could come in two sizes: small and large. For more information, see Product general information settings.
    Was this article helpful?
    (80 out of 80 people found this article helpful )

    What can we do better?

    Thank you!

    Contact Us

    Having trouble finding the answer you're looking for? Check out our Support Center or let us know how we can help.