Tally Prime Auto Backup

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

Tally Prime Auto Backup TDL will help to get autobackup date and time wise. 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.

Tally Prime Auto Backup:

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.
 
HOW TO USE:
 
        1. Dowload TDL code with provided link
        2. Load in Tally ERP9 or in Tally Prime (Method provided below) 
        3. When open or close any company it will ask to take backup of Tally Data
        4. Press enter or Click on Yes to create a back of files with Date and Time
 

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 :
1. How to create backup of Tally Data.
2. How to see backup list with date and time.
3. And Many More…….
HOW TO USE TDL CODE:
 
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Download TDL file with below Download button.
2. Save into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9  OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 
 


Now your TDL is ready to use.
Download TDL file with below download button
 
Connect Tally with Excel to Get GST Summary

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

If you want to Connect Tally with Excel to Get GST Summary then follow this simple process. 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.

Connect Tally with Excel to Get GST Summary:

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:
1. Microsoft Excel
2. Tally Software
3. Tally ODBC URL
4. XML Schema for Export
5. Report Name
 
Follow below Steps to Import Data from Tally to Excel:
1. Open Tally and Excel
2. Go to Excel Data Tab – New Query – From Other Source – Blank Query
3. We can change Query Name in properties section at right hand side.
4. Go in Home Tab and in Advance Editor

5. Paste Below Code in Advance Editor:

let
    url = “http://localhost:9000”,
    _body = “<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export Data</TALLYREQUEST>
