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:
- Navigate to Setups > Security >
Roles.
- Ensure the following resources are selected for
the relevant roles:
- Processing: Loan: Export Loan
Payouts
- Processing: View
Logs
File Layout Setup
- Go to Setups > File
Layouts.
- Define the number of headers,
trailers, and the format of your payout file.
- 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.
- Go to Setups > Bank
Accounts.
- Select the Payout Export
Account checkbox.
- Choose the specific file
layout you defined for payouts.
Ledger Setup
You'll need to set up a bank account ledger.
- Go to Setups > Accounting >
Financial Ledgers.
- Add a new ledger for your bank account.
Event Setup
Set up an event for the double bookkeeping entry
related to payouts.
- Go to Setups > Accounting >
Financial Event.
- Create the necessary event (e.g., "Payment to
Client").
CashBox Setup
Ensure your cash box is linked to the payout
event.
- Go to Setups > Branches > Cash
Boxes.
- Edit the relevant Cash Box.
- Under Financial Events, select
the checkbox for your payout event.
Payout Process Scheduling Setup
You can schedule the payout file to be generated
automatically.
- Go to Setups > Payout Process
Scheduling.
- 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.
- Go to Processing > Loan > Export
Loan Payouts.
- 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.
- Select the date range,
payout event, and the bank account
associated with the file layout.
- 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
- Go to Processing > Logs >
Export Loan Payouts.
- A history of all payout
processes is logged here.
- You can download the Report, Payout File, and Log File
from this screen.
- Use the Details-button to
view which specific loans were included in a particular batch export.
Payout File and Log Access Warnings
- When you click the Payout
file-button, you'll receive a
warning indicating how many times the file has been downloaded.
- The payout log records how many times the
payout file was accessed and by whom.
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.