Automated origination & PAR, ECL and collections
Originate, schedule, collect, and watch PAR in one platform. The loan report shows aging with DPD-based ECL staging, collections split by principal and interest, maturity concentration, and a cash-flow calendar — then posts disbursements and receipts to the general ledger.
Aging & ECL schedule
All branches · Lend out · 207 active contracts| Borrower | DPD | Stage | Exposure | ECL |
|---|---|---|---|---|
| Ngozi Eze | 0 | S1 | ₦4.62m | ₦46k |
| Ikeja Traders Co-op | 18 | S1 | ₦8.10m | ₦81k |
| City Wholesale | 47 | S2 | ₦3.90m | ₦585k |
| Blessing Mart | 112 | S3 | ₦1.30m | ₦650k |
From offer sheet to collection calendar
Officers originate a contract, disburse against privileges, collect against the schedule, then work risk from the same live book.
Originate
Partner, principal, interest style, EMI or bullet schedule, fees, officer, optional collateral notes.
Disburse
Installments with principal/interest split. Privileges gate who can put money on the book.
Collect
Receipts allocate to the schedule. Late rules accrue after grace. Early settlement can rebate interest.
Watch risk
Aging, PAR, ECL stages, forecast cash in, and concentration — export PDF or Excel when the board asks.
Schedules credit teams actually use
Stop rebuilding repayment tables in Excel for every product. AiBiz generates the instalment plan from the contract: EMI, equal principal, interest-only with a bullet at maturity, or principal now and interest later. Flat or reducing balance, monthly or annual basis, plus principal grace periods.
- Origination / processing fees with VAT and WHT where configured
- Late rules: grace days, then fixed, daily, or percent penalties with caps
- Convert a stuck receivable or unpaid sale into structured terms
- Branch-scoped officers; central book for the credit manager
LN-8831 · Ngozi Eze
Lend out · Ikeja branch · Officer: Kemi| Term | |
|---|---|
| Principal | ₦5,000,000 |
| Interest | Reducing · 18.5% annual |
| Schedule | EMI · 12 months |
| Grace | 0 principal periods |
| Origination fee | ₦50,000 |
| Late rule | 2% after 5 grace days |
Principal and interest stay split on every receipt
Each instalment shows principal versus interest before anyone collects. Receipts allocate against the schedule. Officers can take a payment without rewriting the contract. Early close can rebate unearned interest; waivers are recorded, not hidden in a notebook.
- Open the contract from the aging row — same loan ID throughout
- Collect without the right to change rate, tenor, or delete the book
- Same partner record as retail credit or service invoices if you also trade
LN-8831 · Ngozi Eze
Reducing · 18.5% · 12 months · EMI| # | Due | Principal | Interest | |
|---|---|---|---|---|
| 4 | 30 Apr | ₦382k | ₦61k | Paid |
| 5 | 31 May | ₦388k | ₦55k | Due |
| 6 | 30 Jun | ₦394k | ₦49k | Open |
Days past due, stages, and an indicative provision
The aging tab is the credit meeting view: every active contract with disbursement date, due date, outstanding principal, interest, fees, total exposure, DPD, stage, ECL %, and ECL amount. Filter by branch, partner, stage, or aging bucket. Export the schedule to PDF or Excel.
- Stage 1 performing (0–30 DPD), Stage 2 watchlist (31–90), Stage 3 impaired (>90)
- PAR 30, PAR 90, NPL ratio, and coverage on the same summary
- Indicative ECL from DPD — not a full IFRS 9 model, and labelled as such
| Bucket | Count | Amount |
|---|---|---|
| Current | 186 | ₦71.2m |
| 1–30 | 14 | ₦8.1m |
| 31–90 | 5 | ₦3.9m |
| 90+ | 2 | ₦1.3m |
Disbursed, recovered, and what is still on the book
See total contracts (draft, active, settled), principal disbursed versus repaid, interest accrued versus collected, fees paid versus owed, and weighted average rate on outstanding principal. Drill into the contract list without leaving the report.
- Weighted average interest rate on the live book
- Filter lend-out versus money you borrowed from a bank
- Search by borrower or loan ID across branches
| Status | Contracts |
|---|---|
| Active | 207 |
| Draft | 11 |
| Settled | 84 |
What actually hit the account this period
Collections are not a single lump. The report splits total collected into principal recovered, interest income, and fees — then lists each receipt with loan ID, borrower, type, and remark. Date ranges from today through the year, plus custom.
- Open the receipt or the loan from the same row
- Branch and partner filters so an officer sees their book
- Same numbers that already posted to cash, bank, and interest income
This month
1–30 Apr · All branches| Receipt | Borrower | Type | Amount |
|---|---|---|---|
| RC-4412 | Ngozi Eze | Interest | ₦61k |
| RC-4412 | Ngozi Eze | Principal | ₦382k |
| RC-4398 | Ikeja Co-op | Fees | ₦25k |
When the book comes due — and who holds it
Maturity timebands show how much exposure falls in each window, so ALCO is not guessing from a printed ageing list. Top-borrower concentration flags when a few names carry too much of the portfolio.
- Exposure and % of book per timeband
- Top borrowers with loan count and share of portfolio
- Same branch / partner filters as the rest of the report
| Timeband | Loans | Exposure | % |
|---|---|---|---|
| 0–30 days | 22 | ₦6.4m | 7.6% |
| 31–90 days | 41 | ₦18.1m | 21.4% |
| 91–180 days | 68 | ₦29.8m | 35.3% |
| 181–365 days | 54 | ₦22.0m | 26.0% |
| > 1 year | 22 | ₦8.2m | 9.7% |
| Top borrower | Loans | % |
|---|---|---|
| Ikeja Traders Co-op | 3 | 9.6% |
| Ngozi Eze | 1 | 5.5% |
What should hit the account this week — on a calendar
Loan Forecast looks forward: expected receipts on loans you issued and outflows on money you borrowed. Horizons from a week to about a year. The calendar marks inflow, outflow, or both, and whether the day is still due, partial, or paid. Click a date for the contracts behind it.
- Filter by partner or a single loan transaction
- Scheduled versus actual so Friday is not a surprise
- Lending in and borrowing out in the same cash plan
April cash plan
Expected in ₦18.4m · out ₦2.1mInterest income that lives on the books
Recognition settings, WHT on interest and fees, and the same banks, branches, and user roles as the rest of the company. A supermarket that also runs staff loans does not need a second database.
- Disbursements and receipts post principal and interest automatically
- Same till and service sales as the loan book when you also trade
- Profit and loss, balance sheet, and tax from one ledger
| Posted today | |
|---|---|
| Disburse LN-8840 | ₦2.00m principal |
| Receipt RC-4412 | ₦443k P+I |
| Origination fee LN-8840 | ₦20k |
Ask the loan book in plain English
Ask for overdue lists, expected collections, PAR, or who is concentrating the book. Answers come from live reports, not a guess.
What every business gets
Hotel, shop, factory, loans, NGO, or a firm — you still get accounts, tax, payroll, and control over who can see and change what.
You decide who can do what
Give each staff member their own login. Turn rights on or off: sell, discount, delete, open cash, change prices, see other branches, or open the books. A cashier can work the till without seeing payroll or bank.
Check the business from your phone
Owners and managers can see sales, stock, and staff activity from a phone, tablet, or laptop — without sitting at the shop or hotel.
Accounting that posts itself
Sales, purchases, deposits, and payments go into the books, profit and loss, balance sheet, and tax accounts. You do not retype them into another package.
Ask in plain English
Ask about occupancy, best sellers, overdue loans, or cash on hand. Answers come from live reports, not a guess.
Payroll and expenses in the same place
Salaries, deductions, allowances, running costs, and bank transfers sit next to your day-to-day work.
Several branches, one business
Run stores, hotels, factories, or field offices under one organisation. Look at one branch, or all of them together.
AiBiz vs. traditional MFI software
See why credit teams leave Excel schedules and standalone loan packages behind.
| Capability | AiBiz lending platform | Traditional MFI / spreadsheet lending |
|---|---|---|
| Origination & schedules | EMI, fixed principal, bullet, deferred interest, fees, and penalties on one contract | Offer sheets in Word and repayment tables in Excel |
| Accounting integration | Disbursements and receipts post principal, interest, and fees automatically | Weekend journals to catch the loan book up to the GL |
| Portfolio risk | Aging, DPD stages, PAR 30 / 90, NPL, indicative ECL, forecast, and concentration | Manual bucket lists that go stale overnight |
| Collections | Receipts split P/I/fees, officer lists, early-settlement math on the contract | Officers chasing from printed aging reports |
| Cash-flow forecast | List and calendar of expected inflows and borrowing repayments | A separate spreadsheet, if anyone kept it current |
| Lend and borrow | One module for money out and money in, same partners and banks | Loan software plus a bank-loan workbook |
| Staff access | Each officer gets a login. Collect without rewriting contracts or seeing payroll | Shared passwords, or everyone in the same Excel file |
| AI credit assistant | Ask for overdue lists and expected collections in plain English | None — static legacy menus |
Frequently asked questions
Do you support flat rate and reducing balance?
Yes. Contracts support flat or reducing interest, on a monthly or annual basis, plus origination fees and late-fee rules (fixed, per day, or percent, with grace days and caps).
What repayment schedules can we originate?
EMI (equal instalments), fixed principal, interest-only with a bullet principal at maturity, and principal instalments with deferred interest. You can also set principal grace periods before amortisation starts.
Can we lend and also track money we borrowed from a bank?
Yes. Filter reports by direction: money you lent out, or money you borrowed. Unpaid sales or purchases can be converted into structured terms.
How do we watch portfolio risk?
The loan report has four views: aging with DPD-based ECL staging, portfolio overview, collections (principal / interest / fees), and maturity timebands with top-borrower concentration. PAR 30, PAR 90, and NPL sit on the aging summary.
Is the ECL figure a full IFRS 9 model?
No. Staging follows days past due (Stage 1 performing, Stage 2 watchlist, Stage 3 impaired) and applies indicative provision rates to exposure. It is a practical credit-risk view, not a full IFRS 9 expected-credit-loss engine.
What does Loan Forecast show?
Expected receipts on loans you issued and repayments on money you borrowed, over a horizon up to about a year. List and calendar views show scheduled versus collected, with due, partial, and paid status.
Do repayments post into accounting automatically?
Yes. Disbursements and receipts split principal, interest, and fees according to the schedule and your recognition settings, including VAT on fees and WHT where configured.
Can loan officers collect without changing contracts?
Yes. Each officer gets only the rights you give them. They can collect and work their book without changing interest, deleting contracts, seeing payroll, or opening every branch. Sensitive changes are logged.
Can we export the loan report?
Yes. Aging schedules export to PDF and Excel/CSV. Officers can print from the same filters they use on screen (branch, partner, stage, aging bucket).
Can we run a shop or services with the loan book?
Yes. Retail sales and service invoices share the same partners, banks, branches, and ledger as the loans. A supermarket that also lends does not need a second system.
Run the loan book and the accounts together
Board a contract, generate the schedule, collect with principal and interest already posted, and watch PAR from a live aging report.
One intelligent platform. Built for your industry.
Industry workflows, accounts, several branches, and an assistant you can ask in plain English — in the same system.
Hotel & Hospitality
Reservations, guest billing, restaurant and bar, expenses, payroll, tax, and RevPAR — in the same hospitality platform.
Explore Hotel & Hospitality →Retail & Wholesale
High-speed POS, barcode scanning, batch and expiry tracking, multi-store transfers, and wholesale pricing in one cloud system.
Explore Retail & Wholesale →Manufacturing & Production
Default BOMs, production runs that consume materials, batch costing, and a production report with ranking and ₦ per unit — then sell finished goods from the same stock.
Explore Manufacturing & Production →NGO & Non-Profit
Donor and donation tracking, maker-checker vouchers, project tagging, field offices, and audit logs — with tax and payroll.
Explore NGO & Non-Profit →Services & Consulting
Service catalogs, quotes, VAT/WHT invoices, gross-margin service reports, project profitability, and client aging.
Explore Services & Consulting →