Monday, 11 January 2021

Index for all articles

Other Important
Click On Article/TDL Name Video 
Fully customised receipt print Video
Modified GSTR-3B Video
Fully Sales Invoice Customise Yourself  Video 
Item with hsn, gstrate in invoice & stocksummary & colummner report  Video 
Show Ledger @ Voucher Entry Time / Posting time  Video 
Print Invoice on your Beautiful Letter Head  Video 
Find an invoice by GST number  Video 
display gstn on all inventory vouchers  Video 
Convert Json to excel offline utility  Video 
Multi Invoice Printing  Video 
simple inovice printing customise  Video 
Print Bank Detail on Invoice in old Tally versions  Video 
Find negative stock in any date  Video 
Colorfull simple invoice printing in tally  Video 
All companies bank balance & cash on single click  Video 
Bank reconcelation satus on voucher entries  Video 
Tran-1  Video 
Tran-2  Video     

Excel To Tally Index

GST Tutorial Index
Maintain GST structure | जीएसटी पोर्टल की तरह जीएसटी लेजर्स को टेली में
How to updated from original GOVT GST Update
Mandi Tax
GST READY Bill Formats

Tally Advance Tutorial Index
Tally Advance
ऐसे इनवाइस का कैसे पता करें जिनमें क्वा्न्टिटी डालना भूल गए हैं ।
create good address book from tally in excel
Tally Monthly Report without any TDL
Handle Mandi tax with GST in Tally

Understand Tally Erp9 / Tally Prime / Tally Developer Concept of Simple UDF with practicle & assignments

 Understand Tally Erp9 / Tally Prime / Tally Developer Concept of Simple UDF with practicle & assignments


Use:- UDf is used to store values parmanently in tally database associated with related object.

Types of Udf

1. Simple UDF: Used to add columns and store values in existing table of object.

2. Aggregate UDF : Used to add complete table with columns and row with assiciated internal object.

[System : UDF]

 <Name of UDF> : <Data Type> : <Index Number>

<Index Number> can be any number between 1 and 65536

The index numbers 1 to 29 are already used for Default TDL*/

;Simple UDF

