# Bank Statement OCR and Expense Categorization

> Accepts uploaded bank statements, extracts transactions via OCR, categorizes each transaction by expense type, logs categorized data to a spreadsheet, and generates a spending breakdown chart. Perfect for personal finance analysis or small business bookkeeping.

Content type: workflow
Source URL: https://www.agentpmt.com/agent-workflow-skills/bank-statement-ocr-and-expense-categorization
Markdown URL: https://www.agentpmt.com/api/agent/workflows/bank-statement-ocr-and-expense-categorization?format=agent-md
Updated: 2026-04-26T01:18:20.455Z
Author: firef1ie

---

Estimated time saved: 60 minutes.

## Tools

- File Management
- Document OCR Agent
- Google Sheets
- Chart Generator

## Workflow Outline

1. Request Bank Statements: Goal: Collect bank statement files from the user | Inputs: User's bank statement files (images or PDFs) | Outputs: Bank statement files ready for upload and processing | Constraints: Accepted formats: images (PNG, JPG)...
2. Upload Statement Files to File Management: Upload the bank statement files with File Management using action 'upload_standard'. Store them securely for OCR processing in the next step.
3. Extract Transactions via OCR: Extract all transactions from the bank statement including dates, descriptions, amounts, and running balances. Return structured transaction data for categorization.
4. Categorize Transactions: Goal: Categorize each extracted transaction into standard expense categories | Inputs: OCR extracted transactions with dates, descriptions, and amounts | Outputs: Categorized transaction list with a category assigned to...
5. Log to Google Sheets: Create a new spreadsheet with columns: Date, Description, Amount, Category. Add all categorized transactions as rows. Title the spreadsheet with the statement period.
6. Generate Spending Chart: Create a pie chart showing spending breakdown by category with amounts and percentages. Exclude Income and Transfer categories from the spending breakdown.
7. Notify Completion: Send a other request to a human. Bank statement processing complete. Transactions categorized and logged to Google Sheets with spending breakdown chart.