Foreign Currency Gain & Loss Calculator – Excel Template

Work out realised and unrealised exchange gains and losses on foreign-currency customer and supplier invoices.

• Automatic summary: Realised gains / (losses), Unrealised gains / (losses), Total FX result
• Calculated for you: Booked value, Realised gain / (loss), Unrealised gain / (loss)
• Drop-down menus for quick, consistent entry
• Colour-coded status and progress highlights
• Example rows and a step-by-step "How to Use" sheet

Instant download (.xlsx). Works in Excel 2010+, Excel online, Google Sheets, Numbers and LibreOffice. Works with any currency.