Prevent Master duplication TDL | 2022 Best Tally Prime and Tally ERP9 TDL to Prevent Duplicate Ledger and Item

21 August 2022

Stop Master duplication in Tally TDL can boost your business performance. Tally is a most usable business software in India because of it’s simplicity and reporting system. If you maintain your masters and vouchers correctly in Tally then it will become life saving tool for business. But sometime by mistake we create some duplicate masters with another name and by repeating this mistake we make our Tally Data a garbage and can not create a proper reports. So we need to avoid this type mistakes if we want to do proper accounting.  To avoid this type mistakes I have something special for our Tally. We can create a TDL to avoid master duplication so we can do all things in proper way.  So today in this post we will create a TDL for our Tally prime and also for Tally ERP9 to prevent duplicate masters. In this TDL we will add a Master list in Tally Master creation screen so when we go to create masters first we track the name of Ledger or Item that we want to create then after searching we can create unique masters. This is must have Tally TDL for Tally Prime and Tally ERP9 to prevent master duplication.With this Free Tally Prime TDL, we can add ledgers and item lists in our master creation screen that can be tracked by typing present names in Tally master.In this code we do two steps – one for Ledger master and another for Item masters. TDL Code HOW TO USE TDL CODE: Copy above TDL code and make a text file. Save text file then load in Tally Prime (Method provided below the code) Now go to create Ledger or Stock Item Master There you will find ledger list or item list and can search the name before creating new master. 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 master table in Master creation screen. How to alter Tally Master creation screen fields and parts 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\Stop Duplicate.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 prevent duplicate TDL is ready to use

Data Analysis Tally Prime | Best Reports of Tally Prime | Generate Important reports without TDL

19 August 2022

Friends we all use Tally because of it’s simplicity and powerful reporting system. With Tally we can do our accounting easily. Tally have lots of reporting system that we use on daily basis. But some reports we generate via TDL Files, and we don’t know that Tally already have this type reports. So Today I have something special for your reporting systems and MIS .Today I have Data Analysis system of Tally that can fulfill your lots of MIS requirements. Data Analysis facilitates is conducting internal analysis and verification of the company’s financial data. Data Analysis will help in identifying exceptional areas and thereby ease the process of verification. With the help of Data analysis we can create our important MIS reports also. Data Analysis facilities have both Tally Prime and Tally ERP9. But in Tally Prime have more features with easy to use modules. So in this post you will read about Tally Prime Data Analysis. How to view Data Analysis Report in Tally Prime: There is two methods to find data analysis reports: Gateway of Tally > Display More Reports > Analysis & Verification > Data Analysis. 2. Alternatively, press Alt+G (Go To) > type or select Data Analysis Reports > and press Enter Various tools are available in Data analysis section of Tally Prime that can be use for various purpose. Follow below sections/tab of Tally to know more: Verification of Chart of Accounts Verification of Stock Items Verification of Balances Analytical Procedures Pending Documents Periodic Payments and Receipts Repeated Transactions Relative Size factor (RSF) Inter Bank Transactions Cash Withdrawals/ Deposits to Bank Fixed Assets Analysis Transaction on holiday Highest and Lowest Value Transactions Pending Advances Stale Cheque /Instruments (Please watch the above video to see another use of Data Analysis Facility of Tally Pirme and how to use other options and buttons of Data Analysis Facility of Tally Pirme.) Verification of Chart of Accounts – Drill down into this report will help to scrutinize the Chart of Accounts and compare this with previous year Chart of Accounts and suggest the necessary corrections if required. Verification of Stock Items – Drill down into this report will help to scrutinize various Stock Items and compare the Stock Items list with the previous year. This will help in taking necessary decisions and provide necessary corrections. Verification of Balances – Drill down into this report will help to scrutinize the difference in Opening Balances and transaction details during the selected year and suggest necessary corrections based on the exceptions highlighted. The user can also generate the ledger wise variance report for the Closing Balances. Analytical Procedures – This report can be used to analyse the data based on various parameters (e.g. Group, Cost Centre etc.) by a detailed comparison mechanism available. The user can take of note areas where more attention is required. Pending Documents – This report will display all the Pending Bills, Sales Orders, Purchase Orders and Receivables & Payables during the analysis year. Periodic Payments and Receipts – This report provides the list of recurring Ledger Vouchers based on the Periodic Ledgers identified by the users. Repeated Transactions – Drill down into this report will display the transactions for which the same amount is repeated more than once for each Ledger during the analysis year. The user can use this report to check the intentional errors while passing the entries. Relative Size factor (RSF) – Drill down into this report will display the Relative Size Factor for each Ledger Voucher which is arrived by dividing the highest Voucher amount to the second-highest Voucher amount for the Ledger Vouchers. Inter Bank Transactions – This report will display all the transactions carried out between the Banks during the analysis period Cash Withdrawals/ Deposits to Bank – Drill down to this report will display the bank ledgers from which the cash is withdrawn or deposits are made. This report also displays the Total Amount of transaction and the Number of vouchers through which the withdrawal or deposits are made during the selected year. Fixed Assets Analysis – This report provides the details of all the Fixed Assets possessed by the selected Company at the end of the analysis Year. Transaction on holiday – Drill down to this report displays all the transactions recorded on Weekly Off or Declared Holidays in the analysis year. Highest and Lowest Value Transactions – This report provides ledger wise Highest and Lowest value transactions carried out during the selected period along with Difference Range and Difference Range Percentage details. Pending Advances – Drill down to this report will display the ledgers for which the advances made (Loan given) are pending during the analysis year. Stale Cheque /Instruments – Drill down to this report will display the Bank Ledgers with stale cheque/ Instruments. This report also displays the Total amount and count of stale cheques/ Instruments. Also can use another buttons like, Basic of Value, Change View, Exception Reports etc. from side bar buttons of Tally to generate more type detailed reports.

