Open ERP

Create a Sub Ledger

Create a detailed account beneath a main ledger, with the same address, contact, tax and balance information where required.

Select the Mother Account

A sub-ledger is similar to a main ledger, but it must be linked to a parent account. Select the appropriate Mother Account before entering the account and printable names.

Jhapu New Sub-ledger Details form showing the Mother Account selector and account name fields
Select the main ledger that will contain the new sub-ledger.
  • Mother Account: the main ledger under which this sub-ledger is maintained.
  • Account Name and Printable Name: define the internal and document-facing account names.
  • Additional details: complete the address, contact, tax, opening-balance and credit-limit fields as appropriate.

Make the ledger available for bill adjustment

Enable Relate To Bill when this sub-ledger should be available in the Sale and Purchase Add/Less dropdown. Leave it unchecked for sub-ledgers that should not be selected there.

Jhapu Sub-ledger form showing opening balance, remarks and the Relate To Bill checkbox
Relate To Bill controls whether the sub-ledger appears in the Sale and Purchase Add/Less selection.
Before saving

Confirm the Mother Account and Relate To Bill setting carefully. They determine the sub-ledger’s accounting hierarchy and transaction availability.

Import ledgers from Excel

The Excel Import workflow supports both main ledgers and sub-ledgers. Prepare the sheet using the displayed column layout, including the Main/Mother Account ID for each sub-ledger, then choose the file and select Upload Excel File.

Jhapu Excel Import page showing the required main and sub-ledger spreadsheet columns and upload control
Use the Main/Mother Account ID column to link imported sub-ledgers to their parent ledger.
Import check

Ensure the Group ID, Sub-group ID and Main/Mother Account ID values are correct before uploading, so every imported sub-ledger is created under the intended main ledger.

Next guideAccounting