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.