How to find the total GST paid?

Asked by: Meagan Kris  |  Last update: September 24, 2026
Score: 5/5 (56 votes)

To find the total GST paid, identify the GST rate (e.g., 5%, 12%, 18%, 28%) and apply it to the taxable value of goods or services. The formula is: GST Amount = (Original Cost × × GST%) / 100. For items with GST already included, use: GST Amount = Original Cost − − [Original Cost × × (100 / (100 + GST%))].

How to calculate total GST paid?

The GST Calculator operates based on a straightforward formula: GST Amount = (Selling Price x GST Rate) / 100.

How to check total GST paid?

How can I track status of a GST payment without logging to the GST Portal?

  1. Access the https://www.gst.gov.in/ URL. The GST Home page is displayed. ...
  2. In the Enter GSTIN/Other Id field, enter your GSTIN or other Id. In the Enter CPIN field, enter your CPIN. ...
  3. The payment status is displayed. ...
  4. The Challan is displayed.

How to figure out how much GST you paid?

The normal method for GST is subtracting the amount you paid on purchases (aka ITCs) from what you collected on your sales. This is the amount you must remit to CRA or if you paid more GST on your purchases than you collected on sales, CRA will send you a refund. Pretty simple except there are many rules you must know.

How to find out how much GST was paid?

The easiest way to calculate GST on a net price (exclusive of GST) is to multiply the amount by 1.1. To calculate the amount of GST on GST-inclusive goods and services, you'll need to divide the amount by 11.

how to calculate gst amount from total amount in excel

19 related questions found

How to calculate GST reverse?

Reverse Charge Mechanism & Calculation

  1. Formula: Base Amount = Inclusive Amount ÷ (1 + GST Rate/100)
  2. RCM: Recipient pays GST instead of supplier.
  3. Split: For intra-state: CGST + SGST | For inter-state: IGST. Our reverse GST calculator automatically handles RCM compliance calculations.

How do I see my GST payment?

You can sign in to your CRA account to view:

  1. Your next expected payment date and amount.
  2. The status and amount of each payment for the year, from July to the following June.
  3. Your statement of account for the GST/HST credit, including details about amounts and entitlements, dates, and balances.

What is the GST calculation formula?

Let's find out. If you have a GST-inclusive sales price and wish to calculate the 15% GST component of the total price, you can either divide it by 1.15 or follow this formula: Multiply the total sales price by 3. Divide the result by 23.

How to calculate GST using Quick Method?

To calculate the amount of GST/HST to remit, multiply the revenue from your supplies (including the GST/HST) for the reporting period by the quick method remittance rate, or rates, that apply to your situation.

How to calculate hst backwards?

Reverse Sales Tax Calculations:

  1. Price before Tax = Total Price with Tax - Sales Tax.
  2. Sales Tax Rate = Sales Tax Percent / 100.
  3. Price before Tax = Total Price with Tax / (1 + Sales Tax Rate)
  4. Sales Tax = Price before Tax x Sales Tax Rate.

How to check total GST balance?

Manual > Electronic Cash Ledger

  1. Access the https://www.gst.gov.in/ URL. ...
  2. Click the Services > Ledgers > Electronic Cash Ledger command.
  3. The Electronic Cash Ledger page is displayed. ...
  4. Note: You can click the link for the amount displayed under Cash Balance as on date to view the summary of the Cash Balance.

How to check GST details?

Frequently Asked Questions

  1. a. b.
  2. Step 1: Visit the Government of India's official GST portal. Step 2: Click on the “Search Taxpayer” tab. ...
  3. Step 1: Visit the GST portal. Step 2: Click on the 'Search by PAN' option, and then enter the PAN.
  4. Reach out via email to cbecmitra.helpdesk@icegate.gov.in.

How to download GST challan for Payment?

Step-by-Step Process to Download GST Challan

  1. Log in to the GST portal using valid credentials.
  2. Navigate to Services > Payments > Challan History.
  3. A list of generated challans will be displayed; select the relevant challan by clicking on the CPIN link.

How to check how much GST is paid?

Manual > Track Payment Status (Post Login) / View Challan History

  1. Access the https://www.gst.gov.in/ URL. The GST Home page is displayed. ...
  2. The list of Challans with the payment status is displayed. Note: ...
  3. Click the CPIN (Common Portal Identification Number) link. The payment receipt or Challan is displayed.

Is there a simple formula for GST calculation?

The formula for calculating GST is to multiply the net price (exclusive of GST) by 1.1 or divide the price including GST by 11 to determine the GST component.

What is 50000 including GST 18%?

Calculation: Base Price: ₹50,000. GST Amount: ₹50,000 × 18% = ₹9,000. Total Amount: ₹50,000 + ₹9,000 = ₹59,000.

How do you calculate GST paid?

GST is a broad-based tax of 10% on most goods, services and other items sold or consumed in Australia. To work out the cost of an item including GST, multiply the amount exclusive of GST by 1.1. To work out the GST component, divide the GST inclusive cost by 11.

How do you calculate how much GST is paid?

For adding GST, the following formula is used. For example, if a product or service costs Rs. 100 and the GST levied on that is 18%, the GST amount will be 100 x 18% = Rs. 18. The net amount you'd have to pay would be Rs. 118.

How to calculate GST from a total amount?

As most diners include a tip, Accounting uses a formula to determine the GST amount charged, (multiply by 0.04 and divide by 1.04. For example, (GST = $65/1.04 X . 04.)

How to do a reverse GST calculation?

Reverse GST Calculation Example

  1. Gross Amount: Rs.1,300.
  2. GST Rate: 12%
  3. Divisor: 1.12 (since 1 + 0.12)
  4. Base Amount: Rs.1,160.71 (Rs.1,300 / 1.12)
  5. Total GST Amount (Integrated tax/IGST): Rs.139.29 (Rs.1,300 - Rs.1,160.71)

Why do you divide by 11 for GST?

The value of a taxable supply is the consideration payable for the supply (before GST is added). For example, if the value of the supply is $100, the GST payable is 10 percent of $100, being $10. The price GST inclusive of the supply is $110. To work out the GST paid, you can divide by 11.

How do you calculate GST in math?

Here's an example: If a product is sold at Rs. 1,000 and the GST rate applicable is 18%, then the net price calculated will be = 1,000+ (1,000X(18/100)) = 1,000+180 = Rs. 1,180.

What is GST credit, and how does it work?

The goods and services tax/harmonized sales tax (GST/HST) credit is a tax-free quarterly payment for individuals and families with low and modest incomes to help offset the GST or HST they pay. It may also include payments from provincial and territorial programs.

How do I find my GST details?

Step 1: Visit the GST portal. Click on the 'Search taxpayer' option, and then click on ' Search by PAN'. Step 2: Enter the PAN. The list of GST registrations under the PAN will be displayed, along with the state and status of their registration.

How much is the GST payment?

Payment amounts are recalculated every July

For example, the information from your 2024 tax return determines the GST/HST credit amount you get for the payment period from July 2025 to June 2026. You could get up to: $533 if you are a single individual. $698 if you are married or have a common-law partner.