{"id":14637,"date":"2022-06-02T16:40:35","date_gmt":"2022-06-02T20:40:35","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=14637"},"modified":"2023-06-15T12:59:11","modified_gmt":"2023-06-15T16:59:11","slug":"sales-by-customer-with-cost-of-goods-sold","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/sales-by-customer-with-cost-of-goods-sold\/","title":{"rendered":"Sales By Customer with Cost of Goods Sold Report"},"content":{"rendered":"\n

This report is similar to the Sales By Customer report<\/a><\/strong>, except it includes your cost of goods sold per customer as well as the profit received by each customer (and any discounts applied to the customer).\u00a0<\/p>\n

The cost of goods sold (also known as COGS) is the price you paid for an item. The cost of goods sold directly impacts your profit. For example, we bought an item for $50 and sold it for $70. Our profit is $20.00.<\/p>\n

Accessing the Report<\/h3>\n

There are two ways you can access this report. From the top of the screen, click on “Reports<\/strong>,” “Customer Reports<\/strong>,” and “Sales by Customer w\/ Cost Report<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

\u00a0<\/p>\n

Or, from the “Main Menu<\/strong>,” click on “Reports<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Select “Customer Reports<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Click on “Sales by Customer with Cost Report<\/strong>.”<\/p>\n

\"\"<\/a><\/p>\n

Either way, you’ll end up at the following screen.<\/p>\n

\"\"<\/a><\/p>\n

Report Fields<\/h3>\n

You can tweak these fields to filter the report or leave them as they are.\u00a0<\/p>\n

If you want to change the date, enter it manually or select it from the calendar (accessed from the downward-facing arrows).<\/p>\n

\"\"<\/a><\/p>\n

Customer Types<\/strong><\/p>\n

This field contains your list of customer types (ex. retail and wholesale). Select one to only view customers in that category or leave it set to \u201call<\/strong>\u201d to include every customer type.<\/p>\n

Birthdays and Anniversaries<\/strong><\/p>\n

Use these two fields to narrow down any customer birthdays or anniversaries. This is especially helpful if you\u2019re planning on sending out special discounts to customers based on these criteria. Based on how often they\u2019ve purchased from you, you can see if they might be more inclined to purchase from you again soon, and what items they might be interested in.<\/p>\n

\"\"<\/a><\/p>\n

Who Purchased Specific Items or Dollar Amount Between Dates<\/strong><\/p>\n

You can further narrow down the report parameters here. There are plenty of options to \u201cmix and match\u201d your results. For example, you can include customers who purchased at least five items since May 3, 2022. Or, as another example, you can look for customers who purchased more than $50 worth of items in the last three months. These fields truly allow you to be as specific as possible.<\/p>\n

You can even look for customers who bought items with specific descriptions or one of your own custom fields.<\/p>\n

To narrow or expand your report, you may choose to include or exclude keywords and locations. You can also narrow down email parameters and define your report by when the customer was added to Artisan.<\/p>\n

Reading the Report<\/h3>\n

\"\"<\/a><\/p>\n

Customer Name<\/strong><\/p>\n

Lists the company name and first\/last name in the customer record.<\/p>\n

City \/ State<\/strong><\/p>\n

Lists the customer\u2019s location.<\/p>\n

Sales<\/strong><\/p>\n

The amount of sales the customer made during the time period.<\/p>\n

Units<\/strong><\/p>\n

The number of items the customer purchased within the time period.<\/p>\n

Discounts<\/strong><\/p>\n

Total amount of discounts applied to that customer during the time period.<\/p>\n

COGS<\/strong><\/p>\n

Total price you paid based on the customer’s sales. If there is $0.00 COGS, a return was issued.<\/p>\n

\"\"<\/a><\/p>\n

Profit<\/strong><\/p>\n

Total profit from sales based on the customer. If there is $0.00 profit, a return was issued.<\/p>\n","protected":false},"excerpt":{"rendered":"

This report is similar to the Sales By Customer report, except it includes your cost of goods sold per customer as well as the profit received by each customer (and any discounts applied to the customer).\u00a0 The cost of goods sold (also known as COGS) is the price you paid…<\/p>\n","protected":false},"author":17,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":"","_monsterinsights_skip_tracking":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"ht-kb-category":[339],"ht-kb-tag":[],"class_list":["post-14637","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-customer-reports"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/14637","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/comments?post=14637"}],"version-history":[{"count":4,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/14637\/revisions"}],"predecessor-version":[{"id":14651,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/14637\/revisions\/14651"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=14637"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=14637"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=14637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}