The Staff Claim System is a comprehensive Google Apps Script-based solution for managing staff claims, expenses, petty cash, and event-related finances. Built with Google Apps Script, it provides seamless integration with Google Workspace and offers multiple specialized modules designed for different financial management needs.

   

Claim Management Submit, track, and approve claims	Petty Cash Track transactions and balances	Budget Tracking Monitor department expenses
Event Management Create and track event expenses	Advanced Purchases Process purchase requests	Real-time Dashboard Comprehensive financial overview

   

Module	Description	Features
Claim & Allowance	Complete claim management	Multiple claim types, receipt tracking, approval workflows
Petty Cash	Transaction management	Balance tracking, receipt management, reconciliation
Budget & Expenses	Financial oversight	Department budgets, expense tracking, reporting
Event Management	Event financial tracking	Event creation, expense monitoring, reconciliation
Advance Purchases	Purchase management	Request processing, status tracking, vendor management
Dashboard	Central command center	Real-time analytics, quick access, data visualization

   

🍽️ Meal Allowances Track and manage meal-related expenses ✅ Daily meal allowances ✅ Special event meals ✅ Receipt validation ✅ Automated calculations ✅ Approval workflows	🏨 Stay Claims Accommodation and lodging expenses ✅ Hotel bookings ✅ Accommodation receipts ✅ Duration tracking ✅ Cost validation ✅ Reimbursement processing
🚗 Transportation Travel and transportation claims ✅ Multiple transport types ✅ Company car usage ✅ Mileage tracking ✅ Fuel expenses ✅ Route validation	💼 Extra Claims Additional miscellaneous expenses ✅ Custom claim types ✅ Flexible categories ✅ Supporting documents ✅ Approval chains ✅ Audit trails

   

Prerequisites

Requirement	Status
	Required
	Required
	Required
	Basic Knowledge

Installation Steps

🚀 Click to expand installation guide

1. Clone the Project

   # Access the Google Drive Project Folder
   # https://drive.google.com/drive/folders/1jB1Oz5LHALip139ylOfjn41CNCs6rZk-
   # Make a copy of the entire project folder

2. Configure Project Settings

   {
     "timeZone": "Asia/Singapore",
     "dependencies": {},
     "webapp": {
       "executeAs": "USER_ACCESSING",
       "access": "ANYONE"
     },
     "exceptionLogging": "STACKDRIVER",
     "runtimeVersion": "V8"
   }

3. Multi-Deployment Setup

   • Deploy Main Directory
   • Deploy each module independently
   • Deploy all forms separately
   • Update deployment URLs in configuration

4. Set Up Google Sheets

   • Create required spreadsheets
   • Configure sheet structures
   • Set up data validation

5. Configure APIs

   • Enable Google Drive API
   • Set up Google Maps API
   • Configure OAuth consent

   

Staff Claim System/
├── 📊 HTML Files/
│   ├── CRUDAdvancePurchasesManagement.html
│   ├── CRUDBudget&Expenses.html
│   ├── CRUDClaim&Allowance.html
│   ├── CRUDDashboard.html
│   ├── CRUDEventCreation.html
│   ├── CRUDPettyCashManagement.html
│   ├── CRUDSettings.html
│   ├── MainDirectory.html
│   ├── Claim&AllowanceForm.html
│   ├── PettyCashTransaction.html
│   ├── EventCreationForm.html
│   ├── AdvancePurchase.html
│   ├── Post-EventExpensesForm.html
│   └── Unauthorized.html
├── ⚙️ JavaScript Files/
│   ├── Petty Cash Transaction.js
│   ├── Event Creation Form.js
│   ├── CRUD Settings.js
│   ├── CRUD Petty Cash Management.js
│   ├── CRUD Budget & Expenses.js
│   ├── CRUD Claim & Allowance.js
│   ├── CRUD Dashboard.js
│   ├── CRUD Event Creation.js
│   ├── Claim & Allowance Form.js
│   ├── Advance Purchase.js
│   ├── CRUD Advance Purchases Management.js
│   ├── Main Directory.js
│   └── Post-Event Expenses Form.js
└── 📋 Configuration/
    └── appsscript.json

   

📝 Submitting Claims Easy claim submission process 1️⃣ Navigate to Claim & Allowance Form 2️⃣ Fill in required information 3️⃣ Attach necessary receipts 4️⃣ Submit for approval 5️⃣ Track status in real-time	💰 Managing Petty Cash Streamlined cash management 1️⃣ Access Petty Cash Management 2️⃣ Record transactions 3️⃣ Attach receipts 4️⃣ Update balance 5️⃣ Generate reports
🎉 Creating Events Comprehensive event management 1️⃣ Go to Event Creation module 2️⃣ Fill in event details 3️⃣ Set budget and expenses 4️⃣ Track event status 5️⃣ Post-event reconciliation	📊 Monitoring Budgets Real-time budget oversight 1️⃣ Access Budget & Expenses section 2️⃣ View department budgets 3️⃣ Track expenses 4️⃣ Generate reports 5️⃣ Analyze spending patterns

   

API Service	Purpose	Required Scopes
Drive API (v3)	File management & attachments	drive.file, drive.readonly
Google Maps API	Location services	Places API, Maps JavaScript API
Sheets API	Data storage & management	spreadsheets, spreadsheets.readonly
Gmail API	Notification system	gmail.send, gmail.readonly

   

Security Feature	Implementation
Authentication	Google Workspace Integration
Data Storage	Secure Google Sheets
Access Control	Role-Based Permissions
Data Protection	Enterprise-Grade Security
Audit Trail	Complete Activity Logging
Encryption	Data Encryption at Rest

   

🚀 Built by Backpack Tech Works

Lead Developer @Darkguyaiman

Co-Developer @Ak-ko

   

📱 Follow Our Journey

   

📖 Initial Start

🛠️ Support

   

We welcome contributions to improve the Staff Claim System! Here's how you can help:

Step	Action	Description
1️⃣	Fork	Fork the repository to your account
2️⃣	Branch	Create a feature branch for your changes
3️⃣	Code	Implement your improvements
4️⃣	Test	Thoroughly test your changes
5️⃣	Submit	Create a Pull Request

🎯 Areas for Contribution

Features New functionality

Bug Fixes Issue resolution

Documentation Improve guides

Testing Quality assurance

🎯 Ready to Transform Your Financial Management?