d-basics Collector

d-basics Collector is a comprehensive solution for automatic exchange of financial information. The software extracts financial information from a large number of data sources, verifies this information, creates data files in predefined formats and sends these files to recipients such as factoring companies, banks, credit managers etc.
 

Import information

 
d-basics Collector automatically extracts the required financial information from different kinds of data sources:
  • on premise accounting packages
  • other on premise financial applications
  • online accounting packages
  • other online financial platforms

Depending on the data source, d-basics Collector connects to either the database, web service or API and automatically copies the required financial information to its own database for further processing.

List of connected accounting packages
 

What kind of information can be extracted?

Because d-basics Collector connects directly to the data sources it can extract all of the information that is stored in a data source. Below are examples of information that can be extracted by d-basics Collector.

Sales ledger

  • Debtor master data (name, address, etc.)
  • Open items / invoices
  • Invoice lines
  • Sales transactions

Purchase ledger

  • Creditor master data (name, address, etc.)
  • Open items / new invoices
  • Invoice lines
  • Purchase transactions

General ledger

  • General ledger master data
  • General ledger (periodic) balances
  • General ledger transactions

Inventory

  • Inventory master data
  • Inventory amounts, age, location etc.

Because d-basics Collector only extracts the information required by the recipient, in most cases only a some of these items are extracted.

In case of extraction through a web service or API, the kind of information that can be extracted is limited to the possibilities offered by the web service or API.
 
 
 

Verify and correct information

 

The financial information which is extracted by d-basics Collector often is not fully compliant with the data specifications of the recipient.

To make sure that the data files which are created by d-basics Collector can be processed by the recipient, d-basics Collector verifies if the financial information complies with the technical specifications of the recipient.

If shortcomings are detected, d-basics Collector corrects them for as far as this is technically possible and notifies the user in case of shortcomings which cannot be corrected automatically (e.g. required information is missing).

Verification can result in a notification, a warning or an error. In case of an error it is not possible to continue (send data files) until the user has fixed the issue.

 

Examples of corrections which are applied automatically by d-basics Collector:

  • Replace user defined country-, currency- and language codes with the proper ISO-codes
  • Convert invoice numbers which exceed the length that can be processed by the recipient
  • Convert information to a different data format
 

Create and send data files

 

After the information has been verified, d-basics Collector automatically creates data files (that have the technical file format as expected by the recipient).

During this process filters can be applied to determine which of the extracted financial information will be included in the data files and which information should be excluded.

Further export accounts can be used to create multiple sets of data files, where each set of data files contains a specific part of the extracted financial information (e.g. different sets of data files per currency)

List of avialable export plugins
 
 
 
 

Workflows and scheduling

 

When d-basics Collector creates and sends data files, a sequence of actions is executed. Each of these actions can be triggered manually, but it is also possible to execute a workflow which will automatically trigger a sequence of actions.

During the installation of d-basics Collector a default workflow in created that executes all relevant actions, additionally users can create other workflows if they need alternatives.

Scheduling

d-basics Collector can be extended with a Scheduler plug-in that executes workflows in accordance with a predefined schedule.

With this plug-in the entire process of extracting and sending financial information can be carried out without user interference.

 
 

Customized reports

 

The standard export plugins of d-basics Collector create a fixed set of data files according to the technical specifications of the recipient.

In addition to these plugins, d-basics Collector can be extended with the customized reports plugin, a plugin that creates customized reports based on client specific report definitions.

If the customized reports plugin is used in combination with the scheduler plugin, these customized reports can be created automatically in accordance with a predefined schedule.

This way d-basics Collector offers a automated solution for periodical internal and external reporting.

 
 
 
 

Write back to accounting package

 

D-basics Collector not only extracts information from data sources, in certain cases the software can also be used to automatically add or update information to an accounting package or data source.

During this process d-basics Collector compares the information inside the accounting package with information from an other data source and - automatically - updates the accounting package's information if this is not up to date.

Examples of information that can be written back:

  • Feedback from recipients (e.g. invoice payment information)
  • Information provided by online data sources (e.g. debtor ratings or credit limits)
 

 Must be supported by accounting package

Writing back information is only possible if this is supported by the accounting package or the data source.

In general this is only the case if an interface (API) is available that is able to process write back requests in accordance with the business rules of the accounting package or data source.

Please note that d-basics Collector will never change or add information in/to the database of the accounting package or data source without using the proper interface, so write back is only possible if a (licensed) copy of such an interface is available.