This section explains how to export loan payment collection files for batch processing, often used with internet banking systems.

MaxMoney Setup

Before you can export loan payment collections, some configurations are needed in MaxMoney.

Access Requirements

To use this feature, users will need specific Resources enabled in their roles:

1. Go to Setups > Security > Roles.
2. Ensure the following resources are selected for the relevant roles:
   • Processing: Loan: Export for Payment Collections
   • Processing: View Logs

File Layout Setup

The available file layouts for payment collections are pre-coded into the system. A new type, FNB EnDO, is now available. This CSV file layout includes the following columns:

• Recipient Name: Client No & Surname
• Recipient Account: Bank Account No
• Recipient Account Type: Bank Account Type (L) (1 = cheque, 2 = savings, 3 = transmission)
• BIC Code: Bank BIC code
• Amount: Instalment Amount
• Contract Reference: Loan Agreement no
• Tracking: Tracking days
• Abbreviated Name: Legal Entity Short Name
• Reason for Collection: 33

Ledger Setup

You'll need to set up a bank account ledger.

1. Go to Setups > Accounting > Financial Ledgers.
2. Add a new ledger for your bank account.

Bank Account Setup

Configure your bank account within MaxMoney.

1. Go to Setups > Bank Accounts > Add/Edit Bank Account.
2. Enter a Description for the bank account (e.g., "Payments Received from Borrowers").
3. Select the Enabled checkbox.
4. Select the Financial Ledger you set up previously.
5. Enter the complete bank account information.
6. Select the Payment Export Account checkbox.
7. Choose the appropriate file layout from the list.
8. Enter a short name for your entity, as some batch files require this.

How to Use Batch Payment Collections in MaxMoney

Client and Loan Prerequisites

• The client must have an Enabled, Preferred, Payback Bank Account configured in their client bank setup.
• When a new loan is created for a client, the system automatically generates a schedule of instalments the borrower must pay.

Batch Export Process

This process allows you to generate a file containing a batch of instalments according to a specified file layout.

1. Go to Processing > Loan > Export for Payment Collections.
2. You will be presented with various parameters to filter which instalments to include in the batch:
   • Select the desired date range.
   • Select the Export Type (i.e., the file layout you wish to use).
   • Select the bank account from which the payments will be collected.
   • If you select Move Action Date, you must also specify the date on which the payments should be collected. If you unselected Move Action Date, the original instalment date will be used in the file.
3. Click the Finish-button to execute the process.

Export Payment Collection Reports

Export Payment Collection Summary Report

This report lists all the instalments that were processed and included in the generated file.

Payment Collection File

This is your actual batch file, which will contain the instalment entries formatted according to the file layout you selected.

Processing Log

The processing log provides a summary report of the batch process. It also lists any problems or errors encountered during the file creation.

• To view the process log, go to Processing > Logs > Export for Payment Collections.
• A history of all processes is logged and can be viewed by a manager or owner.
• Use the Detail-button to view which specific instalments were included in a particular batch export.

FAQs

Q: I'm getting a MaxMoney error after enabling this module. What should I do? A: If users suddenly encounter errors after this module is enabled, please double-check all the setup configurations for this module to ensure they are correct.