Opening Balance in ERPNext
The opening balance is the balance brought forward at the beginning of an accounting period from the end of the previous period, or when starting a new business or accounting system.
It represents the initial financial position of a company when it begins operations in ERPNext or transitions from another accounting system.
Opening balances ensure continuity of financial records when migrating to ERPNext or starting a new financial year.
1. Introduction to Opening Balance
Opening balances are required when:
- A new company starts operations
- A business migrates from legacy systems like Tally or FoxPro
- Financial data is moved into ERPNext at any point during the year
While it is recommended to start ERPNext from a new financial year, businesses can also begin mid-year by properly importing opening balances.
Required Financial Position at Start
When starting ERPNext accounting, the following balances must be available:
Assets
- Stock in hand
- Fixed assets (furniture, computers, machinery)
- Accounts Receivable (money owed by customers)
- Cash, bank balances, deposits, and other current assets
Liabilities
- Capital or owner’s equity
- Loans and other current liabilities
- Accounts Payable (money owed to suppliers)
Before importing opening balances, always close financial statements in the previous system and ensure that the Chart of Accounts is properly configured in ERPNext.
Opening entries are only created for Balance Sheet accounts and not for Profit & Loss accounts.
2. Opening Balance of Assets
2.1 Fixed Assets
Fixed assets include long-term assets such as equipment, furniture, and computers.
Step 1: Create Asset Records
To record existing assets:
- Create an Item with “Is Fixed Asset” enabled.
- Go to Assets > Assets > New.
- Enter Asset Name and Item Code.
- Specify Location and Purchase Date.
- Enter Gross Amount.
- Tick Is Existing Asset.
- Save the record.
Step 2: Create Journal Entry
Since existing assets do not automatically affect the ledger, a journal entry is required:
- Go to Accounting > Masters and Accounts > Journal Entry > New.
- Enter Posting Date.
- Debit the appropriate fixed asset accounts.
- Credit the Temporary Opening account with balancing amount.
- Set Is Opening = Yes.
2.2 Stock Assets
Stock opening balances are managed through the Opening Stock process in ERPNext. This ensures accurate inventory valuation at the start of operations.
2.3 Accounts Receivable
Accounts Receivable represents money owed by customers for previously issued invoices.
These can be imported using the Opening Invoice Creation Tool.
After import:
- Sales Invoices are created automatically
- Payment Entries can be recorded when payments are received
2.4 Current Assets
Current assets include cash, bank balances, deposits, and similar short-term assets.
To import:
- Go to Accounting > Company and Accounts > Journal Entry > New.
- Enter Posting Date.
- Debit the relevant current asset accounts.
- Credit the Temporary Opening account.
- Set Is Opening = Yes.
3. Opening Balance of Liabilities
3.1 Capital Accounts
Capital accounts represent owner’s equity.
- Go to Journal Entry.
- Credit capital accounts.
- Debit Temporary Opening account.
- Set Is Opening = Yes.
3.2 Current Liabilities
Current liabilities include loans, salary payables, and other obligations.
- Go to Journal Entry.
- Credit liability accounts.
- Debit Temporary Opening account.
- Set Is Opening = Yes.
3.3 Accounts Payable
Accounts Payable represents amounts owed to suppliers.
These can be imported using the Opening Invoice Creation Tool, after which Purchase Invoices are generated automatically.
4. Verification of Opening Balance
After completing all entries, ensure that:
- All assets and liabilities are correctly recorded
- The Temporary Opening account balance is zero
This confirms that the books are balanced and the opening setup is complete.
SUMMARY
Opening balances represent the starting financial position of a company in ERPNext. They include assets, liabilities, receivables, and payables, and are essential for accurate accounting continuity when migrating from another system or starting a new financial year.
