Through this page, you can import voucher details to a predefined excel sheet through the Journey Entry Block by selecting the Branch and Journal Type and clicking on the  to get the predefined excel sheet.

 

 

 

The predefined excel sheet will be displayed as below :

 

 

Please note the below while filling the excel sheet :

 

-       Journal date the format should be (DD-MM-YYYY)

-       After filling  the Amount in Foreign , the system will auto calculate the amount in LC and EX-Rate

-       GL Account Segment Code is the account Number defined in the chart of accounts

-       Currency : Predefined in the system

-       Branch : Predefined in the system

 

You must save the excel sheet as .csv format

 

Related Topics

Transactions