Tent House Stock Register Format in Excel: Daily Stock, Issue, Return & Missing Items
Inventory & Godown

Tent House Stock Register Format in Excel: Daily Stock, Issue, Return & Missing Items

Need a tent house stock register format in Excel? Copy this practical stock summary and movement register for chairs, pipes, carpets and decoration items. Learn the formulas to calculate total and available stock, track event dispatch and returns, and record repair, missing and scrap items.

By LaganBook Editorial Team
•
8 min read
•

Key Takeaways & Executive Summary

The main points at a glance

  • Use one unique item code for each tent house stock item or variant.
  • Keep a Stock Summary sheet for available quantity and a separate Stock Movement log for every dispatch and return.
  • Excel formulas can calculate total stock and available stock from opening, purchase, issue, repair and shortage quantities.
  • Use gate-pass numbers to connect event dispatch with the return count.
  • Physically verify high-value and frequently moved items, then investigate differences instead of overwriting old records.

What a tent house stock register should track

Track availability, not just purchases

A useful register should answer what you own, how much is in the godown, what is currently issued, what is in repair, and what is missing or written off.

Keep the item master separate from the movement history. The master stores a current summary; the movement log records every purchase, dispatch, return, repair transfer, sub-rent receipt or write-off.

  • Item code and item description
  • Unit and opening quantity
  • Current issue and sub-rent status
  • Repair, missing and scrap quantities
  • Available stock and reorder level
“A stock register is useful only when it tells you what is available for the next booking.”

Tent house stock register format for Excel

One row per item code

Use columns for Item Code, Item Name, Unit, Opening Qty, Purchase Qty, Sub-rent Received, Total Stock, Currently Issued to Events, Sub-rent Out, In Repair, Missing, Scrap / Written Off, Available Qty, Reorder Level, Godown / Location and Remarks.

Use separate item codes for different sizes, quality levels or rental rates. The sample quantities in this article are illustrative.

  • TNT-CHA-001 — Banquet Chair – White — 350 total, 215 available
  • TNT-PIPE-002 — MS Pipe 10 ft — 210 total, 100 available
  • TNT-CAR-003 — Red Carpet 6 ft — 14 total, 9 available
“Standardise item names and units before entering the first stock count.”

Excel formulas to calculate stock automatically

Total stock and available stock

For columns A to P, Total Stock in G2 is =SUM(D2:F2). Available Qty in M2 is =G2-SUM(H2:L2). Copy the formulas down the sheet.

Apply conditional formatting when Available Qty is less than or equal to Reorder Level. Reduce Currently Issued only after the returned quantity has been checked in.

  • G2: =SUM(D2:F2)
  • M2: =G2-SUM(H2:L2)
  • Optional status: =IF(M2<=N2,"REORDER","OK")
“Do not treat an event dispatch as a permanent reduction in owned stock.”

Use a separate stock movement register

Keep the history instead of overwriting it

Create a second sheet with Date, Voucher / Gate Pass No., Item Code, Item Name, Transaction Type, Event / Customer / Vendor, Qty In, Qty Out, Issued By, Received By, Vehicle / Location, Checked By and Remarks.

Use consistent transaction types such as Purchase, Sub-rent Received, Event Dispatch, Event Return, Sub-rent Out, Repair Transfer, Repair Return and Scrap / Write-off.

  • Link the event dispatch and return with the gate-pass number
  • Add a return entry; do not delete the original dispatch
  • Record damage or shortage after the physical count
“Every dispatch should have a corresponding return check.”

Item coding and godown organisation

Make stock easy to identify

Use a code such as CHA-001 for chairs, PIPE-010 for pipes, CAR-003 for carpet rolls and LED-014 for lights. Use consistent units such as pcs, sets, pairs, rolls, bundles, metres or square feet.

Record location in a repeatable format such as Godown A / Rack 02 / Shelf 03 so staff can find items quickly.

  • One unique code per item variant
  • One standard unit per item
  • A fixed location naming convention
“Good item coding saves time before the truck leaves the godown.”

Daily stock-control routine for tent house teams

Dispatch, return and weekly verification

Before dispatch, compare the event checklist with available stock and issue a gate pass. On return, count the items before mixing them with general stock. Move repair items to a separate location.

Count high-value and frequently moved items physically every week, investigate mismatches and keep a backup copy of the workbook.

  • Check and record before dispatch
  • Count and reconcile after return
  • Review differences weekly
  • Restrict editing and maintain backups
“Record every movement on the day it happens.”

Excel register vs a digital stock-management system

Move to connected workflows when the operation grows

Excel is a good starting point for a small team. It becomes harder to coordinate when several people update stock, multiple events overlap or dispatch, returns and bookings need to be linked.

LaganBook helps Indian event-service businesses connect bookings, inventory and day-to-day business workflows.

  • Booking-date-aware stock visibility
  • Dispatch and return tracking
  • Missing, damaged and repair workflows
“A connected workflow becomes valuable when stock, bookings and teams need to stay in sync.”

Free templates and next steps

Start with a consistent format

Browse the LaganBook template collection for event-business formats, including quotation and gate-pass resources. Adapt the columns and item codes to your own godown.

For broader missing and damaged stock controls, read the existing tent-house godown stock-management guide. This article focuses on the Excel register and formulas.

  • Choose standard item codes and units
  • Record every movement with a voucher number
  • Review the available balance before confirming a booking
“An accurate register starts with a consistent daily process.”

Frequently Asked Questions

Direct Answers & Industry Standards

Q:What columns should a tent house stock register contain?

At minimum, record item code, item name, unit, opening quantity, purchases, stock received, quantity issued, quantity in repair, missing quantity, scrap, available quantity, reorder level and godown location. Keep a separate movement log for each dispatch and return.

Q:How do I calculate available stock in Excel?

For the summary format in this guide, Total Stock equals Opening Qty plus Purchase Qty plus Sub-rent Received. Available Qty equals Total Stock minus Currently Issued to Events, Sub-rent Out, In Repair, Missing and Scrap / Written Off. The article includes the corresponding Excel formulas.

Q:Should I make a separate stock register for every tent house item?

Use one row per unique item code in the summary sheet. Keep different sizes, colours, qualities or rental variants under separate codes when they need separate tracking. The movement log can contain many transactions for the same code.

Q:How should I record material dispatched for a wedding?

Record the date, event or customer, item code, dispatched quantity, gate-pass number and the person who issued it. When the material returns, add a separate return entry and record the checked quantity, damage and shortage.

Q:How often should tent house stock be physically checked?

Check stock at every dispatch and return. In addition, physically count high-value and frequently moved items at a regular interval, such as weekly, and investigate differences between the physical count and the register.

Q:Is Excel enough to manage tent house inventory?

Excel can work for a small operation with a limited number of editors. When multiple teams, godowns, overlapping event dates, gate passes, returns and repairs must stay connected, a dedicated inventory workflow can be easier to control.

Q:Where can I find tent house quotation and gate-pass formats?

LaganBook has a template collection for event-service businesses. Visit the Templates page to review available quotation and gate-pass formats, then adapt them to your own business process.

LaganBook Editorial Team

LaganBook Editorial Team

Verified Industry Expert

Event Industry Analyst

The LaganBook Editorial Team publishes practical guides for Indian event-service and rental businesses, covering bookings, stock control, quotations, billing and day-to-day operations.

Ready to Upgrade Your Event Business?

Experience Zero-Clash Bookings & 10-Second WhatsApp Quotes

Built for Indian tent house, DJ sound, and wedding decor businesses that want faster, smoother operations.

Explore More Guides

Recent Event Industry Articles

Browse All Guides