Kaaj raises $3.8M in seed funding to power the future of small business lending 🎉Read the announcement
← Resources

Free lender worksheet

Commercial credit memo template with a worked example

A lending credit memo should explain the borrower, request, repayment capacity, risks, policy exceptions, and evidence behind the analyst’s assessment. Use this blank structure in your own committee format, then inspect a filled example with its source records and calculation.

By Kaaj editorial team ·

Editable plain-text files. No signup. All names, documents, figures, and rules in the worked example are fictional. They illustrate evidence preparation and human review, not a credit recommendation or required lender policy.

A credit memo structure you can adapt

Start with your credit policy and committee’s actual requirements. Record missing information explicitly rather than filling gaps with assumptions. This is a loan-underwriting memo, not an accounts-receivable credit note.

  1. Borrower and request

    Legal entity, owners, facility, use of funds, term, repayment schedule, and analyst.

  2. Evidence register

    Document ID, source, period, date received, verification state, and source location.

  3. Business verification

    Entity record, ownership, address matches, unresolved identities, and evidence dates.

  4. Financial spread

    Periods and entities in scope, line mapping, lender-defined formulas, adjustments, and source references.

  5. Bank activity

    Deposits, transfers, financing proceeds, ambiguous transactions, debt payments, and reviewer corrections.

  6. Debt service and coverage

    Existing and proposed payments on the same period, permitted adjustments, formula, and result.

  7. Equipment and collateral

    Invoice items, deposits, credits, requested funding reconciliation, and unresolved vendor or collateral questions.

  8. Policy and exceptions

    Rule, threshold, observed result, exception reason, mitigants, required authority, and approval state.

  9. Analyst assessment

    Verified facts, unresolved inputs, qualitative context, and the analyst’s proposed next action.

  10. Conditions and approval

    Missing items, owner, due date, reviewer changes, approver of record, and final disposition.

Fictional example · draft for review

Northwind Fabrication Example LLC

Request: $100,000 equipment facility. The fictional invoice totals $110,000, less a $10,000 deposit. The supplied scenario assumes $24,000 of proposed annual principal and interest. APP-01 · INV-01

Repayment analysis: the simplified worksheet produces $102,000 of annual cash available and $78,000 of combined annual debt service, or 1.31x coverage. Its formula comes from the fictional policy, not from monthly deposits. Check the calculation.

Bank activity: October deposits of $120,000 include a $20,000 transfer and $15,000 of financing proceeds. Candidate operating inflow is $85,000 after those exclusions. The statement balances reconcile; this does not establish revenue-classification accuracy or document authenticity. BANK-01

Open issues: the borrower has less than two years in business and the requested August and September statements are missing. Current-year financial performance, debt completeness, vendor verification, and collateral value remain unverified in this teaching file.

Analyst’s proposed next action: collect the missing evidence and route the time-in-business exception to the lender’s authorized approver. No approval or decline is recorded. A coverage result alone is not a credit decision.

Check the coverage worksheet

This example adds annual net income, depreciation, and interest expense, then divides by existing plus proposed annual principal and interest. Actual formulas and adjustments follow the lender’s policy.

Annual cash available
$72,000 + $18,000 + $12,000 = $102,000
Annual debt service
$54,000 + $24,000 = $78,000
Illustrative coverage
$102,000 ÷ $78,000 = 1.31x, rounded

Historical 2025 earnings are compared with an illustrative annual debt schedule. Current or forward coverage is not established. No other add-backs, distributions, taxes, intercompany eliminations, or guarantor cash flows are assumed.

Inspect FIN-01 · Inspect DEBT-01 · Inspect POLICY-01 · Read the DSCR guide

Inspect the fictional source records

These labeled excerpts are the complete inputs used for this example’s calculations. They are teaching records, not bank-issued PDFs, an actual state filing, or a real borrower’s full loan package.

APP-01 · fictional application

Applicant: Northwind Fabrication Example LLC
As-of date: November 14, 2026
Request: $100,000 equipment facility
Purpose: workshop equipment
Illustrative proposed annual principal and interest: $24,000
The payment is a supplied scenario assumption, not calculated from a quoted rate or term.

ENTITY-01 · fictional entity record

Legal name: Northwind Fabrication Example LLC
Formation date: January 10, 2025
Scenario status: active
As of November 14, 2026: less than two years in business
This is a fictional record, not a state lookup.

FIN-01 · fictional annual P&L excerpt

Period: January 1 through December 31, 2025
Revenue: $1,200,000
Net income: $72,000
Depreciation expense included above: $18,000
Interest expense included above: $12,000
No other add-backs assumed. This excerpt is supplied for the simplified worksheet only.

DEBT-01 · fictional debt schedule

Period for comparison: annual
Existing obligations, annual principal and interest: $54,000
Proposed facility, annual principal and interest: $24,000
Combined annual debt service: $78,000
Status: proposed schedule requires lender verification; no obligations are assumed paid off.

BANK-01 · fictional October statement excerpt

Period: October 1 through October 31, 2026
Opening balance: $15,000
Deposits: $120,000
Withdrawals: $110,000
Closing balance: $25,000
Deposit detail: $85,000 candidate operating inflows; $20,000 transfer from another business-owned account; $15,000 financing proceeds.
Balance check: $15,000 + $120,000 - $110,000 = $25,000.
The transfer ownership and financing treatment are supplied scenario assumptions. A real review must verify them.

INV-01 · fictional equipment invoice excerpt

Buyer: Northwind Fabrication Example LLC
Equipment: $100,000
Delivery and installation: $10,000
Invoice total: $110,000
Deposit: $10,000
Net requested funding: $100,000
No appraisal, market value, title status, or vendor verification is established by this example.

POLICY-01 · fictional evaluation rules

These are teaching assumptions, not a recommended credit policy.
Minimum time in business: two years
Illustrative coverage threshold: 1.25x
Cash available for this example only: annual net income + depreciation + interest expense
Debt service: existing plus proposed annual principal and interest
Documents requested: August, September, and October bank statements
August and September statements: not supplied
Any exception requires an authorized lender approver; none is recorded here.

Keep exceptions and missing evidence visible

Time in business
Fictional rule: two years minimum. Formation: January 10, 2025. As of November 14, 2026: not met. Mitigants and exception authority: not supplied. Approval: pending.
Document completeness
Requested: August, September, and October statements. August and September are missing; only October is included in these excerpts. Do not treat the three-month review as complete.
Coverage rule
Illustrative minimum: 1.25x. Calculated historical result: 1.31x. Met under the example formula, subject to verification of the source amounts and obligations.
Reviewer record
Reviewer, review date, changes, exception approval, conditions cleared, and final disposition: to be completed by the lender.

Test memo automation with the same file

Give each vendor the same permissioned package and your template. Ask the reviewer to trace five figures, correct one classification, identify missing evidence, and show the exception handoff. Measure preparation time and reviewer corrections separately from the final decision.

Kaaj drafts source-linked credit memos in the lender’s format for human review. Use the template to compare the work product with the memo your team would prepare.

Credit memo automation checklist · Compare credit memo software · Exception management guide