[#Part: LED Mailing Address]

Add:Line:After:LED Mailing Address:addharno


Field:longprompt, adharnum

Local:Field:longprompt:Set as:"Aadhar No."


Use:Name Field

;Set as:"123456789012"




;==========end of code==============



=============Practice Assignment===========

;Add three lines i.e.  Vechile Number, Transporter Name, Lr Number before Narration of sales voucher



[#Part: DBLLINE Narration]

    Add                  : Line : Before : Vch Narrprompt :addharno

Tuesday, 15 December 2020

Tally TdL - Print Bank Slips from Tally and Print Neft/RTGS Details behind cheque

Tally TdL - Print Bank Slips from Tally and Print Neft/RTGS Details behind cheque

Feature 1:-

Today I am going to give a very important tally TDL. In which you can print your party payment details beneficiary details like account number, IFSC code, bank name, branch mame behind cheque very easily from tally accounting software. These details are very important when you make payment using Neft Or rtgs.

By entering manually behind cheque or writing on a bank slip - these details consuming more time and more chances of mistake. But using this TD are you can directly print these details from Tally behind the cheque. 

This Tdl not only giving you a facility, but also without any mistake, you can make your work fast.

For more details watch below full video and download this TDL

Feature 2:- As you know filing bank slip is a time consuming and typical task to fill accurate all information. sometimes we need to fill again another slip due to some mistake and cutting not allowed on bank slips as per banking rules. So this tdl will solve this problem if your bank allowed to print bank slip on behalf your self for your transactions. This is a most awaited tally tdl. Requirement of this tdl was came to me through email. I like that mail and give assurance to sender that i will definitely design or develop required tally tdl. So now i am very happy to design it and i hope it will help every business.

Let's know about this feature Today dt 15-12-2020 Now i am going to release this advance feature in same tally tdl. In this release in which you can also print bank slips like Neft/RGTS, Cheque Deposit slip directly from you tally accounting software.

    You can print slips as well as you can design you slip as you want or required. Its a ultimate tdl in which you can add many designs you want.

to know complete process you have to check below video

Download Now

Sunday, 8 November 2020

Auto Remove Invoice number and invoice date from credit note in GSTR1 Json Generated file without efforts

 Q.1. Why it required?

Ans:- In old version of tally invoice number and invoice date in credit note entry show in tally gstr1 json. but currently portal accepting so we required latest verison of tally. but using this tdl without purchasing latest tally you can genereate gstr1 json without invoice number and invoice date in credit note.

Q.2. What is manual way to do it?

Ans. I allready credated video on it you can check it below

Q3.What is automatic way to do it?

Ans:- Download this tdl link available below in this article. check video also

Download Now

Saturday, 7 November 2020

All Input Vouchers Like GSTR3B for GSTR2A Reconciliation-Tally TDL

 All Input Vouchers Like GSTR3B for GSTR2A Reconciliation-Tally TDL

This is a tally tdl (Tally Add on).

Using this tally tdl you can not only check all purchase/inward supplies without any error unlike tally default gstr3b.

Q.1 What it is required?

Ans:- For GSTR2A Reconciliation we required all inward supplies vochers summary. but default reports of tally 3b take too much time show that report & show us many errors. but this tally tdl provides you one click inward vouchers summary.

Q2. Is it like 3b all other input itc table?

Ans:- Yes

Q3. Is this Tally TDL compatible with my tool GSTR2a Reconciliation Utility?

Ans: Yes, It is compatible you can export this report into excel then you can use my previous upload free tool GSTR2a Auto Reconciliation.

Q4. How to use this tally tdl

Ans: watch my below video

Q5. How to download it?

Answer:- click on below link 

Download Now

Friday, 23 October 2020

Multiple Repeat Voucher Entry Automatically in Tally

 Multiple Repeat Voucher Entry Automatically In Tally

Q.1 What will learn in this article?

Ans:- You will learn how to make multiple repeated entries automatically in tally without extra effort. You can make entires without caring about dates. You can make again entry automatically by deciding number of days.

    With this tdl you can make entries on last date of every month, same date on every month, daily bases and repeated after decided number of days.

Q.2 Why we use this tdl?

Ans:- If you maintain yearly accounts of any firm then it will much useful for you. you can easily make repeat entry of expenses, journalisation, payment, receipt entries etc in Tally.

Q.3 How many types of entry we can do using this Tally Tdl?

Ans:- Basically it supports 3 types of entry in tally.

    1. Journal

    2. Receipt

    3. Payment

Q.4. How it works?

Ans:- It will ask from you for auto repeate entry

    1. Which type of entry do you want to do?

    2. Name of Debit Ledger & Name of Credit Ledger?

    3. Start & End date of time period in which you want to repeat entry?

    4. Select periodicity means in how many days you want to repeat it automatically?

Q.5.How to download it?

Ans:- Click Me for Download

Q.6. How to know about more it?

Ans:- Watch below provided video for practical & more information

Tuesday, 20 October 2020

GST Mismatch Report :- GSTR2A Reconciliation Fastest Utility | Get Mismatch With in Seconds

This article related to following query if you searching
gstr 3b and gstr 1 mismatch
gst mismatch
mismatch in the nature of transaction and place of supply
gstr 9 itc mismatch
gstr 2a mismatch

gstr 3b and gstr 2a mismatch
itc mismatch in gstr 9
mismatch in gst return
itc mismatch
mismatch in gstr 2a
mismatch in gst

Quickly GST Mismatch Report
Question:-  जब हम Press to continue बटन पर क्लिक करते हैं तो यूटिलिटी काम नहीं कर रही है
( when I click on press to continue button utility not working) 
Solution:-  please check given video I answered in this video

Complete Solution GSTR2A Reconciliation
In this article me and my friend created a utility in ms access in which you can insert your portal and books GST2A. This utility will produce GSTR2A reconciliation within seconds. This Utility different to other because of no user actions required to generate data format mean user efforts are negligible. 

You can not also watch mismatch but also print and export to excel your all mismatch type report  and invoice mismatch type report. This is a very beautiful utility because of very user friendly and free of cost.

Requirements to use this utility:-
1. Ms Access must be install on your system
2. Portal GSTR2A and books GSTR2A
3. download this utility from below given link

1. Free of Cost
2. Effortless reconciliation
3. Easy to print result on A4 Size sheet no need to settle.
4. Separate reports for only invoice mismatch etc.

This is first version of this utility. so may be some limitation. so track problems and send to me on my mail address :- for further corrections.

for more information about this utility watch given below video

Version 7-8-3 Release Dated 14-09-2020

1.Reconcile Monthly/ Annually etc.
2.Reconcile B2B as well as CDNR
3.Multi Rate Invoices will show only in single row
4.Match Invoices if invoice number string incorrect
5.All Reports into Excel Export facility
6.computax Problems solved

Download Version 7-8-4
check below video to know features of version 7-8

Saturday, 10 October 2020

Sales Invoice wise GST Summary with GSTN from Voucher & Ledger without any expiry

 Sales Invoice wise GST Summary with GSTN from Voucher & Ledger

I given a answer of protect yourself to making mistakes in gstr1. Most of the times parties inform after 2-3 years about mismatch When due dates of corrections gone.

you will learn how to check party gstin in voucher entry that is uploaded in portal. You can check yourself your gstr1 before filing September gstr1 filing to make yourself error proof.

  1. How to know my gstr1 is ok or not?
  2. How to check what mistake I have done in my gstr1 filed already?
  3. Any way to check gstr1 correct or not?
  4. Any tally tdl that checks gstr1 mistakes?
  5. Any free tally tdl which informs about wrong gstin entered on vouchers or invoices?
  6. How to protect myself making mistakes in gstr1 filing?  

Friday, 2 October 2020

how to collect TCS from 01-10-2020 under section 206C (1H)

As per my understanding from various videos on YouTube about TCS

News:- TCS on business turnover greater than 10 Crore from 01-oct-2020

206C (1H)


If you are a Goods Seller


If turnover in previous years or in current year > 10 Crore


   You have to collect tcs from certain buyers (except government, embassy, high commission, importers etc.)


                If received >50Lakh from single party (from 01-04-2020 to 30-09-2020) as advance or against goods sold any f.y.


                                Not required to collect TCS from that buyer


                If received any amount above 50 Lakh after 30-09-2020 to 31-03-21 advance or against goods sold (bill amount)


                       Collect TCS on that excess amount at the time of receipt of amount only from that party

PAN / AADHAAR furnished

Up to 31st March 2021







                For further f.y from 21-22 to further

                Over 50 lakh received in a f.y. as advance or against goods sold of any f.y.


                                Collect tcs on that excess amount only when received amount only from that party


PAN / AADHAAR furnished

From 1st April 2021







                If received less than 50 lakh in a f.y. as advance or against goods sold of any f.y.


                                Not required to collect tcs