Export Loan Payouts

Bulk Loan Export for Loan Payouts

This section outlines how to export loan payout files in bulk for distribution through internet banking systems. This process helps prevent duplications and maintains a history of batch creations.


MaxMoney Setup

Before you can export loan payouts, several configurations are required in MaxMoney.

Access Requirements

To use this feature, users must have specific Resources enabled in their roles:

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

File Layout Setup

  1. Go to Setups > File Layouts.
  2. Define the number of headers, trailers, and the format of your payout file.
  3. Next, define the columns within the file layout:
    • Go to Setups > File Layouts > Detail.
    • Remember to set up the linking column as specified in the header definition.

Account Types

MaxMoney supports various account types, including those specific to FNB Namibia.

Bank Account Setup

Configure your bank account to handle payout exports.

  1. Go to Setups > Bank Accounts.
  2. Select the Payout Export Account checkbox.
  3. Choose the specific file layout you defined for payouts.

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.

Event Setup

Set up an event for the double bookkeeping entry related to payouts.

  1. Go to Setups > Accounting > Financial Event.
  2. Create the necessary event (e.g., "Payment to Client").

CashBox Setup

Ensure your cash box is linked to the payout event.

  1. Go to Setups > Branches > Cash Boxes.
  2. Edit the relevant Cash Box.
  3. Under Financial Events, select the checkbox for your payout event.

Payout Process Scheduling Setup

You can schedule the payout file to be generated automatically.

  1. Go to Setups > Payout Process Scheduling.
  2. Set up a new schedule with the following parameters:
    • Description: Assign a descriptive name for easy identification.
    • File Layout: Select the specific file layout template for the payout file.
    • Start Time: Define the exact time (on the hour) for the payout file generation process.
      • Note: The process can only be triggered once every 30 minutes.
    • Start Loan Agreement Date From: Specify the number of past days from the current date to include payout entries in the file generation.
    • Email Notifications:
      • Enable Email Notification: Select to receive an email upon successful execution.
      • Email Recipients: Select the users who should receive the email.
    • SMS Notifications:
      • Enable SMS Notification: Select to receive an SMS upon successful execution.
      • SMS Recipients: Select the users who should receive the SMS.
    • Enabled/Disabled: Check the box to activate or deactivate the scheduled process.
    • Payment to Client: Select the specific accounting event to which this scheduled process applies (e.g., "Payment to Client").

How to Use Batch Loan Payouts in MaxMoney

New Loan Creation

When creating a new loan for a client, the user must select the appropriate payout event before completing the active loan.

Batch Export Process

This process allows you to select and export a batch of loans into a file based on specified criteria.

  1. Go to Processing > Loan > Export Loan Payouts.
  2. You'll see various parameters to specify which loans to include.
    • Note: Loans previously exported will not be included again when you rerun the process.
  3. Select the date range, payout event, and the bank account associated with the file layout.
  4. Click the Finish-button to execute the process.

Export Loan Payout Reports and Logs

Export Loan Payout Report

This report lists all the loans that were included in the generated payout file.

Payout File

This is your batch file, containing the loan entries in the layout you configured.

Processing Log

This report provides a summary of the export process.

Process Log

  1. Go to Processing > Logs > Export Loan Payouts.
  2. A history of all payout processes is logged here.
  3. You can download the Report, Payout File, and Log File from this screen.
  4. Use the Details-button to view which specific loans were included in a particular batch export.

Payout File and Log Access Warnings


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.

 


MAXMONEY Developed by MYCOMAX MICROFINANCE SOLUTIONS. Novamesh 18/06/2026