OpenAI Codex for Finance: A Smart, Practical Guide

OpenAI Codex for finance is best understood not as developer software but as an agent you talk to in plain English that cleans, transforms and reconciles your data files. You describe a data or spreadsheet task, Codex writes and runs the code (usually Python) to do it, then shows you both the result and the script. This is the hands-on guide: for each job, you get what it does, the exact steps, a real example you can copy, and what to double check. It pairs with our AI in Finance and Accounting guide, our AI prompts for finance guide, and our Claude for finance and accounting guide.

Codex is one product across four surfaces that share the same login and the same GPT family models: a web and cloud experience, a command-line tool (the Codex CLI) that runs on your own machine, an extension for code editors, and a desktop app. For finance work the CLI and the desktop app matter most, because they can run on your own files.

Reproduce this reconciliation before using client files

Use two fictional CSVs. The bank contains B01: 1,180; B02: 2,360; B03: −118. The ledger contains B01: 1,180; B02: 2,350; B03: −118. Match on document ID, preserve signs and allow zero tolerance.

Expected result: two matched records and one amount mismatch, B02, with bank minus ledger = 10. Bank total is 3,422; ledger total is 3,412. No row should be removed or invented. If the script reports all three as matched, check its tolerance and duplicate rules.

Ask for a new output file and an exception report. Keep the source files unchanged. This original fixture tests the workflow’s accounting controls; it is not a benchmark score for Codex.

Clean a messy data export

The first and most useful job. Point Codex at a messy CSV or spreadsheet export and tell it, in plain words, how to tidy it.

What it does for finance.

• Dedupes rows, standardises date and number formats, splits or merges columns, and fixes amount signs
• Reads a bank or ledger export and flags anomalies or blanks
• Outputs a clean spreadsheet or CSV plus the script it used
• Accepts a screenshot of the layout you want as a guide

How to do it, step by step.

1. Install the Codex CLI. On macOS or Linux run curl -fsSL https://chatgpt.com/codex/install.sh | sh, or use npm with npm install -g @openai/codex; the desktop app is the no-terminal option.
2. In your terminal, move to the folder with your file and type codex to start.
3. Keep the default approval mode so Codex asks before it runs anything or touches the network.
4. Describe the cleanup in plain English and let Codex propose and run the script.
5. Open the output file, check a few rows against the source, and ask for corrections in plain English.

Where to be careful.

• Check the output against the original before you use it; Codex can mishandle blank rows, duplicates, rounding and date formats.
• Keep the script Codex wrote, so you can see and rerun exactly what was done.

Build a reconciliation as a reusable script

Because Codex writes a script, a reconciliation you build once reruns next period on fresh files. This is where it earns its keep at close.

What it does for finance.

• Compares two sources, books versus bank, general ledger versus subledger, your purchase register against your GST 2B, or your records versus a supplier statement
• Emits matched, unmatched and partially matched lists with the reconciling items
• Reruns on next period’s files without rebuilding the logic
• Can be told your match rules: tolerance, keys, how to treat credit notes

How to do it, step by step.

1. Put both files in one folder and start Codex there.
2. Tell Codex the two files, the columns to match on, and the tolerance.
3. Let it write and run the matching script and produce the output workbook.
4. Review the unmatched and mismatched lists and refine the rules in plain English.
5. Save the script so next month you just drop in fresh files and rerun it.

Where to be careful.

• Reconcile totals back to a control figure you trust before relying on the output.
• State your edge cases (credit notes as negatives, rounding) or Codex will guess.
• The output is a workbook of values from a script, not a live formula chain, see the audit note below.

Turn a one-off into a repeatable monthly task

Once a cleanup or report-prep works, you can make it routine.

What it does for finance.

• Saves a tested instruction as a reusable task
• The desktop app can schedule recurring runs, and the cloud can run tasks in the background, including several in parallel
• Useful for monthly file processing or report-prep that repeats the same way

How to do it, step by step.

1. Get the task working once and confirm the output is correct.
2. In the desktop app, save it as a recurring task on the cadence you need.
3. Have results land in a review queue so a person checks before anything is used.
4. Re-verify the first run of each period, because source files and formats drift.

Where to be careful.

• Automation does not remove review; check the first run each period.
• If a source layout changes, the script may need a tweak before it runs clean.

Choose your surface: web, CLI, IDE or desktop app

Choose the surface by the tools, files and permissions the work needs. Model availability and authentication options can differ between products and accounts; local execution and data processing are separate considerations.

• Codex CLI: runs tools in a local terminal. With hosted models, prompts and selected file or tool content can still be sent to the model provider; local execution does not mean offline processing.
• Desktop app: for macOS and Windows, the no-terminal option, with scheduling and parallel tasks.
• Web and cloud: runs tasks in OpenAI’s cloud, good for longer or parallel jobs, less suited to confidential files.
• IDE extension: for those who already work in a code editor, and can hand longer jobs to the cloud.

Connect your own tools with MCP

Codex can be wired to tools and data sources you configure through the Model Context Protocol, so it can fetch from or act in systems beyond your local files. This is an advanced setup, useful once you have a stable workflow and want Codex to reach a specific source you control.

Local versus cloud: two confidentiality postures

A local coding agent can read and execute files on your machine while using a hosted model for reasoning. A sandbox controls tool actions; it does not by itself prevent the contents read by those tools from entering model context. Cloud tasks run their tools remotely. Review the account’s data terms, model provider, retention and connector permissions before sharing client records. OpenAI’s approvals documentation explains action controls; its Codex plan guide distinguishes training settings for personal and business accounts.

Plans and how usage is metered

Codex is available with the ChatGPT plans listed in the current pricing guide, including Free and Go with limits. Included usage, eligible models and extra credits depend on the plan and workload. API-key usage is separately metered at API rates. Confirm the actual account’s access and billing before scheduling repeated work.

The audit-trail caveat you must respect

Where Codex falls short

• It is a coding agent, not accounting software or tax advice, and will not know your specific treatment unless you tell it.
• It can be confidently wrong and mishandle edge cases, so reconcile to a control total first.
• Hosted-model processing can include prompts, selected file content and tool results even when execution is local. Check the data permission and account terms.
• Formula preservation depends on the requested output and available tools. Inspect the workbook formulas and test dependencies before relying on it.

How to get started

1. Confirm your account access, then choose the CLI, desktop or web surface based on its tools and the permitted data-processing arrangement.
2. Use the official installation instructions for your operating system, or install the supported desktop app.
3. Start with a small, safe cleanup on a copy of a real file, with approvals on.
4. Once it works, save it as a reusable script or scheduled task, and always review the first run each period.

The information and tools on this page are for general information only and are not legal, tax, accounting or financial advice. For advice on your own situation, contact us.