📊 Data Processing Community
Monthly Bank Reconciliation with Auto Invoice Matching
Cowork automatically extracted bank transactions, consistently renamed invoice files, categorized expenses, flagged missing invoices, and generated Excel reports. Saves a full afternoon every month
★★☆ Intermediate 30-60 min (was half a day) 1. Februar 2026
📋
Scenario
User needed to manually match bank statements to invoices monthly and flag missing documentation. This task typically took half a day.
💬
Prompt
Help me with monthly bank reconciliation: 1. Extract all transactions from this bank statement PDF 2. Match each transaction to invoices in this folder 3. Rename invoice files consistently (vendor_date_amount format) 4. Categorize all expenses 5. Flag any transactions with missing invoices 6. Generate an Excel summary report
✨
Expected Result
Cowork completed the full reconciliation workflow — extracted transactions, renamed invoices, categorized expenses, and generated an Excel report. "Saves a full afternoon every month."