Skip to content

Inventory management in Excel, without the manual recount

Excel handles inventory fine, right up until the sheet and the shelf disagree, and nobody's sure which one is wrong.

The sheet and the stockroom drift apart

An inventory spreadsheet is accurate the day someone does a full count and enters it. After that, every sale, receipt, and adjustment either gets typed in or doesn't. Most don't, every time: not because the format is wrong, but because updating a spreadsheet by hand is its own job.

Where Ferra fits

Ferra doesn't replace your inventory spreadsheet. It fills one. Upload a stock report or forward a supplier shipping confirmation, and Ferra updates the matching rows instead of you retyping quantities. If you're just after a free template, Vertex42 and Smartsheet both have good ones; Ferra is for when keeping it updated became the actual problem.

A Ferra table tracking inventory, with columns for SKU, item name, quantity on hand, and reorder point

Preview image: the real screenshot for this page is still coming.

Frequently asked questions

No: Ferra builds the table from what you describe, it isn't a pre-made template. If you want a free static template, Vertex42's and Smartsheet's are good starting points.

No. Ferra updates the table from the files you upload and the emails you forward, a shipping confirmation or a stock report, for example, not from a physical count.

You can export what Ferra builds, but the table itself lives in Ferra and updates from what you feed it.

Upload one stock report and see the rows update.