- Home
- Skills
- Finance & Accounting
- Invoice Data Extractor
Invoice Data Extractor
Extracts structured financial data from invoices and receipts into a validated, duplicate-aware CSV ledger.
Free
Works with the AI Agents you already use
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
| File | Vendor | Date | Total | Status | Notes |
|---|---|---|---|---|---|
inv_772.pdf | CloudScale UI | 2024-03-12 | 1,250.00 | Added | Verified item total |
rec_9910.jpg | Blue Bottle Coffee | 2024-03-14 | 18.50 | Added | Hand-written tip included |
stmt_march.pdf | DigitalOcean | 2024-03-01 | 45.12 | Skipped | Already exists in ledger |
receipt_scan.png | Staples | 2024-03-15 | 112.99 | Review | Total 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
- Open
outputs/financial-ledger.csvto manually reconcile the $2.00 discrepancy in the Staples receipt. - The folder contained a
.heicfile which was skipped; convert this to JPG if you need it processed. - Run the command with
--append-conflictsif you want to force the Staples entry into the ledger anyway.
inv_772.pdf
CSV · data export
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
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
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 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