Friday, 23 October 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
sr.no.
GST
Video
4
Maintain GST structure | जीएसटी पोर्टल की तरह जीएसटी लेजर्स को टेली में
3
How to updated from original GOVT GST Update
2
Mandi Tax
1
GST READY Bill Formats



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

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

Advantages:-
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 :- contact.aasansolution@gmail.com 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

YES

0.075%

NO

0.75%

 

                }

                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

YES

0.1%

NO

1%

 

                }

                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.

Saturday, 1 August 2020

Tally Developer Course Index

Table of Contents

0.
What Charges of this course आपके इस कोर्स की क्‍या फीस है

Any Certificate I Will Receive after this course टेली डवलपर के इस कोर्स को करने के बाद क्‍या कोई सर्टिफिकेट मिलेगा

What are benefits of this free course for creator इस कोर्स को बनाने वाले को क्‍या लाभ होगा


1.
Eligibility to learn Tally Developer टेली डवलपर सीखने के लिए क्‍या योग्‍यता जरूरी है

I passed 10th class can I Learn Tally Developer क्‍या 10 वीं पास भी टेली डवलपर सीख सकता है।

I Don’t have any knowledge of Programming Can I do this Course टेली डवलपर बनने के लिए बेसिक प्रोगामिंग की नॉलेज होना आवश्‍यक है

Can I Earn after learning Tally Developer Course  क्‍या टेली डवलपर सीखकर पैसा कमाया जा सकता है।

What level of this course इस कोर्स को करने के बाद किस लेवल की नॉलेज डवलप होगी


2.
What Is Tally TDL टेली टीडीएल क्‍या है

Use of Tally TDL, Why We Use Tally TDL टेली टीडीएल का क्‍या उपयोग है

Why Required to customize Tally software  हमें टेली को कस्‍टमाइज करने की क्‍या आवश्‍यकता है

System Requirement to customize Tally टेली कस्‍टमाइजेशन के लिए मिनिमम System Requirements क्‍या है