|


THE
LOAN TRACKER
is
ABA’s Loan Tracking System, which is the product of more than 16
years practical experience in Micro Lending. it came up from real
market needs and reflected the real demand required by ABA staff to
evaluate and follow up .The System can be rapidly modified to meet
country-or institution-specific requirements.
Loan Tracker in ABA:
-
Tracking more than
170,000 borrowers with 500,000 loans and a total amount of loans around
1.5 Billion L.E.
-
It is now operating in 35
branches of ABA located in 5 different governorates
Loan Tracker now is working in many other NGO's:
•
•
Inside Egypt
Outside Egypt
•
Cairo
Kingdom of Bahrain
•
Alexandria
Yemen
•
El Gharbeya
Croatia
•
Bany Swief
•
Sohag
•
El Menia
•
Assiut
•
Quena
•
El
Fayoum
•
Sinai
•
Aswan •
Integrated
systems to Loan Tracker:

MAIN ASPECTS AND
FEATURES OF THE LOAN TRACKER:
-
Rely on ORACLE database server technology (the
most powerful database worldwide). -
Can handle both individual and group
lending methodologies. -
Bilingual (Arabic & English). - Step-by-step loan set-up. - It is flexible and includes many
variables that can be set according to
requirements such as: Rate of
interest, different repayment schedules, different currencies,
Bad debt provision percentages,
etc. -
Client’s history and
details could be retrieved by name or part of, as well as the
client’s code -
The system can generate any number of reports whether statistical or
analytical which help in monitoring and
evaluation. -
The reports could
be produced as needed. -
The reports
are also produced at different levels of the administration from the
field officers to the executive director. - Generated reports include: Loan activity
report (by gender, activity, location, loan size,
loan term, sector, etc), repayment forecast, delinquency tracking,
repayment rates, penalties on late repayments,
client’s status report, client’s profile,
performance evaluation (field officers, branch
managers, branch overall performance, etc),
incentive calculation according to performance,
desertion rate calculations, calculation of the
portfolio at risk, income statement reports balance sheet reports,
cash flow reports, etc. -
A unified
user-friendly graphical user interface (GUI) across all
screens. -
An accurate sub-system for
data and application security allowing various
authorities and privileges at several levels
from accessibility to the system, screen level and
down to field and screen item level. - Capable to be installed in any type of
infrastructures up to multi-sites business units,
whether connected by leased line or dial-up telephone lines
providing flexibility regarding on-line batch data
processing. -
Comprehensive auditing
to keep track of any system transaction by logging
data modifications and the user responsible for
the change and the timestamp (Journal).
- Comprises a fast and easy-to-use General
Ledger System (GL), where all financial transactions
are accumulated and used to generate financial statements and
various reports. It could import and store journal
entries automatically generated in other modules
(Loan tracker).
MAIN OPERATIONS:
-The
system automates all different operations required for the loan
cycle.
-Loan
disbursement
-Loan repayment
-Loan reschedule
-Penalties
(automated calculations)
-Loan settlement off
-Loan write off
(social and financial).
-To
every transaction there is a reverse transaction.
-The
system can easily track all historical transactions to any specific
user.
-The system saves the information of
rejected clients as well as the information of approved ones so it
can give warning reports if any rejected client tried to apply
again.
-Every client could be linked to a
group of partners or grantors and the system could discover if any
of these partners or grantors applied for a new branch
Outputs and Reports:
-Contains
a lot of statistical and analytical reports that help in decision
making and strategy monitoring.
-Portfolio at risk analysis
-Repayment analysis and
Repayment percentage.
-Classification of clients
-Loan status report
-Delinquency analysis
-Productivity indicators
-Performance measurements
-All financial and loan performance indicator are reported by the
system to support different management levels.
-Capable to break down any analysis to various levels and
categories.
-Integrates with other financial system and give consolidated
financial figure and indicators.
-System is able to evaluate and rank credit officers via a very
powerful point system.
-System could be linked to a strong incentive system related to
loan performance. -It could evaluate the clients according to their past repayment
records and rank them to various levels.
|