Enter your idea

Problem
When a user uses Xero's Transfer Money function to transfer the entire balance of a foreign currency bank account, the foreign currency balance correctly becomes zero.
However, due to exchange rate differences between the original transaction date and the transfer date, Xero may leave a residual balance in the base currency (for example, SGD) within the account transaction history.
This remaining balance represents a realised foreign exchange gain or loss arising from the disposal of the foreign currency funds. Therefore, Xero should automatically recognise this FX difference and clear the bank account balance.
The expected accounting outcome should be:
• Foreign currency balance: 0.00
• Base currency balance: 0.00
• Realised foreign exchange gain/loss correctly recognised in the appropriate FX gain/loss account

Current system limitation
Currently, when a user transfers the full balance of a foreign currency bank account using Transfer Money, Xero does not automatically recognise the realised foreign exchange gain or loss generated from the transaction.
As a result:
• The foreign currency balance is already zero.
• The bank funds have already been fully transferred.
• However, a residual base currency balance may remain in the account transaction history.
This prevents users from completing the accounting process through the normal Transfer Money workflow.

Issue with the suggested Spend Money / Receive Money solution
Xero Support previously suggested creating additional Spend Money / Receive Money transactions and adjusting the FX amount to clear the remaining balance.
However, this suggestion is not applicable for Singapore Xero organisations for the following reasons:
1. The Singapore version of Xero does not provide a function to independently override the base currency amount in a Spend Money / Receive Money transaction.
2. Creating an additional foreign currency transaction would change the foreign currency bank account balance and would not naturally maintain the foreign currency balance at zero.
3. These transactions do not represent actual banking activity. They would only be created to force the system balance to clear.
4. This approach would result in:
o Artificial transactions appearing in the bank account history.
o Additional accounting adjustments.
o Reduced transparency and auditability.
o More complicated bank reconciliation processes.
Therefore, Spend Money / Receive Money is not a standard or appropriate solution for Singapore Xero users facing this scenario.

Suggested product improvement
Enhance Xero's multicurrency functionality so that when a user transfers the full balance of a foreign currency bank account:
1. Xero automatically calculates the realised foreign exchange gain or loss.
2. Xero automatically posts the FX difference to the correct realised currency gain/loss account.
3. Xero automatically clears:
o The foreign currency balance; and
o The corresponding base currency balance.
4. The accounting record remains accurate by keeping only the actual Transfer Money transaction, without requiring artificial adjustment entries.

Example scenario
A USD bank account receives USD 16,800,000, recorded at SGD 21,759,346.81 based on the exchange rate on the receipt date.
The full USD 16,800,000 is later transferred to an SGD bank account using Transfer Money, recorded at SGD 21,742,560.00 based on the exchange rate on the transfer date.
Result:
• USD bank account balance: USD 0.00 (correct)
• Remaining SGD difference: SGD 16,786.81
The SGD 16,786.81 difference represents a realised foreign exchange gain/loss and should be automatically recognised by Xero as part of the Transfer Money process.
Currently, users are required to find manual workarounds, but these workarounds are either unavailable in Singapore Xero organisations or do not represent proper accounting treatment.

Benefits
• Provides an accounting workflow that reflects real-world foreign currency transactions.
• Avoids creating artificial bank transactions.
• Improves audit trail transparency.
• Reduces manual adjustments and user errors.
• Provides a more consistent multicurrency experience across Xero regions.

Requested enhancement
Please consider adding functionality so that when a user transfers the full balance of a foreign currency bank account using Transfer Money, Xero automatically recognises the realised foreign exchange gain/loss and clears both the foreign currency and base currency balances.
In addition, Xero Support guidance should be updated to avoid recommending Spend Money / Receive Money adjustments in regions where the required functionality is not available.