Latest Files

GSTR 2B/ GSTR 2A Matching Excel Utility (FREE)

GSTR 2B/2A MATCHING EXCEL UTILITY V.1 (AI VERSION) (FREE) GSTR-2B Is Month-Wise Auto Drafted Statement For Regular Taxpayers Introduced On August 2020 And Can Be Generated From 12th September 2020 Onwards. This GSTR-2B Generated Report Allows Taxpayers To Reconcile ITC With Their Own Books Of Accounts And Records. Although Taxpayers Strug...

Access Denied! Only Regstered Users Can Download The File. Register Here

Excel utility for preparation of GSTR 9 & GSTR 9C

Excel utility for preparation of GSTR 9 (Annual Return) & GSTR 9C (Audit Report) Excel utility for preparation of GSTR 9 (Annual Return) & GSTR 9C (Audit Report) for Financial Year 2019-20. File is Easy to use and contains three type of fields i.e those which user has to fill, those which will be automatically […]...

Access Denied! Only Regstered Users Can Download The File. Register Here

Format of Quarterly Cash flow Format As per AS-3

Article contains Format in Excel of The Cash Flow statement prepared under the ‘Indirect Method’ as set out in the Accounting Standard-3 on Cash Flow Statement issued by the Institute of Chartered Accountants of India....

Download File

Excel utility for preparation of GSTR 9 & GSTR 9C for FY 2019-20

Excel utility for preparation of GSTR 9 (Annual Return) & GSTR 9C (Audit Report) for Financial Year 2019-20. File is Easy to use and contains three type of fields i.e those which user has to fill, those which will be automatically generated based on input by use and drop down list which user has to […]...

Access Denied! Only Regstered Users Can Download The File. Register Here

Income Tax Calculator from FY 1997-98 to 2021-22

