Sunday 4 April 2021

Bank Statement import

For Tally ERP Version ODBC PORT Setup..! 

Click here to download from Gdrive

 Follow the step by step instrcutions: 
 * Open Tally 
 * Press F12 Key for CONFIGURE 
 * Go to -> ADVANCED CONFIGURATION Option 

 * SET -> Tally Acting Option  - BOTH 
 * SET -> Enable ODBC Server Option  - YES 
 * SET -> PORT Option  - 9005 
 * Restart Tally & Make Sure Tally ODBC is ON at the Bottom of Tally. 
 * Click on the Main Tab"Tally "in Excel and Send Data to Tally 
 * Please See calculator panel in tally for Ledger Creation and other information 
 *If there is need to retrive the ledger from Tally press control+shift+z for predefine and 
    predict the ledger
 *For any doubts , please call  @ 9788932173                                                                            Important Points  before pasting bank statement in this work book-Check the amount Fields are number and date field should be date as excel should recognize as date  ,Remove "," between amounts and blank space before importing

No comments:

Post a Comment