BUSINESS SUMMARY TDL | Business Dashboard TDL for Tally Prime | 2022 best Free Tally Prime TDL

21 April 2022

We must do accounting to maintain business books and see it’s progress. If you use Tally to maintain business accounting and maintain it’s books, always create a business summary to follow your profits and customers along with top lists of ledger account. So today I have something special to create a business summary of your Tally books. In Tally we can customize our reports with TDL (Tally Definition Language ) files.With this Tally TDL we can find out our business summary within a second. In this Tally Prime TDL we can see reports for a fixed period, like Profit loss, Sale purchase, cash and bank reports, outstanding of top customers and top selling products in single click. This is best Tally TDL file to have in your Tally. With this Free Tally Prime TDL, Now we can create our business summary with top selling and supplier ledgers and products, top receivables and payable, profit and cash flows etc. TDL CODE HOW TO USE: Copy above TDL code and make a text file Load in Tally Prime (Method provided below) Now you will find Business button on top of Tally between toolbar buttons Set period and click on business button to see business summary This is best free TDL to have in your Tally . This TDL can use for lifetime. This free TDL Code will perfectly work with Tally Prime. Watch above video to learn : How to use business button How to modify TDL code FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Make a Text file of above code Save it in to your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Business Summary.txt) Open Tally Prime Software Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Set Load TDL file on Startup – Yes Paste The path in blank space Press enter and save Now your Business Summary TDL is ready to use

How to Connect Tally with Excel to Get GST Summary | Tally to Excel GST Summary | Tally Prime to Excel Data Import | Tally to Excel Power query

12 April 2022

Always required Excel in a business or accounting to maintain books of income, expenses and taxes etc. Excel is most usable software for calculations/presentations for a business. And also lots of businesses use Tally to maintain books properly. If it possible to connect Tally with Excel to fetch Tally Data into Excel then our most of  problems will be solved. This Tally to Excel data import method will be “Sanjeevani” for CA and accountants. So this can possible through Excel Power Query and Tally ODBC connectivity. To Import Tally Data into Excel most powerful and fastest way is Excel Power BI. We can import any report of Tally directly into excel through this Power BI method. After reading this post you will be able to import GST summary from Tally to Excel and can refresh it every time after any changes. Required Tools/Codes to connect Tally with Excel: Microsoft Excel Tally Software Tally ODBC URL XML Schema for Export Report Name Follow below Steps to Import Data from Tally to Excel: Open Tally and Excel Go to Excel Data Tab – New Query – From Other Source – Blank Query We can change Query Name in properties section at right hand side. Go in Home Tab and in Advance Editor Paste Below Code in Advance Editor: After pasting above code in advance editor press Done Now you can see Tally reports in Excel Power query home Go to Home Tab – Click on “Close and Load” or “Close and Load to…”  If select Close and Load to… then you can choose Excel reference sheet and cell to show Data. Now you will find all your Tally data to related reports in Excel. Refresh Excel sheet to recollect data from Tally Change Date in Power query Advance editor code as per your requirement. Watch above video for more details.How to See and enable Tally ODBC Port : Click Here

Tally Prime Auto Backup | Automatic Data Backup TDL for Tally Prime | 2022 Best Tally Prime Auto Backup TDL | Free Tally Backup TDL

12 April 2022

We always work hard and want to try finish our work on time. In life we can not restore our past life backup. But in Tally software it allow to restore data backup and works smoothly without any error.It is very important in working to take software backups to solve our mistakes by restoring data backup.If you use Tally Prime or Tally ERP9, this Auto backup TDL will help to create backups of data at company open and company close time. And always this will help to remember to create backup file of your working company.This is must have Tally TDL for Tally Prime and Tally ERP9.With this Free Tally Prime TDL, Now we can create Tally Data backups without any fail. This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. This free TDL Code will perfectly work with Tally Prime. HOW TO USE: Copy TDL code and Make a text file and save it in your computer. Load in Tally ERP9 or in Tally Prime (Method provided below) When open or close any company it will ask to take backup of Tally Data Press enter or Click on Yes to create a back of files with Date and Time You can change Tally Backup path in code Tally Backup TDL Code: HOW TO USE TDL CODE: Copy above TDL code and make a text file Save text file in your computer Copy text file path including its name and extension (as – C:\Users\HP\Desktop\rec\Party Detail.txt) Open Tally Prime or Tally ERP9  Press F12 and goto Product and Features (for Tally ERP9) Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Load TDL file on Startup – Yes Paste The path in blank space Press enter and save Now your TDL is ready to use.  Watch above video to learn : How to create backup of Tally Data. How to see backup list with date and time.

Bank Details with QR Code in Invoice | 2022 Best Free Tally Prime TDL

26 March 2022

