Automated Daily Bank Reconciliation Flow

Job ID: 40391749

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.