skills.rest
iterationlayer
iterationlayerOFFICIAL
Explore all skills by this author →
WebsiteGitHub

extract-carrier-invoices-to-spreadsheet

Extract per-shipment charges from carrier invoice PDFs into a formatted XLSX cost tracker.

2|Updated Mar 14, 2026
Search Tags:#automation#invoices#finance#xlsx#data-extraction#carrier#sheet-generation
One-click install
npx skills add https://github.com/iterationlayer/skills --skill extract-carrier-invoices-to-spreadsheet
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: extract-carrier-invoices-to-spreadsheet
Source: https://github.com/iterationlayer/skills/tree/main/skills/extract-carrier-invoices-to-spreadsheet
Command: npx skills add https://github.com/iterationlayer/skills --skill extract-carrier-invoices-to-spreadsheet

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Logistics and freight teams receive carrier invoices as PDFs and need a single, auditable place to reconcile line-level charges against budgets. This workflow extracts per-shipment charges from multiple invoices and compiles them into a ready-to-share XLSX tracker.

Core Features & Use Cases

  • End-to-end extraction: Pulls carrier, invoice number, date, shipment reference, service level, charges, and currency from each invoice.
  • Consolidation & tracking: Generates a formatted XLSX cost tracker with totals and currency handling for finance reviews.
  • Use Case: Reconcile monthly carrier invoices across UPS, FedEx, and DHL into a single, auditable sheet.

Quick Start

Process ups-invoice-march.pdf, fedex-invoice-march.pdf, and dhl-invoice-march.pdf to generate a consolidated Freight Cost Tracker XLSX.

Frequently Asked Questions about extract-carrier-invoices-to-spreadsheet

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I extract data from multiple carrier invoices into a single spreadsheet?▼

Yes, you can consolidate invoices from UPS, FedEx, and DHL into a single sheet. The workflow extracts carrier, invoice number, date, shipment reference, service level, charges, and currency from each PDF for auditable finance reviews.

How do I create an XLSX cost tracker from PDF invoices?▼

To create an XLSX cost tracker from PDF invoices, the workflow uses Document Extraction and Sheet Generation APIs with a defined schema, outputting a single sheet that includes a total row for finance reconciliation.

Do I need an API key to extract shipment charges from PDF invoices?▼

Yes, you need an Iteration Layer API key to extract shipment charges from PDF invoices. This key is required to access the Document Extraction and Sheet Generation APIs used during the end-to-end workflow.

What is the best way to reconcile monthly freight invoices against budgets?▼

The best way to reconcile monthly freight invoices against budgets is to extract line-level per-shipment charges into an XLSX tracker. This provides a single, auditable place to review carrier costs and totals.

What specific data fields are extracted when processing carrier invoices?▼

When processing carrier invoices, the extracted data fields include carrier, invoice number, date, shipment reference, service level, charges, and currency. These fields are compiled into a formatted XLSX cost tracker.

Related Skills

Explore More Finance & Accounting Skills→
finsilabsfinsilabs
44

shipping-rate-calculator

Calculate real-time shipping rates from UPS, FedEx, USPS, and DHL APIs.

Official
Intermediate
microsoftmicrosoft
242

azure-cost-optimization

Analyze Azure subscription costs and utilization to generate optimization recommendations.

Official
Advanced
iterationlayeriterationlayer
2

invoice-to-pdf-report

Extract invoice fields with a schema and generate branded PDF reports.

Official
Intermediate
kouisokouiso

logistics-exception-management

Classify freight exceptions and apply carrier-specific resolution workflows.

Community
Advanced