# Extract invoice line items and totals to JSON

**Use case:** 

Turn a PDF invoice into JSON tables you can import into accounting software, an ERP or Google Sheets: every line item with quantity, unit price and amount, plus the whole invoice as Markdown with totals, tax and payment terms. Digital PDFs are read without OCR in a few seconds. The example parses a sample invoice with six line items.

## Input

```json
{
  "documentUrls": [
    "https://api.apify.com/v2/key-value-stores/gZUDoFSN6sExqUTEm/records/sample-invoice.pdf"
  ],
  "ocrMode": "auto",
  "extractTablesAsJson": true,
  "maxPages": 100,
  "maxFileSizeMb": 50,
  "maxDocuments": 100,
  "documentTimeoutSecs": 300
}
```

## Output

```json
{
  "source_url": {
    "label": "Source URL",
    "format": "string"
  },
  "table_count": {
    "label": "Table count",
    "format": "integer"
  },
  "tables_json": {
    "label": "Tables (JSON)",
    "format": "array"
  }
}
```

## How it works

### 1. Sign up on Apify or log in

The Invoice, Receipt & PDF Table to JSON/Markdown OCR Actor is ready to run with the inputs already set for "Extract invoice line items and totals to JSON". [Sign up or log in](https://console.apify.com/create-task-from-example/dbdOXBMhpxYLYD792) and you'll land in Apify Console with a copy of this exact task.

### 2. Start the "Extract invoice line items and totals to JSON" task

The Invoice, Receipt & PDF Table to JSON/Markdown OCR Actor will start running based on the input automatically. You can also change all the input fields, like document urls, OCR mode, and more, to match your specific use case.

### 3. Receive the "Extract invoice line items and totals to JSON" output

Monitor the progress in real time. You will be notified as soon as your dataset is complete and ready for review. Each result includes data such as source url, table count, and tables (json).

### 4. Integrate into your workflow

The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow. You can also [run the "Extract invoice line items and totals to JSON" task via API](https://apify.com/panix/invoice-table-json-extractor.md).

## FAQ

### What does the invoice to JSON task return?

The invoice to JSON task returns one row per invoice with every table as JSON (headers plus one object per line item), the page counts, and the whole invoice as Markdown that keeps the layout, totals and payment terms.

### Does it return the invoice number and due date as fields?

The invoice to JSON task returns tables as JSON and the rest of the invoice, including invoice number, dates and totals, as Markdown text. Pass the Markdown to an LLM or a regex step to map those values to your own fields.

### Can it read scanned or photographed invoices?

Scanned pages and photos are detected automatically and read with OCR, which costs more per page than a digital page. The invoice to JSON task works with PDF, JPG, PNG, TIFF, BMP and WEBP files.

### How much does the invoice to JSON task cost?

The invoice to JSON task costs $0.005 per digital page on the Apify Free plan and $0.0045 on Starter, less on Scale and Business, plus $0.004 per run. A one-page invoice costs under one cent; failed files are free.

## About this Actor

This example demonstrates how to use [Invoice, Receipt & PDF Table to JSON/Markdown OCR](https://apify.com/panix/invoice-table-json-extractor.md) with a specific input configuration. Visit the [Actor detail page](https://apify.com/panix/invoice-table-json-extractor.md) to learn more, explore other use cases, and run it yourself.


## How to integrate an Actor?

This Task's input is already configured above. Use it as-is rather than inventing a new one.

Do not guess an integration path. Every one of them is in the agent quickstart at https://apify.com/agents.md: the Apify MCP server, Agent Skills with the Apify CLI, the JavaScript and Python clients, the REST API, and the account-free path for an agent with no human to sign in. It also carries the rule on stating cost before the first paid run.

For full API examples (JavaScript, Python, CLI, MCP, OpenAPI), see this Task's Actor page: https://apify.com/panix/invoice-table-json-extractor.md

Each client library has reference documentation the quickstart does not restate: [JavaScript/TypeScript](https://docs.apify.com/api/client/js/docs.md) (`npm install apify-client`) and [Python](https://docs.apify.com/api/client/python/docs.md) (`pip install apify-client`).
