Stock and margin

The Stock and margin page in the Management section of the menu answers questions such as “how much money sits on my shelves?”, “does my stock turn fast enough?” or “how much do I make on the parts I sell?”. It reads the stock and the issued documents without changing anything.

Who sees what

The page shows for anyone who can view the stock. The amounts then depend on their other permissions:

• values (stock value, rotation, days of stock, value of dormant items, value of inventory gaps) need, like the costs on the stock screens, the permission to edit the catalogue or to adjust the stock;
• the parts margin also needs the permission View the Sales and payments report.

Without them, the page shows what remains (dormant items with their quantity, number of stock counts and parts adjusted) and a short sentence says what is missing. A hidden amount is not computed.

Today

These figures do not depend on the chosen period.

• Stock value: for each part tracked in stock, its quantity times its weighted average cost (the average cost updated at each receipt), summed. Below, the same value 12 months ago, on the morning of the same day a year earlier; if the stock has less than 12 months of history, the page says so.
• Rotation over 12 months: the cost of the exits of the last 12 months (interventions and counter, returns deducted, at the weighted average cost of each exit) divided by the average stock, the mean of the value 12 months ago and today’s value. The formula and its two amounts show under the figure. Without 12 months of history, the average stock is today’s value.
• Days of stock: 365 divided by the rotation, how long the current stock would take to go out at the pace of the last 12 months.
• Dormant items: parts in stock without any exit (intervention or counter) for more than 180 days, with the value they tie up. A part that never went out counts from its first stock movement.

The Dormant items table lists the twenty parts tying up the most money (or, without access to costs, those dormant the longest): reference, description, quantity, date of the last exit and value. Clicking a part opens its sheet in the catalogue.

Over the period

The Week, Month, Year and Custom period buttons and the arrows work as on the Sales and payments page. Each figure is compared with the year before, the same period one year earlier.

Parts margin

The margin counts parts that left the stock and were invoiced on invoices and credit notes issued in the period (a draft does not count):

• Parts sales excl. VAT: the price excluding VAT of the part lines, after the line discount and the document’s overall discount, credit notes deducted;
• Cost of exits: the invoiced quantity at the cost of its stock exit (the weighted average cost at the time of the exit);
• Margin and margin rate: the difference, and its share of sales.

Left out, with their amount shown on the page: parts invoiced without a stock exit (part not tracked in stock, typed as free text, intervention invoiced before being done) and parts included in a flat rate (the flat rate is sold for its price, not part by part). A stock exit not invoiced yet is not in the margin either: it comes in the day its invoice is issued. Every counter sale is invoiced on the spot.

Inventory gaps

The adjustments written by the stock counts validated in the period: number of stock counts and parts adjusted, then the value of the surplus, the missing parts and the net gap, at the weighted average cost of the day of the adjustment.

These figures help run the garage; they do not replace your accountant’s stock valuation.