Financial Reconciliation Desktop App

Automated Financial Reconciliation and Transaction Matching System Project Overview: We are looking for an experienced Python developer to build a desktop-based financial data reconciliation application that automates the comparison of financial records from multiple data sources. The application should allow users to import Excel and CSV files containing bank transactions, payment records, and internal financial data. Its primary purpose is to identify matching transactions, detect discrepancies, and simplify the reconciliation process. Project Requirements: The application should support importing and processing multiple financial datasets and automatically compare transactions using relevant fields, including transaction references, dates, amounts, and descriptions. It should identify exact matches as well as potential matches where transaction details differ slightly. The system should detect unmatched transactions, duplicate entries, missing records, and differences in transaction amounts. Reconciliation results should be categorized into matched, unmatched, and discrepancy records, allowing users to review and manually confirm or correct potential matches. The application should also generate a reconciliation summary showing the total number of transactions processed, successful matches, unmatched records, and identified discrepancies. Users should be able to export the final reconciliation results into Excel or CSV format. Technical Requirements: Python, Pandas, NumPy, Excel/CSV processing, transaction matching algorithms, data validation, and desktop application development using PySide6 or Tkinter. Deliverables: A functional desktop reconciliation application, multi-file data import, automated transaction matching, duplicate and discrepancy detection, manual review functionality, reconciliation summary reports, Excel/CSV exports, testing, and setup documentation. Suggested tags you need to select: - Python - Financial Analysis - Data Processing - Pandas - Excel - Data Reconciliation - Desktop Application - Data Validation - Automation - Software Development