Multi Currency Margin & FX Timing Tracker Spreadsheet
How much of the margin you quoted was lost between pricing the job and the money landing, split between the market, the bank and the wait.
Between the day a job is priced and the day the money lands, the rate moves. Nobody agrees to it, nobody signs it off, and it never appears as a line on anything — it comes straight out of the margin you already quoted. Your accounts show one year-end figure called something like foreign exchange difference, and it cannot tell you whether the money went on the market, on your bank’s spread, or on a customer who takes ninety-three days to pay.
What is in it
- Every invoice held at two rates — the one you priced at and the one it landed at — with the difference on the row
- Bank charges kept separate from the rate: one rate per currency in Setup, applied to every conversion
- How Long You Waited: the rate difference banded by the days between pricing an invoice and being paid for it
- By Customer: what a slow payer hands back in points of margin before anybody has discounted anything
- Your Price List: what 10,000 of your own money turns into at your standing rate against today’s
- Leave the payment date blank and an invoice still out is converted at today’s rate and shown as money still exposed — 1,000 rows, eight linked tabs
Who it is for
Anyone who prices in one currency and is paid in another: exporters, importers, agencies and manufacturers invoicing abroad. It works the same way on purchases as on sales, and it works from the first row if you only have a handful of foreign invoices a year.
The worked example
Across the eighteen worked months in the file, 420 invoices were priced at $2,263,576 on a margin of 39.1%. The rate cost $27,673 and the bank took $32,414 — $60,087 together, and 1.7 points of margin gone, leaving 37.4%.
Sorted by the wait, the rate difference runs from 0.5% on invoices paid inside 30 days to 2.7% on those over 120. Had everything converted as quickly as the fastest band the rate would still have cost $11,230, so $16,443 of it had nothing to do with the market at all — and one customer at 93 days handed back 2.5% against 0.7% from another at 47.
How it works
Compatible with Microsoft Excel 2016 or newer on Windows or Mac, Google Sheets, and LibreOffice. No macros, no add-ons, no account to create, nothing to install.
The download has two workbooks: one with the example above already filled in, so you can see what every column expects, and the same file completely blank for your own figures. A plain-English guide comes as a PDF. Order on WhatsApp — $9
Orders are taken on WhatsApp: message me and I’ll send the payment details, then the files as soon as the payment is confirmed.
A look inside the file
Questions people actually ask
How do I work out what currency movement is costing my margin?
Convert each invoice at the rate on the day you priced it and again at the rate on the day the money landed, and take the bank's spread off separately — they are three different problems with three different fixes. In the worked eighteen months the rate difference was $27,673 and bank charges $32,414, $60,087 together, turning a quoted 39.1% margin into 37.4% — 1.7 points gone. Sorted by how long each invoice waited, the cost runs from 0.5% under thirty days to 2.7% over 120.
We buy in foreign currency rather than sell — and we only have a handful of foreign invoices a year.
It works the same way on purchases: the rate difference and the bank charge are the two columns that matter and they behave identically. A handful of invoices is fine — everything works from the first row, the bands on How Long You Waited just get thinner. If you sell in your own currency only, the file has nothing to tell you, which is itself worth knowing, because it means you have moved the whole risk onto your customer.
Does it pull live rates, and where do I get the rates from?
No live feed, on purpose — you type the two rates that actually applied, and you already have both: one is on the quote, the other is on the bank statement. A live feed would tell you today's number, which is the one number that cannot help you. Leave the date paid and the landing rate blank while an invoice is still out, and the file converts it at today's rate, keeps counting the days, and shows it as money still exposed at a rate nobody has fixed.
Does it work in Google Sheets, and do I need any add-on for the rates?
Yes — the file is built as .xlsx, so it opens in Excel 2016 or newer on Windows or Mac, goes into Google Sheets through File → Import → Upload, and works in LibreOffice. No macros, no add-ons, no account to create, nothing to install and no subscription. You download a file and it is yours. The file holds 1,000 invoice rows, ten currencies and twenty-four customers, and comes with eighteen worked months, a blank copy and a plain-English PDF guide.
Is this a treasury or hedging system, and does it name my bank?
No — it is not a live rate feed, a treasury system or a hedging tool, not accounting or tax software, not financial advice, and no bank, broker or platform is named anywhere in it. If you already hedge, your forward rate goes in as the rate you priced at and the file measures whether the hedging was worth what it cost. It will not move the market; it tells you what the wait costs, what the bank costs, and how far your own price list has drifted — the worst currency in the worked file is 23.4% out.
Need it built around your business?
This file assumes you invoice abroad and convert when the money lands. If yours is different — forward contracts booked against each order, a marketplace or payment provider that converts at its own rate before it pays you, intercompany invoicing between two of your own entities, or landed cost arriving in a third currency — I can build the same logic around how you actually work.
All other templates are listed on the Excel & Google Sheets Templates page.