How to calculate sales tax and add it to the total amount?

Charging sales tax on a Google Form means doing the sum yourself, because the form has no order amount to take a percentage of. Each response needs the tax worked out and the total sent to the customer, and over many orders a mistake is easy to make. In Neartail, you add a Tax field with your rate, such as 7%, and your Google Form shows the order amount, the tax and the amount to pay while the customer orders. The same figures are on the order you receive.

Let's start. Import your Google Form and follow the steps below.

How to calculate the taxes based on order amount?

  • On the page that opens, paste your Google Form's link or click Browse to pick it, then click Import.
  • Select your currency and click Continue.
  • When it says "Your order form is ready", Neartail has made a product from each question with a price and added an order total and summary. If it says no products were found, add a price to any question.
  • Click Preview your form. Then, under Manage, click Edit form to open the form builder.
The Neartail page to import a Google Form, with a form link pasted in and the link box and the Import button marked
Your form now has your products and an order total question that adds up by itself. In this article, it's called Order Amount.
If you know the tax rate you charge, add it here. If you don't, check it with your accountant. Let's say the sales tax is 7%.
  • Click on the Order Amount question, then click Add price field in the toolbar on the right
The form in the editor, with the Add price field icon marked in the toolbar on the right
  • Select Tax and click Next
The Add price field list, with Tax selected and Next marked
  • Select Percentage % and click Next
The Tax settings with Insert after Order Quantity and Percentage % selected, marked with Next
  • Enter 7, check that Of says Order Amount and click Create
  • Click Save
The Percentage box with 7, Of Order Amount and the Create button marked

How to calculate the total amount including taxes?

Add a Net Amount price field. It adds the Tax by itself. Your customers pay the Net Amount.
  • Click on the Tax question, then click Add price field. Select Net Amount and click Next
The Add price field list, with Net Amount selected and Next marked
  • Select Standard calculation using NETTOTAL() and click Next
The Net Amount settings with Insert after Tax and Standard calculation using NETTOTAL() selected, marked with Next
  • Click Create
  • Click Save
The Standard calculation box with NETTOTAL() and the Create button marked
Your customers will see the Order Amount, the Tax and the Net Amount to be paid as they order. Your customers pay the Net Amount.
The Bakery order form with two cupcakes ordered, Order Amount $20.00, Tax $1.40 and Net Amount $21.40

Summary

A Google Form can't work out tax, because it has no order amount. With Neartail, you add a Tax field with your rate and a Net Amount, and the form shows the tax and the total to pay as your customers order. Import your Google Form and complete the steps above. If you have any questions, write to support.

Add sales tax to your order form.

Import your Google Form and add a Tax price field with your rate and a Net Amount, so customers see the tax and the amount to pay as they order.

Last updated: