GST Transactions Import from Excel- MAP Excel Columns, All Voucher Types, Multiple Items & Ledgers

Welcome

 

Every one is requested to feel free to write back to me in case they face any difficult in importing transactions

email id is ca.devendra.rawat@gmail.com

 

update ?

 

New Screenshots updated

 

More process related images uploaded.

Thanks

 

Error Message: "RBCImportGST.tcp":errorT0027:Attribute defination started without a valid Description.
How can i load this tdl. please help.

 

I have uploaded revised TCP file.. please check for error... also send screen shot of calculator panel for viewing exact error
26/11/2018

Bug fixed : auto update of excel file is now working without deleting previous mapping

 

Excellent Utility Sir.... it works, but can you please confirm how can we add column /map another column as per requirement e.g. VAT sales & discount column.
if possible.

 

Vat Column can be Mapped under other "non gst tax" field provided

There is no provision for discount ledger in columnar way.. but please note that any number of ledgers can be added to voucher .. just keep item name column blank and entry amount in item value column only... you can do it for

1. Transportation
2. Discount
3 loading/unloading
types of ledgers

I can guide you over anydesk

email id is ca.devendra.rawat@gmail.com

 

hello.. come live on anydesk.. I will try to help

email id is ca.devendra.rawat@gmail.com

 

any example of multiple items in single voucher plz

 

dear garima sir please help me i have seperate excel file i want to upload that excel into tally please help me

 

Getting Error Can you please check this Screenshot?

 

there are two errors.
Accounting ledger is not being selected. check your excel file, delete existing mapping for accounting ledger field and remap it.
secondly in GST options, you need to check structure of your GST ledgers... are you following same tax ledgers for Sales and Purchase or different this option is to be set accordingly.. their lies the error for Appropriate GST ledger missing.

you can come online of anydesk plz mail me in advance on ca.devendra.rawat@gmail.com

thanks

 

Here is excel file and GST option are set according to the GST structure in Tally settings.
Getting error when try to upload excel file.

 

Shared via email. Please check.

Thank you
Naveen

 

Thanks a lot sir. garima@
regards.
naveen

 

pls send me udayachell@gmail.com

 

Hi Garima Ji,
I have tried your TCP , GST Trans Import but its not picking GST ledgers under sub group of Duties & Taxes.
Kindly make desired corrections.
Regards

 

pls send me : pvr.rakeshsharma@gmail.com

 

It should pick them up.
kindly share screen shot of your GST ledger (master)..

It will pick up only when you have set separate tax ledger for Sales and Purchase to "Yes" in GST Options.. if it set to "No" there is no need to pick up. it will pick up during import based on the rate you defined.

you can share your time (availability) on "AnyDesk" so that I can help you.. email ca.devendra.rawat@gmail.com suitable time for me is 6.00pm to 7 pm

 

everything is going good but it is not importing reference no every time i have to open invoice and resaved it kindly help for that
thanks in advance

 

Which reference no sir ?

Party Bill ?

 

no reference number to set out the payment reference

 

Can you send the tally company and your excel file ?