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:
- Click the App Drawer button .
- In the App Drawer, click Reports.
- On the Reports menu, click Sales.
- On the Sales menu, click hidden.
- 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
|Number of Transactions||The total number of transactions that took place during the selected date range.|
|Total Net Sales||The sum of all Net Sales amounts (after discounts but before taxes) for transactions that took place during the selected date range.|
|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.|
|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
|Transaction ID||The unique transaction identification number.|
|Client Name||The name of the client who made the transaction.|
|Transaction Time||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.|
|Amount||The sale price for one unit of the item sold to the client or returned by the client.|
|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.|
|Sales Tax X||One 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 Taxes||The total amount of taxes applied to the transaction.|
|Total Sale Amount||The total amount of the transaction after applied taxes.|
|Total Tips||The total amount of tips associated with the transaction.|
|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.|
|Transaction Origin||The source of the transaction (e.g., scheduled payment, installment plan).|
|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 Beta Report
|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?|
|Locations||Use this filter to determine which locations to include in the report.|
|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.|