Inventory Excel templates: download them all

Here you will find every inventory Excel template we have published on the blog: thirty-seven downloadable files arranged in ten groups, according to the problem each one solves. You start with the basics, the stock ledger and the stock cards, and then move on to counting, reconciliation, warehouse documents, purchasing, food and expiry control, shrinkage, cash, accounting and warranties. If you ever looked for a specific template and could not find it, this index is the shortcut: a complete list, in order and with no detours.

Each link opens the article in English where the green button downloads the .xlsx file, the same file you can open in Excel or upload to Google Sheets. You can adapt it to your operation, change its fields and share it with your team. The plan is simple: download it, fill it with your data and start controlling inventory today, knowing there is a next step once volume grows. Pick the group you need, open the article and get the template.

This is the overview: the ten groups and what each one solves.

Group	What it solves
Stock ledger and stock cards	How each item moves and its balance, in the classic card and in the valued version.
Inventory: counting, reconciliation and control	How to count, compare the count with the system and load opening inventory.
Warehouse: receipts, issues, transfers and returns	The daily warehouse documents that keep stock aligned.
Start-up and closing kits	Ready-made packs to start inventory and to close it with supported adjustments.
Purchasing, orders and suppliers	From the internal request to the purchase order, goods receipt and vendor evaluation.
Food, batches and expiry	Control of perishable goods, with batches and dates ordered for issue.
Shrinkage and waste	A record of what is lost, damaged or expired, with cause and cost.
Cash and commercial documents	Invoice, quotation, receipts, cash count and the other daily sales paperwork.
Accounting, costs and assets	The asset register and the split of expenses by area or process.
Warranties and serials	The link between product, serial number and warranty date to handle claims.

Now, group by group, with every template and its download link.

Stock ledger and stock cards

kardex template in Excel — The base template: a stock ledger sheet with receipts, issues and a running balance that follows every item, one by one.
printable kardex card — The paper version, ready to print, with the classic stock ledger columns and a short guide to filling it in by hand without mistakes.
weighted-average kardex template — Adds unit cost and valued balance, so you know how much money sits still in each inventory reference.

Inventory: counting, reconciliation and control

Inventory control template in Excel: free download — Logs receipts and issues and recalculates on-hand stock; a solid first base before moving to software.
Physical inventory count sheet template in Excel: free download — A sheet to count product by product on the floor, with counted, difference and remarks columns on every line.
Cycle count plan template in Excel — Plans which items to count each day or week, so you cover the whole inventory in parts without stopping the operation.
Inventory reconciliation template in Excel — Compares what the system says with what was counted and keeps a trace of each difference and its adjustment, line by line.
Opening inventory template in Excel — Used to load your product list with quantities and costs for the first time, right when control begins.
Free inventory template for Google Sheets — The same inventory logic in a template built for Google Sheets, so you can work online and share it with your team.

Warehouse: receipts, issues, transfers and returns

Goods received note template in Excel: free download — Records the goods that arrive, with supplier, quantities and the signature of whoever receives the order.
Warehouse issue slip template in Excel: free download — Documents what leaves the warehouse, who collects it and where it goes, so nothing leaves unsupported.
Inter-warehouse transfer template in Excel: free download — Tracks product moving between two locations, so stock balances at both ends.
Returns register template in Excel: free download — Keeps a record of what comes back from the customer or goes back to the supplier, with reason and item condition.
Warehouse operations kit in Excel: issue slips, transfers and returns — Brings the three daily operation forms into one file: issue slips, inter-warehouse transfers and returns.

Start-up and closing kits

Inventory startup kit in Excel: 3 downloadable templates — Three templates together to get inventory started: opening list, opening count and basic data capture.
Inventory closing kit in Excel: counting, reconciliation and adjustments — Combines counting, reconciliation and adjustments to close the period with inventory reviewed and well supported.

Purchasing, orders and suppliers

Purchase order template in Excel: free download — Formalises what you order from a supplier, with prices, quantities and terms agreed in writing.
Vendor directory template in Excel: free download — A tidy list of contacts, terms and details for every supplier, so you stop hunting for them every time you buy.
Purchase requisition template in Excel: free download — The internal request raised by the warehouse or by the area that needs the item, before it becomes a purchase.
Backorder tracking template in Excel — Follows what has been ordered but not yet delivered, so you know what is missing, from whom and whom to chase.
Goods receipt form in Excel — Notes what was received, how much and in what condition, as the step before it formally enters inventory.
Supplier scorecard template in Excel — Sets criteria and scores to compare suppliers and decide who is worth keeping for the year ahead.

Food, batches and expiry

Expiry and batch tracking template in Excel: free download — Watches expiry dates and batches, so you move out first what expires first and avoid silent losses.
Food and expiry control kit in Excel: 3 templates — Three templates to control food, batches and expiry in businesses that handle perishable goods.

Shrinkage and waste

Shrinkage and waste control template in Excel — Logs what is damaged, lost or expired, with cause and cost, so you tackle the problem with data instead of guesses.

Cash and commercial documents

Sales invoice template in Excel: free download — An invoice form for your sales, with customer details, product lines and totals.
Quotation template in Excel: free download — Presents prices and terms to a customer before the sale, with validity and an easy-to-read breakdown.
Cash receipt template in Excel: free download — Proves the money coming in, with date, amount, concept and the signature of whoever receives it.
Payment voucher template in Excel: free download — Supports the payments that leave the cash box, with payee, amount and the reason for the outlay.
Cash count sheet template in Excel: free download — Counts the money at the end of a shift or day and compares the result with what should be in the drawer.
Delivery note template in Excel: free download — Travels with the goods going out to the customer and supports the delivery at the door.
Petty cash template in Excel: free download — Controls the small day-to-day expenses, with their receipts, so the detail is not lost at month end.
Cuenta de cobro template in Excel (Colombia) — A form to present the charge for a service or a job, with a breakdown of what was done.
Credit note template in Excel — Records an adjustment or a return on a sale that had already been invoiced.

Accounting, costs and assets

Fixed assets register template in Excel: free download — Lists the assets you own, their value and their condition, so you know what you have and what it is worth.
Cost center template in Excel — Splits expenses by area or process, so you can see which part of the business consumes the most each month.

Warranties and serials

Warranty and serial number tracking template in Excel — Links each product to its serial number and warranty date, so you reply fast when a customer makes a claim.

When does it make sense to move from templates to software? When inventory no longer fits in a spreadsheet: several warehouses, hundreds of items, more than one person editing the same file, or the need for instant history and reports. That is when templates become a bottleneck and the natural step is a system such as Kardex Tauro, which does the same work without formulas that break. Until that moment arrives, start with the template that helps you most today: download it, open it and build your control with real data.

Labels:

#templates #excel #downloads