Pay Budget vs Actual Analysis Tool
Budget: $250 – $750 CAD
I have two payroll spreadsheets—one shows what we planned to spend, the other records what we actually paid, both already broken out by department. I need a solution that lets me compare the two quickly, spotlight variances, and surface trends without wrestling with formulas every month.
Here’s what I’m after:
1. A refined spreadsheet template (Excel or Google Sheets is fine) that I can drop fresh data into at any time. When I paste or import the budget and actual files, the template should instantly calculate departmental variances, highlight over- or under-spend, and roll everything up into a clean executive summary.
2. A lightweight web app that performs the same comparison online. I want to upload the two files (CSV/XLSX), hit “run,” and see:
• automatic side-by-side comparisons,
• interactive charts I can filter by department or date,
• clear indicators of budget adherence, overall spending trends, and detailed departmental breakdowns.
Use whatever stack you’re most comfortable with (a simple Flask-React combo or something similar is fine) as long as it’s easy for my team to host internally and maintain.
Deliverables are the working spreadsheet, the web app with source code, and a quick walkthrough so we can update the data regularly without needing further help.
Here’s what I’m after:
1. A refined spreadsheet template (Excel or Google Sheets is fine) that I can drop fresh data into at any time. When I paste or import the budget and actual files, the template should instantly calculate departmental variances, highlight over- or under-spend, and roll everything up into a clean executive summary.
2. A lightweight web app that performs the same comparison online. I want to upload the two files (CSV/XLSX), hit “run,” and see:
• automatic side-by-side comparisons,
• interactive charts I can filter by department or date,
• clear indicators of budget adherence, overall spending trends, and detailed departmental breakdowns.
Use whatever stack you’re most comfortable with (a simple Flask-React combo or something similar is fine) as long as it’s easy for my team to host internally and maintain.
Deliverables are the working spreadsheet, the web app with source code, and a quick walkthrough so we can update the data regularly without needing further help.