EXCEL TO TALLY – GST READY – Ledger Master, Voucher
THIS SOFTWARE HELP YOU TO EXPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY LIKE TALLY 7.2, TALLY ERP 9, TALLY ERP, OR GST READY TALLY THROUGH EXCEL SHEET. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME. NOW WITH UPDATED VERSION YOU CAN GENERATE –
1. LEDGER MASTER WITH GST DETAIL AND ADDRESS, 2. VOUCHER WITH ALL GST RATES AND WITH OR WITHOUT STOCK ITEMS 3. NOW ITS ERROR FREE, YOU CAN GENERATE ENTRIES WITH ONE CLICK
EXCEL TO TALLY 4.9.9 – ITEM MASTER, LEDGER MASTER, ADVANCE VOUCHERS- WITH ALL GST DETAIL
THIS SOFTWARE HELP YOU TO EXPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY LIKE TALLY 7.2, TALLY ERP 9, TALLY ERP, OR GST READY TALLY THROUGH EXCEL SHEET. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME.NOW WITH UPDATED VERSION YOU CAN GENERATE –
1. ITEM MASTER WITH HSN CODE AND GST RATES, 2. LEDGER MASTER WITH GST DETAIL AND ADDRESS, 3. VOUCHER WITH ALL GST RATES AND WITH OR WITHOUT STOCK ITEMS 4. NOW ITS ERROR FREE, YOU CAN GENERATE ENTRIES WITH ONE CLICK 5. ADVANCE SALES VOUCHER (INVOICE VIEW, EFFECT IN GST, ALL DISPATCH DETAILS, SEPARATE BUYER AND CONSIGNEE DETAILS.) 6. ADVANCE PURCHASE VOUCHER (INVOICE VIEW, EFFECT IN GST, ALL DISPATCH DETAILS, SEPARATE BUYER AND CONSIGNEE DETAILS.) 7. ADVANCE DEBIT NOTE AND CREDIT NOTE ENTRY AS PER GST NORMS 8. COLUMN FOR BILL WISE DETAIL(IN ACCOUNTING INVOICE SHEET) – REFERENCE NAME, CREDIT PERIOD, AMOUNT , REF TYPE 9. USE SEPARATE REFERENCE NUMBER AND REFERENCE DATE FOR SALE, PURCHASE, CREDIT NOTE AND DEBIT NOTE 10. USE VOUCHER NUMBER AS YOU WANT 11. WRITE YOUR OWN VOUCHER TYPE 12. SELECT MULTIPLE GODOWN NAME – ENTER YOUR OWN GODOWN THAT YOU CREATED. 13. EXPORT GODOWN MASTERS 14. BANK VOUCHERS ENTRY WITH AUTO BANK RECONCILIATION AND WITH BILLWISE DETAILS. 15. MAINTAIN BATCH WISE DETAIL TAKE BATCH WISE ENTRIES 16. SEPARATE BUYER AND CONSIGNEE GSTIN 17. RECEIPT NOTE AND DELIVERY NOTE VOUCHERS (IN ADVANCE ITEM PURCHASE AND ADVANCE ITEM SALES) 18. GIVE DISCOUNT IN EVERY STOCK ITEM 19. ENTER TAX CLASSIFICATION IN ACCOUNTING INVOICE 20. ENTER TRACKING NUMBER (NOTE NUMBER) IN ADVANCE SALES AND PURCHASE VOUCHERS 21. ADD REFERENCE / BILL WISE DETAILS IN ALL LEDGERS WITH ACCOUNTING INV SHEET 22. VOUCHERS FOR EXPORT IMPORT ENTRIES INCLUDING ALL TAX CLASSIFICATIONS 23. NOW TAKE SALE AND PURCHASE VOUCHERS WITH ORDER DETAILS 24. NOW IMPORT STOCK MASTER WITH ALIAS AND OPENING BALANCES INCLUDING ALL GST DETAIL 25.NOW WITH BILL WISE BREAKUP OF LEDGER OPENING BALANCES
THIS EXCEL TO TALLY MANUFACTURING EDITION SOFTWARE HELP YOU TO EXPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY LIKE TALLY 7.2, TALLY ERP 9, TALLY ERP, OR GST READY TALLY THROUGH EXCEL SHEET. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME.NOW WITH UPDATED VERSION YOU CAN GENERATE –
ITEM MASTER WITH HSN CODE AND GST RATES,
LEDGER MASTER WITH GST DETAIL AND ADDRESS,
VOUCHER WITH ALL GST RATES AND WITH OR WITHOUT STOCK ITEMS
NOW ITS ERROR FREE, YOU CAN GENERATE ENTRIES WITH ONE CLICK
ADVANCE SALES VOUCHER (INVOICE VIEW, EFFECT IN GST, ALL DESPATCH DETAILS, SEPARATE BUYER AND CONSIGNEE DETAILS.)
ADVANCE PURCHASE VOUCHER (INVOICE VIEW, EFFECT IN GST, ALL DESPATCH DETAILS, SEPARATE BUYER AND CONSIGNEE DETAILS.)
ADVANCE DEBIT NOTE AND CREDIT NOTE ENTRY AS PER GST NORMS (WITH OR WITHOUT STOCKS)
COLUMN FOR BILL WISE DETAIL(IN ACCOUNTING INVOICE SHEET) – REFERENCE NAME, CREDIT PERIOD, AMOUNT , REF TYPE
USE SEPARATE REFERENCE NUMBER AND REFERENCE DATE FOR SALE, PURCHASE, CREDIT NOTE AND DEBIT NOTE
USE VOUCHER NUMBER AS YOU WANT
WRITE YOUR OWN VOUCHER TYPE
SELECT MULTIPLE GODOWN NAME – ENTER YOUR OWN GODOWN THAT YOU CREATED.
EXPORT GODOWN MASTERS
BANK VOUCHERS ENTRY WITH AUTO BANK RECONCILIATION AND WITH BILLWISE DETAILS.
MAINTAIN BATCH WISE DETAIL TAKE BATCH WISE ENTRIES
SEPARATE BUYER AND CONSIGNEE GSTIN
RECEIPT NOTE AND DELIVERY NOTE VOUCHERS (IN ADVANCE ITEM PURCHASE AND ADVANCE ITEM SALES)
NOW POST DISCOUNT IN STOCK ITEMS
ENTER TAX CLASSIFICATION IN ACCOUNTING INVOICE
ENTER TRACKING NUMBER (NOTE NUMBER) IN ADVANCE SALES AND PURCHASE VOUCHERS
ADD REFERENCE / BILL WISE DETAILS IN ALL LEDGERS WITH ACCOUNTING INV SHEET
VOUCHERS FOR EXPORT IMPORT ENTRIES INCLUDING ALL TAX CLASSIFICATIONS
NOW TAKE SALE AND PURCHASE VOUCHERS WITH ORDER DETAILS
NOW IMPORT STOCK MASTER WITH ALIAS AND OPENING BALANCES INCLUDING ALL GST DETAIL
NOW WITH COST CENTER DETAILS IN BANK VOUCHER SHEET.
ALSO CAN IMPORT COST CENTER MASTER WITH SEPARATE SHEET
OPENING BALANCES WITH MULTI BILL WISE REFERENCE
NOW WITH SIMPLE ACCOUNTING VOUCHER SHEET- YOU CAN GENERATE ENTRIES WITH MULTI REFERENCES AND COST CENTERS
THIS EXCEL TO TALLY- LITE SOFTWARE HELP YOU TO EXPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY LIKE TALLY 7.2, TALLY ERP 9, TALLY ERP, OR GST READY TALLY THROUGH EXCEL SHEET. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED. * VIA THIS YOU CAN ENTER LOTS OF LEDGERS IN ONE VOUCHER. (AS IF YOU PAY SALARY TO 400 PEOPLE WITH ONE CHEQUE , YOU CAN ENTER THESE ALL NAMES IN ONE VOUCHER.) * YOU CAN IMPORT ALL TYPE OF VOUCHERS WITHOUT STOCK ITEM.
IT WILL BE VERY HELPFUL TO TAKE JOURNAL, PAYMENT , RECEIPT, CONTRA, DEBIT NOTE, CREDIT NOTE, SALES, PURCHASE VOUCHERS WITH MULTIPLE DR. CR. LEDGERS.
In Tally when we go to open or edit any ledger, there we can see only ledger name. And sometime feel that if we can find it’s opening and closing balances or it’s GST number and phone numbers. Ho it is possible ?
Yes, now it is possible with this Tally TDL file.
Now we use GST in India, by this tdl we can also check GST at ledger opening time.
After adding this TDL file in Tally, you can see ledger GST Number, it’s Group, Phone Number, Mobile Number, Opening Balance and Closing balance at one place.
To download the TDL file click on below download button :
To install in Tally please follow the below steps:
1. Download the TDL from above link
2. Write click on TDL file
3. Goto Property, Security and copy the file path.
4. Open Tally press F12 – goto product and features – then press F4
5. Load on Startup-Yes
6. Paste the path (Alt+CTRL+V) on blank cell
7. Press enter and save
Now it’s ready to use
(If details not shows, Please restart your Tally)
It is Tally TDL 2019. You can use it on all latest versions of Tally ERP
If you use Tally and want to see your business summary at one place, no need to go Profit & Loss account or Balance Sheet. Also in P&L and Balance Sheet you can not see more details about your business, Like Cash Flow, Top Customers List, Top Selling Products etc.
But by this easy to use and life time use TDL you see your business summary at one place with one click.
By this You can See these Reports at one Place :
Cash and Bank Balances
Cash flow
Outstanding
Capital & Fixed Assets
Loans and Advances
Profit & Loss Account
Purchase and Sales
Top 5 Customers
Top 5 Suppliers
Top 5 Receivables
Top 5 Payable
Fast Moving Items
Slow Moving Items
Non Moving Items
It is very useful and Must have TDL. You can download it with this Link : https://imojo.in/g3ajy6
HOW TO LOAD TDL FILE IN TALLY
To load TDL file in Tally follow these steps:
1. Download TDL file with provided Link.
2. Select file and right click on It
3. Go to Property – Security and copy the path.
4. Open Tally – Press F12 – Press F4
5. Paste the Path at blank Cell in Tally (For Paste in Tally use Alt+Ctrl+V) then press enter and save.
Now your TDL is ready to work.
Go to your Tally Home page , find here business summary to see your report.
(FOR EXCEL TO TALLY DATA CONVERTER GOTO EXCEL TO TALLY PAGE OF THIS WEBSITE)
TALLY TDL 2019 – DISPLAY CUSTOMER DETAILS WHEN INVOICING
Invoicing is most important parts of a business. It will be Sales, Purchase, Debit Note, Credit Note etc. and for a business need some software to handle it. For handle a business there is lots of software available. In these software Tally play important role to handle your business because it is so simple and used by lots of people. For make it more useful and simple we add some TDL ( Tally Definition Language ) files to our Tally Software.
In this segment I have something special for you. It is TDL 2019 – Customer details when invoicing.
By this TDL you can see customer details like, Address, Contact , GST, Vat etc at the time of invoicing. It will help you to prevent mistakes about customer details that you entered in voucher.
It works for Sales Voucher, Purchase Voucher, Debit Note Voucher, Credit Note Voucher, Receipt Note Voucher, Delivery Note Voucher, Sale order and Purchase Order vouchers.
How to install in your Tally software.
This TDL will work in all version of your Tally. Follow below steps to add the TDL file in Tally software :
1. Download the TDL file from provided link
2. Right click on TDL File.
3. Go to Property.
4. Then go to Security.
5. Copy the path
6. Open Tally – Open any company, that you want to work.
7. Press – F12
8. Go to Product & Fetures
9. Press F4
10. Paste the path (Alt+Ctrl+V) in empty box and press Enter key
(your TDL will be loaded and ready for work)
Now when you go to Vouchers for entry and select your customer it will show all the details of customer that you provide at time of ledger creation.
It is very nice and helpful TDL File. You can download it with below link :
NOW IMPORT YOUR STOCKS DIRECTLY FROM EXCEL IN TO TALLY WITH GST, ALIAS AND OPENING DETAILS
We know that most of us or businesses use Tally and mostly do business of sale, purchase. And if you do sale and purchase, you need the things that you want to sale. If you want to sale things and use tally software, this is the right place for you.
Before starting your sale, purchase business you need to enter stock items in accounting software, like Tally etc. If you use Tally for maintain your books, use this tool to import your stock directly from Excel to Tally.
You can import stock items with alias, group, godown, GST and opening details.
Just copy or write stock name and fill other details, click generate button.
How to import stock items from excel to tally :
It is very simple process to import excel data in to tally. Just ready your file that you want to import and follow these steps :
1. Open Excel2Tally Software.
2. Go to E.Stock sheet.
3. Put, write or paste the name of Items from your other excel sheet.
4. Fill the required details that you want to show with stock items like – Alias, GST percents, Group (that you created in your Tally), Opening Details, godown details etc.
5. After filling the sheet click on Generate button that provided in the sheet.
6. You will find XML file at location where you put this software.
7. Select XML file and right click on it.
8. Go to property and then security.
9. Select the path provided in security section (C:UsersHPDesktopallstock.xml) and copy it.
10. Open tally – go to Import Data – Master – Paste (Alt+Ctrl+V) and press enter.
You will find, your all stock items imported in Tally. You can modified it if required.
And now you are ready to write your vouchers in Tally.
You can also import Godown Master, Ledger Masters with all details, all type vouchers that provided in tally with your modifications. You can use it for lifetime. No renewal required.
It works on every version of Tally (Tally 6.3, Tally 7.2, Tally 9, Tally ERP 9, Tally ERP 9 GST)
You can also use it on Tally Crack version or Licence version.
For download it click on below download link:
For more details watch above video or goto Excel to Tally section of This website.
It will make your work very simple.
for make it more simple or any solution you can call me. at +91-9131810293 or mail me at Learnwells@outlook.com
IF YOU HAVE MULTIPLE GODOWNS OR BRANCHES IT’S FOR YOU
Now a days everyone want to grow and become a famous business man. For grow our business, we maintain multiple branches and reach to more peoples. In any business that have two or more branches along with head office, they need to transfer there stock to branches and from branch to head office. Sometime it become lengthy process to maintain transferable stocks, because of there quantity. We can simplify these things with accounting software, and most simple accounting software now a days is Tally. Power of Simplicity. By this Excel to Tally utility it will become more simple process. We know that we transfer lots of stocks and sometime it is not possible to take these entries manually. Our mostly work we do in Excel, because of it’s calculations and accuracy. And you can transfer your Excel data into Tally by this Excel2Tally software.
It is very simple to use and you can enter thousands of entries with thousands of stock items with one click. You can transfer your stock items with stock journal voucher and this utility will help to do all these things in simple way. By this also can enter manufacturing vouchers.
You can enter all stock details like godown, batches, quantity, freight etc with this utility. Just simple copy and paste your excel data in its format and generate XML for import in Tally.
By this tool also can import Stock master, Ledger Master, Godown Master, all type vouchers with stock or without stock with all details including gst and vat.
Also you can generate XML for delivery notes, receipt notes, sale order and purchase order vouchers.
You can give details of consignee, buyers, dispatch etc.
Also can enter debit notes and credit notes vouchers.
You can also maintain your Amazon, Flipkart data in Tally by this utility in very simple way.
It works on all platform of tally. Use any version of Tally, it will work perfectly.
I wish one day you become a great business man and take your business in highest peak.
You can download Excel2Tally software with below link and it will be for lifetime use:
For any query you can contact me. 24×7 I am with you. You can call me at +91-9131810293, also can mail me at learnwells@outlook.com
