Summary
Monthly bank reconciliation task to ensure all transactions in our bank accounts match the records in Xero. This includes reviewing bank statements, matching transactions, and creating journal entries for any discrepancies.
Flow Diagram
- Download bank statements from all configured accounts
- Parse and normalize transaction data
- Match transactions against existing Xero records
- Flag unmatched or discrepant transactions for review
- Generate appropriate journal entries
- Submit entries to Xero via API after approval
- Generate reconciliation report and audit log
Triggers
Repeats monthly on the last day of the month
Next run: 2024-03-31