COGS Register Report

Go to Reports --> Custom Reports

The COGS Register Report is a custom report that provides a concise overview of sales transactions and sales by the different tenders you accept at the register.

The console provides the ability to export the report data to a flat file on your local file system. The export function currently supports the CSV file format, which presents the report data as fields separated by commas (,).

Exporting the Report

Click on the report and the date range, and you can download the whole report in a CSV.

Currently, you can only generate reports for up to 100 days. But if you still want to generate more than 100 days, give your email and generate the report to your email, you will get an email with the report CSV attached. 

Enter the email address (export link will be sent to this mailing address) →Export.

Once the export is processed, you'll receive a download link through email and you can download the file.

The COGS Register Report includes the following fields:

• Transaction Date: The date when the transaction took place.
• Transaction #: A unique identifier assigned to each transaction.
• Transaction Type: The type of transaction, such as a sale or return.
• Venue: The venue where the transaction occurred.
• Store: The specific store within the venue where the transaction occurred.
• Register: The register or point-of-sale terminal used for the transaction.
• Product ID: The Product ID of the product being sold.
• Item ID: The Item ID of the product being sold.
• UPC: The Universal Product Code, a barcode used to identify the product.
• Description: A brief description or name of the product.
• Department: The department or section of the store where the product belongs.
• Category: The category to which the product belongs.
• SubCategory: The subcategory within the main category.
• Size: The size of the product, if applicable.
• Supplier: The supplier or manufacturer of the product.
• Units Sold: The number of units sold in the transaction.
• Retail Price: The price at which each unit was sold.
• Retail Sales: The total sales revenue generated for the product in the transaction.
• Unit Cost: The cost of each unit to the retailer.
• Total Cost: The total cost incurred by the retailer for the units sold.
• Current QOH (Quantity On Hand): The current stock or inventory level of the product after the transaction.
• Pending PO QTY (Purchase Order Quantity): The quantity of the product pending in a purchase order.

By examining this report, retailers can analyze sales performance, track inventory levels, calculate the cost of goods sold, and make informed business decisions based on the provided information.

Articles in this section

• Item Import Field Descriptions
• Overview
• Merchant Onboarding
• Navigation Bar
• Reports
• Items
• Settings
• Dashboard Overview
• Company
• Register

See more