Skip to content
TakoAPI
Back to skills

heath-ledger

by wrannaman

CLI Utilities
330Downloads reported by clawskills.sh
1Stars
0Views
0 likesSign in to like this skill
—Not yet rated
Your rating

Brief

AI bookkeeping agent for Mercury bank accounts.

Description

What This Skill Does

AI bookkeeping agent for Mercury bank accounts. Pulls transactions, categorizes them using vendor rules and AI, and generates Excel workbooks with P&L, Balance Sheet, Cash Flow, and transaction detail. Supports optional Stripe integration for exact gross revenue and fee tracking.

The rule system compounds across runs, so repeat vendors get categorized automatically without AI calls after initial setup, reaching ~95% auto-categorization after a few thousand transactions.

When to Use It

  • Generating monthly P&L for a startup using Mercury
  • Auto-categorizing hundreds of bank transactions by vendor
  • Producing quarterly financial statements for tax preparation
  • Reconciling Stripe revenue and fees against Mercury deposits
  • Reviewing and correcting ambiguous transaction categories before closing books

Example Workflow

INPUT

User asks: Generate March 2025 books for my Mercury account

AGENT
  1. 1

    Connects to Mercury API and discovers accounts using the stored token

  2. 2

    Pulls all posted transactions for March 2025

  3. 3

    Applies seed and learned categorization rules to known vendors

  4. 4

    Sends unmatched transactions to AI for categorization, flags low-confidence items for user review

  5. 5

    Generates a four-tab Excel workbook with P&L, Balance Sheet, Cash Flow, and transaction detail

OUTPUT

Excel workbook covering March 2025 with complete financial statements and itemized transactions

Requirements

  • Mercury API token (from Mercury Dashboard, Settings, API Tokens)
  • Stripe API key (optional, for exact gross revenue and fee data)

Installation

clawhub install wrannaman/heath-ledger

Run the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.

Links