Inventory Tracking Excel
Automatically calculates remaining stock from incoming and outgoing movements, the low-stock alert, and total stock value.
Warehouse Goods In/Out Slip Example (Excel Template)
A warehouse goods in/out slip is an internal document that records, in writing and with signatures, a single movement of goods into or out of the warehouse: what the goods are, how many, why they moved, and who handed them to whom. A stock table answers the question "how many do I have on hand?"; the slip answers "when did these 12 buckets of paint come in, through whose hands, and with which delivery note?" The first tab of this file is the printable slip itself: slip number, date, in or out type, delivery note (irsaliye) or invoice number, reason for the movement, counterparty, the item table, and three signature areas for the person handing over, the person receiving, and the warehouse manager are all ready; item amounts and the total are calculated by formula. The second tab is the slip register: every item of every slip is a separate row, so you can filter to see all the ins and outs of a product. The Summary tab gives the in and out amounts, this month's totals, and the amount for each movement reason — purchase, sale, transfer, return, and wastage — separately. Keeping the remaining stock is the job not of this file but of the stock tracking Excel template; you add the quantity on the slip to the In or Out column there.
Free download
Excel (.xlsx) · formulas, drop-down lists and colored alerts built in · no membership required.
📄 31 KB · .xlsx🧮 Formulas ready🔓 No password, no watermark💳 Free
What columns are in the template?
| Column | What it does |
|---|---|
| Slip No. / Date | The slip's serial number (e.g. DF-2026-0146) and the day of the movement. The number should increase without gaps; a lost or torn slip is the first place to look when explaining a count difference. If you want separate series for in and out, use the prefixes DG- and DÇ-. |
| Slip Type | Dropdown list: In (goods entering the warehouse) or Out (goods leaving the warehouse). |
| Document No. | The external document the movement is based on: the number of the supplier's delivery note (irsaliye, the Turkish dispatch note), a sales invoice, a return invoice, or a wastage report. The slip does not replace these documents; it is matched against them. |
| Movement Reason | Dropdown list: purchase receipt, customer return, receipt from production, transfer from branch, sales issue, return to supplier, issue to production / consumption, transfer to branch, wastage / damage write-off. The Summary tab separates the totals by this field. |
| Counterparty | The supplier who brought the goods, the customer who received them, the branch they were transferred to, or the staff member who took delivery of the material. |
| Stock Code / Product Name | Enter it exactly as the code in your stock table; this is the link that matches the two files. If you have no coding system, you can write the barcode on the item row. |
| Unit / Quantity | Unit from the dropdown list (piece, kg, liter, meter, m², case, pack, box, set). Quantity is the amount going in or out on that slip, not the remaining stock. |
| Unit Cost / Amount | Unit cost is the product's purchase cost; the amount is automatic: Quantity × Unit Cost. Outgoing items are also valued at cost, so in and out amounts are compared on the same basis. Selling price is a matter for the invoice and the price list. |
| Shelf / Note | The shelf location where the goods were placed or taken from, and a note for any item that arrived short or damaged. |
| Handed Over By / Received By / Warehouse Manager | Three signature areas. On an incoming slip, the person bringing the goods hands them over and the storekeeper receives them; on an outgoing slip, the reverse. A slip without signatures does not show who is responsible when there is a count difference. |
| Slip Register and Summary | On the Data tab, each item is a single row with the same slip number. Summary: number of unique slips, item rows, total and this month's in and out amounts, and amount by movement reason. |
How to use it
- Download the file and, at the top of the "Goods In/Out Slip" tab, write your business name, the warehouse name, and the warehouse manager.
- When goods enter or leave the warehouse, assign a new slip number and select the date and slip type; if there is a supplier delivery note, invoice, or report, write its number in the Document No. field.
- Select the movement reason from the list and write the counterparty; then enter each product on its own row with stock code, name, unit, quantity, and unit cost. On receipt, count the goods one by one against the delivery note and write any shortage or damage in the note column; the receiving steps and checklist are in the how to receive goods guide.
- Print the slip, have the person handing over and the person receiving sign it at the same time, and file it together with a copy of the delivery note or invoice. For a sales issue where the goods are shipped to the customer, the slip documents the exit from the warehouse; track which vehicle or courier the goods went with, and whether they were delivered on the promised day, in the shipment tracking sheet.
- Add each item of the slip to the "Data" tab with the same slip number and post the quantities to the In or Out column of your stock tracking table. At month-end, check the wastage and return amounts on the Summary tab.
Who is it for?
- Warehouses, wholesalers, and distributors that receive goods from suppliers and want a signed delivery record
- Chain stores that send goods from a central warehouse to their branches and want both sides to sign the transfer
- Workshops and construction companies that issue raw materials to production, or materials to a site or to staff
- Small businesses that want to trace, slip by slip, where count differences come from
Frequently asked questions
What is a warehouse goods in/out slip?
A warehouse goods in/out slip is an internal document, signed by both parties, that records for a single movement the type and quantity of goods entering or leaving the warehouse, the reason for the movement, and the people handing over and receiving. It shows which movement the stock records are based on and is the first document checked when a count difference turns up.
What should a warehouse in/out form contain?
At a minimum: slip number, date, whether it is in or out, reason for the movement, counterparty, the delivery note (irsaliye) or invoice number it is based on, the stock code, product name, unit, and quantity for each item, and the name and signature of the person handing over and the person receiving. If you also write the cost, at month-end you can see the value of goods that came in and went out.
Does a warehouse in/out slip replace a delivery note or an invoice?
No. This slip is the business's own internal record; it does not take the place of documents such as the dispatch note (irsaliye) or invoice that must be issued for transporting and selling goods. Which official document is required for which movement depends on your business's situation; consult your accountant about it. You match the two by writing that document's number in the slip's Document No. field.
How do I keep a warehouse in/out register?
Each item of each slip is written in the register as a separate row, with the slip number: date, in or out, reason, counterparty, product, quantity, and signatories. This template's Data tab is that register; when you filter on a product's name, all its movements appear in date order. The register keeps movements; for a product's remaining quantity, post the movements to the stock tracking table.
If I have a stock tracking table, do I still need to keep slips?
The stock table shows only the result: the remaining quantity. The slips are the evidence for every movement that led to that result. If a count comes up 5 units short and the table says only "Out 45," you cannot find the cause; in the slips, you can see which day, for what reason, and with whose signature it went out. We explain how to resolve a count difference on the stock count report page.
How do I record transfers between warehouses or branches?
The sending warehouse issues an out slip with the reason "Transfer to branch," and the receiving warehouse issues an in slip with the reason "Transfer from branch / warehouse"; each slip's number is written in the other's Note field. That way, by comparing the quantities on the two slips, you can see whether goods were lost in transit.
How do I write off wastage or damaged goods?
Issue an out slip with the reason "Wastage / damage write-off," write the number of the wastage report in the Document No. field and the cause in the Note field; the Summary tab gives the wastage amount separately at month-end. To calculate the wastage rate, you can use the wastage rate calculator; consult your accountant for how to book the wastage in your accounts.
Can I track warehouse in/out with software instead of Excel?
For a few movements a day, this Excel file is enough. As the number of movements grows, writing the slip and then posting it separately to the stock table becomes double work, and that is where errors creep in. In warehouse tracking software, stock updates the moment a purchase, sale, or return is entered, and each product's movement history is kept automatically; Ofisx Inventory Management has barcode purchase, sale, and return, stock counts, and movement history.
Is the template free, and is it available as Word or PDF?
Yes, it is free; it asks for no email, membership, or payment, and has no watermark or cell protection. The file is in Excel (.xlsx) format because item amounts and totals are calculated by formula. You can open it in Excel, Google Sheets, or LibreOffice and print it, or convert it to PDF with "Save as PDF." For a blank slip, delete the sample items, print it, and fill it in by hand.
Related templates
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.
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.
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.
Last updated: October 6, 2026
Search terms: warehouse goods in/out slipwarehouse in/out form excelwarehouse goods in/out slip examplewarehouse in/out registerwarehouse in/out excel sheetmaterial in/out slip