Stripe Payment & Fee Processing Example

Stripe Payment & Fee Processing Example

The following is an example of how a payment and associated fee is processed in Woosage.   In this example we :
  1. Use a Stripe payment, but a PayPal payment is processed in the same way.
  2. Import the website order as a sales order, so if the website order is being imported as a sales invoice the first step will be omitted.
  3. Assume that the payment has been setup correctly in Woosage50>Settings>Payments.
  4. Assume that the fee account associated with the bank account has been correctly setup in Sage Bank Account>Settings.
Further details of payments setup can be found in the following articles:
  1. Woosage50 Payment Settings
  2. Stripe & PayPal Fees

1. Sales Order

The following sales order was imported to Sage from the website by Woosage.


Note the following (highlighted):
  1. The Sage order number is 1718
  2. The website order number is 556
  3. The order total is £68.40 and the deposit payment is £68.40
  4. The customer account is WC000001
On the Order tab we used the custom fields to show the payment method, pay-out amount and fee amount. This is purely for illustration in this example and is not required for processing. Note that although the order total is £68.40, the pay-out amount is £65.98, due to the deduction of the fee by Stripe, which is £2.42.


On the Payment tab of the order (shown below) you can see that the customer payment is £68.40 and it is currently showing as a payment on account (SA) as there is no invoice to pay at this stage. Also note the Payment ref is the website order number and the nominated bank account for the Woosage settings is 1250.

2. Sales Invoice

If we now complete (despatch) the sales order and create a sales invoice this creates invoice number 127 (shown below) from order number 1718.


On the Payment tab, the payment is still showing as a payment on account (type SA).


On the next Woosage order processing cycle the payment type is update to Allocate Payment to Invoice and Woosage creates a fee transaction on the fee account associated with the bank account, which is this example it is the same a the bank account (1250). If we the manually post the invoice (Update Ledgers), you can see that transactions are created for the line items and carriage and the payment on account is changed to a payment received. 
 
 
If we examine the bank account (1250) you can see that Woosage has created a fee credit of £2.42 and the payment debit is showing as a sales receipt.


As expected, the payment is showing as a sales receipt on the customer account.