|
|
|
You can transfer funds between Bank Accounts in different currencies. If you are using the Rates Table the Exchange Rate will be retrieved but can be overridden. If you are not using the Rates Table you will need to enter an Exchange Rate.
Banking Receipts into a Foreign Bank Account
Realised Variations Dissections will occur when you bank foreign AR Receipts into a Bank Account of a different currency if the Exchange Rate differs between the Banking Items and the Banking Summary. These journals go into the Cash book Batch.
The GL Account used here is mapped from the Analysis Code selected in the Realised Variation Code field in Cash Book Settings > Integration Tab.
Realised Variations
During the Revaluation process the net movements of the Period are compared with the Bank Account Opening Balances, and Realised Variations are calculated when the funds move towards zero. This is done by going to Navigator > Tasks > CB > Revalue Foreign Balances.
Revalue Foreign Balances is required as part of the End of Period Update process, but you can Revalue as often as you wish.
In Cash Book, Bank Account Balances are Revalued, not Transactions.
You can customise to show the Variation Realised Bs field in the CB Bank Account Maintenance, Balances tab.
Variation Realised Bs Calculation
To calculate Variation Realised Bs, first an Opening Rate must be calculated, to be used when backing out Opening Unrealised Variations.
The Opening Rate calculation is: PeriodOpeningBalance / (PeriodOpeningBalanceBs - OpeningUnrealisedVariationBs)
Then Accredo checks the Opening Balance against the Closing Balance and if both balances are in funds, any Withdrawal Activity will result in a Realised Variation Bs.
The Realised Variation Bs calculation is: (WithdrawalActivity / OpeningRate) – WithdrawalActivityBs
If the Opening and Closing balances are both in overdraft, any Deposit Activity will result in a Realised Variation Bs.
The Realised Variation Bs calculation is: (DepositActivity / OpeningRate) – DepositActivityBs
If the Opening Balance starts in overdraft but ends in funds, a Realised Against Opening Bs must be calculated first.
The Realised Against Opening Bs calculation is: - (PeriodOpeningBalance / Opening Rate)+((PeriodOpeningBalance / WithdrawalActivity)*WithdrawalActivityBs)
The Realised Variation Bs calculation in this situation is: RealisedAgainstOpening +((OpeningBalance +WithdrawalActivity) / (DepositActivity / DepositActivityBs)-((OpeningBalance +WithdrawalActivity) \ WithdrawalActivity)*WithdrawalActivityBs)
Alternatively if the Opening Balance starts in funds but ends in overdraft, a Realised Against Opening Bs must be calculated first.
The Realised Against Opening Bs calculation for this situation is: - (PeriodOpeningBalance / Opening Rate)+((PeriodOpeningBalance / DepositActivity)*DepositActivityBs)
The Realised Variation Bs calculation is: RealisedAgainstOpening +((OpeningBalance +DepositActivity) / (WithdrawalActivity / WithdrawalActivityBs)-((OpeningBalance +DepositActivity) / DepositActivity)*DepositActivityBs)
Unrealised Variations
Unrealised Variations are also calculated when Bank Accounts are Revalued.
You can customise to show the Variation Unrealised Bs in the CB Bank Account Maintenance, Balances tab.
Unrealised Variation Bs Calculation
The Unrealised Variation Bs calculation is: (Period Closing Balance/ Revaluation Exchange Rate)-(PeriodClosingBalanceBs Before Revaluation+VariationRealisedBs).
If the Bank Account has already been Revalued during the month, the Variations are deducted from the Period Closing Balance Bs before being recalculated.
Transfer to General Ledger
Navigator > Tasks > Cash Book > Transfer to General Ledger
When you transfer to General Ledger for Cash Book, Accredo creates a separate Cash Book Exchange Variation batch.
To reconcile your GL Realised Gain Loss on Exchange and GL Unrealised Revaluation Reserve with CB sourced Transactions, use: Navigator > Reports > Cash Book > Account Reports > Exchange Variation Sequence.
This report lists the exchange variations in the period order they were calculated in. You can filter on Variation Type = U for Unrealised Variations, and Variation Type=R for Realised Variations, or you can group the report by Variation Type.
|
|
|
