| 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 | |
|---|---|
| Debit | Credit |
Bank 100 EUR | Funds in Transit 100 EUR |
...
Transfer of funds with foreign currencies
...
- Complete steps 1 and 2 above.
- 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
- 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.
...
| Debit | Credit |
|---|---|
Forex Gain/Loss 5 EUR | Funds in Transit 5 EUR |
...
Inter-company transfers
- For inter-company transactions you will need to setup a Inter-company clearing account rather than a Funds in Transit GL.
- The accounts needs to be setup for inter-company elimination (tick the check box on the account record)
- Otherwise it behaves the same as in the instructions above
...
| Debit | Credit |
|---|---|
Forex Gain/Loss 5 EUR | Intercompany Clearing 5 EUR |
The clearing account should balance to zero after both bank statements have been posted. In case there should be elimination, the elimination journal should be created separately, outside the bank statement,