PDF Invoice to Excel Converter & Reconciler

    1

    Convert PDF invoices to Excel with automated arithmetic checks, duplicate detection, and ledger reconciliation.

    $9

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    PDF Invoice to Excel Converter & Reconciler

    Example session with this skill installed

    I have uploaded 3 PDF invoices from my recent office supply purchases. Can you convert these into an Excel file and check for any errors or duplicate charges?

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

    I have processed 3 PDF invoices: inv_supply_01.pdf, inv_supply_02.pdf, and inv_supply_copy.pdf. One duplicate was identified, and all amounts have been normalized.

    The grand total for all unique invoices is 342.50.

    Invoice Extraction Summary

    DateVendorInvoice NoAmountTaxTotal
    2024-05-12Stationery HubSH-9921120.0012.00132.00
    2024-05-15Tech SolutionsTS-4450190.0020.50210.50
    2024-05-12Stationery HubSH-9921120.0012.00132.00

    Reconciliation Log

    Invoice NoIssueDetail
    SH-9921duplicateSame vendor + invoice number appears twice (2 files).

    The full .xlsx workbook has been generated with frozen headers and auto-filters enabled on the Invoices sheet.

    Next steps

    1. Download the generated Invoice_Summary.xlsx file.
    2. Review the duplicate entry for SH-9921 to ensure you don't pay the same bill twice.
    3. Provide a bank statement CSV if you want to reconcile these against your actual payments.

    inv_supply_01.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

    Input: PDF invoices or bills. Output: a structured Excel workbook (Date | Vendor | Invoice No | Amount | Tax | Total) plus a reconciliation list flagging duplicates, missing tax and missing values. You paste or upload the PDF text, the skill extracts every line item, normalizes dates and amounts, and returns the Excel-ready table.

    What it does

    • Data extraction pulls date, vendor, invoice number, amount, tax, and total from text-based PDFs.
    • Data normalization converts diverse date formats to ISO (YYYY-MM-DD) and strips currency symbols for clean numerical processing.
    • Arithmetic verification calculates if the net amount plus tax equals the total for every row.
    • Duplicate detection flags repeated vendor and invoice number combinations to prevent double payments.
    • Reference matching compares extracted PDF data against your provided ledger or bank statement to find mismatches.

    How it works

    1. Identify inputs by confirming the quantity and filenames of the uploaded PDFs.
    2. Process extraction to capture all six required fields per invoice while checking for a text layer.
    3. Clean and validate the data by standardizing money values to two decimals and unifying vendor names.
    4. Generate workbook with a filtered "Invoices" sheet and a detailed "Reconciliation" sheet for any issues found.

    Frameworks & tools

    This skill works with text-based PDF files and generates standard .xlsx workbooks. It requires PDFs with a readable text layer; scanned image PDFs require an external OCR step first.

    Why this beats prompting it yourself

    Writing prompts to handle math and cross-row deduplication often leads to hallucinations or skipped errors. This skill follows a strict logic for arithmetic checks and multi-factor duplicate detection that ensures every discrepancy is logged rather than ignored.

    Use cases

    • Tax preparation by consolidating a year of receipts into a sortable spreadsheet.
    • Accounts payable audits to find duplicate billing from the same vendors.
    • Ledger reconciliation by checking PDF invoices against a bank export or CSV ledger.
    • Bookkeeper handoffs by creating clean, filtered workbooks with normalized data.

    Known limitations

    Does not support scanned handwriting or non-invoice documents like contracts. Requires an external OCR tool for PDFs without a text layer.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.

    Text-based PDFs only; images require OCR first. No handwriting support. Stops and asks for clarification if multiple currencies are detected in one batch.

    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 buying a skill.

    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

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 2 days ago

    Requires

    Nothing to install.

    Permissions

    Read Files
    Write Files
    Listed2 days ago

    What's inside

    Frequently Asked Questions

    This skill requires text-based PDFs; if you can highlight text within the document, it will work. For scanned images or photos of receipts, you must run them through an OCR (Optical Character Recognition) tool before processing with this skill.

    The skill performs a three-way arithmetic check (Net + Tax = Total) for every invoice and runs a duplicate detection algorithm across the entire batch. Any discrepancies or repeated invoice numbers are automatically flagged in a dedicated 'Reconciliation' sheet within the final Excel file.

    Yes, the skill is designed to normalize diverse vendor naming conventions and date formats (like 12/01/24 vs. Jan 12, 2024) into a single, clean ISO standard (YYYY-MM-DD). This ensures your Excel data is ready for immediate sorting and filtering without manual cleanup.

    You will receive the AI agent skill configuration, which includes the specialized logic for extraction, validation, and Excel generation. It is ready for deployment within your supported AI agent environment immediately after purchase.

    You can upload a CSV export of your bank statement or internal ledger alongside your PDFs. The skill will cross-reference the extracted invoice data against your ledger to identify missing entries, overpayments, or unmatched records.

    New in Finance & Accounting