Streamlit Web App for Profit Calculation

Overview:
I need a web-based tool (built in Python using Streamlit) that allows me to upload files and outputs a clean monthly profit breakdown as a downloadable PDF.

The system must:

Read my Spiff Dashboard Excel

Parse Invoice PDFs

Accept manual entries (Accessory Profit, Residual, Retention)

Check for missing rebates

Output a professional PDF report showing all profit components

Inputs:
1. Spiff Dashboard (Excel file)
Contains rows like:

1st Month Spiff

Wallet Funding Amount

MRC Net Discount

Extract:

Total "1st Month Spiff" → Spiff Profit

Wallet - MRC → Activation Residual Profit

Use invoice # or device name to cross-check rebates

2. Multiple Invoice PDFs
Support upload of multiple PDFs

Extract values from any lines containing:

"additional spiff" → Retention

"residual order" → Residual Profit

"expense" → Expenses

3. Manual Inputs
Accessory Profit ($)

Manual Retention (optional override)

Manual Residual (optional override)

Additional Feature: Rebate Checker
Cross-check Invoice Numbers or Order Numbers in PDF invoices against the Spiff Dashboard Report to:

Flag any missing device rebates or spiff entries

List them in a separate section: “ Missing Rebates”

Output
A PDF Report styled like a 2-column summary:


Spiff Profit: $XXX.XX
Activation Bonus: $XXX.XX
Accessory Profit: $XXX.XX
Retention: $XXX.XX
Residual: $XXX.XX
Expenses: $XXX.XX
-------------------------------
Net Profit: $XXX.XX
Bonus: Include a “Missing Rebates” section if any expected spiffs are missing.

Tech Stack (Required)
Python

Streamlit (must work on Streamlit Cloud)

pandas

PyMuPDF (for PDF parsing)

FPDF or ReportLab (for PDF generation)

openpyxl (for Excel)

Testing Requirements
Must be tested using provided sample files:

SpiffDashboardReport_RAW_04-25.xlsx

Sample Invoice PDFs (provided)

Deliverables
GitHub repo with all working code

Streamlit app (live on Streamlit Cloud or easily deployable)

README with setup instructions

Clean UI, no clutter

⏱ Deadline
Preferably delivered and tested within 3–5 days

Code must be modular and maintainable