How to Import Manual Journal?

• It is an option to upload bulk Manual Journal into HB Indian Account without entering the same manually.
• This simplifies the process of recording multiple Manual Journal in HB Indian Account with minimum effort simply by uploading excel worksheet containing Manual Journal Data.

• User need to import an excel worksheet (containing Manual Journal data with all the mandatory fields) into HB Indian Account.

• Navigate to Journals → Manual Journal → Import and load the excel sheet that you have created

Mandatory fields required to be filled in excel worksheet or select the drop down list in the Software at Import Page. The mandatory fields are:-

• Journal Number
• Date
• Narration
• Account
• Debit Amount
• Credit Amount

• If user does not enter mandatory fields in excel worksheet and tries to upload, the system will not accept the file.
• It will show the error list on import view page with line number.
• The User needs to reload excel worksheet again after filling those missing mandatory fields.

The other relevant information is:-

• Journal Number should be unique.
• Date format should be DD/MM/YYYY
• By default, Manual Journal should be saved as Post.