Skip to content
WarehouseCalcFree · beta · no account needed
WarehouseCalc file tools · Free · beta · no account needed

Stock control tools that show their working.

Five tools for stores, warehouses and inventory teams whose records live in Excel or CSV: find dead stock in years of movement history, reconcile two stock reports, run a physical count against book stock, check a 3PL invoice against your rates and records, and turn an existing workbook into a clear dashboard. Files are read in your browser, and every result points back to the rows behind it.

Free to use, no account or payment details needed. Your files are read in your browser and are not uploaded. How it works

Results dashboard of the Dead Stock Analyzer: 24 of 94 items with no qualifying movement for a year or more, a band chart and a reliability panel
Dead Stock Analyzer results with invented sample data.

Five free tools

Each one reads your Excel or CSV files inside your browser and gives you an Excel report you can check line by line. The screens below show invented sample data. All five are beta versions, tested on synthetic data.

Dead Stock Analyzer

Beta

Find stock with no qualifying movement for 1, 2, 3 or 5 years from years of movement history, with the source rows behind every result.

You need
One .xlsx workbook (or a CSV file) with movements, or monthly consumption per item (one column per month); stock lists optional.
You get
Excel report with dashboard, item list, movement history, data checks and method.

Stock Reconciliation & Variance Analyzer

Beta

Compare two stock reports line by line — system against warehouse, or two dates. Shows matched lines, quantity differences, lines missing from either report, duplicate keys and ambiguous matches, with the reason for each.

You need
Two .xlsx or .csv stock reports; column names may differ. Match on item code, plus location, batch or lot when you have them.
You get
Excel report: summary, every line with its source rows, rows not used, both sources and the matching rules.

Physical Stock Count & Variance Report

Beta

Run a stock count against book stock: count sheet to print or fill in, counts imported or typed on screen, variance by line, recounts and reviewer comments.

You need
Book stock as .xlsx or .csv; counts as a file (the filled-in count sheet works) or typed on screen.
You get
Printable count sheet and an Excel variance report with the calculation for every line.

Excel Workbook Designer

Beta

Choose the spreadsheet you already keep, in your own layout (up to four files). The designer reads it, says what it found and what is missing, asks only what it cannot tell, and makes a clear workbook from your actual data: a WarehouseCalc attendance register or stock list, a new register from an employee list, or a redesigned copy with a dashboard.

You need
One or more .xlsx or .csv files with tables under headings: attendance registers or logs, employee lists, stock or item lists, expenses, other tables.
You get
A professionally designed workbook built from your data, checked against your file, with a list of every change and of what is left to complete.

3PL Invoice Audit

Beta

Check a 3PL invoice against your contracted rates and your own order, shipment and receipt records. Every flagged line shows the billed and expected amount, the evidence used and what to do next; a line that is not flagged was not contradicted by the checks that could run.

You need
The 3PL's detailed invoice as .xlsx or .csv (required); your rate card and an operational export (optional).
You get
Review queue on screen, an Excel evidence report with every line, finding, reconciliation and method, and a draft query to edit and send yourself.

Read the guide to 3PL invoice auditing

Excel inventory workbooks

Keep your stock records in Excel: stock in, stock out and balances, every row checked, no macros. These are not beta tools and need no account: Simple is free for everyone, Custom and Advanced are paid once; their prices are on the workbooks page.

Simple Inventory workbook

Free download

Items, stock in, stock out and a balance for every item, with OK, LOW, OUT and NEGATIVE status and every row checked. The dashboard shows key figures, an item card with a 12-month chart, items by status and store activity, and updates as you type.

One location, up to 1,000 items and 5,000 rows each of stock in and stock out. Excel 2016 or later, no macros. Version 1.3.0.

Custom Inventory workbook

Paid, one-time · ordering opens soon

Everything in Simple with your business name, your own units and lists, and the parts you choose: several locations with transfers, a reorder list with order quantities, monthly usage per item. Same dashboard as Simple.

Up to 1,000 items, 5,000 rows per sheet and 20 locations. Generated from your choices.

