excel to Tally Full version for Bank Statements, Multiple Journal, Payment and sales

Discussion in 'Free Source Codes' started by rmraja, Oct 30, 2016.

         
  1. rmraja

    rmraja Member


    For Tally ERP Version ODBC PORT Setup..! _ One Time
    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




    In this Utlity
    You can import 500 Entries of
    * Import Bank statements
    * Sales With 9 stock items and 1 ledger
    * Payment With 2 cost centre
    * Payment With reference upto 10 ref (bills)
    * Journal with 4 Dr and 5 CR entries
    * Journal with 10 bills Reference
     

    Attached Files:

    Last edited: Nov 3, 2016
    Amit Dahiwade, B PRAVEENKUMAR and AFT like this.


  2. Arjun.M

    Arjun.M New Member


    Super Sir,full version for free Very useful for all, waiting for your next excel,
     


  3. rmraja

    rmraja Member


    Thanks
    Will Upload shortly
     


  4. Sundar.L

    Sundar.L New Member


    Thanks, No need to create XML and import manually,its automatically posting entries directly from excel with single click, good work go ahead with new uploads.
     


  5. Younus Khan

    Younus Khan New Member


    Dear Sir

    Great Job
    But please added one option payment entry with cost centre with cost Category and one more sheet for Receipt Note Entry for material receipt
     
    rmraja likes this.


  6. vsrm

    vsrm New Member


    Simply Super excel to connect with tally, please keep add more modules
    Thank you sir
     


  7. mpal2311

    mpal2311 Active Member


    Great
     
    rmraja likes this.


  8. AFT

    AFT New Member


    Thanks,Really Super
     
    rmraja likes this.


  9. vsrm

    vsrm New Member


    Dear Sir,
    can you provide ledger sales in sales invoice?
     
    rmraja likes this.


  10. rmraja

    rmraja Member


    Thanks for all your comments
     


  11. Arjun.M

    Arjun.M New Member


    Sir,Please upload purchase import
     


  12. SHREYASH PATIL

    SHREYASH PATIL New Member


    PLEASE SEND WITHOUT INVENTRY SALES AND PURCHASES
     


  13. rmraja

    rmraja Member


    Will upload shortly
     


  14. Younus Khan

    Younus Khan New Member


    Please Provide a Excel sheet for Receipt Note from Excel to Tally
     

    Attached Files:



  15. rmraja

    rmraja Member


    Dear sir,
    Please provide xls format from tally
     


  16. MZMS

    MZMS New Member


    Sir I am Unable to Use this Utility Please Provide Video Tutorial for it.
     
    anjan banik likes this.


  17. tvs preeti

    tvs preeti New Member


     


  18. tvs preeti

    tvs preeti New Member


    this utility how to work , what you are say config done but i am not see any link on panel
     


  19. rmraja

    rmraja Member


    just open tally
    Press F12 goto ADVANCED CONFIGURATION
    SET -> Tally Acting Option - BOTH
    * SET -> Enable ODBC Server Option - YES
    * SET -> PORT Option - 9005
    and restart tally
    Now open excel and open particular company in tally
    then click send data to tally from excel to tally
     


  20. tvs preeti

    tvs preeti New Member


    still i have problem. please send me screen shot. where send data to tally option.
     


  21. MZMS

    MZMS New Member


    Sir Please provide video toturial for it.
     


  22. rmraja

    rmraja Member


    upload_2016-11-17_11-25-19.png
     
    kapil22 likes this.


  23. MZMS

    MZMS New Member


    sir please provide video for how to use this utility
     
    vishnuggc likes this.



  24. NICE CUSTOMIZATION SIR
     
    rmraja likes this.


  25. rmraja

    rmraja Member


    Thanks
     


Share This Page