Hisaab Docs Support Download

Docs / Move your books

Enter opening balances

Put opening balances on ledgers and stock items by hand or from a sheet, and confirm with the Trial Balance that they agree.

How-toHisaab 0.6Updated 19 November 2026

An opening balance is stored on the ledger or stock item itself, not in a voucher. Debit openings and credit openings must total the same amount.

What the set-up already did#

If you gave a bank balance and cash in hand when you created the company, those two openings are in place, with the same total credited to Capital Account. Every other opening is still zero.

Enter an opening balance on a ledger#

  1. Click Chart of Accounts in the sidebar.
  2. Select the ledger and press Ctrl+Enter, or click Alter. To add a new ledger, press Alt+C.
  3. Type the amount in Opening balance.
  4. Click Dr or Cr beside it.
  5. Press Ctrl+S to save.

Enter opening stock#

  1. Click All Masters in the sidebar and open Stock Items.
  2. Select the item and press Ctrl+Enter.
  3. Fill Opening quantity and Opening value.
  4. Press Ctrl+S.

Import openings from a sheet#

  1. Click Import & Export in the sidebar.
  2. Beside Blank sheets to fill in, click ledgers. A file named ledgers-template.csv is saved in your exports folder.
  3. Open it in a spreadsheet and fill one row per ledger, as in the example below.
  4. Save as CSV or .xlsx and drop the file on the Hisaab window. It is imported straight away, and the status bar says how many ledgers were added.
Ledger Name,Under,Opening Balance,Dr/Cr,GSTIN,State,Address,Credit Days,Bill-wise
Sharma Traders,Sundry Debtors,25000.00,Dr,27AAPFU0939F1ZV,Maharashtra,"12 MG Road, Pune 411001",30,Yes
Kaveri Mills,Sundry Creditors,18500.00,Cr,,Karnataka,,45,Yes

Ledgers that already exist are updated, not duplicated, and only the columns in your sheet are changed. A sheet with only Ledger Name, Opening Balance and Dr/Cr is enough to set openings on existing ledgers. If Dr/Cr is blank, the amount is taken as a debit.

For stock, use the stock items sheet and its Opening Qty and Opening Value columns.

Careful: Re-importing a legacy XML file does not change the opening balance of a ledger that already exists. To correct an opening after the first import, alter the ledger or use a sheet.

Check with the Trial Balance#

  1. Press Ctrl+K, type trial and press Enter.
  2. Look at the totals at the bottom. Debit and Credit must be equal.
  3. Look for a row named Difference in opening balances.
Trial Balance with debit and credit totals
Trial Balance with debit and credit totals

If that row is there, your openings do not agree. The amount in that row is how much is missing on one side.

To find the cause:

  • Compare each group total with the closing balance sheet from your previous software.
  • Check that creditors, loans and capital were entered as Cr.
  • Check that capital and reserves are included.

The Data Health report, under All Reports, has an Opening balances line that says either "debits equal credits" or the amount they differ by.

Limits#

  • An opening balance is one figure per ledger. There is no screen to split a party's opening into separate bills. In Bills Receivable and Bills Payable it appears as a single bill named "Opening balance".
  • Opening stock is one quantity and one value per item. It is not split by godown or batch.
  • The Opening value of stock does not enter the debit and credit check of ledger openings above.

Next#

Something here wrong or missing? Open a ticket and mention this page.

Hisaab is developed and supported by Aware Consultants  ·  About  ·  Support  ·  Privacy