Revaluation of Bank Accounts: Process Activity

The following activity will walk you through the process of performing the revaluation of a bank account.

Story

Suppose that the accounting department of SweetLife Fruits & Jams company has to revalue the company's bank account in CAD several times within each financial period. Acting as a SweetLife accountant, on January 24, 2023, you need to revalue the cash account for the 01-2023 financial period and post the generated GL transactions.

Configuration Overview

For the purposes of this activity, the following features have been enabled on the Enable/Disable Features (CS100000) form:

  • Standard Financials, which provides the standard financial functionality
  • Multibranch Support, which supports multiple branches in your instance of MYOB Advanced
  • Multicompany Support, which supports multiple companies within one tenant.
  • Multicurrency Accounting, which enables multicurrency operations in the system

On the Chart of Accounts (GL202500) form, the 84010 (Cash Account Revaluation Gain/Loss CAD) account has been created.

Process Overview

In this activity, you will review the revaluation rate type specified for the 10215 account on the Chart of Accounts (GL202500) form. On the Account Summary (GL401000) form, you will review the balance of the account, which is denominated in CAD, before its revaluation. (You created this GL account and the corresponding cash account in Multicurrency Cash Accounts: To Configure an Account.) On the Revalue GL Accounts (CM506000) form, you will revalue the denominated account and review the GL transaction generated by the system on the Journal Transactions (GL301000) form. Finally, you will review the updated balance of the denominated account on the Account Summary form.

System Preparation

To prepare the system for the steps of this activity, do the following:

  1. Launch the MYOB Advanced website, and sign in to a company with the U100 dataset preloaded. To sign in as an accountant, use the following credentials:
    • Username: johnson
    • Password: 123
  2. On the Company and Branch Selection menu, also on the top pane of the MYOB Advanced screen, make sure that the SweetLife Head Office and Wholesale Center branch is selected. If it is not selected, click the Company and Branch Selection menu button to view the list of branches that you have access to, and then click SweetLife Head Office and Wholesale Center.
  3. As a prerequisite activity, make sure that the multicurrency accounting functionality has been configured as described in Multicurrency Functionality: Implementation Activity and Configuration of Rate Types and Rates: To Configure Rates.
  4. As a prerequisite activity, make sure that you have configured an account as described in Multicurrency Cash Accounts: To Configure an Account.
  5. As a prerequisite activity, make sure that you have processed a funds transfer as described in Multicurrency Funds Transfers: Process Activity.

Step 1: Reviewing the Revaluation Rate Type

To review the revaluation rate type for the account denominated in CAD, do the following:

  1. Open the Chart of Accounts (GL202500) form.
  2. In the Revaluation Rate Type column, review the revaluation rate type in the row with the 10215 account.

    The revaluation rate type should be SPOT.

    Note: If the revaluation rate type is not specified for a particular account, for the revaluation of this account, the system uses the default rate specified in the GL Revaluation Rate Type box of the Currency Management Preferences (CM101000) form.

Step 2: Reviewing the Balance of the Denominated Account Before Revaluation

To review the balance of the 10215 account, which is denominated in CAD, do the following:

  1. Open the Account Summary (GL401000) form.
  2. In the Selection area, specify the following settings:
    • Company/Branch: HEADOFFICE - SweetLife Head Office and Wholesale Center (inserted automatically)
    • Ledger: ACTUAL
    • Period: 01-2023
    • Show Currency Details: Selected
  3. Review the balance of 10215 (Checking Account CAD).

    The balance of the denominated 10215 checking account for the specified period is $336.75, which is C$430.23 in the currency of denomination. (Notice that the Currency ID column contains CAD for this account.)

Step 3: Revaluing the Bank Account

To revalue the bank account denominated in CAD, do the following:

  1. Open the Revalue GL Accounts (CM506000) form.
  2. In the Selection area, specify the following settings:
    • Company/Branch: HEADOFFICE - SweetLife Head Office and Wholesale Center (inserted automatically)
    • Fin. Period: 01-2023
    • Currency Effective Date: 1/24/2023
    • Currency: CAD
    • Description: GL Revaluation 01-2023 CAD
  3. Select the unlabeled check box in the only row in the table, and on the form toolbar, click Revalue to perform the revaluation for the selected account. The system generates a revaluation transaction and opens it on the Journal Transactions (GL301000) form.
  4. On this form, review the revaluation transaction in the base currency. Notice that the Auto Reversing check box in the Summary area is cleared; the created batch is not auto-reversing and thus will not be reversed at the start of the next period.

    When the revaluation transaction was automatically posted, the following actions were performed in the system:

    • The revalued 10215 checking account was debited in the amount of the calculated revaluation gain ($0.63).
    • The revaluation gain/loss account specified for the CAD currency (84010), which you specified when you defined the CAD currency in Multicurrency Functionality: Implementation Activity) was credited in the amount of the calculated revaluation gain ($0.63).

Step 4: Reviewing the Balance of the Denominated Account After the Revaluation

To review the balance of the 10215 account denominated in CAD, do the following:

  1. Open the Account Summary (GL401000) form.
  2. In the Selection area, specify the following settings:
    • Company/Branch: HEADOFFICE - SweetLife Head Office and Wholesale Center (inserted automatically)
    • Ledger: ACTUAL
    • Period: 01-2023
    • Show Currency Details: Selected
  3. Review the table. The balance of the denominated 10215 checking account is now $337.38, which is C$430.23 revalued by the system by using the CAD exchange rate effective on 1/24/2023.
  4. Click the row with the 84010 (Cash Account Revaluation Gain/Loss CAD) account, and on the form toolbar, click Account Details.
  5. Review the Account Details (GL404000) form, which opens. The revaluation gain in the amount of $0.63 has been credited to the 84010 account.