Your Cart
Loading

Inventory & Profit Tracker — Excel Workbook

On Sale
€12.00
€12.00
Added to cart

Know what is in stock. See what each product contributes.


A practical Excel workbook for independent online shops that want a clearer view of stock, reorder needs and contribution profit.


WHAT YOU GET

• A blank tracker for up to 200 SKUs

• A fictional worked example

• An English Start here guide inside the workbook

• Automatic stock, reorder, product-cost, contribution-profit and margin calculations


HOW IT WORKS

Enter opening stock, receipts, units sold, sellable returns, net product sales, unit costs and other variable costs. Use one period and one currency per workbook copy. Input cells and calculated results are clearly separated. Duplicate SKUs, missing numbers and inconsistent stock are flagged. Fix flagged rows before relying on totals.


GOOD TO KNOW

Requires Microsoft Excel. Delivered as one .xlsx file. Runs locally without macros or account connections. Contribution profit is before overhead and income taxes. It does not handle changing unit costs, returns from earlier periods, multiple locations or inventory adjustments. No accounting or tax advice.


Prepared with AI assistance. Tested by recalculating the exported workbook in our spreadsheet engine; native Microsoft Excel recalculation has not been independently verified. One-time purchase. Applicable taxes may be added at checkout.

You will get a XLSX (81KB) file