EXCELCRAFT PRO TEMPLATE
Inventory management
with reorder planning.
Stop counting to find out what you have. Record what comes in and goes out, and the planner keeps stock levels, works out reorder points from real usage, and lists exactly what to buy.
Planned pricing: $8 a month or $60 a year. No payment is taken today.
- Stock from movements
- Reorder points from usage
- Suggested buy list
INSIDE THE WORKBOOK
Every sheet
has one job.
Mint cells are where you type. White cells calculate. Instructions inside the file explain each field.
- Dashboard
- Stock value, items to reorder, out of stock and median days of cover, with value by category and units in and out by month.
- Items
- Each SKU with cost, opening quantity, safety stock and lead time; received, issued, on hand, usage, reorder point, cover and suggested order calculate.
- Movements
- Every receipt, issue and adjustment with date and reference.
- Reorder
- The buy list: items at or below their reorder point with supplier, suggested quantity and order value.
- Settings · Checks · Instructions
- Usage window and cover days; checks that stock reconciles to movements.
WHY IT HELPS
Built around
the real task.
Receipts, issues and adjustments with automatic stock, reorder points and a buy list.
Stock that keeps itself
On hand = opening + received − issued + adjustments. No more editing quantities by hand.
Reorder points from real usage
Average daily usage over the last 90 days × supplier lead time + safety stock. Busy items reorder sooner automatically.
A purchase list, not just a warning
Reorder lists what to buy, how many and what it will cost, grouped with the supplier.
GETTING STARTED
Three steps
to your own version.
The sample shows a working example; the blank version keeps every formula ready for your records.
Set up items
Enter each SKU with unit cost, opening quantity, safety stock, lead time and supplier.
Record movements
Log deliveries as receipts, sales or use as issues, and stock-count differences as adjustments.
Order from the list
Open Reorder, check the suggestions and place your orders.
QUESTIONS
Before you begin.
Short answers about how the workbook behaves.
How is the suggested order worked out?
Enough to bring stock up to the reorder point plus a cover period (30 days by default) of usage.
What if an item has no sales yet?
Its usage is zero, so the reorder point equals safety stock until movements build up.
Does it value stock at FIFO or average cost?
It uses the unit cost on Items. For accounting valuation methods, use your accounting system.
Can I track several locations?
Use one workbook per location, or add the location to the SKU (for example TOTE-WH1).
How do I keep my changes?
Use Download XLSX or PDF in the editor before closing the tab. Nothing is saved to a server automatically, and your workbook never leaves your device while you edit.
Will it work in Excel and Google Sheets?
The files use standard XLSX formulas without macros, pivot tables or external links. They are checked with the ExcelCraft engine; compatibility with every Excel or Google Sheets version is not guaranteed. Review formulas, charts and formatting in your app before relying on important figures.
Can I change the currency?
Amounts use a $ number format. Change the cell format to your currency; the formulas do not convert between currencies.
EXCELCRAFT PRO · EARLY ACCESS
Part of
ExcelCraft Pro.
Pro workbooks cover whole workflows: purchasing to receiving, journal to balance sheet, tasks to portfolio health. Pro is planned to include AI credits for editing through chat. Pro downloads and the AI assistant are not available yet.
- Every Pro workbook as it is released, with dashboards, checks and instructions
- Planned: monthly AI credits for editing spreadsheets through chat
- Planned launch pricing; final terms are not set
$8/ month
or $60 / year · planned launch price
No payment today. We email you once when Pro opens.
How Pro worksRELATED
Works well with.
Separate workbooks for neighbouring jobs. Records do not sync between files.
Purchase Order & Receiving Tracker
POs, line items and deliveries, with late orders and supplier on-time rates.
See what is inside
Sales Report & Forecast
Sales by month, product and region against target, with a year-end outlook.
See what is insideYour workbook stays in this browser while you edit. Use Download in the editor to keep your work, and review important figures in the saved copy. How local files are handled.
Original ExcelCraft workbook design, formulas and fictional sample data · CC0. Management tool only; not tax, legal or accounting advice.