Within Kapoq, Reports such as the P&L in Accounting allow you to produce true financial reports breaking out all costs to confirm margins. In order for these reports to be as accurate as possible, COGS can be input within Kapoq.

To upload Bulk SKU-level COGS, navigate to Accounting > Settings. NoteClick “Bulk Upload” to download the template.

Note: By default, if no COGS are added into Kapoq at the product level, Kapoq will auto default the COGS amount to the 20% value or to whatever is in place. Example below:

To input COGS, fill out the requested information in the yellow, editable cells:

Column H - Choose your preferred COGS method from the dropdown: currency value or percentage of selling price. Percentage must be entered as a decimal (e.g., enter 0.1 to express 10%).

Column I - Input your COGS value based on the COGS method you chose.

Column J - Provide a start date for when the COGS value can go into effect. This can be a future date, or a historic date you wish to backfill.

Note: Do not alter the template columns or headers; the file must be uploaded in the same format as it was provided. In addition, Column A - Item ID is hidden and must remain within the file otherwise errors will be reported.

To complete, save the file and use the same “Bulk Upload” button to upload the file.

Once established, COGS can be referenced by downloading the Export to review what was uploaded at a later date or viewed in the Listings Module at the SKU level, shown below:

COGS will also appear in the Accounting P&L as well as in the Analytics > Performance and Comparison Tools.

If you have any questions or need help setting up COGS, please let us know.