FX Gain & Loss Calculator

Calculate realised and unrealised foreign exchange gains and losses on balances and transactions.

Key features

• Transaction and settlement rates
• Realised and unrealised FX
• Period-end revaluation
• Journal entries

Who it is for

Accountants · Financial controllers · Finance managers · Auditors

What is included

• Instructions
• Settings
• Rates
• Transactions
• Revaluation
• Journals

Make it yours

Add your company or business name, logo, address, currency and date format. In the web app your branding is saved and shown on the dashboard and exports. Rename categories and lines to match your business.

Requirements

Excel: Microsoft Excel 2016 or later, or Microsoft 365 (Windows or Mac). Google Sheets: a free Google account. Web app: a current browser on computer, tablet or phone.