Advanced Inventory System (beta)

Paid, one-time · beta · ordering opens soon

Goods receiving, material requests and issues, transfers, returns, adjustments, stock counts, batches and expiry, consumption reports and printable forms, with a configurable dashboard of key figures, alerts and charts.

Reports cover the first 200 items and 12 locations (expiry report: 300 batches).

Free to use, no account needed

Open any tool and start. There is no sign-up, no approval and no payment. The tools are still in beta: results have been checked on synthetic data, so compare them with what you know and tell us what is wrong or missing on the contact page.

  1. Open a toolFrom the list above or the tools page.
  2. Try the sample filesEach tool has invented sample files, so you can see what it does before you use your own.
  3. Use your own filesExcel or CSV, in your own layout. They are read in your browser and not uploaded.
  4. Download the reportEvery result points back to the rows behind it. Nothing is kept after you close the tab unless you switch on the 3PL audit history, which stays in your browser.

How each tool works

  1. Choose your files.Excel (.xlsx) or CSV, up to 50 MB and 300,000 rows each. Column names and order may differ between files.
  2. Confirm how they are read.Columns and rules are suggested; you confirm them. The rules are shown on screen and written into the report.
  3. Review and download.Filter the results, open any line to see the rows behind it, then download the Excel report.

Your files stay in your browser

The tools read your Excel and CSV files inside your own browser tab. They are not uploaded to WarehouseCalc or anyone else, stored in a database, or sent to an AI service. In our tests the only requests the tools made were for their own program files and sample files. Reports are created in your browser and saved straight to your device. Like any website, our hosting and security providers see ordinary request information such as your IP address. No account is needed, so we keep nothing about you for the tools. Read the privacy notice.

Who the tools help

  • Storekeepers and inventory controllers who compare system stock with warehouse records
  • Teams running a year-end or cycle count from a printed or Excel count sheet
  • Spare-parts, MRO and distribution stores looking for stock that has stopped moving
  • Accountants preparing a stock ageing or count variance for a year-end review

Questions

Is it free?

Yes. The five tools are free to use and need no account, sign-up or payment details. The Excel inventory workbooks below are separate: Simple is free, Custom and Advanced are paid once.

Do I need an account?

No. Open a tool and use it. Accounts from the earlier controlled beta still work but are not needed.

What files are supported?

Excel .xlsx and CSV (.csv or .txt; comma, semicolon, tab or bar separated). The Workbook Designer also reads .xlsm, but its copy has no macros. Old .xls, .xlsm, .ods, password-protected and PDF files are not read: save them as .xlsx or CSV first (for a 3PL invoice, ask the provider for the invoice detail as Excel or CSV). Up to 50 MB and 300,000 rows per file.

What do I need in my files?

Dead Stock Analyzer: item code, date, movement type (or quantity in and out) and quantity — or one row per item code with a column per month of consumption and the current stock. Stock reconciliation: two stock reports with item code and quantity; location, batch, lot and unit cost help. Stock count: a book stock list (item code and quantity) and the counts, from a file or typed on screen. Workbook Designer: any table with a heading row; stock lists, attendance registers (one column per day, or one row per person and day) and general tables get their own dashboards. 3PL Invoice Audit: the detailed invoice export with at least a line amount; a rate card and an operational export are optional and add checks.

Are my files uploaded or stored?

No. They are read inside your browser tab and discarded when you close it; reports are created in the browser and saved to your device. No account is needed for the tools.

What are the limits of the beta?

Results have been checked on synthetic data only, and the Excel reports have been checked in LibreOffice, not yet in Microsoft Excel. Nothing is saved between visits: column choices, review notes and results go when you close the tab, so download the report (the 3PL Invoice Audit can keep column choices and audit summaries in your own browser if you switch that on). The tools never change your stock system or ERP, and a difference between two figures is shown as a difference to check, never as proof of loss or error. They work best in a current Chrome or Edge on a computer.

Can I try it without my own data?

Yes. Each tool has a button that loads invented sample files.