Wednesday 13 May 2020

Bank Statement import

For Tally ERP Version ODBC PORT Setup..! 


 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               click here for Download                                        

1 comment: