How to upload the opening balances for assets and liabilities?

How to upload the opening balances for assets and liabilities?

Step 1: Go to the General Ledger section -->> Select Journal Entries -->> Click on Bulk Posting -->>Then, choose "Batch upload Opening Balance from Excel."

Step 2: Download the provided template from Step 1 and input the relevant data:

  • Account: Get the General Ledger Code from the Chart of Accounts Screen.

  • Comment: Add a comment.

  • Debit Amount: Specify the amount for the account to be debited.

  • Credit Amount: Indicate the amount for the account to be credited.

  • Posted Date (MM/DD/YYYY): Enter the accounting start date.

Step 3: After filling the template, save it in CSV format. Then, proceed to "Choose File" and "Upload" to submit.

In case of incorrect data upload, follow these steps to delete entries:Go to General Ledger -->> Journal Entries -->> Select Bulk Corrections -->> Fetch entries you want to delete based on the date.