We always follow best techniques to do our work smartly and finish on time. In this QR images play important roles in our daily life work. If we want to pay instantly and without any error, we use QR code because QR payment methods are easily available and can do transactions with any UPI payment apps. And same if we use Tally to generate invoices, there are bank details option in Invoice printing. With this bank details our customers can pay by adding our account details on there books/Bank. But this is lengthy process on today’s era. But if you want to collect payments instantly then can use QR images in Invoice. So today I will provide a best TDL code to add Bank details with QR Code in our Tally invoices. We can add QR image along with Bank Details. With this anyone can pay our bills by scanning of QR images. In this TDL code we use Tally Prime QR code facility.In this Tally Prime TDL code we can add some additional fields or we can remove extra fields according to our need, and this will work perfectly with Tally Prime. Best simple tdl code add QR code in Invoices. HOW TO USE: Copy below TDL code and make a text file Save text file then load in Tally Prime (Method provided below the code) Now go for invoicing and enable bank details for invoice. Now we can see Bank details with QR Code Image in our Invoice print. This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. This free TDL Code will perfectly work with Tally Prime. Watch above video to learn : How to add extra fields in Invoice Print How to add Use Tally QR code facility. TDL Code :  FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Copy the code and paste in a Text file. Save the text file into your computer. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Party Detail.txt) Open Tally Prime Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Load TDL file on Startup – Yes Paste The path in blank space Press enter and save  Now your TDL is ready to use.

To Do Reminder List in Tally Prime | 2022 Best Free Tally Prime TDL

23 March 2022

Sometime in our life we forget important things and can not finish our work on time.Same things we do at business. We forget to file returns on time, We forget to collect outstanding, We forget to join important meetings, We forget to sign cheques on time, and many more things we can not do on time. To avoid this we maintain manually notes, that is not proper solution. In mostly business to maintain our books we use Tally. And in Tally we can create reminder list or Todo list to solve this problem.So today I have very special free To-Do List Tally Prime TDL for your Tally.With this To-Do Tally TDL we can maintain our to do list in Tally and can excess every time from any screen from Tally. In this we can maintain important notes about our work. We can maintain reconciliation notes about our customers.These things make it must have Tally TDL for Tally Prime.With this Free Tally Prime TDL, Now we can add To-Do List in toolbar button that will help to remember our work and help in finish works on time. HOW TO USE: Copy TDL code Make a text file and save in your computer Load in Tally ERP9 or in Tally Prime (Method provided below) Now go to To Do button provided in toolbar section beside Goto button. Open it and add important work lists with there dates. This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. This free TDL Code will perfectly work with Tally Prime. Watch above video to learn : How to add toolbar button. How to create reminder list. FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Copy above TDL Code in Text Document Save Text file in your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Party Detail.txt) Open Tally ERP9  OR Tally Prime Press F12 and goto Product and Features (for Tally ERP9) Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box)  Load TDL file on Startup – Yes Paste The path in blank space Press enter and save  Now your TDL is ready to use. 

4. How to Start Tally Prime in Developer Mode | Tally TDL Tutorial

21 March 2022

If you want to create a Tally TDL file or want to learn Tally TDL Coding then you must have to know how to start Tally Prime or Tally ERP9 in Developer Mode. Onscreen Tooltip feature has been provided for the developers from Tally Prime and Tally.ERP9 , who can identify the Field/ Report Names by placing the mouse pointer wherever required. So it is most important to work on Tally in Developer mode to know field and report names of Tally , that you can modified it by your TDL Code. This behavior will work only in Developer Mode which means that the Tally Application must have started with a Command Line Parameter /DevMode. Process to start Tally Prime or Tally ERP9 in Developer Mode: Right Click Tally Prime or Tally.ERP9 application icon. Go to Properties  In Shortcut Tab you will find Target path of Tally Copy Target Path Start Run Command (Windows Key + R or can search Run) Paste Copied path in Run Command Add /devmode (“C:\Program Files\TallyPrime\tally.exe”/devmode) Press Enter (Tally will start in Developer mode) Follow below images: Tally Property and Target Path Devmode Path in Run Command Tally in Developer Mode

Receipt Modes in Sales Voucher | POS invoice module in Sales Voucher |2022 Best Free Tally Prime TDL

21 March 2022

If we use Tally, can do lot’s of things for accounting and reporting. And in Tally have POS (Point of Sale) invoicing features also, that is an amazing feature. In POS invoicing we can describe Payment or Receipt Modes and there amount that help us to maintain outstanding of customers or cash billing. But this unique feature not find in normal Sales vouchers. So in this Tally Prime TDL we will add Receipt modes in normal sales vouchers like POS Invoice. With this Tally TDL we can add Receipt modes in Sales Voucher and also can create Receipt mode types.With this Free Tally Prime TDL, Now we can add receipt modes in Sales voucher that will help to remember payments by customer and help in collect outstanding. This works like POS Sales Invoice. HOW TO USE TDL FILE IN TALLY:  Copy Below TDL Code and make a Text file Load in Tally ERP9 or in Tally Prime (Method provided below) Now go for Sales Invoice – Click on Receipt Modes provided in Side toolbar button Create Receipt Modes type – like google paye, cash , etc. Now Create Invoice and select receipt modes in Invoice and Fill there amounts. This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. This free TDL Code will perfectly work with Tally Prime. Watch above video to learn : How to add Receipt Modes Master How to add Receipt Modes in Sales Vouchers FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Copy TDL code and make text file Save text file in your computer Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Party Detail.txt) Open Tally ERP9  OR Tally Prime Press F12 and goto Product and Features (for Tally ERP9) Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box)  Load TDL file on Startup – Yes Paste The path in blank space  Press enter and save  Now your TDL is ready to use.

