Every business wants to have their chart of accounts or ledgers present in the AEOC for smooth and comfortable accounting entries. To achieve that, we have to do the following:

Step 1: Open AccountsEasy On Cloud from HQ and navigate to Tools > Configuration > Admin Configuration.

Step 2: Click on the Transactions tab.

Step 3: Scroll and locate "Not allow Opening balance Import Multiple Times" and remove the check box if it is checked.

*** Note: This configuration must be unchecked when importing the opening balance for a ledger multiple times using the opening balance import template.

When this configuration is enabled, the system will block any attempt to re-import the opening balance for a ledger that has already been imported.

If you have imported an opening balance incorrectly, you must manually reset the balance to zero and then re-import the correct values using the template. It is essential to uncheck this configuration when updating an already-imported ledger.

Once the opening balance is imported, this configuration is automatically enabled. If you need to adjust it, you must manually disable it for any subsequent imports.

Step 4: Navigate to Voucher Entry > More > Opening Balance Import.

Step 5: The OPENING BALANCE IMPORT screen will open. Click Download Template.

A file named "FileTemplateVoucherImport" will be downloaded. This file will contain the default format, which you can use as a reference to create your own file.

The important fields are highlighted in the below screenshots.

Step 6: Fill in the necessary details in the file and then upload the same.

Here, the OPVDATE format should be yyyy-mm-dd.

Add the LEDGERNAME, proper GROUPNAME, DR or CR values, proper ParentGroupName, billwiseflg, and status properly.

Status should always be A for Active.

Step 7: Select the proper transaction year using the [Select a TranYear] dropdown on the left side of the screen.

Step 8: Click Upload / Drag and Drop a CSV file and select the CSV file you just filled out.

The details will be loaded into the screen.

Step 9: Click Import to import the data.

Step 10: Click Confirm in the pop-up.

Step 11: Click OK in the confirmation pop-up.

If you mistakenly try to import the same ledgers again, it will give you the below error message.

Step 12: To verify in your master, navigate to Masters > Expenses. Click on the F7 View button and enter the name of the ledger you just created in the search box. For this example, we will use "Pooja." You will see all the ledgers that have been created.

Step 13: To verify the information in the payment entry screen, navigate to the Payment Single Voucher. Select the account, and then press the Enter key in the Particulars column. This will bring up the list of ledgers (LOV). Search for the ledger names you just created; for this example, we will use "Pooja."