Cost of Sales Charts

• Cost of Sales - this year vs. budget
• Cost of Sales - this year vs. last year
• Cost of Sales % of Revenue
• Cost of Sales Split
• Direct Wages
• Top Three Cost of Sales

Cost of Sales - this year vs. budget

Explanation

Tracks the value of all items recorded as cost of sales and compares these to the budgeted cost of sales.

Formula

Cost of Goods Sold

Report Codes used

EXP.COS

Cost of Sales - this year vs. last year

Explanation

Calculates the sum of all cost of sales accounts for this year and compares it to the last year. The dotted green line represents future periods and displays the budget data.

Formula
Series 1 - Cost of goods sold [YTD]

Series 2 - Cost of goods sold [last 12 months]

Report Codes Used

EXP.COS

Cost of Sales % of Revenue

Explanation

Shows and tracks what percentage of revenue is spent on direct costs related to the product or service.

Formula

Cost of goods sold / Revenue * 100

Report Codes Used

EXP.COS and REV.TRA

Cost of Sales Split

Explanation

Shows the proportion of each Cost of Sales account and displays them in a pie or donut chart. The labels on this chart are determined by the Spotlight Display Name on the Customise Data tab.

Formula

Cost of goods sold

Report Codes Used

EXP.COS

Direct Wages

Explanation

Measures the monthly cost of wages directly related to the production of goods or services. The dotted blue line represents future periods and displays the budget data.

Formula

Direct Wages

Report Codes Used

EXP.COS.WAG

Top Three Cost of Sales

Explanation

Shows the proportion of the different components of Cost of Sales. This allows you to see which Cost of Sales areas are consuming the most amount of revenue.

‍