Automated Daily Bank Reconciliation Flow
Budget: ₹600 – ₹1,500 INR
I need a Microsoft Power Automate Desktop (PAD) flow that runs every morning against my online banking portal, retrieves the previous day’s transactions (the portal provides a CSV download), matches every line with my existing ledger, and finishes by saving a clear reconciliation report.
Key deliverables
• Automated log-in to the portal, including any MFA or captcha steps, and download of the daily CSV into a date-stamped folder.
• Data cleaning and normalisation so the columns in the CSV align with my ledger structure.
• Transaction-level matching against the ledger workbook and flagging of any variances.
• Generation of a concise reconciliation report (Excel or PDF) showing matched, unmatched, and duplicate items.
• Run-time status and error logging so issues are easy to trace and fix.
The flow should be parameter-driven (file paths, date range, portal URL) so I can adapt it without editing the underlying actions. I will consider the project complete once the packaged PAD solution reconciles three consecutive days flawlessly on my workstation.
Experience with Power Automate Desktop, browser automation, and Excel-based data comparison will be valuable here. Sample projects or brief demos of similar work are welcome.
Key deliverables
• Automated log-in to the portal, including any MFA or captcha steps, and download of the daily CSV into a date-stamped folder.
• Data cleaning and normalisation so the columns in the CSV align with my ledger structure.
• Transaction-level matching against the ledger workbook and flagging of any variances.
• Generation of a concise reconciliation report (Excel or PDF) showing matched, unmatched, and duplicate items.
• Run-time status and error logging so issues are easy to trace and fix.
The flow should be parameter-driven (file paths, date range, portal URL) so I can adapt it without editing the underlying actions. I will consider the project complete once the packaged PAD solution reconciles three consecutive days flawlessly on my workstation.
Experience with Power Automate Desktop, browser automation, and Excel-based data comparison will be valuable here. Sample projects or brief demos of similar work are welcome.
Related categories:
Visual Basic
Data Processing
Excel
Software Architecture
Microsoft Access
Data Analysis
Automation
Power Automate