IFN accounting data export interface

Development of shadow accounting with Excel and TALIS for a factoring bank

eWorks was commissioned by IFN Finance GmbH (Cologne), a bank for factoring and financing, to develop a universal accounting data export interface based on Microsoft Excel ("Shadow Ledger").

The objective was to convert almost any accounting data records in the heterogeneous computer environment of IFN customers into the standardized target format "TALIS for I-FACTOR"(HPD Software Limited, London).

To solve this task, software was developed that can convert almost any accounting export format to "TALIS for I-FACTOR". Technical operability on the broadest possible installation basis was achieved by implementing the software in the form of a Microsoft Excel add-in: the only installation requirement was therefore Microsoft Excel 2003 or newer. Usability by all IFN customers was achieved through simple operation and appealing usability. The add-in developed could be used on the computers of all IFN customers and enabled regular use in day-to-day business. The goal was thus achieved.

The implementation of a qualified electronic signature using a signature card and card reader was a particular challenge. This technology is used as a legally recognized, digital signature substitute, but is generally still unknown to PC users. The resulting hurdles were circumvented as part of the project by seamlessly integrating the digital signature into the software using a signature card and card reader.

The technical project planning was carried out together with the client before the start of the project. The Microsoft Excel add-in was then developed on the basis of an approved requirements specification. In the period that followed, eWorks continuously made further adjustments and has since supported IFN and its customers in operating and customizing the interface by e-mail and telephone.

eWorks carried out the technical design, development and subsequent customizing for IFN customers. The first pilot customers successfully started regular operation of the accounting data export interface in January 2008.

Used technologies

Microsoft Office
VBA

Related references

Would you like to
commission a project?

Enquire now!

Are you looking
for a job?

Apply now!