Skip to content
logo Knowledgebase

Reconcile Stripe payments through Sage Accounting

Created on  | Last modified on 

Summary

How to use online payment service Stripe with Sage Accounting.

Resolution

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.


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 Sage Accounting less the Stripe transaction fees. Your Stripe fees are recorded to ledger account 7900 - Bank Charges and Interest by default.
  3. Once the customer has paid their invoice, Stripe transfers the money to your chosen business Bank account.

You can only use Stripe with Sage Accounting to accurately reconcile invoices. Sage Accounting only supports payments for Invoices raised within the product. Website Payments taken via Stripe are not supported.

Connect Stripe to Sage Accounting

  1. From Settings select Apps and connections.
  2. To create a new Stripe account, select Create Account then Create Account again.
  3. If you have a Stripe account already, select click Sign in then Sign In to Stripe.
  4. Enter the details required by Stripe to set up an account. Select Authorise access to this account.
  5. In the Manage Connection menu, set the ledger account where your Stripe fees will be recorded. Like before, you should make sure that the ledger account is set to 7900 - Bank Charges and Interest by default.
  6. Select where your pay-outs will be transferred. Your pay outs will transfer to the bank account you chose when creating your Stripe account.
  7. Save any changes. Stripe pay-outs will then transfer to your nominated bank account every two weeks.

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 pay-out 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 pay-out 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.

 








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