// Power Automate Desktop - Bank Reconciliation Automation Script

// Step 1: Open Bank Statement Excel File
LaunchExcel("C:\Users\User\Documents\Bank_Statement.xlsx", openMode:=Excel.OpenMode.Read)

// Step 2: Open Accounting Ledger Excel File
LaunchExcel("C:\Users\User\Documents\Accounting_Ledger.xlsx", openMode:=Excel.OpenMode.Read)

// Step 3: Read Bank Transactions
ReadFromExcelWorksheet(Instance:=ExcelInstance1, GetLastRow:=True, RetrieveColumnNames:=True)

// Step 4: Read Accounting Transactions
ReadFromExcelWorksheet(Instance:=ExcelInstance2, GetLastRow:=True, RetrieveColumnNames:=True)

// Step 5: Compare Transactions (Match by Amount & Date)
For Each Row In ExcelDataTable1
    MatchedRow = FindInDataTable(ExcelDataTable2, Column:="Amount", Value:=Row["Amount"])
    If MatchedRow Is Nothing Then
        AppendToFile("C:\Users\User\Documents\Unmatched_Transactions.txt", Row)
    End If
End For

// Step 6: Save and Notify
DisplayMessage("Bank Reconciliation Completed", "Unmatched transactions saved in Unmatched_Transactions.txt")

// Step 7: Close Excel Files
CloseExcel(Instance:=ExcelInstance1, SaveChanges:=False)
CloseExcel(Instance:=ExcelInstance2, SaveChanges:=False)