GroupsRUs Report
GroupsRUs Insurance Report
Specification
Overview & Purpose This
report allows microlenders to generate the GroupsRUs Insurance Report for their
entity. It consolidates two key data streams into a single integrated
view:
New Loans: Similar to the
Global Loan Protection Loan
List Report. Receipts & Reversals:
Similar to the Global Loan Protection
Premium Receipt Report. Key Business Rules & Requirements
Excluded Data: Bad debt recovery must be omitted from the report.
Receipt Reversals &
Disputes: Reversal transactions must be included and
assigned the Sub-Type Receipt Amount
Formatting: Standard receipt amounts in Column AD must display as
negative values.
Capital Amount Inclusion: The Capital Amount (Column T) must be populated for all
new loan entries.
System Adjustments: The
System Setup & Navigation
Permissions: Navigate to
Accessing the Report:
Navigate to Payment Mapping: On
cash receipts, map Report Field Mapping Catalog
Loans: Total loan amount.
Receipts: Sum of
If GroupsRUs Policy is • Loans: • Receipts: If GroupsRUs Policy is • Loans: GLP Insurance Total Premium (incl.
VAT)
• Receipts: Split payment to an AET account. If
'Dispute'. Reversal amounts in Column AD must
display as positive values.
GroupsRUs
Integration Report must be updated
for the specific Micro Lending Entity (MLE) to mirror these
outputs.
MAXMONEY > Setups >
Security > Roles and enable GroupsRUs Integration
Report for authorized
roles. MAXMONEY > Reporting >
Insurance > GroupsRUs Integration Report.AmountToAllocateAgainstClient to indicate
where the branch allocated cash payments for Voluntary Life Insurance
(MAXUP).
Col
Field Name
Description & Data Source
Mapping
A
Branch Code
GroupsRUs Branch Code ( MaxMoney > Setups
> MAXUP > GroupsRUs Setup > GroupsRUsUserSetup > Branch
Code)
B
Entity Name
Name
of the entity
C
Branch Name
Loan
Home Branch Name
D
Group Type
RECEIPT (for
receipts) or LOAN (for new loan
creation)
E
Sub
Type
Event Attribute Description (for receipts) or Loan Status
(for new loans)
F
ID
Number
Client ID Number or Passport Number
G
Surname
Client Surname
H
Name
Client Name or Initials
I
Loan
Nr
Loan
Number
J
First Date
First instalment date
K
Period
Total number of loan instalments
L
Frequency
Loan product repayment frequency
M
Created On
Receipt creation date or Loan creation
date
N
Created By
Blank
O
TransactionDate
Transaction date (receipts) or Loan agreed date (new
loans)
P
Operator
Blank
Q
Cashbox
Blank
R
Description
Event Description
S
Ref.
Transaction Batch Code (receipts) or Loan Invoice
Transaction Batch Code (loans)
T
Capital
Capital amount disbursed on a new loan
U
Interest
Blank
V
Cost
Blank
W
Repay Cost
Blank
X
Late Int.
Blank
Y
Overpay
MaxMoney_Receipt.AmountToAllocateAgainstClient
Z
Insurance
Sum
of Column AM + Column AI
AA
Ini. Fee
Blank
AB
Serv. Fee
Blank
AC
VAT
Blank
AD
Total
AmountToAllocateAgainstLoans and AmountToAllocateAgainstClient (displayed
negatively for normal receipts; positively for
reversals).
AE
Contact No
Client cellphone number
AF
Client Email
Client email address
AG
Client Address
Physical Address (Lines 1–3) and Postal
Code
AH
Reference / Policy No
Payment Allocation Ref (if GroupsRUs Policy
is True)
AI
Voluntary Life
True:
(Instalment Count) ×
(MAXUP Monthly Fee)
MAXUP Product Total
Monthly Fee
AJ
NewGroupsRUsSilver
Blank
AK
NewGroupsRUsGold
Blank
AL
NewGroupsRUsPlatinum
Blank
AM
NewGroupsRUsCreditLife
True:
(GLP Total Premium
incl. VAT) / (Instalment Count)
AN
SplitAmount
Payment Allocation Sent =
True:
((GLP Total Premium incl. VAT)
/ (Instalment Count)) + (MAXUP Monthly
Fee)