# Ratio Analysis of Database for GST Audit by Department

RATIO ANALYSIS OF DATABASE FOR AUDIT BY GST DEPARTMENT to detect wrong Input Tax Credit availed, To identify under valuation of goods as value-addition should involve adequate difference between the two, To identify removal of goods without payment of duty, To identify claiming of input tax credit on inputs used in exempted products, to identify  Fraudulent availment of credit like availment of credit without receipt/actual use of input, To identify outward supplies made in the guise of exempted supplies,  To identify supply of essential parts of outward supply as exempted supplies,  To identify under valuation of outward supplies by overvaluing exempted outward supply etc.

(PROCEDURE/FORMATS SEPARATE FOR GOODS AND SERVICES)

PART –A: GOODS

PART-B FOR SERVICES RATIO ANALYSIS OF DATABASE

 Source Documents Utility of the Ratios in GST Audit and manner of use Nature of Ratio / Method of calculation 1. Profit & Loss Account;2. Income &Expenditure Account(in case of non-profit organisations like clubs); and3. GST return Compare the ratio over a period of 3-4 years. If the ratio is increasing there is possibility of the following irregularities:- i) Rendering of unaccounted outward supply. ii) Undervaluation of outward supply. iii) Diversion of outward supply income into non- taxable income. Compare this ratio (A) with (B) If ratio B is greater than ratio A, then there is a possibility of wrong availment of credit either due to calculation mistake or availment of credit on inward supply being not used properly in outward supply. Total cost of inputs received (both Goods & Services) : Value of Taxable outward supply (say A) Credit availed: Total GST payable (say B) 1. Profit & Loss Account;2. Income &Expenditure Account(in case of non-profit organisations like clubs); and 3. GST return Compare the ratio over a period of 3-4 years or with the Taxable person rendering the same services. If the ratio is increasing over a period of time or it is more when compared to other suppliers, then there is a possibility of under valuation by showing outward supply income as non-taxable / exempted income. Other incomes not charged to GST : Value of taxable outward supply Balance Sheet A comparison of this ratio with the rate of growth of the value of taxable outward supplyduring the year may be useful in verifying whether the value of taxable outward supply has been correctly declared.It is particularly to be checked in cases where the additions to plant & machinery / fixed assets directly impact the volume of outward supplies. Additions to plant and machinery / fixed assets during the year : Total value of assets at the beginning of the year GST returns Compare the ratio over a period of 3-4 years. If the ratio is increasing there is the possibility of the following irregularities:- (a) Rendering of unaccounted outward supply; (b) Under valuation of outward supply; (c) Showing outward supply income as non-taxable outward supply income. (d) Inflation of inward supply credit. Amount of input tax credit availed on inward supply : Total tax liability on outward supply GST returns i) To identify wrong availment of input tax credit ii) To identify under valuation of outward supply as value-addition should involve adequate difference between the two. iii) To identify outward supplies made without payment of GST. iv) To identify claiming of input tax credit on inward supplies used in exempted outward supplies. Input Tax Credit (A) : Total Tax paid through (Electronic cash ledger + Input Tax Credit) (B) = (A)/(B) Balance Sheet & GST return i) Addition to the Plant & Machinery is available from the Fixed Assets Schedule enclosed to the Balance sheet. Input tax credit availed on Capital Goods purchased during the year : Addition to Plant & Machinery Profit & Loss Account. If this ratio is higher than previous period, it may be on account of the following: a) Under valuation of outward supply by non-inclusion of other incomes b) GST liability on Other Income Other Income: Outward supplies

November 2020
M T W T F S S
1
2345678
9101112131415
16171819202122
23242526272829
30