Take a print of the following and insert the respective data. This sheet is for Tax Agents and accountants who file GST returns for multiple businesses. It is mandatory for every business registered under the GST regime is to submit GSTR 9 which is the Annual GST return. GSTR 9 Calculation Sheet consists of the 12 months data of GST Output Tax, GST Input Tax, Reverse Charge, and Net Payable GST.Īt the end of each month, insert the respective figures against each month. IGST Output Tax – IGST Input Tax – IGST Reverse Charge = Net IGST GSTR 9 Calculation Sheet SGST Output Tax – SGST Input Tax – SGST Reverse Charge = Net SGST Net Payable GST = Net CGST + Net SGST + Net IGSTĬGST Output Tax – CGST Input Tax – CGST Reverse Charge = Net CGST It applies the following formula to calculate the Net Payable GST: This section displays the Net Payable amounts of CGST, SGST, and IGST. After inserting the above details, enter the amount of CGST, SGST and IGST reported under RCM transactions. Purchases from unregistered suppliers are to be reported under Reverse Charge Mechanism. Net Purchase = Sales – Purchase Returns – Credit Notes The template automatically calculates the Net Purchase for you. Insert the amount of each against the respective heads. This section consists of the following heads of GSTR-2:Īll registered businesses are entitled to get an Input Tax Credit for goods or services purchased and used for business purposes under the GST regime. Net Sales = Sales – Sales Returns + Debit Notes GST Input Tax Calculations The template automatically calculates the Net Sales for you. This section consists of the following heads of GSTR-1: Insert taxable value, applicable GST (CGST and SGST or IGST) against each head in the following section.ĬGST and SGST apply to businesses doing Intra-State transactions whereas IGST applies to businesses involved in Inter-State Transactions.ĬGST and SGST are payable to the State government and IGST is payable to Central Government. Moreover, this section consists of the following columns to enter sales and purchase data: Insert monthly and year from the dropdown list and enter your GSTIN. The header section consists of the following: The monthly GST payable Calculator consists of 4 sections: Header Section, GST Output Calculations, GST Input Calculations, and GST Payable Calculations. How to calculate gst in excel how to#Let us understand how to use these sheets in detail. This template consists of 3 sheets: Monthly GST Payable Calculator, GSTR 9 Calculation Sheet, and Printable GST Payable Calculator. You can hire us for our services on Fiverr or directly contact us at Components of GST Payable Calculator Template We also design new templates based on your needs. How to calculate gst in excel download#Microsoft Excel OpenOffice Calc Google Sheetįor regular GST businesses, you can download the Fully Automated GST Invoice Template from the link below:Īdditionally, you can download Accounting templates like Inventory Template, Accounts Payable Template, Cash Book Template, Petty Cash Book Template, Marketing Budget, Expense Report Template, and Payroll Template With Attendance.įeel free to contact us for the customization of this template as per your requirement. This template helps you to calculate the GST liability for each month.ĭownload by clicking below on the desired format: We have created a GST Payable Calculator with predefined formulas and functions. What is the time limit to finish GST Payment?ĭownload GST Payable Calculator Template (Excel, OpenOffice Calc, & Google Sheet).Components of GST Payable Calculator Template.Download GST Payable Calculator Template (Excel, OpenOffice Calc, & Google Sheet).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |