Inventory Opening Balance:
- Go to Setup.
- In Setup, the Company Setup section appears, open CSV templates there.
- A dropdown appears in the CSV template window. Select inventory adjustment then export CSV file.
- Upload your data in a system-generated file.
- Now go to Item & inventory → Transaction → Inventory adjustment.
- Select your location where you want your openings.
- Click on Choose file → Choose the inventory Adjustment CSV file on your device.
- After choosing the file click on Load Cart → Process adjustment.
- Your inventory opening balances have been uploaded.
HOW TO ENTER CUSTOMER OPENING BALANCES IN HISAAB ERP & ACCOUNTING SOFTWARE?
- Go to General Ledger
- Select/Add Date, Currency and other fields as per the need.
- Select Account, Counter Party and Debit Amount.
- Select Account Recievable.
- Select Opening Balances amount in the credit box & add → Process Journal Entry.
HOW TO IMPORT CUSTOMER OPENING BALANCES?
- Go to Setup.
- In Setup, the Company Setup section appears open CSV templates.
- A dropdown appears in CSV template window. Select Journal Entries-AR then export CSV file.
- Upload your data in a system-generated file as guided in the video.
- Now go to General Ledger → Journal entry → Select Date → Choose file → Import
- Add Opening Balance Equity (on credit side).
- Process Journal Entry.
HOW TO ENTER SUPPLIER OPENING BALANCES?
- Go to General Ledger->Transaction-> Journal Entry
- Select Account Receivable or Account Payable from Account Description dropdown
- Select Customer/Supplier from Counterparty dropdown
- Enter amount
- Repeat the procedure for all the customers/suppliers
- Now balance the entry by selecting the contra account – Opening Balance Equity, and enter the amount.
- Save by clicking the Process Journal Entry button.
The following video refers to the procedure to enter customer and supplier opening balances.
HOW TO IMPORT SUPPLIER OPENING BALANCE?
- Go to Setup.
- In Setup, the Company Setup section appears open CSV templates.
- A dropdown appears in CSV template window. Select Journal Entries-AP then export CSV file.
- Upload your data in a system-generated file as guided in the video.
- Now go to General Ledger → Journal entry → Select Date → Choose file → Import
- Add Opening Balance Equity (on debit side).
- Process Journal Entry.
Cash and Bank Opening Balance:
Go to Banking and General Ledger-> Transactions -> Journal Entry (J.V)
- Select opening balance date
- Select account name from Account Description
- Enter opening balance amount in Debit column (e.g 50,000)
- Enter Memo (e.g Opening balance of Bank Alfalah as at 1.7.2013)
- Click Add Item
- Now select any other cash or bank account if required and repeat steps 3-5 above
- Select Account – Opening Balance Equity
- Enter the accumulated balance in the Credit column and click Add Item
- Click Process Journal Entry to save
- Check View this Journal Entry to verify the transaction effect.