Excel To Tally Sales with GST informations

Discussion in 'Free Source Codes' started by rmraja, Oct 26, 2019.

    
  1. rmraja

    rmraja Active Member


    Sales Template
    • It has 13 Duties Ledger and 5 sales accounts
    • The column header is the ledger name so you can change the ledger name upon altering the column header of duites ledger and sales ledger
    • It will import GST No , GST DEaler Type
    • Round off facility available
    • can you use against Reference of New Reference

    uniqueness -
    • Unlimited data migration
    • It will retrieve the ledger from tally and provide prediction while entering date in excel (use tally Ledger Help option)
    • It will not overwrite the existing master, it will find the ledgers in tally if not available then only create the required ledger.
    • Unlimited company migration
    • Automatic completion task and work
    • An average import 10,000 records in 10 minutes
    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

    1.Excel to tally Gst Ledgers
    2.Importing from excel to tally it cover all rates there is
    are four slabs fixed for GST Rates - 5%, 12%, 18% and 28% and it includes same level purchase ledger also
    3.Posting Round off entries
    4.File Gst reports with ease with this Excel to Tally Software
     

    Attached Files:



  2. anish

    anish Member


    Thank you so much Sir !
     


  3. Arjun.M

    Arjun.M New Member


    Dear Sir,
    Is it possible to provide the file for my customer with my contact details if so what will the price ?
     


  4. rmraja

    rmraja Active Member


    Yes , Rs.500 for the change in contact Details
     


  5. rmraja

    rmraja Active Member


    *For any doubts , please call @ 9788932173
     


  6. udaya

    udaya Active Member


    Amazing tooll sir.... i need Alternative Unit also.... Can You sir....
     


  7. suyash

    suyash New Member


    too good plz help me how to import line wise item description from excel to tally

    1230030 : INSERT COLLECTION OBJECT : INVENTORYENTRIES
    12300311 : Set Target : INVENTORYENTRIES[1]
    1230031 : SET VALUE : StockItemName : "Wages Received"
    1230034 : SET VALUE : IsDeemedPositive : No
    1230035 : Set Value : ISLASTDEEMEDPOSITIVE : No
    Rh123 : Set : RHAmt : $$AsAmount:$BillStkamt1
    1230039 : Set Value : AMOUNT : $$AsAmount:##RHAmt ;*$$AsAmount:##VarB);$Column10 ;;$$TgtObject:$$AsAmount:$Column16 ;;##VarA ;$$AsAmount:"1482.20";($$AsAmount:##varA) ;

    123desc1 : Set Value : BasicUserDescription : $BillDesc1

    1230048 : Insert Collection Object : ACCOUNTINGALLOCATIONS
    1230049 : Set Value : LEDGERNAME : "Sales Account"
    1230050 : Set Value : ISDEEMEDPOSITIVE : No
    1230051 : Set Value : AMOUNT : $$AsAmount:##RHAmt;($$AsAmount:##VarBR2*$$AsAmount:##VarB)
    G1 : Set : Roff1 : $$AsAmount:##RHAmt;($$AsAmount:##VarBR2*$$AsAmount:##VarB)
    1230052 : Set Target : ...
     


Share This Page