Reconcile Stripe payments through Sage Business Cloud
Description

Stripe is a third-party secure, online payment service that integrates with Sage Accounting, and lets you add a payment link to your invoices so your customers can pay you online.

To get started, you must create a new Stripe account just for Accounting.

Stripe charges a transaction fee that you can review before creating your account. The fee is entirely transparent, and there is no waiting for approval, meaning you can start taking card payments immediately.

Cause
Resolution

How to use Stripe with Accounting

  1. Create an invoice to send to your customer. The invoice PDF contains a Pay Now button that links to your Stripe bank account.
  2. Your customer pays the invoice using the Pay Now button. The money is paid into your Stripe bank account and recorded in Accounting less the Stripe transaction fees.
  3. Your Stripe fees are recorded to ledger account 7900 - Bank Charges and Interest by default.
  4. Once the customer has paid their invoice, Stripe transfers the money to your chosen business Bank account.

 NOTE: Sage Accounting only supports payments for Invoices raised within the product. Website Payments taken via Stripe are not supported. 

Connect Stripe to Sage Accounting

For help to connect Stripe to Sage Accounting, please read this article.

Manage payments sent directly through stripe.com

If a customer has sent their payment directly through the Stripe website rather than paying their invoice using the Pay Now button, this could show a disparity when the payout is processed in Sage Accounting. This is because we don’t recognise this website payment as a known transaction.

For example:

  • If your customer pays you £100 through Sage Accounting, and £50 through the Stripe website, we’ll recognise that £50 payment as an unknown transaction
  • In this instance, Sage Accounting would process a payout for £150 to ensure your business’ current account balance is accurate. The £50 website payment will be processed differently using the suspense account in Sage Accounting, which will not include VAT on the receipt of the transaction
  • You would need to create a new journal to reverse the effects of this transaction. The journal needs to credit the bank account £50, and debit the suspense nominal by £50. You would then need to post a new receipt with the correct Net and VAT amounts for Sage Accounting to process

[BCB:299:UKI - Personal content block - Dane:ECB]
[BCB:307:UKI - Search override - Start UK / IE:ECB]
[BCB:276:UKI - hide back button:ECB]

Steps to duplicate
Related Solutions

Benefits of using Stripe

How to connect Stripe to Accounting

How to view your Stripe activity in Accounting

How to view the Stripe dashboard

Refund a card payment via Stripe

Stripe – Why was a customer’s card payment declined?

Disconnect your Stripe account from Accounting