Powersoft

Sage 50 integration

A Windows service that posts journals into Sage 50 and pulls data back out. It sits beside any other system and connects it to your accounts, without either side being rewritten.

Authorised Sage Developer
Sage 50 services

The bit nobody wants to build twice

Almost every Sage 50 integration project asks the same two questions. How do we get transactions into Sage 50 reliably, and how do we get data back out to report on it? Answer those once, properly, and the interesting part of the project becomes the business problem rather than the plumbing.

So we built a Windows service that does exactly that: it posts journals into Sage 50 and pulls data from it. It runs continuously, it sits alongside whatever other system you have, and it bridges the two.

We use it as the foundation for our own solutions, which means it is not a proof of concept. It is the component under several live systems in UK businesses.

Why this is not trivial

Sage 50 Accounts is a Windows desktop application, not a cloud service with a public web API. Integrating with it is a different problem from integrating two SaaS products, and it is the reason so many Sage 50 integrations end up as a manual export and a spreadsheet.

Where we have used it

Legal case management

A law firm running LexisNexis Visualfiles alongside Sage 50, with the accounting moving between case management and the ledger instead of being rekeyed.

Group reporting

Extracting data from Sage 50 and feeding a global head office for consolidated accounts.

More on reporting →

Insurance policy accounting

An insurance and reinsurance policy and claims system posting its accounting into Sage 50.

More on insurance →

Supplier invoice feed — freight

Guernsey Freight

Guernsey Freight receive electronic invoices from DHL. We built a solution that reads the purchase invoice file, validates it, matches the sales ledger account, calculates the sell value with an agreed percentage uplift and presents the resulting invoices for approval — then updates Sage 50 and emails the PDFs to customers. They carry on using Sage 50 normally for payments against those accounts.

Legal case management

LexisNexis Visualfiles

We have been integrated with LexisNexis Visualfiles for a law firm running it alongside Sage 50, so that the accounting moved between case management and the ledger rather than being retyped.

Worth saying plainly: a good deal of the work on that one happened on the Visualfiles side rather than ours. We mention it because it shows the range of systems our Sage 50 service has sat behind, not because it is something we can drop in.

Frequently asked questions

Does Sage 50 have an API we can use?

Sage 50 Accounts is a Windows desktop application rather than a cloud service, so integrating with it is not the same as calling a web API on a SaaS product. That is exactly why we built a service that handles the connection and presents a clean interface to whatever system needs to talk to it.

What does the bridge service actually do?

It runs as a Windows service, posts journals into Sage 50 and pulls data back out. It sits beside another system and moves accounting information between the two on a schedule or on demand, without either system being rewritten.

Why a service rather than a one-off import?

Because a one-off import is a person with a file and a deadline. A service runs continuously, handles failures, and keeps the two systems in step without anybody remembering to do it on a Friday afternoon.

What sort of systems have you connected to Sage 50?

Group reporting feeding a global head office; an insurance and reinsurance policy system; supplier invoice feeds such as electronic DHL invoices for a freight client; and legal case management, where we have been integrated with LexisNexis Visualfiles.

Can it work with a system you have not seen before?

Usually, yes. The Sage 50 half of the problem is the part we have already solved and reused; what changes each time is the other end. That is why these projects tend to be smaller than clients expect.

More on Sage 50

Talk to us about your Sage 50 system

Tell us what Sage 50 will not do for you and what you are working around today. We will tell you honestly whether it needs bespoke development, a change of process, or nothing at all. We are based in Horsham, West Sussex, and we work with Sage 50 clients across the UK.

Telephone: +44 (0)1293 562730
Email: sales@powersoft-services.co.uk

We are not a Sage reseller

We can supply Sage 50 if you want us to, but we do not depend on it. No licence revenue means no reason to recommend an upgrade you do not need.