# Invoice & Receipt to Excel (`enezli/invoice-to-excel`) Actor Reads PDF/image invoices and receipts with AI and extracts date, seller, tax ID, VAT/tax, total and line items into a clean Excel/CSV table. No subscription — pay only per document you process. - **URL**: https://apify.com/enezli/invoice-to-excel.md - **Developed by:** [Turgay NANTA](https://apify.com/enezli) (community) - **Categories:** Automation, AI - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing from $100.00 / 1,000 document processeds This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## Invoice & Receipt to Excel Reads your PDF, image, Excel or Word **invoices and receipts** with AI and extracts **date, seller, tax ID, VAT/tax, total and line items** into a clean spreadsheet that pastes straight into Excel. > **No subscription — you only pay per document you process.** --- ### What it does Typing hundreds of invoices into a spreadsheet by hand takes hours and is error-prone. This actor turns that into **minutes**: - 📥 **Every file type:** PDF · image (PNG/JPG/WEBP/GIF) · Excel (.xlsx) · Word (.docx) · text/CSV/HTML - 🧠 **AI reading:** date · seller · tax/VAT ID · subtotal · VAT/tax · total · line items · currency - 📤 **The format you want:** Table · **Excel (.xlsx)** · CSV · **PDF report** · HTML report - 🌍 **Works on any language** — invoices in English, Turkish, German, Spanish, French and more - ✅ **Honest:** unreadable or suspicious fields are flagged **"Low confidence"** — never fabricated ### How it works 1. Upload your invoices (`files` — base64) or paste them as text (`texts`). 2. Choose an output format (Excel / CSV / PDF / HTML / All). 3. Run → you first get a **free preview** (document/page count). Turn on `process` to extract. 4. Grab your clean table from the **Dataset** tab, or the extra file from the key-value store. ### Who it's for Small-business owners · accountants · bookkeepers · finance assistants · e-commerce sellers — anyone who enters invoices every month. ### Why this actor - **No subscription** — competitors charge a fixed monthly fee; here you pay only per document processed. - **Transparent accuracy** — uncertain fields are shown to you, not hidden. - **One tool** for many input types and many output formats. - **Free preview first** — see the document/page count before any charge. ### Output Delivered in two layers: - **Dataset (table):** one row per invoice — columns: `Document` · `Date` · `Year` · `Month` · `Day` · `Seller` · `Tax ID` · `Subtotal` · `VAT/Tax` · `Total` · `Currency` · `Confidence` · `Note`. Amount columns stay numeric (summable) but display with thousands separators. - **Extra files (key-value store):** `INVOICE_TABLE.xlsx` · `INVOICE_TABLE.csv` · `INVOICE_REPORT.pdf` · `INVOICE_REPORT.html` (depending on the chosen format). A `PREVIEW` and a `REPORT` summary are also stored. #### Example output | Document | Date | Seller | Tax ID | Subtotal | VAT/Tax | Total | Currency | |---|---|---|---|---:|---:|---:|---| | invoice1.pdf | 2026-06-01 | Acme Metals Inc. | 1740832609 | 3,443.20 | 688.64 | 4,131.84 | USD | ### Pricing (Pay-Per-Event) You only pay for what you use: - **Actor start** — once per run. - **Documents processed** — per document the AI actually extracts. The free preview and any skipped/empty documents are **not** charged. No monthly subscription. # Actor input Schema ## `files` (type: `array`): The invoices to process — ALL common file types: PDF, image (png/jpg/webp/gif), Excel (.xlsx), Word (.docx), text/CSV/HTML. Each item: {name, data} (data = base64 or a data-URI). The type is detected automatically from the file signature + extension. ## `output_format` (type: `string`): A table is always produced (dataset). Additionally you can request Excel (.xlsx), CSV, a PDF report or an HTML report. 'All' produces every format. Extra files are downloadable from the run's key-value store. ## `texts` (type: `array`): Plain-text invoice content instead of an image (OCR output or pasted text). Handy for quick tests and BYOD. ## `language` (type: `string`): Language for any descriptive labels the AI generates. Field values are always copied verbatim from the document. ## `model` (type: `string`): Vision model. The default is a strong model (accurate seller/tax ID even on tricky invoice layouts). For very simple/standard invoices the cheaper model lowers cost. ## `process` (type: `boolean`): When off, you only get a FREE preview (document/page count). When on, the documents are processed with AI — you are charged per processed document. ## Actor input object example ```json { "files": [], "output_format": "excel", "texts": [ "INVOICE Invoice Date: 2026-06-29 Seller: ABC Ltd Tax ID: 1234567890 Subtotal: 1,000.00 USD VAT/Tax: 200.00 USD Grand Total: 1,200.00 USD" ], "language": "English", "model": "claude-sonnet-4-6", "process": false } ```` # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "files": [], "texts": [ "INVOICE Invoice Date: 2026-06-29 Seller: ABC Ltd Tax ID: 1234567890 Subtotal: 1,000.00 USD VAT/Tax: 200.00 USD Grand Total: 1,200.00 USD" ] }; // Run the Actor and wait for it to finish const run = await client.actor("enezli/invoice-to-excel").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "files": [], "texts": ["INVOICE Invoice Date: 2026-06-29 Seller: ABC Ltd Tax ID: 1234567890 Subtotal: 1,000.00 USD VAT/Tax: 200.00 USD Grand Total: 1,200.00 USD"], } # Run the Actor and wait for it to finish run = client.actor("enezli/invoice-to-excel").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "files": [], "texts": [ "INVOICE Invoice Date: 2026-06-29 Seller: ABC Ltd Tax ID: 1234567890 Subtotal: 1,000.00 USD VAT/Tax: 200.00 USD Grand Total: 1,200.00 USD" ] }' | apify call enezli/invoice-to-excel --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=enezli/invoice-to-excel", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "Invoice & Receipt to Excel", "description": "Reads PDF/image invoices and receipts with AI and extracts date, seller, tax ID, VAT/tax, total and line items into a clean Excel/CSV table. No subscription — pay only per document you process.", "version": "0.1", "x-build-id": "b9XBhfVAIySASxBMP" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/enezli~invoice-to-excel/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-enezli-invoice-to-excel", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/enezli~invoice-to-excel/runs": { "post": { "operationId": "runs-sync-enezli-invoice-to-excel", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/enezli~invoice-to-excel/run-sync": { "post": { "operationId": "run-sync-enezli-invoice-to-excel", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "properties": { "files": { "title": "Invoice files (PDF / image / Excel / Word / text)", "type": "array", "description": "The invoices to process — ALL common file types: PDF, image (png/jpg/webp/gif), Excel (.xlsx), Word (.docx), text/CSV/HTML. Each item: {name, data} (data = base64 or a data-URI). The type is detected automatically from the file signature + extension." }, "output_format": { "title": "Output format", "enum": [ "tablo", "excel", "csv", "pdf", "rapor", "hepsi" ], "type": "string", "description": "A table is always produced (dataset). Additionally you can request Excel (.xlsx), CSV, a PDF report or an HTML report. 'All' produces every format. Extra files are downloadable from the run's key-value store.", "default": "excel" }, "texts": { "title": "Text invoices (BYOD / OCR'd)", "type": "array", "description": "Plain-text invoice content instead of an image (OCR output or pasted text). Handy for quick tests and BYOD." }, "language": { "title": "Output language", "enum": [ "English", "Türkçe", "Deutsch", "Español", "Français" ], "type": "string", "description": "Language for any descriptive labels the AI generates. Field values are always copied verbatim from the document.", "default": "English" }, "model": { "title": "Model (advanced)", "enum": [ "claude-sonnet-4-6", "claude-haiku-4-5-20251001" ], "type": "string", "description": "Vision model. The default is a strong model (accurate seller/tax ID even on tricky invoice layouts). For very simple/standard invoices the cheaper model lowers cost.", "default": "claude-sonnet-4-6" }, "process": { "title": "Process (incurs charges)", "type": "boolean", "description": "When off, you only get a FREE preview (document/page count). When on, the documents are processed with AI — you are charged per processed document.", "default": false } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```