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.

• Related Articles

• Payment processing

  Woosage50 will process payments that are made at the time of order for any payment method that is enabled in Woosage50>Settings>Payments. The payment process depends on the how the website order is imported to Sage (sales invoice or sales order) and ...

• Stripe & Paypal Fees

  Stripe & PayPal payments by customers are not remitted to your bank account in full, but are split into a pay-out and a fee, which sum to the customer payment. This can lead to additional work when reconciling Stripe & PayPal transactions in the bank ...

• Woosage50 Payment Settings

  Woosage50 can help with processing payments, allowing you to create the payment in Sage with the sales order or sales invoice, to be posted when the invoice is posted. Payment Settings The payment settings are shown below. Configure the above ...

• Credit Ordering Processing

  Introduction Credit ordering allows you to permit specific customers to place order without payment. Woosage deals with the processing of the order, including optional check on their Sage account for: Available credit to cover the order value Account ...

• Woosage 50 Processing Schedules

  Orders Processing Cycle The orders processing cycle deals with time-critical data, orders and stock updates, and is run normally according to a schedule. When running it will do the following. Get any unprocessed orders from the website and import ...