Automated Excel Cash Flow Reporting
Budget: ₹100 – ₹400 INR
I have a series of CSV exports that land in a folder every month, and I need Excel to pull them in automatically, consolidate the figures, and produce a clean cash-flow statement I can share with management.
Here is the flow I’m picturing: the moment a new CSV is dropped into the folder (or selected through a prompt), Excel—likely through Power Query or a well-structured VBA routine—should import the data, map the columns to my existing chart of accounts, and refresh a formatted cash-flow report on a separate sheet. No manual copy-and-paste; the process has to be repeatable with a single click or, ideally, on file open.
Deliverables
• An Excel workbook (XLSX) with automated CSV import configured
• A dynamic cash-flow statement that refreshes from the imported data
• Clear, commented code (Power Query steps or VBA) so I can adjust paths or account mappings later
• A brief walkthrough documenting how to add new CSV sources or expand the date range
Acceptance Criteria
– I drop a fresh CSV with the same column structure into the designated location and click “Refresh”; figures in the cash-flow statement update correctly.
– All formulas, Power Query steps, or macros execute without security warnings on a standard Windows 11 / Office 365 setup.
– No hard-coded file paths remain; everything is either relative or easily editable in a single settings area.
If you have tackled similar import-to-report automation before, especially with Power Query or VBA, I would love to see a quick example or description of your approach when you respond.
Here is the flow I’m picturing: the moment a new CSV is dropped into the folder (or selected through a prompt), Excel—likely through Power Query or a well-structured VBA routine—should import the data, map the columns to my existing chart of accounts, and refresh a formatted cash-flow report on a separate sheet. No manual copy-and-paste; the process has to be repeatable with a single click or, ideally, on file open.
Deliverables
• An Excel workbook (XLSX) with automated CSV import configured
• A dynamic cash-flow statement that refreshes from the imported data
• Clear, commented code (Power Query steps or VBA) so I can adjust paths or account mappings later
• A brief walkthrough documenting how to add new CSV sources or expand the date range
Acceptance Criteria
– I drop a fresh CSV with the same column structure into the designated location and click “Refresh”; figures in the cash-flow statement update correctly.
– All formulas, Power Query steps, or macros execute without security warnings on a standard Windows 11 / Office 365 setup.
– No hard-coded file paths remain; everything is either relative or easily editable in a single settings area.
If you have tackled similar import-to-report automation before, especially with Power Query or VBA, I would love to see a quick example or description of your approach when you respond.