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 attached […]
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.
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 is claimable. This situation arises usually […]
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 Interest […]
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 in furnishing return of Income , default in payment of Advance tax and for deferment of Advance tax .
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 […]
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 Interest if there […]
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 […]
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 […]
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 […]