Overview
When your company makes International Wire Transfers (IWTs), the exchange rate applied at the time of payment may differ from the rate recorded when the transaction was originally booked. This difference creates a foreign exchange (FX) gain or loss, which must be accounted for in your books.
To help your accounting team reconcile these differences quickly and accurately, Spendesk provides a dedicated FX Gains & Losses export for all IWT payments made within a calendar month.
Why Does This Matter?
If your trial balance is not balancing to zero, unrecorded FX gains and losses on international payments are a common culprit. Without a clear breakdown, accountants can spend hours troubleshooting discrepancies, especially when multiple currencies are involved.
This report gives you a line-by-line breakdown of every paid IWT and its corresponding FX impact, so you can post the correct journal entries in your ERP or accounting system without the guesswork.
What Is Included in the Report?
The FX Gains & Losses report is provided as a CSV file and contains one row per paid International Wire Transfer. For each transaction, you will find:
Payment date
Beneficiary name
Transfer amount (in the destination currency)
Settlement amount (in your account currency)
Exchange rate applied at booking
Exchange rate applied at payment
FX gain or loss amount
The CSV format makes it easy to import or adapt the data for your accounting system.
When Is an FX Gain or Loss "Realised"?
An FX gain or loss becomes realised at the moment the payment is actually made. This is the point at which the exchange rate difference is no longer theoretical; it reflects the real cost or saving to your company. For this reason, the report is anchored to paid IWTs only and generated on a monthly basis.
How to Access the Report
The FX Gains & Losses CSV is delivered automatically each month, alongside your Account Statement:
At the end of each calendar month, you will receive an email containing a download link for the report.
The email is sent at the same time as your monthly Account Statement notification.
Click the download link in the email.
You will be prompted to authenticate with your Spendesk account.
Once authenticated, the CSV download will begin automatically.
Note: The report is only sent for months in which at least one IWT payment was made. If no IWTs were processed during a given month, you will not receive a report for that period.
How to Use the Report in Your Accounting System
Download the CSV from the link in your monthly email.
Open the file in your preferred spreadsheet tool (Excel, Google Sheets, etc.) or import it directly into your ERP.
Use the FX gain or loss column to create the corresponding journal entries for exchange rate differences.
Reconcile these entries against your IWT transactions to bring your trial balance to zero.
Tip: Because the report covers a full calendar month, we recommend processing it alongside your monthly account statement to keep your close process streamlined.
Frequently Asked Questions
Q: Can I get the FX report more frequently than monthly? The report is currently generated on a monthly cadence, aligned with your account statement. This ensures the data is complete and avoids the risk of duplicate entries in your ERP from multiple exports of the same transactions.
Q: What if I do not receive the email? Check your spam or junk folder first. If you still cannot find it, make sure your account statement notifications are enabled in your Spendesk settings, or contact our support team.
Q: Is PDF format available? The report is currently available in CSV format only, which offers the most flexibility for importing into accounting systems.
Q: Does the report cover all currencies? Yes. All paid IWTs in any currency are included in the monthly report.
Need Help?
If you have questions about reconciling FX gains and losses or need assistance with the report, please reach out to our Support Team via the in-app chat or at support@spendesk.com.