Loan Servicing and ED-209 Reporting
Most systems make you choose. Loan servicing software prices the payments but has never heard of a federal grant. Grant systems know the reporting but cannot amortize a loan. ExecutivePulse does both: real amortization schedules, payments allocated across fees, interest and principal, days past due calculated from the schedule itself, and EDA Form ED-209 with its Portfolio Loan List at the end of it.
A Real Ledger, Not a Spreadsheet With Logins
Every figure the fund reports is calculated from the loan's own schedule and payment history. Outstanding principal, days past due and next payment due are recomputed after every payment and every reversal, so the portfolio is accurate the moment a check is recorded instead of the next time somebody updates a column.
Nothing is overwritten. A payment entered in error is corrected by a reversal that mirrors it, and both entries stay on the ledger, because that history is what the cumulative figures in Part III of Form ED-209 have to reconcile against.
What's included
- Amortization Schedule Generation
- Payment Allocation: Fees, Interest, Principal
- Days Past Due Calculated From the Schedule
- Reversals That Preserve the Audit Trail
- Loan Modification and Consolidation
- Creditable Job Cohorts in FTE
- EDA Form ED-209, Parts I to IV, and Portfolio Loan List
- 12-Stage Loan Lifecycle Pipeline
- Public Loan Application Intake Form
Loan Servicing Features Built for EDOs
Public lending has requirements ordinary loan software has never had to meet. Every calculation, every record type, and every export here was built around those requirements.
Amortization Schedules
Principal, annual rate, term in months and first payment date produce the full schedule: payment number, due date, scheduled amount, interest portion, principal portion and ending balance. Held to the cent, with the final payment absorbing rounding so the loan closes at exactly zero.
Payment Allocation
Payments apply to outstanding fees first, then interest, then principal. A payment smaller than the interest owed is recorded as interest only and leaves principal untouched, so a struggling loan's balance stays honest. Principal-only curtailments skip the interest step.
Days Past Due, Calculated
Delinquency is measured against the loan's own schedule, not typed into a field. It refreshes after every payment and reversal, so a borrower who catches up clears immediately and a loan that slips is flagged without anyone reviewing the portfolio.
Reversals, Never Deletions
A payment recorded in error is undone by a reversal that mirrors it. Both entries stay on the ledger. Editing or deleting the original would be simpler and would destroy the history that the cumulative figures in Form ED-209 Part III are reconciled against.
EDA Form ED-209
The RLF Financial Report exports as one workbook with a sheet per part: Part I grantee data, Part II financial status, Part III the portfolio loan list, and Part IV both the performance measures and the CDE section, plus a validation sheet that checks the filing before you submit it. The Portfolio Loan List also exports on its own in the layout EDA asks for.
Creditable Job Cohorts
Jobs are recorded as dated cohorts in full-time equivalents, created and retained. Only creditable cohorts total: one outside EDA's five-year window, or one failing the 18-month persistence test, is excluded from the record exactly as it is from the filing. The number on the loan is the number you file.
Modifications and Consolidation
Restructure a loan when a borrower's circumstances change, or consolidate several into one, and the schedule rebuilds from the new terms. The superseded schedule is retired rather than erased, so the loan's full history survives the change.
12-Stage Loan Pipeline
Full lifecycle: Inquiry, Pre-Application, Application Received, Under Review, Credit Analysis, Approved - Pending Close, Closed/Active, In Repayment, Delinquent, Forgiven, Written Off, Paid Off. Every stage change is timestamped.
The Whole Credit File
Collateral items, project funding sources, prior loans, lender fees, loan documents and compliance reports are all real records attached to the loan, not notes in a field. Open a loan and the credit file is there.
Public Application Intake
Embed a loan application on your own website. Applicants fill it in without a login, and submissions land as loan records in the pipeline with company and contact already attached. Nothing gets rekeyed.
Committee Workflow
Because days past due and outstanding principal are stored on the record, your workflow can act on them. Send a reminder at 30 days, notify the loan officer at 60, require a committee review at 90. Each transition is recorded with who made it and when.
Program Organization
Run a microenterprise fund, a gap financing program and a facade program side by side. Capital deployed, outstanding balance, delinquency and jobs impact break out per program for board reporting and per funder.
Why Two Systems Becomes One
Most RLF programs run a spreadsheet, or a loan servicing package bolted to the side of their CRM. Ordinary loan software prices payments well and has never heard of a federal grant, so the reporting half stays manual either way.
A spreadsheet, or servicing software on the side
- Balances recalculated by hand, or held in a system the CRM cannot see
- Delinquency noticed when a borrower stops answering the phone
- Payment history in the accounting package, away from the borrower record
- Jobs counted in a separate survey, with no test for what is creditable
- Form ED-209 assembled by hand from several files each period
- A correction made by editing the row that was wrong
With ExecutivePulse
- Outstanding principal computed from the schedule after every payment
- Days past due measured against the schedule, refreshed on every entry
- Payment history on the loan record, beside the borrower and the credit file
- Job cohorts tested against EDA's five-year window and 18-month rule
- Form ED-209 and the Portfolio Loan List generated from the same ledger
- A correction made by a reversal, with both entries left on the record
Frequently Asked Questions
Common questions from EDOs evaluating revolving loan fund management software.
How many pipeline stages does loan management have?
12 stages covering the full loan lifecycle: Inquiry, Pre-Application, Application Received, Under Review, Credit Analysis, Approved - Pending Close, Closed/Active, In Repayment, Delinquent, Forgiven, Written Off, and Paid Off. Every stage change is timestamped, giving you a complete history of where each loan has been.
Does ExecutivePulse generate EDA Form ED-209?
Yes. ExecutivePulse produces the RLF Financial Report, Form ED-209, as a single workbook with a sheet per part: Part I grantee data, Part II financial status, Part III the portfolio loan list, and Part IV covering both the performance measures and the CDE section. A validation sheet ships in the same workbook so the filing can be checked before it is submitted. The ED-209 Portfolio Loan List also exports on its own, in the file layout EDA asks for.
Does it calculate amortization schedules?
Yes. Give it the principal, the annual rate, the term in months and the first payment date, and it builds the full schedule: every payment number, due date, scheduled amount, interest portion, principal portion and ending balance. Figures are held to the cent, and the final payment absorbs rounding so the schedule closes exactly at zero.
How are payments applied to a loan?
Payments are allocated in order: outstanding fees first, then interest owed, then principal. A payment smaller than the interest owed is recorded as interest only and does not reduce principal, which is what keeps a struggling loan's balance honest. Principal-only curtailments skip the interest step. A payment is undone by recording a reversal that mirrors it, never by editing or deleting the original, because the cumulative figures on Form ED-209 Part III are reconciled against that history.
How does delinquency tracking work?
Days past due and outstanding principal are calculated from the loan's own schedule rather than typed in, and they are recalculated after every payment and every reversal. A payment that brings a borrower current clears the flag immediately. A loan that slips past due is flagged without anyone reviewing the portfolio. Because the figures are stored on the record, your workflow can act on them: send a reminder at 30 days, notify a loan officer at 60, require a committee review at 90.
Can we track multiple loan programs?
Yes. Loans are organized by program, so a microenterprise fund, a gap financing program and a facade program each get their own view while sharing one system. Capital deployed, outstanding balance, delinquency and jobs impact all break out per program for board reporting and per funder.
Does it track jobs created and retained for EDA reporting?
Yes, and it tracks them the way EDA counts them. Jobs are recorded as dated cohorts in full-time equivalents, split into created and retained. Only creditable cohorts are totaled: one outside EDA's five-year window, or one that fails the 18-month persistence test, is excluded from the record exactly as it is excluded from the filing. The number on the loan is therefore the number that gets filed, which is what keeps a cost-per-job figure defensible in front of a board or a funder.
Can borrowers apply online?
Yes. A public loan application form can be embedded on your own website, with no login for the applicant. Submissions arrive as loan records in the pipeline with the applicant's company and contact already attached, so nothing has to be rekeyed.
How are compliance reports connected to loans?
Compliance Reports are child records linked to the parent loan application. Every compliance milestone, covenant check, and reporting deadline lives attached to the borrower record - not in a separate spreadsheet that can get out of sync. When you open a loan, the full compliance history is right there.
