Collections Report Generator — Flask App

Setup

# 1. Install dependencies
pip install -r requirements.txt

# 2. Run the app
python app.py

Then open http://localhost:5000 in your browser.

How It Works

1. Pick a report date (leave blank for today, or enter a past date to backfill).
2. Upload your four Excel files — Salesperson, Customers List, BD, and Cash.
3. Click Generate Report — a styled .xlsx file downloads automatically.

File Naming Tips

The app auto-detects file types by filename keywords:

File	Must contain in filename
Salespersons	salesperson
Customers	customer
BD	BD
Cash	cash

Output Sheets

The generated Excel workbook contains:

• Collections Summary (Daily) — transactions on the selected date
• Collections Summary (MTD) — 1st of month → selected date
• Collections Summary (YTD) — 1st Jan → selected date
• Customers List, Salesperson, Cash, BD (raw enriched data)