README.md

metadata

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:

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:

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