Migrate opening balances (Office-wise)
As a Head Accountant, I wish to set the opening balances for GL (General Ledger) accounts for a branch or an entire organization. This makes it easier for an organization wanting to move to Mifos to transfer GL account balances (from their existing accounting application or manual system) to Mifos X Accounting.
Opening balances must be set before entering any journal entries in accounting system.
Beginning at the main screen, click on Accounting. This will launch the Accounting menu.
Select Migrate Opening Balances
Could not load image

Step 1: Go to "Global configuration" (Admin>>System)

Enable "office-opening-balances-contra-account"
Could not load image

Step 2: Go to "Chart of accounts" (Admin>>Accounting)

Create a Contra-account (for example. Opening Balances Contra-account, which would be an Equity account)
Could not load image

Step 3: Go to "Accounts linked to Financial Activities" (Admin>>Accounting)

a) Click on "Define New mapping"
Could not load image
b) Select and update the mapping as mentioned below:-
Financial activity: Opening Balances Transfer Contra
Account: Opening Balances Contra -account
Then click on Submit.
Could not load image

Step 4: Go to Migrate opening Balances (Admin>>Accounting)

Could not load image
a) Select the desired office from the drop down
Could not load image
b) Select "Date of Opening Balance"
Select "Currency"
Enter Debit balance - Amount in the field box, with respect to your GL account.
Enter Credit balance - Amount in the field box, with respect to your GL account.
Then click on Submit button to pass the opening balance entries.
Could not load image
Note:
a) Prior to this, no transactions should occur.
b) You should follow the mentioned conditions below before you pass the Opening balance entry:
>> Either debit or credit balance may be specified for a particular account
>> Both debit or credit balance may NOT be specified for a particular account
>> Total debits should be equal to Total credits.

What happens if Opening balances are set after entering any journal entries in accounting system:

Be cautious that Opening balances are set before making any journal entry in accounting system. If you fail to do so, you won't be able to set the opening balance. Below are a few scenarios which should not be done before setting opening balance.
Scenario 1:Don't Define a Loan Product With Accounting Enabled:
  • If you are setting up opening balances, make sure that you don't have any loan product with accounting enabled.
Could not load image
  • In case you have loan product with accounting enabled and this loan product is linked with any of the clients, you won't b able to submit opening balances. So make sure that while setting up opening balances you don't have any loan product with accounting enabled.
Could not load image
Scenario 2: Don't Define a Savings Product With Accounting Enabled:
  • If you are setting up opening balances make sure that you don't have any savings product with accounting enabled.
Could not load image
  • In case you have savings product with accounting enabled and this savings product is linked with any of the clients, you won't be able to submit opening balances. So make sure that while setting up opening balances you don't have any savings products with accounting enabled.
Could not load image
Related articles
Last modified 2yr ago