Choose one of three approaches. The steps for that option appear below.
Choose an option above. On a phone, swipe the tabs left or right to see all options →
ChatGPT runs a code-backed total by currency and maturity. You inspect the code and recalculate samples.
Get inputs, rules ready
Draft in Python
Check and save pack
Use: You
Have ready: balance CSV (row ID, currency, signed amount, maturity date), reporting date and currency, sign convention, maturity buckets, date convention, netting rules, rate table.
Stop if upload permission is absent. Verify date, currency, completeness and the supplied rules; do not replace missing rules with guesses. Keep inputs in an access-controlled local draft. Check the valuation-date rate table states rate direction and source.
Use: ChatGPT
Only the approved input package from step 1: attach the CSV, paste the rules. ChatGPT shows Python code, row counts, assumptions and exception rows.
What to paste into the tool
Task: Produce a draft currency-by-maturity exposure table showing gross and net balances, translated amounts where supported, and missing-rate exceptions. Inputs: [ATTACH: the approved balances CSV from step A-1] [PASTE: reporting currency] [PASTE: reporting date] [PASTE: sign convention identifying receivables and payables] [PASTE: maturity bucket boundaries, date convention and treatment of missing maturity dates] [PASTE: rate table with rate direction and source] [PASTE: netting rule]. Use only these inputs. Show the Python used and a row-level audit trail with source IDs. Keep gross receivables and payables visible before netting by currency and maturity bucket. Use only supplied rates and approved netting rules; no live rate lookup or forecast. If the rate direction is not stated or the rate is missing, the translated amount stays not stated. Do not treat netting as legal set-off or recommend trades. Never silently drop or repair rows. Report missing facts as 'not stated'. Do not access accounts or external sources, send messages, post entries, change the master ledger, sign, publish or pay. Produce a draft for human review only.
Use: You
Check the output, correct or reject it. Save the checked pack locally as draft. Record date and rate source.
Recalculate one balance per currency, both signs, each maturity boundary and every missing-rate case. Local-currency gross and net totals reconcile to source rows; translations use documented multiply/divide direction; unsupported currencies not stated. Do not send, sign, pay, publish, post journals or update master records.
Copilot in Excel suggests formulas from synthetic sample columns only. You apply checked formulas locally to the real draft.
Get inputs, rules ready
Suggest formulas
Test, build, check
Use: You
Have ready: balance CSV (row ID, currency, signed amount, maturity date), reporting date and currency, sign convention, maturity buckets, netting rules, valuation-date rate table.
Stop if upload permission is absent.
Use: Copilot in Excel
Only the approved input package from step 1. Ask in chat mode for formulas; it must not modify the workbook or make a finance decision.
What to paste into the tool
Task: Suggest spreadsheet formulas and test cases for a private draft worksheet, not a finance decision. Inputs: [PASTE: 5-10 synthetic example rows, no real balances] [PASTE: column names] [PASTE: approved rate direction and netting rules] [PASTE: synthetic reporting date and rate table, reporting currency, sign convention, maturity bucket boundaries, date convention and treatment of missing maturity dates]. Use only these inputs. Keep gross receivables and payables visible before netting by currency and maturity bucket. Use only supplied rates and approved netting rules; no live rate lookup or forecast. If the rate direction is not stated or the rate is missing, the translated amount stays not stated. Do not treat netting as legal set-off or recommend trades. Explain references, date boundaries, sign handling and error conditions. Give formulas as text, with sample expected results; do not edit files. Missing inputs must produce a 'not stated' note or an explicit exception. Do not choose accounting policy or recommend action. Do not send, post, sign, publish or pay.
Use: You
Test formulas on synthetic normal and edge cases. Build the draft yourself. Save the checked pack locally as draft. Record date and rate source.
Do not send, sign, pay, publish, post journals or update master records.
You do all matching and arithmetic first. Claude only summarises a small, checked text note.
Calculate by hand, write note
Summarise the note
Check and save pack
Use: You
Have ready: balance CSV (row ID, currency, signed amount, maturity date), reporting date and currency, sign convention, maturity buckets, netting rules, valuation-date rate table.
Stop if upload permission is absent. Total currency and maturity groups by hand with supplied rates; reconcile signs; note concentration and not-stated-rate rows.
Use: Claude
Only the approved input package from step 1: the checked note, not the data file. Claude summarises it and lists open questions, no recalculating.
What to paste into the tool
Task: Write an internal narrative of the checked currency exposure inventory, with no forecast, hedge proposal or instructions to trade. Input: [PASTE: the human-checked note from step C-1]. Use only this note. Preserve every amount, unit, date, label and source ID exactly. Do not recalculate, infer missing facts or add a judgement. Keep gross receivables and payables visible before netting by currency and maturity bucket. Use only supplied rates and approved netting rules; no live rate lookup or forecast. If the rate direction is not stated or the rate is missing, the translated amount stays not stated. Do not treat netting as legal set-off or recommend trades. Say 'not stated' for missing information. Separate facts from open questions. Do not draft an external message or instruct anyone to act. Do not access accounts, send, post, sign, publish or pay. Return internal draft text only.
Use: You
Check every sentence and number against your note; remove unsupported claims; keep not-stated facts. Save the pack locally as draft. Record date and rate source.
Do not send, sign, pay, publish, post journals or update master records.
Best when: A structured export needs repeatable batch totals you can inspect.
What it does: ChatGPT calculates in code; you recalculate samples.
Strong at: Shows the Python code and row-level audit trail.
Limit: Free plan limits file uploads and data analysis.
Free plan: Yes, limited (file uploads, data analysis)
Best when: You want to build and own the formulas.
What it does: Copilot in Excel suggests formulas; you build and test them.
Strong at: Explains formulas and gives synthetic test cases.
Limit: On iPhone and Android, chat mode only.
Free plan: Paid plan needed
Best when: You want to do all the arithmetic yourself.
What it does: You calculate by hand; Claude summarises the checked note.
Strong at: Preserves every amount, date and source ID exactly.
Limit: Usage is capped in 5-hour and weekly windows.
Free plan: Yes, limited (usage capped in 5-hour and weekly windows)
Before you paste into any AI tool, remove any confidential information. Put it back at the end.
Deciding between ChatGPT and Claude for this? See the comparison.
Never paste credentials or full payment details.
Confirm authorised inputs and rules before use.
Independently recalculate at least one balance per currency, both receivable and payable signs, each maturity boundary and every missing-rate case. Confirm the reporting date and rate source are recorded.
Reconcile completeness and totals, preserve open questions, and save only a draft.
Check the result against your original inputs. Approve it before sharing or acting.
Based on official product documentation checked on 2026-10-29.