Solution Properties
Solution ID:
260729133650067
Last Modified Date:
Thu Jul 30 09:21:24 UTC 2026
Taxonomy Path:
Case category//How do I...//processing
Author:
[email protected]
Reverse bank transfers between different currencies
Description

You can reverse bank transfers between different currency accounts if you've made an error.  

Cause
Resolution
▼ Automatically reverse a foreign currency bank transfer
  1. Go to Nominal codes, select Journal reversal then OK.
  2. In the Posting Information section, enter the date of the bank transfer, then press OK.
    You can see the message 'Please one or more foreign bank revaluation journals have been excluded from the reversal list'. If so, follow the To manually reverse a foreign currency bank transfer section.
  3. Select the bank transfer journals you want to reverse, then press Reverse.
    To reverse the journals, the balance must be 0.00.
  4. Press Save.
▼ Manually reverse a foreign currency bank transfer
  1. Go to Bank accounts and select the bank account you want to transfer from.
  2. Select Bank transfer then complete the Bank Transfer window as follows:
    From Enter the bank account you want to transfer money from.
    To or Account to Enter the bank account you want to transfer money to.
    Date Enter the date of the transfer.
    Reference Automatically displays 'TRANS'. If required, you can amend this.
    Details or Description Automatically displays Bank Transfer. If required, you can amend this.
    Department Enter the department.
    Payment Amount Enter the payment value of the transfer, in the currency you're transferring from.
    Receipt Amount Enter the receipt value of the transfer, in the currency you're transferring to.
    Exchange Rate

    Enter the exchange rate for the transfer. You can enter an exchange rate with up to 6 decimal places.

    If prompted, to update the exchange rate in your currencies list, press Yes or No as required.
    The comment on the Bank Transfer window indicates how the software uses the rate.

    For example, you enter an exchange rate of 1.3 and you transfer from Euros to US Dollars, the comment is 'One euro is worth 1.3 US Dollars.'
  3. Press Save then Close.
▼ Reverse a bank transfer between two foreign currency bank accounts, if the original transfer includes a revaluation

Locate the original transfer and values

The below example is based on a company with a Sterling base currency. Follow all the sections in order.

  1. Go to Transactions and locate the bank transfer journals and revaluation journals and write down the transaction values.
    For example, a bank transfer of €1000.00 from Euro bank account (1200) to Dollar bank account (1210) for $1500.00 creates the following:
    Type Nominal Details Date Ref Net Tax T/C
    JC 1200 Bank Transfer 15/04/26 TRANS 937.50 0.00 T9
    JD 1210 Bank Transfer 15/04/26 TRANS 937.50 0.00 T9
    JC 7906 Foreign Bank Transfer Revaluation Journal from (number) 17/04/26 REVAL 168.27 0.00 T9
    JD 1200 Foreign Bank Transfer Revaluation Journal from (number) 17/04/26 REVAL 168.27 0.00 T9

    TIP:

    The revaluations always post using the program date.

     

Calculate the value of the transaction in your base currency

  1. Deduct the revaluation value from the bank transfer value.

For example, using the values above 937.50 - 168.27 = 769.23 therefore this is the original sterling value.

Calculate the exchange rate required for each currency

For the bank account that hasn't had a revaluation posted:

  1. Go to Transactions then select Edit, to find the exchange rate.

For example, using the transactions above, the bank transfer transaction for nominal code 1210 hasn't had a revaluation posted. In 'Transactions', the exchange rate shows 1.600000. This is the Dollar exchange rate.

  1. For the bank account with the revaluation, divide the foreign gross value by the value you calculated in the previous section.

For example, using the transactions above, the foreign gross value is 1000.00 and the value in the previous section is 769.23. Therefore, the exchange rate is 1.300001. This is the Euro exchange rate.

  1. Go to Transactions then select Edit to find the Foreign gross value.

Enter the exchange rates in the currency list

  1. Go to Settings then select Currencies and select the required currencies.
  2. Note the existing exchange rate, then enter the exchange rates calculated in step 3.

For example, using the values from step 3 the Dollar exchange rate is 1.600000 and the Euro exchange rate is 1.300001.

  1. Press Close.

Change the program date to the date of the original revaluation

  1. Go to Settings then select Change Program Date, then press Yes to close any open windows.
  2. Enter the date of the revaluations then press OK.

For example, using the above transactions, the date is 17/04/26.

Post the opposite bank transfer

  1. Go to Bank accounts then select Bank transfer and enter the relevant details.
From or Account from This is the bank account you used to post the original bank transfer to.
To or Account to This is the bank account you used to post the original bank transfer from.
Payment Amount This is the foreign gross value and is to match the original bank transfer value for the bank account the original bank transfer you posted to.
Receipt Amount This is the foreign gross value and is to match the original bank transfer value for the bank account the original bank transfer you posted from.
Date This is the bank transfer date and is to match the original bank transfer date.

For example, using the transactions above:

From or Account from 1210 Dollar Account
To or Account to 1200 Euro Account
Payment Amount USD $ 1500.00
Receipt Amount EUR € 1000.00
Date 15/04/26
  1. Press Save then Close.

Change the program date to the current date

  1. Go to Settings then select Change Program Date.
  2. Press Yes to close any open windows, enter the current date, then press OK.

Change the exchange rates back to the original rates

  1. Go to Settings then select Currencies.
  2. Select the relevant currencies, then enter the exchange rates that you entered before you changed them.
  3. Press Close.
[BCB:366:UKI - training sales:ECB]
Steps to duplicate
Related Solutions