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

RecordUsed forWatch out
Invoice IDKeeps each row distinct, so every invoice counts once.Two rows that share an ID make the totals unreliable.
Type: receivable or payableSets the sign. Receivables add to the currency position and payables subtract from it.A credit note entered as a positive receivable inflates the position.
CurrencyGroups 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.
AmountThe 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 datePlaces 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

Illustrative sheet with USD and EUR invoices

Illustrative figures, not customer data.

ItemValueNote
USD receivables+USD 105,000INV-201 for 60,000 due on 14 December, and INV-207 for 45,000 due on 20 January.
USD payables-USD 70,000BILL-88, due on 5 December, before either customer pays.
Net USD+USD 35,000Long USD overall, but USD 70,000 must be paid nine days before the first receipt lands.
Net EUR-EUR 30,000BILL-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

StageFinance questionWhat to check
CleanIs every row open, dated, and in its invoice currency?Paid rows, blank due dates, and currency symbols in place of ISO codes.
NetWhat do we owe and expect in each currency?Receivables minus payables, plus foreign bank balances, per currency.
BucketWhat falls due first?Overdue, 0-30, 31-60, 61-90, and 90+ day windows.
StressWhat 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

Hedgr is read-only. It does not execute trades, move funds or give investment advice.

Guides

Accounting integrations

Pricing · All integrations · Home