Automatic Narration, Party Ledger, Taxable Ledger in Voucher | 2022 Best Tally Prime and Tally ERP9 TDL

20 March 2022

When we use Tally for Our Business Accounting. We realize it is very simple and very fast to use. We all know how important is finish our work on time. So today I have something special for your Tally Prime and Tally ERP9. With this we can save our lots of time while invoicing or vouching. If you want to save time and labour, then this TDL is for your Tally. Yes! with this TDL file we can add predecided Party Ledger name, Taxable Ledger name and also Narration with invoice number.In this Tally Prime and Tally ERP TDL code we can add some additional fields or we can remove extra fields according to our need, and this will work perfectly with Tally Erp9 and Tally Prime. Best simple tdl code to simplify and fasten our vouchers. HOW TO USE: Copy below TDL code and make a text file. Save text file then load in Tally ERP9 or in Tally Prime (Method provided below the code) Now go to voucher screen to create vouchers with auto narration and Ledgers. This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. This free TDL Code will perfectly work with Tally Prime. Watch above video to learn : How to add a Invoice number in Narration .  How to create vouchers with pre added ledgers. TDL Code :  HOW TO USE ABOVE CODE: Copy the code and paste in a Text file. Save the text file into your computer. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Party Detail.txt) Open Tally ERP9  OR Tally Prime Press F12 and goto Product and Features (for Tally ERP9) Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Load TDL file on Startup – Yes Paste The path in blank space  Press enter and save  Now your TDL is ready to use.

Free Tally Prime and Tally ERP9 TDL – Voucher Type Changer and Voucher Numbering Automatic to Manual | 2022 Best TDL for Tally Prime

19 March 2022

Sometime when we use Tally and need corrections for previous entries. When we wrongly entered voucher type and want to change it. But changing any voucher one by one, takes more time and going through lengthy process. And same if we want to change voucher numbering automatic to manual then our automatic voucher numbering gone blank. If you required change voucher type along with voucher numbering automatic to manual, then you are in right place. Now we can change voucher type and voucher number system in bulk with this free tally TDL. With this free Tally Prime TDL and Tally ERP9 TDL we can change voucher types and voucher numbering in bulk in few seconds. How to Use: Copy the below Tally TDL Code and make a Text file Load in Tally ERP9 or in Tally Prime (Method provided below) Now go to Daybook, You will find Two extra buttons in right side toolbar (Change Voucher Type and Change Voucher Numbering) Use Voucher type changer button to change voucher type and Voucher numbering button to change voucher numbering Automatic to Manual. This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. This free TDL Code will perfectly work with Tally Prime. TDL Code: Watch above video to learn : How to load TDL file in Tally. How to add toolbar buttons How to use Voucher Changer TDL code in Tally Prime HOW TO USE TDL CODE: Copy TDL code and Make a Text file Save into your computer. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Party Detail.txt) Open Tally ERP9  OR Tally Prime Press F12 and goto Product and Features (for Tally ERP9) Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Load TDL file on Startup – Yes Paste The path in blank space Press enter and save 

Ledger and Outstanding Notes TDL for Tally Prime and Tally ERP9 | 2022 Best free Tally Prime TDL

16 March 2022

We all want to do business properly and collect outstanding timely to run business smoothly. So today I have something special for your Tally. When we reconcile any ledger accounts of debtors or creditors, we create some notes that can remember it for next time and save time in re-reconciliation. This is important to create notes for ledger account and can use to see in outstanding reports. If you use Tally software for your business accounting, you are in right place. With this free Tally Prime TDL and Tally ERP9 TDL we can add ledger notes that also can see in ledger outstanding report. HOW TO USE: Download TDL code with provided link Load in Tally ERP9 or in Tally Prime (Method provided below) Now go to Ledger Account to add notes (See the video for more detail) Also can see added notes in Outstanding Reports/Group Summary of Debtors or Creditors. This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. This free TDL Code will perfectly work with Tally Prime. Watch above video to learn : How to load TDL file in Tally. How to add Notes in Ledger Account TDL Code: HOW TO USE TDL CODE: FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY: Copy above TDL code and make a text file. Save into your computer. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Party Detail.txt) Open Tally ERP9  OR Tally Prime Press F12 and goto Product and Features (for Tally ERP9) Click on Help and click on TDL & Addon  (for Tally Prime) Press F4 (to open a Box) Load TDL file on Startup – Yes Paste The path in blank space Press enter and save