TopRank Skills

Home / Claw Skills / 数据解析 / gridtrx
Official OpenClaw rules 36%

gridtrx

Double-entry, full-cycle accounting suite built for AI agents. Converts bank CSVs, OFX, and QBO files into balanced, auditable books — balance sheet, income statement, general ledger, trial balance. All data stays in a single local SQLite file.

Stars

0

Installs

0

Status

ACTIVE

Visibility

PUBLIC

安装方式

直接复制以下提示词,发送给你的 AI 助手即可完成安装。

请先检查是否已安装 SkillHub 商店,若未安装,请根据 https://skillhub-1388575217.cos.ap-guangzhou.myqcloud.com/install/skillhub.md 安装 SkillHub 商店,然后安装 gridtrx 技能。 若已安装,则直接安装 gridtrx 技能。

Overview

Skill Key
737999/gridtrx
Author
737999
Source Repo
openclaw/skills
Version
-
Source Path
skills/737999/gridtrx
Latest Commit SHA
90df27308094818d9237df2ca9bc0ca4cbafe40a

Extracted Content

SKILL.md excerpt

# Skill: GridTRX Accounting

## Demo

**[Watch the demo: Full accounting cycle in 15 minutes](https://youtu.be/9mmHbgEB3PQ)**

## What it does

Use this skill when the user asks you to "do the books," "categorize expenses," "import bank transactions," "run a balance sheet," or any bookkeeping task. GridTRX is a full-cycle double-entry accounting engine. You prompt in plain English, and the agent completes the books correctly. Every transaction balances. Every amount is deterministic. All data is local — no cloud services, no external APIs.

GridTRX produces a full set of auditable books: balance sheet, income statement, general ledger, trial balance, adjusting journal entries, retained earnings rollforward. Reports are exportable to CSV and PDF for any time period.

## Architecture

GridTRX has three interfaces to the same engine (`models.py` → `books.db`):

1. **MCP Server (preferred for agents)** — Structured JSON tools. 20 tools (12 read, 8 write) wrapping `models.py` directly. No text parsing, typed parameters, deterministic output.
2. **CLI (fallback for agents, power users)** — One-shot shell commands via `python cli.py`. Zero dependencies beyond Python 3.7+ standard library. Any terminal-based agent can drive it via subprocess.
3. **Browser UI (for humans)** — Flask web interface at `localhost:5000` via `python run.py`. Ledger browsing, report viewer with drill-down, comparative reports up to 13 columns, bank import with rule preview, reconciliation marking, dark mode.

All three hit the same `models.py` data layer. Nothing is out of sync. Use MCP when available. Fall back to CLI otherwise. The browser UI is for human review.

### Prerequisites

Install dependencies before first use (one-time setup):

```bash
pip install -r requirements.txt
```

Or install individually: `pip install mcp` (MCP server), `pip install flask` (browser UI). The CLI has no dependencies beyond the Python 3.7+ standard library.

**No packages are installed at runtime.** All dependenci...

README excerpt

# GridTRX

**Built specifically for agent use as a double-entry, full-cycle accounting suite and reporting framework. You prompt in plain english -> agent completes the books correctly.**

GridTRX is a bookkeeping system primarily built for AI agents first, and human accountants second. Feed it a bank statement or an Excel file, and the system produces a full set of auditable books: balance sheet, income statement, general ledger, trial balance. No subscriptions, no cloud, full privacy and security. Full GUI for humans, and CLI for agents.

## Built by a CPA

GridTRX was built by a cross-border tax CPA practitioner who does dual-citizen and international tax returns for a living. Not a developer who read an accounting textbook. A real accountant who got tired of watching the industry bolt chatbots onto QuickBooks and call it AI. The chart of accounts, the import rules, the report structures, and the suspense workflow all comes from doing real client work, not from a product spec.

## What You Get

**Financial Statements**
- Balance Sheet with opening balances, closing balances, $ change, % change
- Income Statement with period comparisons, up to 13 comparative columns
- General Ledger with running balances and cross-account references
- Trial Balance — always ties, debits equal credits
- Adjusting Journal Entry report
- Retained Earnings rollforward and YE close
- Sales tax reporting
- All reports exportable to CSV and PDF. For any time period. Just ask your agent for the report, and GridTRX can produce it.

**Full Accounting Cycle**
- Import bank data from CSV, OFX, and QBO files with auto-categorization
- customizable import rules match vendors to accounts automatically
- Unrecognized transactions land in Suspense (EX.SUSP) for human review and clearing. Tell the AI what the suspense items are and it will clear them. Or clear them yourself through the GUI.
- Year-end close with retained earnings rollover
- editable lock date enforcement for closed periods.
- Recon...

Related Claw Skills