Change of Currency [Home to Foreign]

SOLVED

Accountants have been processing the Foreign currency bank account using the home currency, after processing the cashbook and all being in balance I updated (in home currency), run the year end process, then I cleared the bank account to an opening balances account (as of the request) then setup the account to reflect in the foreign currency. Now when we check the balances in the foreign currency its fine, however the balance of the home currency is strangely not correct anymore as per the bank statement. If I print, the cashbook details though the closing balance is correct (foreign currency) as per the bank statement. The figure on the actual processing screen of the cashbook is correct on the foreign currency not correct in the home currency anymore. I have printed and reconciled and cannot find any discrepancies. Is there anywhere I can look that would affect the closing balance on the updated cashbook details and the balance on the processing screen?

  • +1
    verified answer
    Good day,
    Please note that when creating a cashbook, the system asks if it is a home or foreign currency. If the setup is not done correctly, you will need to create a new account with the correct settings and process using the correct currency.
    We cannot indicate if you are referring to valuation when you cleared the bank account. However, the foreign currency revaluation will only adjust the home currency value to be in line with the foreign currency
    amount, and write the profit or loss to the relevant General Ledger account. It does not clear the history.
    Out-of-period processing can also be a cause of incorrect balances. Please refer to the link below to assist with identifying out-of-period processing.
    How do I identify Out of Period Processing,

    How do I set up and use Multi-Currency
    za-kb.sage.com/.../viewsolution.jsp

    How do I process for customers, suppliers, and cashbooks that use Multi-Currency
    za-kb.sage.com/.../viewsolution.jsp
    Foreign Currency Revaluation
    za-kb.sage.com/.../viewsolution.jsp
    Should you require further assistance in the investigation of this issue, please forward an email to [email protected]. Kindly attach the reports and screenshots for further assistance.
    Kind Regards,