Item HSN, GST, Voucher Date, MRP, Sorted Closing, Standard Cost in Invoice Item List

17 August 2022

To do appropriate invoicing with stock items then you really want to have a deep understanding of items subtleties like Item HSN, GST, Voucher Date, MRP, Sorted Closing, Standard Cost and so on when make receipt.Count have best arrangement about this kind invoicing with it’s TDL documents.So today we will make a TDL for Tally Prime and Tally ERP9 to see item all subtleties, even likewise can see when you deal it last time with Voucher Date.This is should have Tally TDL for Tally Prime and Tally ERP9 for invoicing.With this Free Tally Prime TDL, we can add thing extra subtleties. TDL Code HOW TO USE TDL CODE: Copy above TDL code and make a text file. Save text file then load in Tally Prime (Method provided below the code) Now go to generate invoice and select item. Now we can see item additional details. 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 item details in invoice. How to alter Tally TDL collection. 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\invoiceitem.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 Tooltip TDL is ready to use

Send Whatsapp from Excel | Excel to Whatsapp Sender | Send Unlimited Whatsapp from Excel | Whatsapp Message Sender | Send bulk Message from Excel to Whatsapp

8 August 2022

Now we can send bulk messages in Whatsapp from Excel. Before using the code, you must see above video.Friends nowadays whatsapp become popular everywhere, and also for business. We send lots of business related messages to our customers or office employees, like outstanding details, invoice details, address etc.Sometime we need to send bulk whataspp messages to multiple contact. To avoid this lengthy process we need to make a tool that can send bulk whatsapp. So lets create whatsapp sender in Excel VBA. Follow bellow steps to create whatsapp sender: First of all open a Microsoft Excel File Goto Developer Tab (If not enable developer tab in your Excel, watch above video) Add a module to write codes. Excel to Whatsapp Code: Paste above code in a VBA module Create Some contacts and messages in Excel  We can create Macro Button to send whatsapp messages. (Watch the above video) Now our whatsapp sender is ready to use.

Simple Way to Connect Goolge Sheet with Excel | Google Sheet to Microsoft Excel Live Data Connection | Excel Power BI to Connect Google Sheet

8 July 2022

Friends when have multiple branches or have offices on different locations, or want to work multiple people on same project or sheet. Then we simply use google sheet. In single google sheet many people can work from different computers. But sometime we need to handle it with Microsoft Excel and want to create reports according to our need. Same we can set and import Google sheet data into excel. And also can excess it live. So let’s see how can import google sheet data into Excel and use live.: Goto Google Sheet Open Document That want to import in Excel Click on Share Choose anyone with the link and copy link: Now Open Excel – Goto Data – New query – From Other Source – From Web Paste URL that you copied from Google Sheet: Now do some changes in URL: Example     Copied URL from Google Sheet: https://docs.google.com/spreadsheets/d/1HcvrFNi8hV0G_Rytj7fkjrYDUIIZsALvImSd7AcEg/edit?usp=sharing  New URL after Changes: https://docs.google.com/spreadsheets/d/1HcvrFNi8hV0G_Rytj7fkjrYDUIIZsALvImSd7AcEg/export?format=xlsx (Changes : edit to export ,  usp to format, sharing to xlsx)  Click on Sheet and Click on Load Wait for some time . Now our google sheet will be loaded in Excel We can refresh to fetch new changes. Watch Above video for more details

Automatic Last Rate and Last Discount Ledger Wise and Item Wise | 2022 Best Tally Prime TDL

4 July 2022

Sometime when we do accounting and create invoices of customer, there is lots of things to do in an invoice. We need to check customer all details like, there products, GST, Discount, Selling price, purchase price etc. When customer come to you and told that last time you provided this discount and product price was different, then you go to check there previous details and tell customer the truth that the price and discount was this. If we use Tally then these things become smooth, because of Tally TDL (Tally Definition Language). With TDL file we can fetch customer last purchase rate and item discounts. And at the same invoicing time we can check party last purchase rate and there discounts. So today have something special for your Tally. With this Tally TDL we can track customer or Ledger wise last rate and item discounts and can set it automatically in invoice. After adding this Automatic Last Rate and Last Discount Ledger Wise and Item Wise TDL we can solve all our problems related to customer.If you use Tally Prime or Tally ERP9, this Automatic Last Rate and Last Discount Ledger Wise and Item Wise TDL will help to create invoice correctly . And always this will help to remember customer discounts and there item prices.  This is must have Tally TDL for Tally Prime and Tally ERP9.With this Free Tally Prime TDL, Now we can create invoice correctly without any fail. TDL code: How to use above 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 Auto Last sale rate with Auto last discount TDL is ready to use HOW TO SEE RESULT IN TALLY: Go to Sales Voucher for invoicing. Now we can see previous sale amount and discount % automatic fetches as per ledger. 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 own fields and lines in Tally How to alter Tally field section. How to Modify Item details in invoice. And Many More…….

