How to calculate total amount to include transaction fees

"pass the transaction fee for stripe and for PayPal on to the buyer"- Support forum

Card payments cost you a fee: Stripe keeps a fixed amount and a percentage of each charge, so a $100 order pays you less than $100. To pass that on, the customer has to be charged a little more, worked out from their total. A Google Form can't take payment or calculate anything, so there's no place to add it. With Neartail, the amount charged comes from a Net Amount field, and you can write it as a formula that adds the fee to the order total. Customers see the final amount on the form before they pay.

The formula comes first, then how to charge it on your order form.

Transaction charges

Stripe charges include a flat fee plus a percentage of the total amount. The flat fee and the total charge percentage must be factored into the final charge amount to ensure that you receive the desired amount, after Stripe deducts the fee from the charge.
Final Amount = (Total amount + Fixed flat fee) / ( 1 - Stripe % Fee)

Example: Final amount calculation for US

Stripe charges for US = 2.9% + 30¢ per successful charge
Let's say the total amount is $100. If you would like to pass the transaction fees on to your customers, the final amount to be charged to the customer can be calculated as follows:
Final amount = ($100 + 30¢) / ( 1 - 2.9%) = 100.30/0.971 = $103.29

How to charge the final amount in your form?

  • On the page that opens, click Enter your form name, type your form's name and click Generate.
  • Check the outline it suggests and click Proceed. Your form opens on the Edit tab.
The tabs Edit, Preview, Share and Orders, with Edit marked
Your form comes with products, an Order Amount question that adds up by itself and an Order Quantity question.
  • Click on the Order Quantity 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 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 Order Quantity and Standard calculation using NETTOTAL() selected, marked with Next
  • Click Create. You will replace this formula in the next step
The Standard calculation box with NETTOTAL() and the Create button marked
  • In Field settings, select the Answer tab. Replace what is in the Calculate option with the formula as shown below. TOTAL() is the order amount. Click Save
The Answer tab of the field settings with TOTAL() plus 0.30, divided by 0.971 in the Calculate box, with the Answer tab and the box marked
Your customers pay the Net Amount, with the fee in it. This formula leaves out any Delivery Fee or Discount, so use it on a form that has neither. To turn on card payments, follow How to accept online payments directly through your order form?

Useful Links (Stripe)

Stripe fees for your country
Scope of surcharge ban

Summary

Card fees come out of what you receive unless you add them to what the customer pays, and a Google Form can't do that sum. With Neartail, you write the fee into the Net Amount formula and customers see and pay the final amount. Create your order form and complete the steps above. If you have any questions, write to support.

Last updated: