Export module Creditline

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Export module Creditline

This chapter describes the use of the export module Creditline. This module can be used to send financial information to either a bank or a credit manager. The following topics are covered:

 

Opening the export module

Initial configuration

Creating and sending export files

 

I. Opening the export module

Menu items: Export, Creditline

Use the menu options mentioned above to open the export module for 'Creditline'.

When the export module is opened, it is suggested to import the latest financial information. Always import this information if new entries were entered into the accounting package since the last time that information was imported into d-basics.

 

II. Initial configuration

Before export files can be created, the following initial configuration is required:

 

Select export directory

The export directory is the location where export files will be saved. The default location is: 'c:\export'. To select a different location, push the button at the end of the text box and browse to the desired location.

 

Enter the following company information

Bank account number

Trade registry number

Telephone number

City

 

Enter the following Bank information

Name

Address

City

 

Connection settings

D-basics can send export files to other d-basics users. To use this option, enter the following connection settings:

 

Send files automatically

If this option is checked, d-basics will automatically send the export files to Rabobank after they have been created.

 

Encrypt

If this option is checked, d-basics will automatically encrypt the export files.

 

Network connection

A mail server is used to send e-mail. Use this setting to specify which (dial up) network connection must be used to connect to this mail server.

 

Note:

Do not select a network connection if internet is accessible through the local computer network (LAN).

 

Mail server

Enter the name or IP address of the (SMTP) mail server that must be used to send e-mail.

 

E-mail address sender

Enter the e-mail address of a user that is allowed to send e-mail through the mail server mentioned before.

 

E-mail address recipient

Enter the e-mail address to which d-basics must send the export files.

 

E-mail address confirmation

Enter the e-mail address to which d-basics must send a confirmation message.

 

III. Creating and sending export files

To create export files, the following steps must be completed:

 

Step 1: Manage information

Certain types of debtors must be pointed out before information is send to Rabobank:

 

Inter company debtors

Inter company debtors are debtors that belong to the same concern as the company that sends information to the bank. If a company has such debtors, these must be pointed out as 'Inter company debtors'.

 

Match debtors and creditors

During the assessment of the value of a list of outstanding amounts, the outstanding amounts owed to a company must be subtracted from the outstanding amounts owed by that same company (the company is a debtor as well as a creditor). This requires the matching of debtors and creditors. See paragraph: Match debtors creditors.

 

Step 2: Check filter settings

Filters can be used to exclude information from export files. For more information see paragraph 'Using filters'.

 

Step 3: Creating export files

Push 'Start' to create export files. Before export files are actually created, d-basics performs the following checks:

 

Are all required parameters set?

Required parameters that are missing or not entered correct are displayed in red. In order to proceed, the correct values must be entered.

 

Are the country, language and currency codes matched to the corresponding ISO codes?

If the country, language or currency codes that are used in the accounting package are not compliant with the international ISO standard, these codes must be linked to the matching ISO codes before export files can be created. For more information see the 'Match ISO codes'.

 

Notes:

Each time export files are created, d-basics checks whether all codes that are used in the accounting package are linked to the matching ISO codes. D-basics cannot create export files until all codes are linked with the matching ISO codes.

It is possible to schedule import and export actions. For more information see 'Automatic import and export'.

 

Step 4: Send export files

After the export files are created, they can be send to an external recipient. If the option to send files automatically is not used, push the button 'Send' to initiate this process manually.

 

Step 5: summary and Log

After creating export files, the proceedings of d-basics can be reviewed:

 

Summary

The second tab of the Export module shows a summary of the information that was retrieved from the ledger (administration) in the accounting package.

 

Log

The third tab of the Export module shows the export log. The export log gives a summary of the events that took place during the import and export of information.

See the appendix 'Events log file' for an explanation of the events mentioned in the export log.

 

Note:

Most of the errors mentioned in the log file can be fixed by changing the information in the ledger (administration) in the accounting package.

'Error- and Truncate events are only registered if the corresponding checkbox is checked. It is recommended only to use this feature for debugging purposes, since it has a negative impact on the performance of d-basics.