- Home
- Skills
- Finance & Accounting
- PDF Invoice to Excel Converter & Reconciler
PDF Invoice to Excel Converter & Reconciler
Convert PDF invoices to Excel with automated arithmetic checks, duplicate detection, and ledger reconciliation.
$9
Works with the AI Agents you already use
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
| Date | Vendor | Invoice No | Amount | Tax | Total |
|---|---|---|---|---|---|
| 2024-05-12 | Stationery Hub | SH-9921 | 120.00 | 12.00 | 132.00 |
| 2024-05-15 | Tech Solutions | TS-4450 | 190.00 | 20.50 | 210.50 |
| 2024-05-12 | Stationery Hub | SH-9921 | 120.00 | 12.00 | 132.00 |
Reconciliation Log
| Invoice No | Issue | Detail |
|---|---|---|
| SH-9921 | duplicate | Same 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
- Download the generated
Invoice_Summary.xlsxfile. - Review the duplicate entry for
SH-9921to ensure you don't pay the same bill twice. - Provide a bank statement CSV if you want to reconcile these against your actual payments.
inv_supply_01.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
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
- Identify inputs by confirming the quantity and filenames of the uploaded PDFs.
- Process extraction to capture all six required fields per invoice while checking for a text layer.
- Clean and validate the data by standardizing money values to two decimals and unifying vendor names.
- 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.
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
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
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