This Income Tax calculator is a very useful tool to calculate tax by using excel only. It contains the rate of Income tax for last 25 financial year (i.e Financial year 1997-98 to 2021-22) and income tax calculator for last 16 years (i.e Financial year 2006-07 to 2021-22) for Individuals (i.e including the rates proposed […]...

Access Denied! Only Regstered Users Can Download The File. Register Here

CPC handbook covering FAQs on topics related to ITRs

CPC Handbook For Tax Consultants/Taxpayers – November 2020 Centralized Processing Center, Bangalore has prepared a handbook in order to provide guidance to taxpayers and taxpayers’ representatives regarding e-filing of returns, processing of returns, issue of refunds, validation of bank accounts, filing of rectification applic...

Access Denied! Only Regstered Users Can Download The File. Register Here

Summary Notes on Advance ITT Exam as per ICAI

The impact of Information Technology (IT) on several aspects of accounting profession and practice has been pronounced over the last two decades. The revolutionary developments of various IT tools and techniques have a far reaching impact on the organizations. In today’s business world, accounting professionals have to interact with com...

Access Denied! Only Regstered Users Can Download The File. Register Here

Income Tax Calculator for Financial Year 2020-21 for Individuals

Income Tax Calculator for the Financial Year 2020-21 for Both Regimes in Excel for Salaried Individuals in India-Ver 20.01 This excel based simple and user friendly Income Tax calculator for Salaried Individuals is to compute the Income Tax for both Old and New Regime.  This will help you to decide which Regime to follow to […]...

Access Denied! Only Regstered Users Can Download The File. Register Here

CGST Act 2017 Updated Till 3rd January 2021- Free E-Book

In this Article Author compiled  CGST Act 2017 with all notification / Acts issued and changes which occurred till Till 3rd January 2021. Books contains all Section of CGST Act 2017 as Promulgated by President on 12.04.2017 updated with subsequent changes till 3rd January 2021. Book is Updated by By Ghanshyam Upadhyay and Praveen Upadhya...

Access Denied! Only Regstered Users Can Download The File. Register Here

PPT on Benami Transactions

Benami Transactions One should not enter into any benami transaction as its consequences are severe and unescapable. Please find attached herewith insights on the Prohibition of Benami Property Transactions Act, 1988. Benami property means any property which is the subject matter of a benami transaction and also includes the proceeds f...

Access Denied! Only Regstered Users Can Download The File. Register Here

TCS Calculator – Section 206C(1H)- Sale of goods- FY 2020-21

TCS calculator under section 206C(1H) of Income Tax Act, 1961 – TCS on Receipt on sale of Goods for the period 1st October 2020 to 31st March 2021 Please find herewith Excel Utility developed by our office for calculation of TCS U/s 206C(1H) of the Income Tax Act which may be useful to you. In […]...

Access Denied! Only Regstered Users Can Download The File. Register Here

Tax Calculator (based on Form 16) – New Tax Regime Versus Old Tax Regime

The Central Board of Direct Taxes (CBDT) vide Circular No. 8/2020 dated April 13,2020 has clarified that an employer will have to deduct TDS for FY 2020-21, from an employee’s salary on the basis of the tax regime chosen by the employee else by default TDS would be deducted as per Old Tax Regime Rates. The Union […]...

Access Denied! Only Regstered Users Can Download The File. Register Here

Draft Format of Form 3CEB with Annexures for AY 2020-21

Draft Format of Form 3CEB for AY 2020-21 amended vide Notification No. 82/2020 dated 1st October, 2020 in Excel /Word Format As Form No. 3CEB (Transfer Pricing Audit Report) has been amended recently vide Notification No. 82/2020 dated 1st October, 2020. However, the utility is yet to be updated. So, sharing the updated draft of […...

Access Denied! Only Regstered Users Can Download The File. Register Here

GSTR1 and GSTR 3B PDF to Excel VBA VER 3.2

It is an upgraded version of previous tool, this tool will convert GSTR1 and GSTR-3B files into Excel on a Monthly Basis. Format is the same as provided by the GST department, but I write it in Vertically, so that you can do the following. #Monthly Comparison of your GST Returns #Help in GST Reconciliation […]...

Access Denied! Only Regstered Users Can Download The File. Register Here

Rule 36(4) Template For September 2020 GSTR-3B

Rule 36(4) Template For September 2020 GSTR-3B will calculate the final Input Tax Credit (ITC) to be claimed in September 2020 Form GSTR-3B by just filling in relevant figures.  ...

Access Denied! Only Regstered Users Can Download The File. Register Here

Amended Form 3CD for Assessment Year 2020-21

Form No. 3D for Assessment Year 2020-21 i.e. Financial Year 2019-20 is amended by CBDT vide Notification No. 82/2020-Income Tax/G.S.R. 610(E) dated 01st October 2020. We have compiled the same based on changes made on 01.10.2020 and reproduced the same below- ”FORM NO. 3CD” [See rule 6G(2)] Statement of particulars required to be furn...

Access Denied! Only Regstered Users Can Download The File. Register Here

Checklist for DPT 3

Checklist for DPT 3 so that the same is easily available to get the required details from the Finance Team. Checklist for DPT 3 contains the following detail format- -Net Worth as per the latest audited balance sheet preceding the date of the return as on 31.03.2020 -Particulars of charge as on 31.03.2020 -Particulars of […]...

Access Denied! Only Regstered Users Can Download The File. Register Here

Guide on How to Save Income Tax?

Guide on How to Save Income Tax is RELEVANT FROM FINANCIAL YEAR 2019-20 & ONWARDS, Incorporates changes made in Income Tax laws in Union Budget presented on July 5, 2019 & onwards. Download the attached File to get the detailed analysis of Deduction under Income Tax Act & Rules on following topics- Income Tax New […]...

Access Denied! Only Regstered Users Can Download The File. Register Here

GSTR 9 and GSTR 9C Effects

Effects of Different Situations under GST  relevant to Sales Invoice, Sales Debit Note, Sales Credit Note, Purchase Invoice, Purchase Credit Note and Purchase Debit Note assuming following two situations- Assuming Invoices and Debit/Credit Notes Entered In Books Assuming Invoices and Debit/Credit Notes Not Entered In Books...

Access Denied! Only Regstered Users Can Download The File. Register Here

Practical understanding of effect of ITC in GSTR 9 for F.Y. 2018-19

Form GSTR-9 is an annual return to be filed by all registered taxpayers whose turnover is Rs. 2 crores or more. A taxpayer shall report all outward supplies, inward supplies, taxes paid, refund claimed, demands raised and ITC availed and utilized in Form GSTR-9. It has been observed that practitioners are facing many difficulties to [&hel...

Access Denied! Only Regstered Users Can Download The File. Register Here