Tel: +44 1953 788060


© Sorsis Limited 2009-2018

Website last updated 27 Apr 2018

Bridging the gap between Finance and IT

Automatically transferring data from one system to another is the keystone to running an efficient finance operation.  All too often the finance team is left in the middle between software suppliers.

Importing Multiple data sources Data manipulation Archiving and reporting Automation and manual imports Validation

We can handle text files (including XML), collecting data from other databases via SQL and direct input from other systems into our input tables.

Wherever possible we use the finance system’s API to post data and we expect the API to provide basic validation.  We can also include extra layers of validation based on any automated set of rules you require.

For any import, text files in particular, we can ensure an ‘all or nothing’ approach (i.e. if any document in the file fails validation none of the documents are posted).

Email alerts

Sometimes it is necessary to manipulate the data before posting.  For example, one of the leading suppliers of front desk systems for hotels has a back office interface that regularly outputs unbalanced revenue journals (it is a VAT rounding issue because they always round the sum rather than summing rounded numbers).  In that case we add an extra posting row to write off the difference.

We can automatically apply code mapping, currency conversions and inter-company journals as required.  We can also look for missing account details in other systems.

Any text files that have been successfully imported are, by default, moved to an archive folder.  The system retains a history of all activity and any error messages returned by the finance system’s API.  All of this activity can be reported on as required.

The application can be run on demand manually from the desktop, or automatically from a scheduled task.  We do not offer the application as a Windows service because of issues with some finance system API’s.

For automated imports we offer configurable email alerts for errors only, or any activity.

Example user - Randstad UK Shaping the world of work