🏠 Guest House Register Data

Excel-based guest house management system with professional check-in/check-out slip generation, complete visitor register, and approval workflow automation.

📋 What This Does

Solves the problem: How to efficiently manage guest house check-ins/check-outs, generate professional documentation, maintain a complete visitor register, and track organization approvals all in one system.

Key Benefits:

• Professional check-in/check-out slip generation (print-ready with Ctrl+P)
• Complete visitor register tracking 25+ guests
• Organization approval workflow & validation
• Hardcopy linking for audit trail
• Guest contact & identification tracking
• Unique serial numbering for each guest
• VBA automation for hyperlinks & forms
• Compliance-ready documentation

📸 View the File

Access Guest House Register

Password: 123 Enable Macros for full VBA functionality

---

📸 System Screenshots

Professional Check-In/Check-Out Slip Form

Professional printable slip with complete guest details, organization name, contact information, check-in/out dates & times, approval status, and signature fields.

Organization Approval Validation Sheet

Pre-approved organizations list showing company names, approval status, and approving teams for access control and compliance.

Complete Guest House Register Database

Comprehensive visitor register with 20+ entries including dates, guest names, contact details, organizations, approval status, and hardcopy hyperlinks.

---

✨ Main Features

1. Check-In/Check-Out Slip Form

• Booking request details & confirmation dates
• Guest contact information (name, phone, email)
• Aadhar/Passport number tracking
• Organization name with approval validation
• Check-in date & time recording
• Check-out date & time recording
• Special remarks & instructions section
• Guest feedback & observations field
• Signature lines for check-in & check-out
• Unique slip serial number
• Professional print-ready layout

2. Guest Register Database

• 25+ complete visitor records
• Unique serial number for each guest
• Hardcopy hyperlinks to physical documentation
• Check-in date tracking with day-of-week auto-calculation
• Guest name & contact details
• Organization name (validated dropdown)
• Approval status (Approved/Pending)
• Approved by team/person
• Email address tracking
• Type selection (Business/Personal/Family)

3. Organization Approval System

• Pre-populated list of 25+ approved organizations
• Approval status tracking (Approved/Disapproved)
• Approved by team field
• Dropdown validation prevents unauthorized access
• Easy to add new organizations
• Access control enforcement

4. Data Validation & Automation

• Organization dropdown validation
• Status validation (Approved/Disapproved)
• Date formatting (DD-MM-YYYY)
• Time formatting (HH:MM)
• Auto day-of-week calculation
• VBA-powered hyperlinks
• Auto-numbering system
• Macro buttons for form operations

5. VBA Macro Features

• Hyperlink generation & automation
• Form data population
• Automatic serial number generation
• Data validation enforcement
• Hardcopy linking capability
• Professional form printing support

🚀 How to Use

Initial Setup

1. Download file from link above
2. Open in Microsoft Excel
3. Enable Macros when prompted for VBA functionality

Creating a Check-In Slip

1. Go to "Form" sheet
2. System auto-generates unique serial number
3. Enter guest details:
   • Guest name
   • Organization (select from approved list)
   • Contact details & email
   • Aadhar/Passport number
4. Enter check-in date & time
5. Save the form

Printing Professional Slip

1. Ensure all form fields are complete
2. Press Ctrl+P to print
3. Professional slip prints with all details
4. Guest & staff sign the slip
5. File physical hardcopy

Recording in Visitor Register

1. Go to "Data" sheet
2. Enter guest information:
   • Check-in date
   • Guest name
   • Contact details
   • Organization (auto-validated)
   • Approval status
3. Create hyperlink to hardcopy
4. Register updated automatically

Managing Organizations

1. Go to "Validation" sheet
2. View pre-approved organizations
3. Add new organizations as needed
4. Update approval status
5. Available in Form dropdown instantly

📊 What You'll See

Slip Form Displays:

• Booking Request By: [Name]
• Booking Date: [Date]
• Guest Name: [Full Name]
• Organization: [Company Name - Validated]
• Contact: [Phone Number]
• Email: [Email Address]
• Aadhar/Passport: [ID Number]
• Approval Status: [Approved/Pending]
• Approved By: [Team/Person]
• Check-IN Date: [Date] | Time: [HH:MM]
• Check-OUT Date: [Date] | Time: [HH:MM]
• Special Remarks: [Text]
• Signatures: [In/Out fields]

Register Shows:

• Unique Sr.No | Hardcopy Link | Date | Day | Guest Name | Contact | Organization | Approval Status | Approved By | Email
• Auto-calculates day of week
• Maintains complete history
• Links to physical copies
• Email tracking for all guests

💡 Key Benefits

✅ Professional Documentation: Print-ready slips with Ctrl+P
✅ Complete Audit Trail: 25+ guest records with details
✅ Access Control: Only approved organizations allowed
✅ Approval Tracking: Know who approved each guest
✅ Digital-Physical Linking: Hyperlinks to hardcopy records
✅ Data Validation: Prevents incorrect entries
✅ Unique Numbering: Auto-generated serial numbers
✅ Contact Management: Email & phone tracking
✅ VBA Automation: Hyperlinks & form generation
✅ Compliance Ready: Complete audit trail for audits

🔧 Customization

Add New Organization:

1. Open "Validation" sheet
2. Add organization name & status
3. Auto-available in Form dropdown

Add Guest to Register:

1. Open "Data" sheet
2. Enter guest information
3. Create hyperlink to physical slip
4. Register updates automatically

Modify Approval Status:

1. "Validation" sheet → Update status
2. Reflects in all forms & validation
3. Prevents unapproved guests

Print Multiple Slips:

1. Complete Form with guest details
2. Ctrl+P to print
3. Save Form (data retained)
4. Update Form for next guest
5. Ctrl+P to print new slip

📈 Real-World Usage

Corporate Guest Visit:

• Company: Optivance Consulting LLP
• Guest: Mr. Abhinav Singh
• Check-IN: 17-Nov-25 @ 06:00 PM
• Check-OUT: 27-Nov-25 @ 03:00 PM
• Status: Approved by Management Team
• Slip Generated: Professional document
• Register: Complete tracking maintained

New Organization Approval:

• Request received from new company
• Add to Validation sheet
• Set status: Approved
• All future guests from that org can check-in
• Form validates automatically

Compliance Audit:

• Auditor requests guest records
• Open Data sheet
• 25+ complete guest entries
• Click hyperlink to physical copies
• Complete compliance documentation verified

💼 Technical Skills

• Excel form design & layout
• VBA macro programming
• Hyperlink automation
• Data validation rules
• Unique numbering systems
• Organization management
• Approval workflow design
• Guest management systems
• Audit trail maintenance
• Compliance documentation

📄 License

MIT License - Free to use and modify

---

🌟 Project Stats

---

🏠 Manage Guest Check-ins - Track Visitors - Generate Professional Slips - Maintain Compliance

⭐ If this helps your hospitality operations, please star this repository!

💬 Questions? Open an issue and I'll help!

Password: 123 | Enable Macros Required | VBA Enabled