Inventory and Booking Manager for Rental Business spreadsheet is an excel spreadsheet to manage your company’s rental inventory. It is created particularly for equipment rental businesses, but it can fit any type of rental businesses but in simplified form. Simplified form means this spreadsheet won’t fit your company if you need any inventory details to be recorded and tracked. It main function is to record rental bookings and see the availability of your inventory in one year period. Since it is created in Microsoft Excel, you can find it easy to develop. It requires Excel knowledge, though.
This spreadsheet is suitable for small rental business, like :
- Costumes. Any parties require costume, especially if those parties have particular themes, like halloween, superhero, cartoon etc. If you are managing this type of business, you can use this spreadsheet to manage both inventory and booking to make sure your customers get their costumes at particular time.
- Wedding Equipment. From small to big wedding events, there are plenty of items needs to be rented for that event.
- Catering Equipment. Plenty of cooking and dishes equipment are needed in any type of events.
- Presentation Equipment. Presentation projectors, laptops, tabs, monitors, computers, are some of item to be rented.
- Exhibition. Exhibition booths including its accessories are item that must be prepared by exhibitors.
- Musical Event. Stage and sound systems are equipment that must be available in this event.
- And many more…
You can start defining item and supplier/customer parameters to start using this spreadsheet :
- Type item name and their initial quantity at the beginning of your period
- Type supplier and customer information for purchase and booking references
Then, you can start managing your inventory and booking.
- Use booking summary to monitor the availability of your inventory item
- Use booking worksheet to record your customer booking
- Use daily tracker to update your inventory. Any purchases will increase particular item quantity. Any lost/broken reported by your customers will reduce its quantity.
This spreadsheet is unprotected. You can add more important information into it or create charts for your report.
Inventory and Booking Manager for Rental Business Features
1. 365 Days Inventory Management
You can manage and track your inventory in one full year period
2. 150 lines of inventory item (expandable)
There are up to 150 inventory item rows that can be filled
3. 250 lines of Purchase, Broken, Lost, Repaired inventory item (expandable)
There are up to 250 lines where you can update quantity of your rental inventory item (new purchase, lost item etc)
4. 2000 lines of Booking Transaction (expandable)
There are 2000 rows to input any bookings to be mapped in Booking Summary tab
5. 365 Days Booking Summary with Inventory Stock Marker
There is a booking summary to see rented and remaining item quantity for one full year period
6. All worksheets are unlocked to fully tweaking the formula and customizing its layout
You can put your company logo, name, adjust columns and rows, add more worksheets for your specific needs, or tweak formulas, add charts, create dashboards, etc (you need excel knowledge to do this)
7. Customer Data individual worksheet
There is one worksheet to record customer information
8. Supplier Data individual worksheet
There is one worksheet to record supplier information
9. Compatibility across Excel version and Operating System
You can use this spreadsheet with Excel 2010 for Windows and above and Excel 2008 for Mac and above without having incompatibility issues
10. Multi User License (within one Company)
Any employees are allowed to use this spreadsheet as long as they are working within one company
11. One time payment only
You can use it every year without additional cost
- Microsoft Excel 2007 and above for Windows
- Microsoft Excel 2008 and above for Mac
There is a trial spreadsheet that you can download and see how it works with limited features.
> Inventory and Booking Manager for Rental Business Lite
You may need additional features that are not available in this accounting system spreadsheet. We can customize this spreadsheet based on your requests. Email us for further discussion. Our rate is USD 25 per hour.