Published Last updated Written and reviewed by the Resale Intelligence team
On this page
See the true profit on every unit sold after every cost (purchase price, repairs, parts and fees) with margin, ROI, days to sell and profit per day.
- Who can do this:
- Owner, Store Admin, Manager, Accountant, Auditor (role defaults; the owner can change them)
The True profit per unit report shows how much true profit each unit you sold made, after every cost recorded against that unit. Use it to see which models, grades and periods really make money for the store.
Before you start
-
You need View financial reports. By default that is the Owner, Store Admin, Manager, Accountant, Auditor roles.
-
Profit is right only when the costs of each unit are recorded, such as repairs, batteries, parts and shipping. See Record per-item costs: repair, battery, parts, shipping.
Open the report
Go to Reports and choose True profit per unit in the Finance and profit group.
Pick a period, such as This month or Last month. Units are counted by their sale date.
If the store has several branches, pick a branch or All branches.
Read the headline figures first, then scroll through the units. To see the costs line by line, search the item code in Inventory.
What each column means
-
Total cost: the purchase or trade-in price plus every other cost of the unit, such as repairs, battery, parts, shipping and its share of card fees.
-
Revenue: the money actually received for that unit, after its share of the bill discount, split by price.
-
Net profit: revenue minus total cost.
-
Margin: net profit divided by revenue.
-
ROI: net profit divided by total cost; how hard the money you put in worked.
-
Sold in (days): days from when the unit was first ready to sell until it sold.
-
Profit/day: net profit divided by the days it took to sell. A unit sold within its first day counts as one day.
Card fees are a cost of the unit, not a deduction from revenue. The bill's fee is split across its units by price.
Headline figures
-
Net profit and Revenue add up every unit sold in the period.
-
Average margin is total profit divided by total revenue, not an average of the rows.
-
Overall ROI is total profit divided by total cost.
-
Median days to sell is the days to sell of the unit in the middle, so a few units that sat for a long time do not pull it up.
-
Write-off losses is the cost of units written off during the period. It is shown separately because there is no revenue, but it is money the store really lost.
Why not sale price minus purchase price
Sale price minus purchase price looks like good profit, but it forgets repairs, parts and fees you have already paid. This report uses every entry in the unit's cost ledger, so it shows the money that is really left.
Good to know
-
If a sale is voided, the unit goes back into stock and drops out of this report.
-
Past sales imported from Excel are included, using the cost and sale price from the file.
-
A unit's costs can be recorded only while it is still in stock, so record repairs and parts before you sell it. After the sale the system says Expenses can only be recorded for items still in stock