Foreign Currency/EURActual Return Calculator
Calculate the Box 3 actual return for foreign bank accounts
How does this tool work?
- Select the tax year
- Add your foreign bank accounts, including the ECB currency for each account
- Add all deposits and withdrawals in the transaction table
- The tool automatically fetches the relevant ECB exchange rates per currency
- Export the result as PDF or download a blank Excel template to complete offline
Tax Year
Select the tax year for which you want to calculate the actual return
Accounts
Add all foreign bank accounts and choose the ECB currency for each account
No accounts yet. Click “Add Account” to get started.
Transactions
Add transactions manually, import a filled template, or export a styled template with examples that can be imported back immediately.
The export contains 3 tabs: `Transactions` and `Accounts` each start with a standard Excel table at `A1`, and `Instructions` contains all help text. Example rows are marked `[Example]` and will import as sample data unless you replace or delete them.
| Account | Date | Type | Amount (account currency) | Description | Rate | Amount (EUR) | |
|---|---|---|---|---|---|---|---|
| Add an account first | - | - | |||||
| Add an account first | - | - | |||||
| Add an account first | - | - | |||||
| Add an account first | - | - | |||||
| Add an account first | - | - |
Enter an account, date, and amount to add a transaction.
Enter account balances and transactions to calculate the actual return
Actions
The PDF contains the entered account balances, per-account transactions, ECB rates, and EUR calculations as supporting documentation for your tax return.