Free · no sign-up · in English

Ready-made Excel templates with formulas for your business

📱 Rather use your phone than a spreadsheet? Ofisx Inventory Management scans barcodes with the camera, deducts stock on every sale and keeps customer accounts, on Android, iPhone and the web with one account: App Store · Google Play (Pro from $10.99/month in the US; the offline version without an account from $3.39/month or $20.99 lifetime). Compare it with other options in our best inventory apps for small businesses (2026) comparison.

Files you can download and start filling in for tracking inventory, customer accounts, credit sales, invoices, orders, and income and expenses. Formulas, dropdown lists, critical-level alerts, and a summary sheet come already set up.

22 ready-made templates 0 cost, 0 forms 12 calculators .xlsx Excel · Sheets · LibreOffice

What is an inventory tracking Excel template? An inventory tracking Excel template is a ready-made .xlsx file that keeps your product list and stock in/out movements in the same workbook and automatically calculates the remaining quantity and total stock value with formulas. All 22 templates here are free, require no membership or email address, and open in Excel, Google Sheets, and LibreOffice.

Free Excel templates

Every file has two sheets: the table where you enter data and a summary that totals the figures automatically. Just delete the sample rows and type in your own data.

Inventory Tracking Excel

Automatically calculates remaining stock from incoming and outgoing movements, the low-stock alert, and total stock value.

31 KB · .xlsx · with formulas

Customer Account Tracking Excel

A statement table that tracks the debit–credit balance per customer or supplier account across all transactions and gives due-date warnings.

28 KB · .xlsx · with formulas

Store Credit Ledger Excel

A digital ledger that automatically calculates, per customer, the credit extended, the amount paid, the remaining balance and the number of days overdue.

28 KB · .xlsx · with formulas

Warehouse Count / Inventory Excel

Compares the quantity in your system with the physical count and automatically reports shortages, surpluses and the value of the loss.

29 KB · .xlsx · with formulas

Income and Expense Table Excel

Totals income and expenses by category; calculates VAT, the grand total and net profit/loss automatically.

26 KB · .xlsx · with formulas

Daily Cash Book

Keeps a day-by-day record of cash going into and out of the cash box; automatically finds the difference between the end-of-day count and the book.

27 KB · .xlsx · with formulas

Invoice Tracking Excel

Brings issued and received invoices, VAT, collections and overdue receivables together in a single table.

35 KB · .xlsx · with formulas

Order Tracking Excel

Tracks orders by channel, status, amount and shipping tracking number; calculates delivery time in days.

27 KB · .xlsx · with formulas

Product Price List Excel

A price list with barcodes that automatically calculates the selling price from the purchase price and profit margin, plus the shelf price including VAT.

27 KB · .xlsx · with formulas

Asset Assignment Tracking Excel

Automatically tracks which fixed asset is held by which employee, the planned return date and the total value of assets out on assignment.

28 KB · .xlsx · with formulas

Account Reconciliation Form

Combines a printable reconciliation form to send to the other side with tracking of replies and differences for the reconciliations you've sent, all in one file.

37 KB · .xlsx · with formulas

Account Statement Example

Lists a single account's transactions for the period with a running balance and automatically fills in the A4 statement document to send to the customer.

30 KB · .xlsx · with formulas

Stock Count Report

A printable report, signed by the counting team, that records when, where, and by whom the count was done and its result; the result figures come automatically from the product list.

33 KB · .xlsx · with formulas

Cash Count Report

Counts the money in the drawer by banknote and coin denomination, compares it with the recorded balance and works out the cash shortage or overage; a printable document for the person handing over and the person taking over to sign.

30 KB · .xlsx · with formulas

Collection Receipt

A printable two-copy receipt that documents a payment received from a customer with the date, serial no., amount (in figures and words), payment method, and remaining balance owed; the list of issued receipts is on a separate tab.

21 KB · .xlsx · with formulas

Payment Voucher

A printable two-copy voucher that has the person receiving a cash, bank-transfer, or check payment from the business sign for it; the list of issued vouchers and the total by expense type are on separate tabs.

22 KB · .xlsx · with formulas

Price Quotation Form

A printable quotation document for a single customer, with a validity date and discount and VAT calculated by formula; the list of quotes issued and the acceptance rate are on separate tabs.

28 KB · .xlsx · with formulas

Check & Promissory Note Tracking

A tracking table that keeps checks and promissory notes received and issued in one list with due date, amount, status and endorsement details; it counts the days left to maturity and gives separate totals for what will be collected and what must be paid this month.

30 KB · .xlsx · with formulas

Warehouse Receipt and Issue Voucher

A printable voucher that documents every item entering or leaving the warehouse line by line, with the signatures of the person handing over and the person receiving; a log of all vouchers and totals by movement type are on separate tabs.

31 KB · .xlsx · with formulas

Employee Advance Tracker

A sheet that keeps the advances given to employees, the amounts deducted from salary and the amounts repaid in cash in a single list, and shows each employee's remaining advance by formula; the advance receipt to be signed is on the first tab.

36 KB · .xlsx · with formulas

