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.

    • Related Articles

    • How to upload Vendor Opening Balance?

      Please follow the steps below to upload vendor opening balance in batch. Step 1: Got to Expense Tracker > By Vendors > Bulk Posting. Step 2: Click on 'Batch Upload Opening Balance'. Step 3: Enter the opening balance information against the required ...

    • How to upload the opening balance of particular ledger account?

      Please follow the below steps to upload opening balance of particular ledger account: Step 1: Go to Admin -->> General Ledger -->> Journal Entries Step 2: Click on "Create Journal Entry" Step 3: Enter Journal Notes (Narration), Date and amount in the ...

    • How to upload Vendor Opening Balance in bulk?

      Please follow the steps below to upload vendor opening balance in bulk using excel upload. Step 1: Got to Expense Tracker > By Vendors > Bulk Posting. Step 2 : Click on 'Batch Upload Opening Balance From Excel'. Step 3: Download the Excel Template ...

    • How to upload the opening balance of the bank?

      Please follow the below steps to update the opening balance of the bank: Step 1: Login to ADDA -->> Update the bank name from General ledger -->> Chart of Accounts -->>Assets. You will have to pass the journal entry to post the bank opening balance ...

    • If I had purchased an asset before 01-04-2013 then how can I account for it?

      If the Assets are purchased in the Last year, you can consider them as an Opening Balance. To record it, please pass a journal entries by following the below steps: Step 1: Login to ADDA -->> General Ledger --->> Journal Entries -->> Create Journal ...