Item Wise Discount Amount Instead of Percentage | 2022 Best Free Tally Prime TDL

30 June 2022

Everything possible in Tally through TDL. If you want any invoicing or reports as per your requirement, then can create through TDL (Tally Definition Language). At the same sometime we need to add discount amount for Items instead of percentage. With this we can add discount amount for all items at invoicing time.In this Tally 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 to add item discount as amount in invoice. TDL Code: How to use above 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 Discount Amount TDL is ready to use HOW TO SEE RESULT IN TALLY: Go to Sales Voucher for invoicing. Now we can put amount in the place of discount %. 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 own fields and lines in Tally How to alter Tally field section. How to Modify Item details in invoice. And Many More…….

Track Details with Additional Fields | TDL to add own fields in Voucher and Group Summary | 2022 best free Tally Prime and Tally ERP9 TDL

10 May 2022

In Tally at vouching time we need to see party additional details like, Party Contact details and GST number and also we need to see Item last sale and purchase price when select item in voucher. After this also we need to ledger notes and party contact details in group outstanding summary to track outstanding properly.So with this free Tally TDL code we can add additional fields in our Tally software.Now see contact details, ledger notes, item last sale price, Item Last purchase price etc. in fixed fields. Track Details with Additional Fields.In this Tally 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 see party additional details, item last sale and last purchase price in voucher and group outstanding with party contact details and ledger notes in Tally. TDL CODE: How to use above 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 Outstanding Notes TDL is ready to use HOW TO SEE RESULT IN TALLY: Go to outstanding reports, or Invoice vouchers . Now we can see contact details of ledgers, items and notes etc 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 own fields and lines in Tally How to alter Tally field section. And Many More…….

Tally Tool Tip | Sticky Notes for Tally | Notification TDL for Tally | 2022 Best Free Tally Prime and Tally ERP9 TDL

3 May 2022

When we use any software or tool related to our business, every time we need help or reminder messages to work properly. In this tool tip and sticky notes play important role. With Tooltip and sticky notes we can find out our problems and solve it easily. In Tally there is no tool tip or sticky notes, so sometime we forgot important things. But with Tally TDL (Tally Definition Language) we can modify our Tally software and can add tool tip for vouchers, group summary and ledgers etc.In Tally TDL tool tip option play important role, by this we can add tool tip like sticky notes. With this we can see ledgers note, ledgers contact details and also can see last sale or purchase rates for billing items. Like this we can create other reports also by adding tool tip in Tally fields section.In this TDL code we use Tally tooltip facility. In this Tally 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 see tool tip and sticky notes in Tally. HOW TO USE TDL CODE: Copy below TDL code and make a text file. Save text file then load in Tally Prime (Method provided below the code) Now go to outstanding reports, or vouchers and move cursor on ledgers. Now we can see tool tips for that ledger. TDL CODE: 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 tool tip option in Tally How to alter Tally field section. 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 Tooltip TDL is ready to use

How to get Excel Cell value in Excel Power Query | How to fetch Date from Excel sheet to Excel Power BI | How to Collect Tally Data in to Excel | Tally to Excel Import

1 May 2022

Excel power query is an amazing tool in excel. With Excel Power Query / Excel Power BI we can collect Tally Data in to Excel through ODBC connection. And can import Tally Live Data in to Excel. Please go through this post see how to write codes in power query to import Live Tally Data in to Excel.If you see previous post, you observe that there we can change dates in our code only. So we need to change date etc. from our excel sheet without going in power query code. This will be simple method to collect data from Tally.  How to Connect Excel Cell Value (Date) with Power Query: Write Headings for Cell Value (Like : From Date and To Date) Fill Date below the Headings Select Dates with Header. Right Click on selected cells Choose Get data from Table/Range Click on My Table has headers and Click OK Now you will reach in power query code. In power query Dates will come with time. Remove time by changing datetime into Date in power query code After changing in Date, Right Click on From Date header – Change Type – Using Locale Keep Data Type Text and Locale – English and Press OK  Repeat same process fro To Date (Right click on ToDate – Change Type – Using Locale – Text and English – OK) Right Click on Date and choose Add as new query Repeat same process for second date Now Change From Date and To Date name in properties (name without any space) Now You can use FromDate and ToDate in another power query code of this sheet. Like: body = Text.Replace(Text.Replace(_body, “DATE1”, FromDate), “DATE2”, ToDate), For More clarification Please watch this video: