Kapoq's financial reports, such as the P&L in Accounting, break out all costs to help you confirm accurate margins. To ensure these reports are as precise as possible, Cost of Goods Sold (COGS) can be input directly within Kapoq at the SKU level.
Getting Started
Navigate to Accounting > Settings and click "Bulk Upload" to download the COGS template.
Note: By default, if no COGS are added at the product level, Kapoq will automatically apply a default COGS value of 20% (or whatever default value is currently configured).
Filling Out the Template
Fill in the requested information in the yellow, editable cells. The three key columns to complete are:
Column H — COGS Method Select your preferred COGS method from the dropdown:
Currency Value — a fixed dollar amount
Percentage of Selling Price — must be entered as a decimal (e.g., enter
0.1to express 10%)
Column I — COGS Value Input your COGS value based on the method selected in Column H.
Column J — Start Date Provide the date you want the COGS value to take effect. This can be:
A future date for upcoming changes
A historical date to backfill past data
⚠️ Important: Do not alter any column headers or the structure of the template — the file must be uploaded in the exact format it was downloaded. Additionally, Column A (Item ID) is hidden but must remain in the file, otherwise errors will occur during upload.
Uploading the Completed Template
Once the template is filled out, save the file and return to Accounting > Settings. Use the same "Bulk Upload" button to upload the completed file.
Reviewing Your COGS Data
Once uploaded, your COGS data can be reviewed in the following places:
Bulk Export — Download the export from Accounting > Settings to review what was uploaded
Historical COGS — View your Current COGS by going to Accounting > Historical COGS and viewing the Current COGS tab
Listings Module — View COGS at the individual SKU level
Accounting P&L — COGS will appear as a line item within the P&L report
Analytics — COGS data is reflected in both the Performance and Comparison tools under Analytics > Performance
Deleting COGS
If you need to delete COGS after they have been uploaded, navigate to Accounting > Historical COGS and select the Historical COGS tab.
From here, select one or multiple COGS entries, then use the Actions dropdown and select Delete COGS.
Need Help?
If you have any questions or need assistance setting up COGS, please reach out to the Kapoq support team.