Bookkeeping Reconciliation

AI-Driven Bookkeeping Automation

Transform your manual reconciliation habit into a streamlined, automated workflow. This skill bridges the gap between your mailbox, Mercury bank account, and Zoho Books, orchestrating a sophisticated weekly reconciliation process that matches receipts to bank transactions with high precision.

What it does

• Receipt Discovery: Automatically finds and parses receipts from Gmail, Outlook, or local folders.
• Intelligent Matching: Syncs bank transaction data from Mercury with discovered receipts using date, amount, currency, and counterparty data.
• Categorization: Maps expenses using a configurable vendor-to-category map or intelligent fallbacks, ensuring data integrity.
• Safety-First Posting: Implements a mandatory dry-run phase and approval tokens before any data is written to Zoho Books.
• Compliance Tracking: Specifically identifies and logs Form 5472-eligible transactions for foreign-owned US LLCs.

Why use this skill?

Unlike generic AI prompts, this skill enforces strict accounting logic and safety gates. It prevents duplicate postings, protects your equity accounts from being miscategorized as expenses, and maintains a read-only boundary with your bank. It produces a comprehensive audit trail of every run, including exception registers for manual review and copy-paste ready follow-up packs for operators.

Supported Ecosystems

The core workflow is optimized for Mercury Bank and Zoho Books via MCP connectors, but the logic is designed for extensibility to other platforms by updating the mapping guides. Designed to support IRS5472 record keeping.