Payment Processing Fee, Invoicing and tax

  • Justin
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 8 months ago #116613 by Justin
Hi
On our one payment method, we charge a payment processing fee which is now causing a problem on the invoice
I need to be able to display the following on the invoice

Amount: (Event price excluding Tax)
Discount: (Discount amount excluding Tax)
Payment processing fee: (Fee excluding Tax)
Tax: (Tax on Event + Tax on Payment fee - Tax on discount)

Total Amount payable (Total including Tax)

Please let me know how I would set it up so that the payment fee also includes tax and adds it to the total tax

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
6 years 8 months ago #116615 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Payment Processing Fee, Invoicing and tax
Hi Justin

Unfortunately, there is no way to setup the extension to have it works like that.

The payment processing fee is calculated base on the final payment amount (Amount Before Tax + Tax)

We don't add tax to payment processing fee (it's only used to cover the fee charged by payment gateway for processing the payment so that admin gets expected net payment amount)

If you want to charge tax for payment processing fee, unfortunately, you will have to customize code of the extension which is quite hard

Tuan

Please Log in or Create an account to join the conversation.

  • Justin
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 8 months ago #116616 by Justin
Replied by Justin on topic Payment Processing Fee, Invoicing and tax
Is it possible to show the payment fee on the invoice because what is happening is the following

Event Fee: 1 086.94
Discount: 0
Tax: 163.04
Total: 1 312.50

This makes no sense because the total should be 1250 but the payment fee is pushing it to 1312.50 but not displaying

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
6 years 8 months ago #116617 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Payment Processing Fee, Invoicing and tax
Yes. You can use [PAYMENT_PROCESSING_FEE] tag in the invoice layout to show the payment processing fee

Tuan

Please Log in or Create an account to join the conversation.

  • Justin
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 8 months ago #116618 by Justin
Replied by Justin on topic Payment Processing Fee, Invoicing and tax
Thank you.
What would be the chance of you adding a "Tax rate" block to the "Payfast" payment method, the same way it shows on the events

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
6 years 8 months ago #116622 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Payment Processing Fee, Invoicing and tax
Could you explain how it should work?

Tuan

Please Log in or Create an account to join the conversation.

More
3 years 11 months ago - 3 years 11 months ago #143754 by EBA
I developed the following work-around solution for this which, in practical terms, largely resolved the issue.

In the invoice template, I inserted a line for "Credit card fee including tax" (with [PAYMENT_PROCESSING_FEE] tag, as advised by Tuan above) in-between the "Tax" line and "Total" line, with an explanatory note on how to calculate the tax portion of the credit card fee.

The information on my invoice appears as follows (note: the applicable tax is "GST" of 10%):

> Subtotal: $X
> GST: $Y
> Credit card fee including GST*: $Z
   (*To calculate GST portion of credit card fee, divide fee by 11)
> Total: $(X + Y + Z)

This way, the "Total" amount now accords with the figures displayed and accounts officers can easily calculate the tax portion of the credit card fee (being information they require when entering invoices into accounting records).

It is necessary to adjust the "divide" number based on the applicable tax rate. I hope this helps.
Last edit: 3 years 11 months ago by EBA.

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
3 years 11 months ago #143759 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Payment Processing Fee, Invoicing and tax
@EBA Thanks for sharing your solution

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc