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:
- Click the App Drawer button
. - In the App Drawer, click View All.
- In the list, click Reports. You can filter the list by entering Reports into the Search field.
- On the Reports menu, click Sales.
- On the Sales menu, click hidden.
- 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 card | Description |
| Number Items | The total number of items purchased during the selected date range. Purchases that were refunded or voided aren’t included in the total. |
| Total Net Sales | The 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 Cost | The total wholesale price for all products sold or returned during the selected date range. |
| Total Gross Profit | The total gross profit for all transactions that took place during the selected date range. |
| Custom Tax/Total Taxes | The 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
| Heading | Description |
| Purchase ID | The Purchase ID for the sale. The Purchase ID can also be found next to the Purchase Number on the receipt. |
| Client Name | The 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. |
| Date | The date and time at which the transaction took place. |
| Location | The location at which the transaction was made. |
| Revenue Category | If you use revenue categories to organize your online store, the category (or categories) set for the item sold or returned. |
| Quantity | The number of items sold to the client or returned by the client. |
| Item | The name of the product that is sold to the client or returned by the client. |
| Product Option | The product option selected. For more information on setting product options, see Product general information settings. |
| Subtotal | The 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 Sales | The sale price for all items sold to the client or returned by the client. This is the price before applied discounts. |
| Groupon Code | The Groupon code used for the transaction, if any. |
| Discount Code | The discount code used for the transaction, if any. |
| Discount Amount | The amount of discount applied to the transaction, if any. |
| Total Net Sales | The total transaction amount after applying discounts, but before applying taxes. |
| Cost | The wholesale price of one unit of the product sold to the client or returned by the client. |
| Total Cost of Sales | The total wholesale price for all units of the product sold to the client or returned by the client. |
| Total Gross Profit | The 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 Taxes | The 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. |
| Tips | The total amount of tips associated with the transaction. |
| Surcharges | The total amount of surcharges associated with the items sold. |
| Total Amount | The total amount of the transaction after applying discounts, taxes, and tips. |
| Total Paid | The total amount paid with the payment methods specified in the Payment Method column. |
| Total Receipts | The total amount paid with non-Account payment methods. |
| Payment Method | The 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 Sale | The platform through which the items were purchased. |
| Transaction Balance | The Total Amount minus the Total Receipts. Any amounts greater than zero in this column indicate one of the following:
|
Advanced filters in the Cost of Goods Sold Report
| Filter | Description |
| Display sales with discounts | Use this filter to determine whether to include discounted sales in the report. |
| Discount Codes | Use this filter to determine which sales to include in the report based on which discount codes were applied to the sale. |
| Introductory Offer | Use this filter to determine whether to include introductory offers in the report. |
| Groups | Use 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 Method | Use this filter to determine which sales to include in the report based on the payment methods used. |
| Accounting Method | Use 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. |
| Locations | Use 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 Owner | Use 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 Sale | Use this filter to determine which transactions to include in the report based on their point of sale. |
| Revenue Categories | Use this filter to determine which transactions to include in the report based on their revenue categories. |
| Charged Taxes | Use this filter to determine which sales to include in the report based on whether the client was or was not charged taxes. |
| Taxes | Use 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. |
| Products | Use this filter to determine which product(s) to include in the report. |
| Product Options | Use 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. |