Auto Repair Work Order Form

A printable work order that is filled in when the vehicle is received and signed by the customer, with parts and labor totaled separately; the plate-based service record of every job and the monthly parts/labor revenue are on separate tabs.

37 KB · .xlsx · with formulas

Shipment Tracking Excel

A sheet that tracks every shipment going out to a customer by delivery note no., vehicle or courier tracking no., and number of packages; includes a printable shipment form, days late, and on-time delivery rate by customer.

38 KB · .xlsx · with formulas

Why these templates?

Most "free templates" online either ask for your email or are just an empty spreadsheet. These are ready to fill in.

Formulas built in

Remaining stock, running balance, VAT, profit margin, days overdue — everything is calculated automatically. You don't need to write any formulas.

Color-coded alerts

Critical stock, overdue collections, and missing count rows are highlighted automatically with conditional formatting.

Summary sheet

Figures like total stock value, money tied up in unpaid receivables, and net profit/loss are ready and waiting on a separate sheet.

Dropdown lists

Fields such as category, unit, and status are picked from a list, so there are no errors caused by typos or inconsistent spelling.

No sign-up needed

No email, no membership, no credit card. Press the button and the file downloads.

Opens in any program

Compatible with Excel, Google Sheets, LibreOffice, WPS, and Numbers.

When does Excel start to fall short?

Excel works more than well enough for businesses run by one person with no more than a few hundred items. But when these three situations come up, a spreadsheet starts to slow you down:

  • More than one person enters data in the same file. Version confusion and lost work from overwriting become unavoidable.
  • You need mobile access. Filling in a wide spreadsheet on a phone in the field, at the counter, or in the warehouse is hard.
  • Tracking needs to be automated. Critical stock notifications, due-date reminders, and matching invoices to payments can't be done by hand.

At that point, switching to an app that brings inventory, customer accounts, and basic bookkeeping together in one dashboard saves time. Your Excel file won't go to waste — you can import your data.

Free calculators

Quick answers to a single question without downloading a template: extracting VAT, selling price, the effect of a discount on profit, inventory turnover, reorder point, and barcode labels.

VAT Calculator

VAT-inclusive to exclusive and exclusive to inclusive. 1%, 10% and 20% are preset; net amount and VAT amount instantly.

Profit Margin Calculator

From purchase price to selling price, from selling price to margin. It shows markup on cost and margin on sales separately.

Price Increase and Discount Calculator

The new price after a percentage increase or discount, the rate of change between two prices, and the effect on profit.

Inventory Turnover

How many times a year does your stock turn over, in how many days does it sell out, and how much cash is tied up in the warehouse?

Reorder Level Calculator

At what level should you place an order? It finds the critical level from daily sales and lead time.

Barcode Generator

Generates EAN-13 and Code 39 barcodes, calculates the check digit and prints them as a label sheet.

Late Payment Interest Calculator

Late-payment interest (vade farkı) on overdue receivables, the selling price for sales on credit terms, and the VAT on that interest; the number of days is calculated from the dates.

Safety Stock Calculator

How many units should your buffer hold? It measures sales fluctuation and supplier delay separately.

VAT Withholding Calculator

On a invoice with VAT withholding, the VAT the buyer pays and the amount the seller collects. From the VAT-exclusive amount, the VAT-inclusive amount or the amount paid.

Waste Rate Calculator

Wastage rate and yield percentage, the TL value of the wastage and the true unit cost including wastage.

FIFO Cost Calculator

Cost of goods sold and remaining stock using FIFO from purchase batches at different prices; a comparison with weighted average and LIFO.

Cost of Goods Sold

Opening stock + net purchases − closing stock: cost of goods sold, gross profit and turnover rate.

Guides

Practical walkthroughs to help you use the templates more effectively.

How do you track inventory with Excel?

Step-by-step setup of inventory tracking in Excel: which columns you need, which formulas to use, how to set up a reorder-level alert, and when Excel is no longer enough.

What is an account ledger and how do you track it?

What an account ledger means, how debits and credits are recorded, how to read the balance and how to set up due date tracking. A step-by-step guide with an Excel template.

How to keep a customer credit ledger in Excel

What information should a credit ledger contain, how do you speed up collections, and what limits should you set? Practical methods for small shopkeepers and a free Excel template.

Frequently asked questions

Are the templates really free?

Yes. All files are free; they don't ask for a membership, email, or credit card. The files have no watermarks or locked cells, and you can use them commercially in your business.

Can I download without signing up?

Yes, just click the download button. You don't need to fill in any form.

I don't have Excel — can I still use them?

Yes. The files are in .xlsx format; they open in Google Sheets, LibreOffice Calc, WPS Office, and Numbers, and the formulas work.

Can I modify the templates?

Of course. You can add columns, edit the formulas, and define your own categories. The files are not protected.

When do I need a program instead of Excel?

A program becomes more efficient when your number of products or customer accounts goes past a few hundred, when more than one person enters data at the same time, or when you need mobile access and automatic reminders.

Are the templates in English?

Yes, all headings, drop-down lists and notes are in English; the formulas work in every language version of Excel.