Skip to main content
All CollectionsIntegrations
Sage Accounting UK
Sage Accounting UK

How to connect Sage Business Cloud Accounting UK to Syft

Nikhita avatar
Written by Nikhita
Updated over a week ago

If your organization uses Sage Business Cloud Accounting UK then Syft is the perfect addition to analyze your data and produce beautiful reports.

Syft and Sage Accounting UK

Syft Analytics seamlessly integrates with Sage Accounting and Sage Business Cloud Accounting and transforms your accounting data into financial reports and insights. The Syft and Sage Accounting integration unlocks all functionality available in Syft including reports, visualizations, consolidations, forecasts, budgets, valuations and benchmarks.

How to connect a Sage entity to Syft

To connect your Sage entity to Syft follow the step-by-step guide:

  1. Click "Add entity" at the top right of your screen.

  2. You will now be redirected to our add entity setup page where you can click on “Sage Accounting” under the "Accounting" category.

  3. You will then be redirected to the page below where you will be prompted to select the country the organization is based in.

  4. Syft will redirect you to a login page where you will be prompted to fill in your Sage details. Click “Link account” once your details are complete.

  5. Click “Complete Setup”.

Your Sage entity is now connected to Syft Analytics. You can now make use of all of the features available on Syft for your Sage entity.

Additional information

Shared data

Sage Accounting shares the following data with Syft:

  • Accounts

  • Contacts

  • Invoices

  • Journals

  • Bank transactions

Unrealized and Realized Currency Gains

Due to the timing of multi-currency transactions in a single entity, realized and unrealized transactions are classified. The split between what is classified as realized and unrealized currency gains will be different on Syft compared to what is on Sage.

This is due to the difference in timing of when Syft fetches the data from Sage and the timing of when Sage calculates the value. However, the sum of the accounts will be correct. So it's simply the split between what is realized and unrealized that will differ.

Refreshes

Data in Sage entities is refreshed every 24 hours. If any changes are made to the data in a period more than 12 months ago, you will need to reconnect the entity to Syft. This can be done by clicking "Add entity" and proceeding with Sage. This will reload all data within the entity.

Data mismatches

Syft lets you report on transactions individually but when it's connected to Sage UK, sometimes not all the transaction details are sent over. This can lead to differences between the data on Syft and on Sage. Sage UK unfortunately does not send over all the transactional information; so Syft cannot use individual transaction data reliably. Instead, it can only make statements based on the data Sage sends over.

Additionally, there are no Account Receivable (AR) or Account Payable (AP) reports that can be produced on Syft since there is no customer or product data available for Sage One UK entities. This leads to certain pre-build report templates needing to be adjusted on Syft.

💡 Pro tip

If you run into any errors downloading a pre-built template for a Sage One UK entity, remember to delete any AR or AP reports from the template first. After this, the report template will download as expected.

Did this answer your question?