Automated Excel Cash Flow Analysis - Accounting Expert

My current workbook holds several years of transaction data and a rough projection sheet, but it no longer scales with the volume of information I feed it. The goal is to turn this into a polished, macro-driven model that lets me:

• pull in raw bank and sales data, • analyse historical inflows and outflows, • build an accurate 12-month rolling cash-flow forecast, and • generate a clear, printable cash-flow statement at the click of a button.

To make that happen, I need advanced financial-analysis formulas, dynamic charts, PivotTables/Power Query for data shaping, and well-documented VBA macros to automate repetitive steps such as data import, categorisation, and report production.

Deliverables

1. A macro-enabled (.xlsm) workbook that houses the full cash-flow model, historical analysis, and forecast logic.
2. A dashboard tab summarising key metrics (opening balance, net change, closing balance, variance to plan) with slicers for date ranges.
3. One-click PDF export of the cash-flow statement and dashboard.
4. Inline comments or a short PDF guide explaining how to refresh data, adjust assumptions, and extend the time horizon.

I will provide the raw CSV downloads, my existing spreadsheet, and the chart of accounts once the project begins. The finished file should run smoothly on Microsoft 365 for Windows without additional add-ins. Rate: USD 2–8/hr Skills: Visual Basic, Accounting, Excel, Business Analysis, Financial Analysis, Excel Macros, Data Visualization, Data Analysis, Financial Forecasting, Financial Modeling