PAD Bank Reconciliation Automation

I keep each account’s transactions in separate Excel spreadsheets and want the reconciliation process fully automated with Microsoft Power Automate Desktop. The flow should let me pick which account file to work on, then:

• read the ledger and corresponding bank statement sheets
• match deposits and withdrawals line-by-line using date, amount and narration
• flag anything that does not pair up within the tolerance I define
• generate a clear reconciliation report (matched, unmatched, running balance) in Excel and save it to a folder of my choice
• immediately e-mail or pop-up a notification summarising any discrepancies found

Please deliver the PAD file plus a brief setup guide so I can adjust file paths, tolerance levels and add new accounts later. I’ll test the flow with two sample spreadsheets; acceptance is complete when both reconcile and the alert triggers correctly for any mismatches.