|
This report shows how profitable your stock has been over a period you choose. For every stock item sold, it shows how many units went out, what you charged for them, what it cost the business to supply them, and the resulting profit – in both dollar and percentage terms.
Results can be shown as a list, or broken down into subtotals by stock category and by customer, with a grand total for the whole report.
Every time stock is sold on an invoice, a delivery docket, a customer return, or a debtor's purchase order, Jim2 records the quantity, the amount charged, and the cost of that stock.
This report gathers every sales record that falls within the date range, along with filters you select when you run the report, then totals them up.
Only the transaction types you tick to include (invoices, dockets, returns, debtor PO's) are counted, and only for the date range, locations, customers, stock, and other criteria you've selected on the report's setup screen.
|
These are the options on the report's setup screen. None are compulsory — leaving one blank simply means "include everything" for that filter.
|
|
|
Date Sold (from/to)
|
Only sales that happened in this date range.
|
Location
|
Only stock sold from a particular warehouse/branch location.
|
Customer/Customer groups
|
Only sales to a specific customer, or a group of customers.
|
Price Level
|
Only sales made at a particular customer pricing tier.
|
From/Ship (+ groups)
|
Only jobs sold from, or shipped to, a specific customer or site.
|
Job Type/Job Group
|
Restrict to certain job types, or to Service jobs vs. standard Jobs.
|
Item/Item Make/Item Model/Item groups
|
Restrict to a specific job item, make, model, or group.
|
Account Manager
|
Restrict to sales attributed to a specific account manager.
|
Branch/Sub-branch/GL Department
|
Restrict to a company branch, sub-branch or GL department.
|
Stock/Stock groups/Supplier
|
Restrict to a specific stock item, stock group, or supplier.
|
Include: Invoices/Dockets/Customer
Returns/Debtors PO's
|
Choose which transaction types are counted.
|
Include Freight
|
Whether freight charges are added into the figures.
|
Type: Labour/Depleting/Non- Depleting/Special/Applies/Journal
|
Choose which kinds of stock lines are counted — e.g. exclude Labour to see pure product profit.
|
For Kits show: Kit header/Kit Details
|
Show a kitted item as one combined line, or broken into its individual components.
|
Filter by Margin
|
Only show items whose margin % is above, below, or equal to a value you set.
|
Show Attributes
|
Adds extra spec/attribute detail beneath the item description.
|
Data Only
|
Produces a plain data export (e.g. for Excel) instead of the formatted report with percentage columns.
|
|
Reading from the top of the report down:
•Heading – company details, the report name, and a summary of the date range and filters used.
•Grand totals – the overall qty sold, sold value, COGS, GM value, margin % and Total GP% for everything included in the report.
•Stock category subtotals (up to 5 levels) – if you set a Report Level Depth, the report breaks totals down through your stock group hierarchy (e.g. Department > Category > Sub-category), with a subtotal at each level.
•Customer subtotals – within each stock grouping, sales are further subtotalled by the customer who bought them.
•Line detail – the individual sold stock lines behind each subtotal.
•The Report Level Depth you choose when running the report controls how many of the five possible grouping levels actually appear – set it to (none) for a flatter report, or higher for more sub-totalling. |
This is where each number on the report comes from and how it's calculated.
|
|
|
|
|
Stock Code
|
The item's unique inventory code.
|
Line detail
|
Taken directly from the stock item sold.
|
Description
|
The item's description. If Show Attributes is ticked, extra detail is added beneath it.
|
Line detail
|
Taken directly from the stock item record.
|
Type/Est. Cost flag
|
An asterisk (*) flags a line where the cost shown is an estimate rather than a finalised cost. In"Data Only export mode this column instead shows the raw stock type code (S = Depleting, N = Non-Depleting, L = Labour, A = Applies/other charge, P = Special, D = Journal).
|
Line detail
|
Estimates typically occur on progress-invoiced job lines or credit lines not yet fully cost- settled.
|
Qty Sold
|
Total units sold.
|
Line detail, every subtotal, grand total
|
Sum of the quantity sold across the matching transactions.
|
Sold Value
|
Total amount charged to customers
(revenue).
|
Line detail, every subtotal, grand total
|
Sum of the sale value across the matching transactions.
|
COGS (Cost of Goods Sold)
|
What it cost the business to supply what was sold.
|
Line detail, every subtotal, grand total
|
Sum of the recorded cost across the matching transactions.
|
GM Value (Gross Margin $)
|
The dollar profit made.
|
Line detail, every subtotal, grand total
|
Sold value minus COGS.
|
GP% (Gross Profit %)
|
Profit as a percentage of what was charged, for that single line.
|
Line detail only
|
GM value ÷ sold value × 100.
|
Margin %
|
The same profit-as-a-percentage-of- sale-price measure as GP%, calculated across everything totalled at that level.
|
Every subtotal and the grand total (not shown per line)
|
1 − (COGS ÷ sold value), ×
100.
|
Ave. COGS
|
The average cost per unit.
|
Line detail only
|
COGS ÷ qty sold.
|
Ave. Sold Value
|
The average price actually achieved per unit.
|
Line detail only
|
Sold Value ÷ qty sold.
|
Sold Value %
|
How much of the report's total revenue this line or group represents.
|
Line detail, every subtotal
|
This line/group's sold value ÷ total sold value for the whole report × 100.
|
GM Value %
|
How much of the report's total profit this line or group represents.
|
Line detail, every subtotal
|
This line/group's GM value ÷ total GM value for the whole report × 100.
|
Customer Code/Name
|
Identifies whose purchases are being subtotalled.
|
Customer subtotal band
|
Taken from the customer (card)
record linked to the sale.
|
Real COGS
|
A second cost figure calculated by Jim2 alongside the standard COGS, shown for the report overall.
|
Grand total only
|
Calculated internally by Jim2's stock-profit engine. If this differs noticeably from COGS, it's worth checking with your Jim2 partner what's included – e.g. it may exclude estimated/allocated costs that the regular COGS figure
counts.
|
Total GP%
|
The overall gross profit % across everything shown in the report – useful as a benchmark to compare individual lines or groups against.
|
Grand total only
|
(Total sold value − Total
COGS) ÷total sold value ×
100, calculated across the whole report.
|
|
You may notice an asterisk (*) next to some lines. This flags a line where Jim2 hasn't yet locked in the final cost – most commonly on job lines that were progress-invoiced, or on credit/return lines that aren't fully cost-settled. The sold value and quantity are always final; it's specifically the cost (and therefore the margin) on that one line that's an estimate until the job or credit is finalised.
|
If a figure on this report doesn't look right, or you'd like help tailoring the filters to a specific view (e.g. one customer, one stock group, or excluding labour), contact support@happen biz so we can assist you further.
|
Further information
|
