Worklog← All help
Price list & pricing

Price List Reports

Five reports over your price list, each its own screen: what stock you hold and what it is worth, what you make on every item, what needs reordering, what has stopped selling, and whether your prices still match your costings.

What it is

Items and the Cost Calculator are where you set your prices. Price List Reports is where you check them — Stock On Hand, Margins, Reorder, Dead Stock and Costings, each its own screen under Price List Reports in Reports, with its own Download PDF and Share buttons.

Stock on hand

Every item you hold, valued twice: at what it cost you and at what it sells for. The difference is the profit sitting on your shelves. The total at cost is your closing stock figure — the number an accountant asks for at year-end.

💡Only products and materials appear here. Services, labour and packages have no stock to count, so they are left out rather than listed as zero.

Margins

Every item with its cost, its sell price, the profit and two percentages. Margin is the profit as a share of what you charge; markup is the same profit as a share of what it cost you. The list is ordered worst first, so whatever needs attention is at the top.

  • Anything selling at or below what it cost you is flagged with a warning triangle.
  • Items with no sell price set are counted separately — they are not a bad margin, they are an unfinished one.
  • The average margin is the average of each item's margin, so one expensive line does not drown out the rest of the list.

Reorder

Everything at or under its reorder level, with how many units short you are and what it will cost to restock. Anything that has run out completely is marked and sorted to the top. It is a shopping list you can hand to whoever does the buying.

⚠️An item can only appear here if it has a reorder level set on it. If nothing shows up and you expected something to, check that the item has a reorder level rather than zero.

Costings

When you save a costing to your price list, the item stays linked to the costing behind it. Costings puts the two side by side: what the costing says you should charge, against what you are actually charging.

A price that has drifted below its costing shows in red, and the total at the bottom is what you are giving away on every sale across all of them. Costings never saved to the price list are listed too, marked "not on the price list".

💡This is the report to check after a supplier puts their prices up. Re-do the costing, and anything you are now charging too little for appears here.
Related guides
Manage your price list (Items)Work out a price with the Cost CalculatorSales Reports
Still stuck? Open the in-app help assistant, or email us at hello@worklogsolutions.co.za.
← Back to the Help Centre