Invoice Data Extractor

    1

    Extracts structured financial data from invoices and receipts into a validated, duplicate-aware CSV ledger.

    Free

    2 usesSecurity scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    Invoice Data Extractor

    Example session with this skill installed

    Log all the receipts in the inputs/invoices folder into my ledger. Flag anything that looks like a duplicate or has blurry text.

    • Read your context and instructions
    • Compiled the invoice data extractor
    • Generated the data export

    I have processed the invoices in inputs/invoices/. I scanned 4 files: 3 were successfully added to the ledger, and 1 was skipped as a duplicate.

    Processing Summary

    FileVendorDateTotalStatusNotes
    inv_772.pdfCloudScale UI2024-03-121,250.00AddedVerified item total
    rec_9910.jpgBlue Bottle Coffee2024-03-1418.50AddedHand-written tip included
    stmt_march.pdfDigitalOcean2024-03-0145.12SkippedAlready exists in ledger
    receipt_scan.pngStaples2024-03-15112.99ReviewTotal mismatch; lines sum to 110.99

    Ledger Update Details

    • New Records: 2
    • Total Value Added: $1,268.50 USD
    • Ledger Path: outputs/financial-ledger.csv

    Next steps

    1. Open outputs/financial-ledger.csv to manually reconcile the $2.00 discrepancy in the Staples receipt.
    2. The folder contained a .heic file which was skipped; convert this to JPG if you need it processed.
    3. Run the command with --append-conflicts if you want to force the Staples entry into the ledger anyway.

    inv_772.pdf

    CSV · data export

    Generated

    Example file from a real run - the skill writes it into your workspace.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    The problem

    Manual entry of invoice data into spreadsheets is slow and prone to transcription errors. Typos, missing tax lines, and double-counted expenses often corrupt financial records during hand-coding.

    What it does

    • Scans local directories for PDFs, images, and scans to extract vendor names, dates, and totals.
    • Itemizes line items including shipping, tax, and discounts into structured categories.
    • Calculates stable IDs to prevent duplicate entries when re-scanning the same folder.
    • Validates that line items sum to the invoice total before updating the ledger.
    • Generates a CSV financial ledger with formula injection protection for Excel and Sheets.

    Frameworks & tools

    Python for data processing, Claude Vision for OCR and handwriting analysis, and layout-preserved text extraction for digital PDFs.

    Why this beats prompting it yourself

    Standard prompting often fails at mathematical reconciliation and duplicate detection. This skill uses a dedicated script to verify totals and ensure append-only safety, preventing the agent from hallucinating figures or corrupting existing ledger files.

    Use cases

    • Processing a month of mixed receipts and digital invoices for tax preparation.
    • Reconciling expense folders where vendor formats change constantly.
    • Migrating paper-based bookkeeping into a machine-readable CSV format.

    Known limitations

    Cannot process password-protected PDFs without prior decryption. Does not support multi-currency invoices within a single document.

    Requires unencrypted files. Does not support multi-currency invoices. Scripts require Python 3. Target CSV must match the skill's specific schema.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    2 uses

    Times used to date

    Free forever

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 1 month ago

    • Free with an Agensi account

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Listed1 month ago
    Updated1 month ago

    What's inside

    Frequently Asked Questions

    The skill supports PDF documents (both digital and scanned), common image formats like JPEG and PNG, and even clear photographs of handwritten receipts, using Claude Vision for precise text extraction.

    Unlike basic prompts, this skill includes a verification script that mathematically reconciles line items against the total and generates unique IDs for every invoice to prevent double-entry in your ledger.

    You will receive the complete source code, a configuration guide for local directories, and a list of required Python dependencies to get the extraction pipeline running on your system.

    Yes, the skill is designed to process multiple files in a batch; it will scan your designated local folders, extract data from all supported documents, and append them into a single, structured CSV.

    The output is a standard CSV file protected against formula injection, making it fully compatible with Microsoft Excel, Google Sheets, and most major accounting software packages.

    New in Finance & Accounting