Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

The following instructions are useful in dealing with reconciling bank transfers between different Bank accounts. 

1. Setting up a GL account for Funds in Transit or Transit Account (if required)

...

Receiving Bank
DebitCredit

Bank

100 EUR

Funds in Transit

100 EUR

...

Transfer of funds with foreign currencies

...

  1. Complete steps 1 and 2 above.
  2. By default NetSuite will set the exchange rate on the journals created to the daily rate that was applicable on the day the transaction took place, resulting in an imbalance on the Funds in Transit account
  3. Once both accounts have been reconciled, the exchange rate needs to be manually changed on either of the transactions to balance the amounts on the Funds in Transit account, or the exchange rate difference needs to be posted to a Foreign Exchange expense account manually.

...


DebitCredit

Forex Gain/Loss

5 EUR

Funds in Transit

5 EUR

...

Inter-company transfers

  1. For inter-company transactions you will need to setup a Inter-company clearing account rather than a Funds in Transit GL.
  2. Otherwise it behaves the same as in the instructions above

...