</HEADER>
<BODY>
<EXPORTDATA>
<REQUESTDESC>
<STATICVARIABLES>
<SVEXPORTFORMAT>ASCII (Comma Delimited)</SVEXPORTFORMAT>
<SVFROMDATE>DATE1</SVFROMDATE>
<SVTODATE>DATE2</SVTODATE>
</STATICVARIABLES>
<REPORTNAME>GSTR2TrglActionWise DrillDown</REPORTNAME>
</REQUESTDESC>
</EXPORTDATA>
</BODY>
</ENVELOPE>”,
    FromDate = Date.ToText(#date(2022, 04, 01)),
    ToDate = Date.ToText(#date(2022, 04, 02)),
    body = Text.Replace(Text.Replace(_body, “DATE1”, FromDate), “DATE2”, ToDate),
    Source = Csv.Document(Text.Replace(Text.FromBinary(Web.Contents(url, [Content=Text.ToBinary(body, TextEncoding.Utf16), Headers=[#”Content-Type”=”text/xml;charset=utf-16″]]), TextEncoding.Utf16), “,#(cr,lf)”, “#(cr,lf)”), { “Particulars”, “GSTIN”, “Invoice Number”,”Date”, “Document Type”, “Invoice Value”,”Place of Supply”, “Note Number”, “Note Date”,”Status”,”Taxable Value”,”IGST Amt”,”IGST Eligible Amt”,”CGST Amt”,”CGST Eligible Amt”,”SGST Amt”,”SGST Eligible Amt”,”Cess Amt”,”Cess Eligible Amt”})
in
    Source
Tally ODBC Port

How to See and Set Tally ODBC Port | Tally Prime ODBC Connectivity | Tally ERP9 ODBC Connectivity | How to enable ODBC in Tally Prime and in Tally ERP9

With Tally ODBC Port (Open Database Connectivity(ODBC) we can dynamically exchange data between Tally Prime/Tally.ERP 9 and any other application dynamically.

When we enable Tally ODBC a DSN file will be created in our computer document folder.

 

Tally ODBC Port:

How to Enable ODBC in Tally Prime:

1. Open Tally Prime

2. Go to Tally Prime Help – Setting – Connectivity 

3. Press Enter on List of Configuration

4. Set Tally Prime act as – Both

5. Enable ODBC – Yes

6. Set ODBC Port Number 9000 or any other number as per your requirement.

7. Press Enter to Save changes

8. Tally will ask to Restart to affect changes 

9. Press Yes to restart Tally Prime

10. ODBC will be enabled.

11. Check About section in TallyPrime Help to see ODBC connectivity or move cursor on TallyPrime logo in status bar.


 

How to Enable ODBC in Tally ERP9:

1. Open Tally ERP9

2. Press F12 from Gateway of Tally (Tally Main Screen)

3. Goto Advance Configuration

3. Change Tally ERP9 acting as – Both

4. Enable ODBC server – Yes

5. Set ODBC port Number 9000 or any other number as per requirement

6. After change press CTRL+A to save changes

7. Tally will ask to restart for changes have effect – Press Yes

8. Now Tally will be restart with ODBC Port Number

Our other website Engage to Tech

 

Audit Trial Rule

Audit Trial Rule 1st April 2022 extended to 1st April 2023 | How to use Tally Edit Log feature | Who Should Follow the Rule

In Audit Trial Rule The Ministry of Corporate Affairs (MCA) issued a notification directing companies that use accounting software for maintaining their books of account is required to have an Audit Trail feature, creating an edit log of all transactional changes along with the date.

According to the recent notification, the new audit trail rule in accounting software will now be implemented from 1st April,2023. This was originally planned for 2021 and but later the effective date was moved to 1st April,2022. Now, it is postponed to 1st April, 2023.

To ensure that this is being implemented, companies need to ensure that their existing accounting software comprises an audit trail feature to remain compliant to the latest amendment. With this move, business entities would now be required to keep an edit log of all transactions and time stamps, with changes made in the books of account. They also need to enable their workforce to adhere to it. In case their existing software doesn’t come with this feature, they need to consider shifting to accounting software that provides the audit trail feature.

With the audit trail (edit log) mandated by MCA, you might have questions if the rule is applicable to all businesses? Applicable only for a set or type of companies? Are there any guidelines that define the business applicability of the edit log rule?

Audit Trial Rule:

To answer, the audit trail (edit log) rule is not applicable for all businesses. This rule applies only to those companies that fall under the purview of Ministry of Corporate Affairs (MCA). In short, if your company is governed by the regulations and guidelines of MCA, you need to ensure you follow the rule from 1st April,2023. 

Checkout Business Summary TDL

Type of companies who should follow the rule

As per the Companies Act 2013, the new amendment released by the MCA will be applicable to the following companies, including the companies that are managed by State and Central Government, NGOs who are receiving funds from various stakeholders:

  • All Public and Private Limited Companies
  • One Person Companies (OPCs)
  • Companies owned by Government of India
  • State Government Companies
  • Not-for-Profit Companies/Organization
  • Nidhi Companies

Businesses who are outside the purview of audit trail rule

The following businesses don’t fall under the purview of the audit trail rule:

  • Individuals
  • Proprietorship concerns ​
  • Partnership firms
  • LLP-Limited Liability Partnership

Reasons and implications of the new audit trail rule 

It is undeniable that having an end-to-end log of all financial events like purchases, sales, and expenses can be proven beneficial to back trace any anomalies in the system. The edit log would, further, enable businesses to analyse each activity, thereby helping in remaining compliant.

The new rule has been introduced to bring transparency and restrict or reduce data manipulation of companies. This also implies that all accounting software is required to have the Audit Trail feature to ensure that their users are compliant with the new amendment and must comprise of the following enhancements:

  • Track and create an edit log of all transactional changes made in the books of account
  • Capture all timeline details like date whenever any changes are done
  • Accounting software must ensure that the edit log cannot be disabled

Audit trail (edit log) features of TallyPrime Edit Log Release 2.1

The latest release ‘TallyPrime Edit Log Release 2.1‘, is enhanced with the edit log feature that caters to the amendment released by the Ministry of Corporate Affairs (MCA). Following are the features of  TallyPrime edit log release:

  • Track the edits for masters and every transaction
  • Capture the date details and username when such changes (edits) are made
  • Difference report to show the elements of the version that have been modified
  • Reports are enhanced to filter the edited transactions
  • Designed to ensure edit log feature will be enabled all the time to meet the MCA guidelines of ‘Edit trail cannot be disabled.
Watch the above video to see how to use audit trial rule
Bank Details with QR Code in Invoice

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

In this blogpost we will add Bank Details with QR Code in Invoice. 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.

Bank Details with QR Code in Invoice:

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:
 
    1. Copy below TDL code and make a text file.
    2. Save text file then load in Tally Prime (Method provided below the code)
        3. Now go for invoicing and enable bank details for invoice.
        4. 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 :
1. How to add extra fields in Invoice Print.
2. How to add Use Tally QR code facility.
3. And Many More…….
TDL Code : 
 
 
[*Part : EXPINV BankInfo]
Add : Bottom Parts : After : EXPINV DateTime :LearnWellBankQR
[Part :LearnWellBankQR]
Parts :LearnWellQrP, EXPINV BankDetails
[Part :LearnWellQrP]
Part :LearnWellQRCode
Vertical : Yes
[Part :LearnWellQRCode]
Horizontal Alignment : Left
Vertical : No
Lines :LWQrL
QR code: (“upi://pay?pa=9131810293@ybl&pn=AshishKumarSingh&tn=Bill No. “+$$String:$voucherNumber) : True
Height : 10% page
Width : 12% Page
[Line :LWQrL]
Field :LWQrF
[Field :LWQrF]
Set As : “”
 
HOW TO USE ABOVE CODE:
 
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9  OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

Our other website Engage to Tech

To Do List in Tally Prime

To Do List in Tally Prime | 2023 Best Free Tally Prime TDL | Reminder TDL for Tally Prime

If you want to add notes or To Do List in Tally Prime, then this blogpost will help you. 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.

To Do List in Tally Prime:

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:
 
        1. Dowload TDL code with provided link
        2. Load in Tally ERP9 or in Tally Prime (Method provided below) 
        3. Now go to To Do button provided in toolbar section beside Goto button.
       4. 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 :
1. How to add toolbar button.
2. How to create reminder list.
3. And Many More…….
HOW TO USE TDL CODE:
 
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Download TDL file with below Download button.
2. Save into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9  OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 
 


Now your TDL is ready to use.
Download TDL file with below download button

Our Other website Engage to Tech

Receipt Modes in Sales Voucher

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

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.

Receipt Modes in Sales Voucher:

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:
 
        1. Dowload TDL code with provided link
        2. Load in Tally ERP9 or in Tally Prime (Method provided below) 
        3. Now go to Daybook, You will find Two extra buttons in right side toolbar (Change Voucher Type and Change Voucher Numbering)
        4. 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.
Watch above video to learn :
1. How to add Receipt Modes Master.
2. How to add Receipt Modes in Sales Vouchers
3. And Many More…….
HOW TO USE TDL CODE:
 
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Download TDL file with below Download button.
2. Save into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9  OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 
 


Now your TDL is ready to use.
Download TDL file with below download button

Our Other Website Engage to Tech

Voucher Type Changer and Voucher Numbering Automatic to Manual

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

Voucher Type Changer and Voucher Numbering Automatic to Manual will help to update your old entries asper new requirements. 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.

Voucher Type Changer and Voucher Numbering Automatic to Manual:

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:
    1. Dowload TDL code with provided link
    2. Load in Tally ERP9 or in Tally Prime (Method provided below)
3. Now go to Daybook, You will find Two extra buttons in right side toolbar (Change Voucher Type and Change Voucher Numbering)
    4. 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.
Watch above video to learn :
1. How to load TDL file in Tally.
2. How to add toolbar buttons
3. And Many More…….
HOW TO USE TDL CODE:
 
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Download TDL file with below Download button.
2. Save into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9  OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.
Download TDL file with below download button
Mailing Name and Address TDL for Tally Prime

Mailing Name and Address TDL for Tally Prime | Vouchers with Party Mailing Name. Must have for cash billing | 2022 Best Free Tally Prime TDL

Mailing Name and Address TDL for Tally Prime will help you to track contact details at voucher entry time. If your most of billings in cash or you want customer mailing name along with cash, then this TDL is for your Tally. With this TDL file we can we can add party mailing name after party ledger at invoicing time. In this we can also add party mobile number to collect outstanding easily. And also can see Mailing names in Ledger report.

Mailing Name and Address TDL:

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 get mailing name in invoice screen and in ledger reports.
 
HOW TO USE:
 
    1. Copy below TDL code and make a text file.
    2. Save text file then load in Tally ERP9 or in Tally Prime (Method provided below the code)3. Now go for invoicing and select party name and press enter write mailing name.
 

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 :
1. How to add extra fields in voucher screen.
2. How to add extra fields in ledger summary.
3. And Many More…….
TDL Code : 
 
 
[#Line:EIConsignee]
Add:Field:After:EIConsignee:LWmailingname
[Field:LWmailingname]
Use:Name Field
Set As:$PartyMailingName
Set Always:Yes
Skip:Yes
Color:Blue
 
[#Line:DSP VCHDetail]
Add:RightField:Before:DSPVCHType:LWMailingNameLd,LWAddressLD
[Field:LWMailingNameLd]
Use:Name Field
Set As:$PartyMailingName
 
[Field:LWAddressLD]
Use:Name Field
Set As:$$FullList:Address:$Address
 
[#Collection:Vouchers of Ledger]
Fetch:PartyMailingName,Address
 
HOW TO USE ABOVE CODE:
 
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9  OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

Ledger and Outstanding Notes TDL

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

Ledger and Outstanding Notes TDL will help to add notes along with ledgers. 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.

Ledger and Outstanding Notes TDL:

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:
 
        1. Dowload TDL code with provided link
        2. Load in Tally ERP9 or in Tally Prime (Method provided below) 
        3. Now go to Ledger Account to add notes (See the video for more detail)
        4. 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 :
1. How to load TDL file in Tally.
2. How to add Notes in Ledger Account
3. And Many More…….
HOW TO USE TDL CODE:
 
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
 
1. Download TDL file with below Download button.
2. Save into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9  OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 
 


Now your TDL is ready to use.
Download TDL file with below download button