# 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-19T18:29:42.593Z
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.

## Frequently Asked Questions

### How do I connect this workflow to my local agent like OpenClaw or Claude Code?

You can install the local MCP server by opening a terminal and running:

```
npm install -g @agentpmt/mcp-router
agentpmt-setup
```

This will connect you to local agents like Claude Code, Windsurf, Grok Build, Cursor, etc.

Alternatively you can connect to the hosted version with this config block, no installation required:

```
{
  "mcpServers": {
    "agentpmt": {
      "type": "streamable-http",
      "url": "https://api.agentpmt.com/mcp",
      "headers": {
        "Authorization": "Bearer <AGENTPMT_BEARER_TOKEN>",
        "x-instance-metadata": "{\"client\":\"generic-mcp\",\"platform\":\"remote\"}"
      }
    }
  }
}
```

[View MCP Connection Instructions](/docs/mcp-reference/connection) for more details.

### How do I trigger this workflow?

You can use it here in the browser by clicking the 'Try It' button.

If you 'star' the workflow it will save to your dashboard for quick access.

To use the workflow in an external agent, make sure you have followed the steps to connect it to the MCP server and then copy / paste this prompt, or just tell it to use the AgentPMT MCP server and use this workflow.

> Call the AgentPMT-Workflow-Skills tool with action 'get\_workflow\_skill' and skill\_id 69921b5aaa85db8efed137a0 ("Bank Statement OCR and Expense Categorization").