---
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