Hop Sage One Integration

The integration allows the Accounts Daily export to be automatically pushed through as a Journal import to your Sage One accounting solution, without the need to download it as a CSV file and import the data manually.

Connecting to Sage One

To set up the Sage One integration in Hop, navigate to Administration > Property and look for the section called 'Sage One Integration' towards the bottom of the page.

Click the 'Authorise Integration' button. This will open up a login page, asking you to provide the login details for your Sage One account and grant Hop access to it. 

If the connection is successful, you will be returned back to Hop again. If you see an error message, please contact Hop Support. 

Next, go to the Run time section and select the time of day that you would like the export to run. (Please note this should be at least 2 hours after the Night Audit to ensure all transactions are brought through.) 

Press the 'Update Settings' button to save your changes. 

We also recommend that you tick the 'Enable Accounts Daily Export Notification emails' box to turn on daily email notifications to advise if it has been successful or it has failed. Tick the box and then enter one or more email addresses you would like this to go to. The email will look like this:

If the Integration fails it should advise why and you will need to manually complete the import for this day by uploading the CSV file. Please contact help@hopsoftware.com if you repeatedly receive failure emails so that we can confirm if there is a wider issue. 

Troubleshooting

Q: In the notification email, I see an error like this - what does it mean and how do I fix it?

Cannot find Ledger Account with Nominal Code "1111" for Accommodation 

A: This is a mis-configuration issue between Hop and Sage One. The nominal codes used on the Articles in Hop must match the Ledger Account Codes used in Sage One and vice versa.

Q: In the notification email, I see an error like this - what does it mean and how do I fix it?

Invalid_grant - the submitted refresh_token is invalid 

A: The "refresh token" for this account is out of date. To resolve this, the Sage One user must login to PMS and re-authorize the Hop application on Sage One. Just head to Administration > Integrations and click the Authorise Integration button and then re-input your account login details.