Bank Reconciliation Skill

Reconcile bank statement rows against GL rows and produce an .xlsx workbook that is immediately reviewable by an accountant.

Workflow

1. Identify the bank statement path and GL workbook path.
2. Accept either a bank statement .xlsx file or a bank statement .pdf file.
3. If the bank statement is a PDF, run the workflow so it first extracts the bank statement lines into a structured workbook, then reconciles that extracted workbook to the GL.
4. Confirm the reconciliation threshold. Default to 0.00 unless the user asks for a tolerance.
5. Run scripts/recon_logic.py with the bank file, GL file, output file, and threshold.
6. Return the generated workbook and summarize:
   • matched bank row count
   • matched GL row count
   • unreconciled bank row count
   • unreconciled GL row count
7. If the user asks for follow-up analysis, use the Summary, Unreconciled Bank, and Unreconciled GL tabs first.

Output Workbook