Latest Files

Check-list and calculation Utility – Vivad Se Vishwas Scheme

I have has made an attempt to prepare an UTILITY covering a CHECK LIST and a detailed CALCULATION for working an amount payable/refundable on opting for the recent amnesty scheme ‘VIVAD SE VISHWAS’ pronounced by the Government. Accordingly to me, this utility works as a ready rackoner and a complete calculator. The same is att...

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

E-Book | Vivad Se Viswas Scheme! March Edition

Please find 3rd edition of our e-book on ‘Vivad Se Vishwas Scheme’ which contain: – Brief about Vivad Se Vishwas Scheme – Analysis of Vivad Se Vishwas Scheme – Emerging issues – Key cases from IDS – The Direct Tax Vivad Se Vishwas Act, 2020 – The Direct Tax Vivad Se Vishwas Rules, 2020 ̵...

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

Bank Audit Excel Utility for SBI

This excel tool can convert the text files and perform workings for analysis of NPA, sample selections etc. This utility would work for SBI only....

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

Excel Utility for GSTR – 2A Reconciliation with Books

Matching & Reconciliation under GST Following Mismatches can be noticed by taking up following Matching and Reconciliation exercises: -Differences between the amount of credit shown in GSTR- 3B and the GSTR 2A or/and -Discrepancies between GSTR-3B and GSTR-1 or/and -Differences in the provisional credit claimed and actual credit that ...

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

GST Audit Checklist and Working sheet

Article contains GST Audit Checklist and Working sheet in Excel Format for the benefit of our readers. GST Audit Working sheet have Sheets to Maintain Master Records of Client, For Important Notes related to Client and sheets for GST on Receipt, ITC Availed, Ineligible Credits, Creditor Older than 180 days, RCM Payable, Working of Interes...

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

234ABC Interest Calculator & Brief with Examples

Download Interest Calculator U/s 234A, 234B, 234C of the Income Tax Act, 1961 - Date for Advance tax is nearing and all the Assessees and their Tax Consultant must be busy in calculating advance tax payable for the Month of March. In this article we are discussing Interest payable Under Section 234A, 234B, 234C of the I.T. Act for default...

TDS Interest Calculator as per Section 201A of Income Tax Act

Section 201A of Income Tax Act Nature of Default: (i) Non-deduction of tax at source, either in whole or in part. Interest subject to TDS/TCS amount: 1% Per Month Period for which interest is to be paid: From the date on which tax-deductible to the date on which tax is actually deducted. (ii) After deduction […]...

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

Automatic Calculator for Interest on delayed filling of GSTR – 3B for FY 17-18, FY 18-19, FY 19-20

Automatic Calculator in Excel Format for Interest on delayed filling of GSTR 3B for Financial Year 2017-18, Financial Year 2018-19 and Financial Year 2019-20. This article give you brief idea on topic of Interest under GST & AN AUTOMATIC EXCEL UTILITY for calculation of Interest.  Many taxpayer registered under GST forgot to pay Int...

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

Income Tax / TDS on Salary Calculator for Multiple Employees for FY 2019-20

Bulk Data Income Tax Calculator for Multiple Employees for Financial Year 2019-20 / Assessment Year 2020-21 and Bulk TDS Calculation (Salary) in Excel I have already uploaded an excel Income Tax Calculator for Individuals for this FY 2019-20 which will be useful to individuals. But for HR Department, to arrive the estimated amount of TDS ...

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

Income Tax Calculator for FY 2019-20 in Excel for Salaried Individual in India

Income Tax Calculator for the Financial Year 2019-20 for Salaried Individuals  in India in Excel. Tax Planning in the beginning of the Financial Year is always better instead of doing that at the end of the year in hurry. This will help the Individual to plan their Investments in advance and submit necessary documents to […]...

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

Utility for compliance of CGST Rule 36(4)- Restriction on ITC Claim

Utility for compliance of Rule 36(4) – This utility is prepared in view of notification regarding new rule 36(4) and circular no. 123 to determined maximum ITC (B2B) that can be availed while filing GSTR 3B. As per the new rule 36(4) inserted vide Notification No. 49/2019 dated 09th October 2019,  a taxpayer can claim […]...

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

Download GST Invoice Wise Reconciliation Utility

Invoice wise Reconciliation – Although the purpose is fulfilled through Party wise utility but to be more precise this utility is developed. It works on the criteria of Invoice number + GST number and the respective tax amount. As an additional feature, the user may ignore the desired amount (i.e., rounding up) in the process […]...

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

Download GST Partywise Reconciliation Utility

Party wise Reconciliation – While reconciling ITC as per 2A and ITC (B2B) as per books of accounts with the criteria of invoice number only, there are several problems being faced. Firstly, mismatch of invoice number due to minor clerical error in entering the invoice number in books, which led to mismatch of large number […]...

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

Download GST 2A Convertor

2A Convertor – When documents are downloaded from GSTN portal (i.e. 2A), it is not compatible for further analysis/scrutiny. This utility helps in making it compatible, comparable with books and convert in single line item with all credit notes prefixed by minus (-) sign. It is very useful for the person not using any software/tool [&he...

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

Offline Utility Tool for GST Refund Error

Offline Utility Tool for GST Refund Error solved Dear GST stakeholders. Here is the solution for error !!! The refund offline utility as downloaded from GST portal showing errors as follows Error 1: Either invalid date or Please enter the Invoice or Doc date in dd-mm-yyyy format Error 2: SI.No with Duplicate Entry in row […]...

Annual Compliance Calendar for all Companies (listed and unlisted)

We have attempted to de-mystify and simplify the compliances for Equity Listed Companies as well, as attached,  by segregating them into separate sections  and plotting them in Annual Calendar, so compliances  for the month/year are visible at a glance. With the spate of amendments pouring in, need was felt to consolidate all recent am...

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

Right of Member to Copies of Audited Financial Statement

Copy of Financial Statement (defined under section 2(40) of the Companies Act, 2013 (‘the Act’) shall be sent to persons as envisaged under Section 136 of the Act. Section 136 also tells about the mode, time limit and other additional compliance related to same. This articles briefly elaborates Section 136 of the Act. Section ...

Download File

Constitution (Amendment) Bill, 2020-two child policy-small family norms

The Constitution (Amendment) Bill, 2020 — introduced in Rajya Sabha; Bill to encourage — ‘two child policy-small family norms‘- The Constitution (Amendment) Bill, 2020 as a private member bill was introduced in the Rajya Sabha on February 7 seeking to introduce a Directive Principle in the Constitution with respect to pop...

Income Tax Calculator for FY 2020-21

Download Income Tax Calculator for Financial Year 2020-21 in Excel Format / Download Income Tax Calculator for Assessment Year 2021-22 in Excel Format/ Download Income Tax Calculator for FY Year 2020-21 in Excel Format / Download Income Tax Calculator for AY 2021-22 in Excel Format. Q.1 What are the conditions for opting in the Scheme [&h...

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

Excel Utility to Compare Income Tax | Old & New Regime | Budget 2020

This is an Excel Utility with the help of which one can make simple calculations regarding comparative study of Income Tax as per old regime and income tax as per new regime laid down under budget 2020. User is requested to refer to the yellow colored cells of this utility specifically for giving inputs and […]...

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