Sage Pay integration

Sage Pay is an online payment service which you can link to Sage One Cashbook. To save you time entering transactions, you can import any receipts you receive through your Sage Pay account.

When you import transactions you can match them to existing customer records. To help you keep track of any receipts that you can’t match to a record, you may want to create a new record called, for example, Sage Pay transactions. You can then choose this as the default customer account when enabling the integration and any receipts which aren’t matched to a record are allocated to this one.

If you don’t already have a Sage Pay account, to find out more about the services they provide and how to apply for an account, please visit www.sagepay.com

Before you link your Sage Pay account to your Sage One service, you need to make sure you’ve created the bank account that you want to record any Sage Pay transactions against. This should reflect your merchant account. If you haven’t already done so, you should create one now. By creating the bank account, it helps you keep track of your Sage Pay transactions and you can check them against your Sage Pay account.

To enable Sage Pay integration

  • 1. Settings > Cashbook Settings > Sage Pay Settings.
  • 2. Enter the following information:
Vendor Name * This is your Sage Pay vendor name as registered during your Sage Pay application process.
User Name * This is your Sage Pay user name as registered during the Sage Pay application.
Bank A/C * Choose the bank account you want to use for your Sage Pay transactions.
Default Customer If you want to, you can choose a default customer to record the transactions against.


When you first import transactions the default customer appears. If required you can choose a different customer and the next time you import your transactions that customer appears by default. If you don’t enter a default customer, it creates an other income transaction, which is recorded against the bank account only.
Default Ledger Account * Choose the default sales type you want to record the income against.
Surcharge Ledger Account Choose the default sales type you want to use for any surcharges. For example you may charge a processing fee if a customer pays by credit card and want to record this against a different sales type to the main sale.


Note: If you don’t choose a surcharge sales type, any surcharges are recorded against the same sales type you use for the main part of the sale.
Password * This is your MySagePay login password.
Encryption password * You can view your encryption password by logging in to your MySagePay account as the main admin user.

If you’re not sure what information to enter, you can check your details on the Sage Pay website, www.sagepay.com or contact Sage Pay support on 0845 111 44 55.

Calls will cost 2 pence per minute, plus your phone company’s access charge.

  • 3. Click Save.

You’ve successfully linked your Sage Pay account to Sage One Cashbook and can now import your Sage Pay transactions.

To run the Sage Pay Ecommerce Payments report

  • 1. Summary > click the Sage Pay Ecommerce Payments link.
  • 2. To view transactions you’ve imported for a particular date range, enter the required from and to dates.
  • 3. To export the report to CSV > Download report > Export to CSV file.

Depending on your Internet browser, the file automatically downloads to your Downloads folder or you’re prompted to save the file > browse to where you want to save the file > Save.

To edit or delete a Sage Pay transaction

If you need to edit or delete a Sage Pay transaction, you can do so as normal. However any changes you make may result in a difference between your Sage Pay account and Sage One Cashbook.

  • If you delete a Sage Pay transaction from Sage One, it doesn’t delete the corresponding value from your Sage Pay account.
  • If you edit the amount, date or value of the Sage Pay transaction, it no longer shows as being paid through Sage Pay.

To disable Sage Pay integration

  • 1. Settings > Cashbook Settings > Sage Pay Settings.
  • 2. Enter your Sage Pay password and encryption password.
  • 3. Clear the Enable ecommerce check box > Save.

Let us know what you think...