Inventory Excel templates: download them all

Inventory Excel templates: download them all

Here you will find every inventory Excel template we have published on the blog: eighty-six downloadable files arranged in twelve 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 twelve groups and what each one solves.

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.
• General journal template in Excel: entries that balance — The record of every entry, with a warning when one does not balance.
• General ledger template in Excel: balances by account — The same journal sorted by account, with each account's balance.
• Trial balance template in Excel — The eight columns that check whether the books agree.
• Journal voucher template in Excel: free download — The paper that supports an entry, with signatures.
• 12-column accounting worksheet template in Excel — Adjustments, results and balance on a single sheet.
• Chart of accounts template in Excel — The structure of accounts, with lists and a summary by type.
• Cash book template in Excel: receipts, payments and balance — The cash movement, with a running balance and a monthly summary.
• Bank book template in Excel — Each bank account's movement, with deposits, withdrawals and balance.
• Purchase book template in Excel — What was bought and from whom, with base, tax and withholding.
• Sales book template in Excel: sales and due dates — What was sold and is to be collected, with days to due date.
• Tax book template in Excel: output and input — The record of the tax charged and the tax you can offset, with a value check.
• Withholding book template in Excel — What was withheld from each third party, concept by concept and with its document.
• Payroll register template in Excel — What was paid in the period: gross, deductions, contributions and net, employee by employee.
• Inventory and balance book template in Excel — The accounts with their closing balances and the counted, valued inventory.
• Subsidiary ledger by third party template in Excel — The ledger opened by third party: who owes and who is owed, document by document.
• Aged receivables template in Excel — The five overdue buckets of the ledger, with days overdue and share of the total.
• Fixed asset depreciation template in Excel — The asset expense spread over its life, with book value and a check.
• Loan amortization template in Excel — How each instalment splits into interest and principal, until the loan closes at zero.
• Provisions template in Excel: receivables and inventory — The estimate of what will not be recovered, in receivables and in inventory.
• Debit note template in Excel: free download — The document that raises the value of a sale, with a reason and the document affected.
• Balance sheet template in Excel: assets, liabilities and equity — The statement that shows what the business owns and how it was financed, with the check that it balances.
• Cash flow statement template in Excel: indirect method — Where the period's cash came from and where it went, split into operating, investing and financing.
• Statement of changes in equity template in Excel — What moved equity during the year: contributions, distributions and the result for the year.
• Cost of production and sales statement template in Excel — The cost from raw material through to what was sold, to see where the margin is consumed.
• Notes to the financial statements template in Excel — The register of the notes that explain the statements, with their reference, owner and status.
• Adjusting entries template in Excel — The entries that bring the month up to date: depreciation, accruals, provisions and inventory usage.
• Year-end closing entries template in Excel — Closing the year: zeroing the income and expense accounts and moving the result into equity.
• Tax reconciliation template in Excel — The bridge between the accounting result and the tax base, item by item.
• Inventory and ledger reconciliation template in Excel — The bridge between the stock card and accounting, to explain inventory differences.

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.

The money side: cash, receivables, pricing and results

The templates that are not about inventory, for the money side of the business: income and expenses, cash flow and its forecast, annual budget, receivables and payables, bank reconciliation, income statement, selling price with margin and break-even.

• Income and expense tracker template in Excel: free download — Records what comes in and goes out of the month, with categories, payment methods and totals.
• Cash flow template in Excel: money in and out of the month — Follows cash day by day, with the balance after every entry.
• Cash flow forecast template in Excel: 12 months — The next twelve months: money in, money out and the months with a negative balance.
• Annual business budget template in Excel — The plan of the year by line and month, with monthly and accumulated result.
• Accounts receivable template in Excel: ageing and collection — The customer ledger with balance, days overdue and status by range.
• Accounts payable template in Excel: payments and due dates — Supplier invoices, what is overdue and what falls due this week.
• Bank reconciliation template in Excel — Explains with items the difference between the bank and the books.
• Monthly income statement template in Excel — Income, cost of sales, expenses, profit and margin month by month.
• Selling price template in Excel: cost plus margin — Works out the price from the cost and the target margin, product by product.
• Break-even template in Excel: units and sales value — The units you must sell to cover costs, with a chart.

Sales, costs and people: what you sell and who runs it

The second batch: the daily sales record, targets and commissions, the customer list, product costing and cost of sales, and the people side: hours, attendance, shifts, overtime and the KPI dashboard.

• Daily sales register template in Excel — One line per sale of the day, with the average ticket and the split by payment method.
• Sales targets and commissions template in Excel — Target against actual sales, with attainment, commission and bonus worked out.
• Customer database template in Excel — The customer list with credit limit, balance and available limit under control.
• Product costing template in Excel — Batch cost and unit cost, with scrap included.
• Cost of sales and gross profit template in Excel — Gross profit month by month: what the sale leaves after restocking.
• Timesheet template in Excel: hours worked — Clock-in and clock-out hours with hours worked and the amount to pay.
• Attendance tracker template in Excel — Who came and who did not, with the reason and the attendance rate.
• Shift schedule template in Excel — The shift plan of the month for everyone to see.
• Overtime template in Excel — Overtime by type, with multipliers you set yourself.
• KPI dashboard template in Excel — The business on one screen: figures, indicators and the twelve-month trend.

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.