Spreadsheet workflow
How to find your FX exposure from a spreadsheet
Updated
You can see your currency exposure without an accounting integration. A spreadsheet of open invoices and bills with five columns filled in is enough to net each currency, group it by due date, and see which payments fall due before the matching cash arrives.
For finance teams and founders who keep invoices in Excel, Google Sheets, or a CSV export and want to see their FX exposure.
The short answer
List every open foreign-currency invoice and bill with its ID, whether it is a receivable or a payable, its currency, its amount, and its due date. Subtract payables from receivables in each currency to get the net position, then group the same rows by due date to check whether customer cash arrives before supplier bills fall due. Add the rate each invoice was booked at if you also want unrealised FX gains and losses.
Source records
| Record | Used for | Watch out |
|---|---|---|
| Invoice ID | Keeps each row distinct, so every invoice counts once. | Two rows that share an ID make the totals unreliable. |
| Type: receivable or payable | Sets the sign. Receivables add to the currency position and payables subtract from it. | A credit note entered as a positive receivable inflates the position. |
| Currency | Groups rows into one position per currency. | Use ISO codes such as USD, EUR, and ZAR, because a dollar sign can mean USD, CAD, or AUD. |
| Amount | The foreign-currency value at risk on each row. | For a part-paid invoice, use the amount still due, or the position overstates the exposure. |
| Due date | Places each row in a maturity window, so timing is visible next to the net figure. | A row with no due date cannot be placed in any window. |
| Booked rate (optional) | The rate the invoice was booked at, which unrealised FX is measured against. | Without it you can see the exposure, but there is no gain or loss figure to report. |
Checks before relying on the numbers
- Every row is still open. Paid invoices left in the sheet overstate exposure, so mark them paid or add the payment date.
- Amounts are in the invoice currency. A column already converted to your home currency cannot be netted by currency.
- Foreign bank balances are included. Cash held in a USD account offsets USD payables, and it moves with the rate as well.
- The file is current. A spreadsheet is a snapshot, so upload it again when invoices are raised or paid.
Illustrative sheet with USD and EUR invoices
Illustrative figures, not customer data.
| Item | Value | Note |
|---|---|---|
| USD receivables | +USD 105,000 | INV-201 for 60,000 due on 14 December, and INV-207 for 45,000 due on 20 January. |
| USD payables | -USD 70,000 | BILL-88, due on 5 December, before either customer pays. |
| Net USD | +USD 35,000 | Long USD overall, but USD 70,000 must be paid nine days before the first receipt lands. |
| Net EUR | -EUR 30,000 | BILL-91, due on 28 December, has no EUR receipts to offset it, so the full amount moves with the rate. |
From spreadsheet to exposure view
| Stage | Finance question | What to check |
|---|---|---|
| Clean | Is every row open, dated, and in its invoice currency? | Paid rows, blank due dates, and currency symbols in place of ISO codes. |
| Net | What do we owe and expect in each currency? | Receivables minus payables, plus foreign bank balances, per currency. |
| Bucket | What falls due first? | Overdue, 0-30, 31-60, 61-90, and 90+ day windows. |
| Stress | What would a bad month cost? | Each net position moved by an adverse rate swing, after any forwards you hold. |
Common mistake
Netting the whole sheet into one number per currency and stopping there. The net figure hides whether a payable falls due before the receipt that is meant to fund it, and that gap is the part that needs cash.
Where Hedgr fits
Upload the CSV or connect the Google Sheet to Hedgr and map the five required columns once. Hedgr nets each currency, groups it by due date, and runs the worst-case stress, and Scout answers questions about the result with the rows behind each figure cited.
Related guides
- FX Exposure: Gross, Net, and Cash Timing
- Multi-Currency Invoice Cashflow Risk
- AI Tool to Analyse FX Exposure for a Small Business
Hedgr is read-only. It does not execute trades, move funds or give investment advice.
Guides
- FX exposure basics
- SME FX policy template
- Unrealised FX gains and losses
- Realised vs unrealised FX
- Multi-currency invoice cashflow risk
- Xero FX exposure workflow
- QuickBooks Online FX exposure workflow
- Exporter month-end FX reporting
- Multi-entity FX consolidation software
- SARB BoP categories after the August 2026 change
- Sage One South Africa FX exposure workflow
- Rand exposure for SA importers and exporters
- IAS 21 and the margin basis: does your FX impact double-count?
- FX exposure from a spreadsheet
- AI tool to analyse FX exposure for a small business
- What to do when your FX broker drops your account
- Forward contract deposit and close-out cost for SMEs
- How to hedge one foreign-currency invoice
- What SME FX providers charge in 2026
- How to pay a USD supplier from a GBP account
- How to check an FX margin against the mid-market rate
- EUR supplier payments for a group with a GBP parent
- When to buy foreign currency for invoices
- FX payments with Xero and QuickBooks
- How a small business books an FX forward contract
- Alternatives to your bank for business FX payments
- Can a small business automate FX hedging?
- How invoice-by-invoice FX hedging works
- What agentic FX is, and what an AI FX agent should do
- Canada: USD payables for CAD-reporting importers
- Canada: FX exposure in QuickBooks Online Canada
- Canada: FX gains and losses in Xero
- Canada: checking a USD/CAD bank margin
- Canada: FX forward contracts for small businesses
- Canada: how to pay US suppliers in USD
- FX risk management software for SMEs
- FX hedging software for SMEs
- Hedge accounting software: IFRS 9 checklist for SMEs
- FX risk for e-commerce and DTC exporters