Financial File Normalizer
Under maintenancePricing
from $250.00 / 1,000 successful file normalizations
Exact transaction JSON from customer-owned OFX/QFX/QBO, mapped CSV and transaction-only QIF exports.
You can access the Financial File Normalizer programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.
{ "openapi": "3.0.1", "info": { "version": "0.1", "x-build-id": "a3K65JrOBXqHdx8jy" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/punctual_alghoza~financial-file-normalizer/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-punctual_alghoza-financial-file-normalizer", "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/punctual_alghoza~financial-file-normalizer/runs": { "post": { "operationId": "runs-sync-punctual_alghoza-financial-file-normalizer", "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/punctual_alghoza~financial-file-normalizer/run-sync": { "post": { "operationId": "run-sync-punctual_alghoza-financial-file-normalizer", "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", "required": [ "content" ], "properties": { "content": { "title": "Export file content", "maxLength": 2000000, "type": "string", "description": "Your own structured banking export. Never provide bank credentials. Apify stores actor inputs/outputs under platform retention rules." }, "format": { "title": "Input format", "enum": [ "auto", "ofx", "qfx", "qbo", "qif", "csv" ], "type": "string", "description": "Auto-detect OFX/QIF; CSV requires explicit field mapping. QFX/QBO must be OFX banking or credit-card exports.", "default": "auto" }, "csv_mapping": { "title": "CSV field-to-column mapping", "type": "object", "description": "Exact headers; date plus amount OR debit and credit; optional description, payee, id, account." }, "csv_currency": { "title": "Currency for CSV/QIF", "pattern": "^[A-Z]{3}$", "type": "string", "description": "Required for CSV/QIF; uppercase three-letter currency code." }, "csv_date_format": { "title": "CSV/QIF date convention", "type": "string", "description": "Explicit date convention for CSV/QIF. Day/month order is never guessed.", "default": "%Y-%m-%d" }, "delimiter": { "title": "CSV delimiter", "minLength": 1, "maxLength": 1, "type": "string", "description": "Single-character CSV delimiter; required column names must match exactly.", "default": "," }, "decimal_separator": { "title": "CSV decimal separator", "enum": [ ".", "," ], "type": "string", "description": "Use dot-decimal/comma-grouped or comma-decimal/dot-grouped amounts. Values are never rounded.", "default": "." }, "encoding": { "title": "Explicit file encoding", "enum": [ "utf-8", "cp1252", "latin-1" ], "type": "string", "description": "Optional explicit bytes encoding for library/CLI callers. Actor content is already Unicode text." }, "deduplicate": { "title": "Remove exact account/source-ID duplicates", "type": "boolean", "description": "Remove exact repeats only when the same account/source ID and all transaction values match; conflicts fail.", "default": true }, "max_bytes": { "title": "Reduced content-byte limit", "minimum": 1, "maximum": 2000000, "type": "integer", "description": "Optional smaller content-byte limit; cannot exceed the 2 MB hard maximum.", "default": 2000000 }, "max_transactions": { "title": "Reduced raw-transaction limit", "minimum": 1, "maximum": 10000, "type": "integer", "description": "Optional smaller raw-transaction limit; counts before deduplication and cannot exceed 10000.", "default": 10000 } } }, "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 }, "PROXY_UNBLOCKER_UNITS": { "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 }, "PROXY_UNBLOCKER_UNITS": { "type": "integer", "example": 0 } } } } } } } } }}OpenAPI is a standard for designing and describing RESTful APIs, allowing developers to define API structure, endpoints, and data formats in a machine-readable way. It simplifies API development, integration, and documentation.
OpenAPI is effective when used with AI agents and GPTs by standardizing how these systems interact with various APIs, for reliable integrations and efficient communication.
By defining machine-readable API specifications, OpenAPI allows AI models like GPTs to understand and use varied data sources, improving accuracy. This accelerates development, reduces errors, and provides context-aware responses, making OpenAPI a core component for AI applications.
You can download the OpenAPI definitions for Financial File Normalizer from the options below:
If you’d like to learn more about how OpenAPI powers GPTs, read our blog post.
You can also check out our other API clients: