Accounting > Collection

Menu Bookkeeping> Financial> Electronic banking> Collection.

With this function a Collection file is created based on outstanding invoices debtors.

This function can not be executed in an old bookyear.

In 2014 Clieop03 has been replaced by SEPA.

Per debtor the needed information for collection must be entered on the tabpage Collection

Select Debtors

In the screen 'Automatic collection debtors' you can set a selection of debtors and the description to send with the collection.

From - Until debtor

The range of debtors to be selected for collection.

Description

The description to go with the collection.

The invoice number will be in the description as well.

Creates a proposal.

Proposal Collection

In this screen, you can see the proposal based on the selections made.

Outstanding invoices with an invoice date before the Debtors 'Collection from' date will not be in the proposal.

Correct lines that can be processed have the status "OK" in the Status column.

When an item cannot be processed, the reason is given in the Status column.

It is possible to reduce the amount or to delete a line.

The outstanding invoice from the debtor will not be changed.

The following actions can be executed:

–<Refresh>
The proposal will be altered with new changes in the debtor and payment data.

–<Clear>
All items will be deleted from the proposal.

–<Expand selection>
The screen <automatic collection debtors> will pop up again and the settings can be changed.

–<Print>
A report will be produced.

–<Create file>
The collection file will be created. Only items with an "OK" status will be processed.
There will be a message when no items found with an "OK" Status.

Create file

After choosing <Create file> the settings for the file itself can be set.

Pay to account

Only bank accountants related to a Daybook Type "Cash/Bank" can be selected.

The fields 'Bank account', 'IBAN number' and 'Bic number' have to be set in the daybook belonging to the chosen bank account.

Book in daybook

Only a Daybook with Type "Memorial" can be selected.

After <Create file> the collected items are booked in the selected daybook.

By deleting these journals the collection can be redone.

Opposite account no.

The opposite account number used. When the field is empty, the account number from in Maintenance > Settings > Book > General > General ledger no. automatic batch payments is used.

Payment method.

There are two Payment methods: "Clieop03" en "SEPA".

In 2014 Clieop03 has been replaced by SEPA.

Location Direct Debit file

Location where the created file will be saved.

Collection date

The requested collection date can be entered.

When the Payment method is "SEPA" Mill7 will determine the Collection date.
For debtors collected for the first time the collection date will be the actual date plus 5 workdays.

For other debtors it will be the actual date plus 2 workdays.
When this collection date lies before the requested Collection date entered by the user the collection date will be set to the last one.

Creditor ID

For SEPA the field 'Creditor ID' has to be filled with the number given by the bank in the contract for Direct Debit Collection. This Collection ID is unique per bookkeeping.

After pressing this button the file will be created conform the settings.

There will be a message when the file is created successfully.

Collection via SEPA

There are 2 types for SEPA Direct Debit: CORE and B2B. Because not every bank supports B2B Mill7 will only create a SEPA Direct Debit type CORE.

To reduce the bank costs on transactions the Sepa Direct Debit file will include a maximum of 2 batches each with multiple transactions.

There is 1 batch FIRST for clients who are debited for the first time and a 1 batch RCUR for the recurrent direct debits.

In the SEPA file the field Mandaat ID will be filled with the account number debtor unless the Mandaat ID at Debtor is entered.

When a Debtor is collected for the first time the option First collection must be entered at Debtor> Collection.

The option will be switched off automatically after the collection.