Excel Finance Automation & Dashboards
Budget: $10 – $30 USD
I need to turn a set of manual Excel workbooks into a fully automated workflow that produces up-to-date cash-flow reports. All source data comes from our internal ERP exports and a few legacy Excel files, so the first step is to organize everything in Power Query, apply repeatable transformations, and remove any need for hand edits.
Once the data model is solid, the goal is to surface the numbers in an interactive Power BI dashboard—daily cash position, week-ahead projections, and month-end summaries—with refreshes triggered automatically from the updated ERP and spreadsheet drops.
Deliverables
• Power Query file(s) that ingest the ERP and Excel sources, perform all required joins, calculations, and date alignments
• A master Excel workbook that refreshes with one click (or on schedule) and feeds the Power BI model
• Power BI report focused on Cash Flow—dynamic filters, drill-downs, and printable view for management
• Short hand-off guide so the finance team can maintain connections and add new periods without coding
Acceptance criteria
• Data refresh completes without manual intervention and mirrors ERP totals exactly
• Dashboard loads in under 5 seconds and displays accurate figures for current day, week, and month
• All steps documented inside Power Query and Power BI for auditability
Core tools: Excel 365, Power Query, DAX, Power BI Service/Gateway. If you have suggestions for improving the refresh cadence or reducing file size, let me know—efficiency and accuracy are the priority.
Once the data model is solid, the goal is to surface the numbers in an interactive Power BI dashboard—daily cash position, week-ahead projections, and month-end summaries—with refreshes triggered automatically from the updated ERP and spreadsheet drops.
Deliverables
• Power Query file(s) that ingest the ERP and Excel sources, perform all required joins, calculations, and date alignments
• A master Excel workbook that refreshes with one click (or on schedule) and feeds the Power BI model
• Power BI report focused on Cash Flow—dynamic filters, drill-downs, and printable view for management
• Short hand-off guide so the finance team can maintain connections and add new periods without coding
Acceptance criteria
• Data refresh completes without manual intervention and mirrors ERP totals exactly
• Dashboard loads in under 5 seconds and displays accurate figures for current day, week, and month
• All steps documented inside Power Query and Power BI for auditability
Core tools: Excel 365, Power Query, DAX, Power BI Service/Gateway. If you have suggestions for improving the refresh cadence or reducing file size, let me know—efficiency and accuracy are the priority.