If return in FORM GSTR-3B is furnished on or before the 24th day of June, 2020 (notification no.31/2020 – Cental Tax) The interest shall be calculated from the day succeeding the day on which such tax was due to be paid – section 50(2) of CGST Act.( notification no 13/2017 – Central Tax dated 28th June 2017)

It takes care of the rest of the requirements.

You can download it and use this excel utility to calculate GSTR 3b interest.

here we have compiled Free Excel Utility to Calculate GSTR-3B Interest. But this interest is not calculated by the GSTN portal or even by the department. The late filing of GSTR 3B invites the liability to pay interest. It is not only a return but also a mechanism for self-assessment. We make payment of tax while filing GSTR 3b. Now that we have our arguments, we'll write our function in cell B2.Free Excel Utility to Calculate GSTR-3B Interest Since our cell range is A2:C13, it will search column A. It's important to know that VLOOKUP will always search the leftmost column in the cell range. In this example, we're only looking for exact matches, so our fourth argument is FALSE. If it is FALSE, it will look for exact matches. If it is TRUE, it will look for approximate matches.

The fourth argument tells VLOOKUP if it should look for approximate or exact matches.

The names are stored in the second column of the cell range from the previous argument, so our our third argument is 2. In our example, we're looking for the Product Name.

The third argument is the column index number, which is simpler than it sounds: The first column in the cell range from the previous argument is 1, the second column is 2, and so on.

Note that we're using absolute references so this range won't change when we copy the formula to other cells. In our example, we want it to search for this value in cell range A2:C13 on the Products worksheet, so our second argument is Products!$A$2:$C$13.

The second argument is a cell range that tells VLOOKUP where to look for the value from our first argument.

In our example, we're searching for the product ID number, which is in cell A2, so our first argument is A2.

The first argument tells VLOOKUP what to search for.

The arguments will tell VLOOKUP what to search for and where to look. Before we write our function, we'll need to take a moment to think carefully about each argument and collect some information from our spreadsheet.

How to calculate gst in excel