AgentPMT

Bank Statement OCR and Account Reconciliation

Saves ~45 min

Details

Automates bank account reconciliation in Zoho Books. Accepts bank statement files (PDF, images, scans) from the user, uploads them to File Management, runs OCR to extract transaction data, then cross-references extracted transactions against unmatched bank feed transactions in Zoho Books. For each unmatched transaction, finds potential matching records (expenses, invoices, payments) and reconciles them. Generates a reconciliation summary and notifies the user when complete.

Tools In This Workflow

Workflow Steps

  1. 1Request Bank Statements and Account
  2. 2Upload Statements to File Management
  3. 3OCR Bank Statements
  4. 4Parse OCR Data into Transaction List
  5. 5List Uncategorized Bank Transactions in Zoho
  6. 6Cross-Reference and Identify Matches
  7. 7Reconcile Each Matched Transaction
  8. 8Get Matching Records from Zoho Books
  9. 9Evaluate and Select Best Match
  10. 10Reconcile Transaction in Zoho Books
  11. 11Generate Reconciliation Summary
  12. 12Notify Reconciliation Complete
Step 1 of 12
Prompt1

Request Bank Statements and Account

Goal: Ask the user to provide bank statement files and identify which Zoho Books bank account these statements belong to | Inputs: None - this is the first step of the workflow | Outputs: Bank statement files (PDFs, images, or scans) and the name or ID of the Zoho Books bank account to reconcile | Constraints: Accepted formats include PDF, JPG, PNG, and other common document formats. The user must specify which bank account in Zoho Books these statements correspond to (e.g., Chase Example CC, Bank Of America Example CC, BMG - Mercury - Checking, etc.). If the user is unsure, list the available bank accounts from Zoho Books to help them choose. | Success criteria: The user has provided one or more bank statement files and clearly identified the target Zoho Books bank account for reconciliation

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:

Install commands

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:

Hosted MCP config

{
  "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 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.

Agent prompt

Call the AgentPMT-Workflow-Skills tool with action 'get_workflow_skill' and skill_id 69916466aa85db8efed1342f ("Bank Statement OCR and Account Reconciliation").

Looking for help integrating AI into your business? Set up a free consultation.