Sunday, 8 November 2020

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

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-3
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






Friday, 25 September 2020

Read All GSTR3B Json in once in Tally & Produce Monthwise Summary in Excel as well as Tally Also

 Read All GSTR3B Json in once in Tally & Produce Monthwise Summary in Excel  as well as Tally Also
from this you can convert your all GSTR3B json to excel using tally free version. I provided this tool free to use. This is a zip file that you can download from given below link or directly visit my website. In this zip you will find three files. One for exe file that will help you to merge all gstr3b into one. Second one is tcp file that will be loaded into tally and last third one is tally calculator commands that will provide you your desired data from merged file. after that you can transfer you data to excel very easily. if you want to know full process of this please watch this video from starting to end.
In excel you can generate your desired data by using filter.
For More Info Watch Full Video, Download Link Below

Download Now

Saturday, 15 August 2020

how to fix - Right click response very delay in window 10

Question: - When I right click on my pc- popup menu get long time to load or response in computer

Solution: - Step by step solution you have to follow

1.       Downlaod ShexView 64bit or ShexView 32bit as per your computer requirement
a.       Whatis ShexView
2.       Extract/Unzip downloaded zip file by using winrar extract or 7zip extract
a.       Whatis Winrar or 7zip

3.       In unzip folder right click on shexview application file and choose Run as administrator to open

4.       After opening ShellExView click on Options Tab > choose Filter By Extension Type

5.       Choose Context Menu and click on Ok

7.       Select all highlighted pink color extensions using shift holding or ctrl holding like below

8.       Disable all selected item by click on red button like below

9.       Close it and restart computer
10.   Again open ShexView as administrator
11.   Again select those pink highlighted items
12.   Select on by one and Enable selected items

13.   Check now right click hopefully it working without delay.