Spaces:
Sleeping
Sleeping
| title: Biweekly Invoice Generator | |
| emoji: 📊 | |
| colorFrom: red | |
| colorTo: gray | |
| sdk: gradio | |
| sdk_version: 5.44.1 | |
| app_file: app.py | |
| pinned: false | |
| license: mit | |
| short_description: A Gradio web application that processes employee CSV | |
| # 🧾 Invoice Generator for Launch27 Data | |
| A Gradio web application that processes employee CSV files and booking data to generate invoices with automatic tip calculations. | |
| ## 🚀 Quick Start | |
| ### For Hugging Face Spaces Deployment: | |
| 1. Upload `app.py` and `requirements.txt` to your Space | |
| 2. Set SDK to "Gradio" | |
| 3. The app will automatically launch | |
| ### Local Installation: | |
| ```bash | |
| pip install -r requirements.txt | |
| python app.py | |
| ``` | |
| ### Requirements File (`requirements.txt`): | |
| ``` | |
| gradio | |
| pandas | |
| ``` | |
| ## 📋 Features | |
| - ✅ **Flexible CSV Upload**: Works with 1-3 employee data files | |
| - ✅ **Automatic Tip Processing**: Extracts and includes tips from booking data | |
| - ✅ **Date Range Filtering**: Filter records by bi-weekly periods | |
| - ✅ **Smart Date Parsing**: Handles DD/MM/YY and DD/MM/YYYY formats | |
| - ✅ **Pivot Table Generation**: Creates summary report by employee | |
| - ✅ **CSV Export**: Download processed invoice as CSV file | |
| ## 📁 File Requirements | |
| ### Required Files: | |
| - **Bookings CSV**: Must contain booking data with tips | |
| - **At least 1 Employee CSV**: Employee work data (1.csv, 2.csv, or 3.csv) | |
| ### CSV Format Expected: | |
| - **Employee Files**: Date, Team, Name, Hourly Rate, Hours Worked, Total | |
| - **Bookings File**: Date, Teams Assigned (without IDs), Tip | |
| ## 🎯 Usage | |
| 1. **Upload Files**: Add your employee CSV files and bookings CSV | |
| 2. **Set Date Range**: Enter start and end dates (YYYY-MM-DD format) | |
| 3. **Generate**: Click "Generate Invoice" button | |
| 4. **Download**: Get your processed invoice CSV | |
| ## 📊 Output Format | |
| The generated invoice includes: | |
| - Employee summary with total hours and earnings | |
| - Tips automatically added to respective employees | |
| - Grand total calculations | |
| - Matches Launch27 invoice format requirements | |
| ## 🌐 Deployment | |
| ### Local Development: | |
| ```bash | |
| python app.py | |
| ``` | |
| Access at: `http://localhost:7860` | |
| ### Cloud Deployment: | |
| - **Hugging Face Spaces**: Upload `app.py` and `requirements.txt` | |
| - **Railway/Render**: Deploy with Python runtime | |
| - **Docker**: Works with standard Python containers | |
| ## 📝 Notes | |
| - Default date range: August 9-22, 2025 | |
| - Supports flexible employee file combinations | |
| - Automatically handles name standardization | |
| - Tips are processed from "Teams Assigned" field in bookings | |
| - Output format matches expected Final-Invoice.csv structure | |
| ## 🔧 Technical Details | |
| - **Framework**: Gradio for web interface | |
| - **Data Processing**: Pandas for CSV manipulation | |
| - **Date Handling**: Flexible parsing with dayfirst=True | |
| - **File Management**: Temporary files for secure downloads | |
| Check out the configuration reference at https://huggingface.co/docs/hub/spaces-config-reference | |