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. zip file password is 110

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

Password of zip file is : 123

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