process-my-statements

Process bank and credit-card statement PDFs into an accounting-ready Google Sheets workbook.

2|Updated May 8, 2026
One-click install
npx skills add https://github.com/akiotanaka847/qaio-desktop --skill process-my-statements
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: process-my-statements
Source: https://github.com/akiotanaka847/qaio-desktop/tree/main/store/agents/bookkeeping/.agents/skills/process-my-statements
Command: npx skills add https://github.com/akiotanaka847/qaio-desktop --skill process-my-statements

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates the manual effort of reading bank and credit-card statements and then trying to categorize transactions into accounting codes, producing a spreadsheet your accountant can use.

Core Features & Use Cases

  • End-to-end statement processing: Extracts transactions from PDFs, canonicalizes party names, and categorizes them against your locked chart of accounts.
  • Safety-first bookkeeping: Uses a Suspense bucket for low-confidence items and never invents new account codes.
  • Accounting-ready outputs: Writes a formula-driven Google Sheets workbook (P&L, Transactions, CoA, Recon, and Warnings) via Composio.
  • Cross-account transfer detection: Detects inter-account transfers and tags them to exclude from P&L totals.

Quick Start

Attach your bank and credit-card statement PDFs and specify the period you want to process, then ask for a Google Sheets bookkeeping workbook with transactions extracted, categorized, and reconciled.

Frequently Asked Questions about process-my-statements

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I extract transactions from bank PDF statements into Google Sheets for bookkeeping?▼

You can extract transactions from bank PDF statements directly into an accounting-ready Google Sheets workbook by processing batches of PDFs, canonicalizing party names, and categorizing them against a locked chart of accounts.

Can I reconcile multiple credit card and checking account statements in one workbook?▼

Yes, you can reconcile multiple credit card and checking account statements in one workbook. The system works across various statement layouts, supports multi-period PDFs, and detects inter-account transfers to exclude from P&L totals.

What happens to transactions that cannot be automatically categorized into a chart of accounts?▼

Uncertain transactions are routed to a Suspense bucket rather than being assigned to incorrect categories. The system never invents new account codes, ensuring your locked chart of accounts remains strictly controlled.

How do I set up Google Sheets to receive categorized bookkeeping data from PDF statements?▼

You need a Composio-connected Google Sheets account to receive categorized bookkeeping data. The system loads your chart and ledger context, then writes formula-driven P&L, Transactions, CoA, Recon, and Warnings tabs.

Does bank statement reconciliation detect transfers between my own accounts?▼

Yes, bank statement reconciliation detects inter-account transfers across your connected accounts. It automatically tags these transfers to exclude them from P&L totals, preventing double-counting in your bookkeeping workbook.

What is the best way to categorize extracted bank transactions without creating invalid accounting codes?▼

The best way to categorize extracted bank transactions safely is to validate them against a locked chart of accounts. Low-confidence items are routed to Suspense, and reconciliation mismatches are surfaced so no invalid codes are invented.