FASB 91 Loan fee amortization software  

 Financial Data Support Systems, Inc. 
      Software Products
Prepaid Expenses Amortization   
Deferred Income Amortization
Fixed Assets, FF&E Depreciation  
Excel Worksheet Amortization
Allocation to Cost and Profit Centers
Bond  Purchasers,  Level Yield Method
Bond Purchasers,  Straight Line Method
Bond Issuers, Level Yield or Straight Line
   Loan Fees, FASB 91 Amortization 
Dealer Fees, FASB 91 Amortization
FASB 91, All Products Page
MBS, GNMA, LSBO Loan Packages
Merchant Lending, FASB 91 daily pay
Home page
About, contact us

FASB, GAAP compliance for
hundreds, thousands of loans
at the same time.

Operates on a PC or shared network

Custom services available

     FASB 91 software.
     File calculation services.
     Custom coding.

FASB 91 loan fees amortization software and customization for

Monthly, quarterly, semi-annual and annual payments
Fixed and variable rate
     P&I loans
     Interest only
     Balloons with payment covering balloon term or longer period, such as 360 month P&I and 10 year balloon
     Constant principal amount payment such as $25,000 every quarter
     CPR - Conditional Prepayment Rate using declining balance %
     Daily drafts
     Straight line for non-FASB applicable loans
     Other user defined methods

Import and amortize fees for dozens, hundreds, thousands of loans at the same time.
FASB 91 effective interest rate calculations for 1 to 4 fees per loan.
Monthly income and expense deferral recognition.  P&L, balance sheet totals.
Lifetime month-by-month audit amortization schedules for each fee.
Operates on a PC or network sharing device.
Custom coding and services to meet unique and new loan program needs.     

Hard to

Mortgage and consumer loan data imported from in-house or service bureau systems.  Commercial loans in a spreadsheet.  Anticipated new loan products.

Merchant Lending
Import your master client file with daily payment setup and activity:  Face values, proceeds, bounces, renewals, modification extensions.
Also view Merchant Loans, daily cash payments page

Credit Unions
Indirect lending dealer fees, other existing and new  loan types.  Import from servicing system.  Import Aires report.

Manually Serviced, Boutique Loans
Import basic loan information and repayment terms from Excel each month.

Capital Management
High balance monthly, quarterly, annual payment loans imported from one or multiple worksheets.  360/360, 365/365, 365/360

CPA Firms
Import client loan files, calculate fee recognition for prior periods to current.

What our clients needed ....

Additional fees per loan:
     Client's servicing system could only amortize one deferred fee per loan.
     Our FASB 91 software can calculate individual effective interest rates and recognize up to four (4) unique fees per loan.
     The software also provides individual lifetime month-by-month amortization and recognition audit schedules for each fee.
     Client utilizes our software to amortize the additional fees and account for general ledger P&L and Balance Sheet reporting plus journal entry support documents and postings.

New type of loan offering:
     Client was introducing a new loan product with repayment activity for which their loan servicing system was unable to comply with FASB 91 recognition in a timely manner.
     We modified our software to accommodate their operational and reporting requirements well before the first loan was put on the books.

Manually serviced loans:
     Client had a small portfolio of high balance, high rate, short term loans which were not on an automated servicing system.
     Loans had various conditions including interest calculations of both 360/360 and 365/360.  Many loans were short term balloons with P&I calculations over a longer term.
     Our software provided an solution to their FASB 91 reporting requirements which also met the approval of their outside auditors.

Due diligence, M&A:
     Client was a CPA firm verifying whether a commercial bank under acquisition had properly recorded loan fee recognition.
               As it turned out, the bank had been immediately recognizing income and expense for most loans.  No deferrals.
     Our software was able to recalculate deferred loan fees under FASB 91 and provide fee recognition, P&L and Balance Sheet totals for a specified look-back period.
     Inasmuch as a short time frame was involved for completing this project, they sent loan files to us for processing and we returned desired reports in Excel including
     lifetime fee amortization and recognition schedules for selected loans.

Conversion to FASB 91:
     Client had been calculating loan fee income and expense recognition using the straight line method.
     Our software allowed the client to switch to FASB 91 recognition "as of" the end of their most recent fiscal year using remaining loan and deferral balances as of that point.
     The software also provided client the first year difference between FASB 91 vs. Straight Line by amortizing loans both ways for a 12 month period.

Cash payments vs. Accrued
     Client's loan servicing system recognized deferred fees with each cash payment.  Fee recognition did not sync with their monthly loan interest income which was cash plus accrued.
     Our FASB 91 software is an accrual based system which recognizes fee income and expense each month regardless of payment activity.

Capital management:
     Client loans had semi-annual and annual P&I payments.  Also had custom notes with fixed principal payments due at various times during the year.
     Our software was able to meet their their FASB 91 amortization and reporting requirements.

Independent comparison:
     Client was uncertain their service bureau was properly handling FASB 91 correctly for all of their loan types, some of which actually required a straight line method.
     They used our software to obtain parallel results, including straight line for applicable loans.

Special promotion:
     Client wanted to "test the waters" with an unusual product.
     Rather than incurring all the expense involved in changing FASB 91 recognition using their in-house system, they turned to us for an affordable, immediate resolution.

NDA confidentiality
In situations involving the exchange of confidential information, we will comply with
industry standard Non-Disclosure agreements and also provide a typical NDA which can be viewed here.

"Thank you so much for your help.
  It’s so refreshing to talk to someone who understands!"


"Our outside accountants just completed their audit.
This is the first year we've been using your software AND the first year we received a clean audit report."

          New York

About the software

FASB 91 loan fee recognition and reporting for hundreds, thousands of loans
     •  Effective Interest Rate Calculation for all loans at the same time
     •  Up to 4 unique income/expense items per loan
     •  Amortize Income and Expense for any month
     •  Amortize using:
               Original principal balances, rates, fee amounts and dates or
               Current principal balances, rates and fee balances
     •  Deferred fee income and expense general ledger Balances
     •  Accumulated and Book Values
     •  Monthly Recognition and Totals
     •  Yearly recap (calendar or fiscal) Recognition and Totals including prior year(s) restatements
     •  Changes during term:
               Effective interest rate recalculation due to rate changes
               Accelerated (additional) recognition of deferral for paydowns, curtailments, payoffs
               Full recognition of deferral balance for early payoff
     •  Audit and exams:
               Month-by-month lifetime loan fee detail recognition schedules
    •  Reports:
               View on screen
               Send to local or network printer
               Send to Adobe pdf
               Send to Excel

Supports all of these fee recognition methods at the loan level:
  •  FASB 91 income, expense amortization over
          Actual loan terms
          Balloon terms - Interest only, P&I based on longer term, fixed principal reductions
          Average portfolio life
          Fee amortization periods reduced for other reasons
  •  Straight line for non-FASB applicable
  •  CPR - conditional prepayment rate, declining balance percentage
  •  Other user defined methods

Amortize deferred fee income and expense for
     •  Mortgage loans
     •  Consumer loans
     •  Commercial and other loans
     •  Secured, unsecured
     •  Purchased discounts/premiums at the individual loan level   at the package level
     •  Monthly, quarterly, semi-annual and annual payments
     •  P&I amortizing
     •  Interest only:
               As interest only and
               Interest with periodic principal payments of a constant amount (e.g., $25,000 every three months)
     •  Balloons:
               Interest only with a balloon
               P&I over balloon period
               P&I over longer term such as 5 year balloon with 30 year P&I
               P&I over average portfolio life
     •  Constant $Amount payment, such as lease payments
     •  % reduction of remaining principal balance, such as 8.3% of this month's balance, then 8.3% of next month's balance
               Typically for loan packages using a CPR (conditional prepayment rate)
     •  Fixed rate
     •  Zero rate
     •  Variable rate
     •  360, 365, 366, 365/360
     •  FASB, GAAP compliant
     •  Customization available  

Import and amortize loan fees from
     •  Core system, service bureau
               Download your loan file with current balances to the software each month
     •  Aires - credit union report
     •  Manually serviced loans
     •  Excel
               A preformatted worksheet comes with the software.
               Enter or copy loan data to the worksheet once and the system takes care of everything else
               import the worksheet each month with current loan balances, rates, paid off loans, new loans ....
     •  Other files and sources

Accrual basis accounting
     •  Fee Recognition is NOT based on payment transactions
     •  Fee Recognition occurs every month regardless of whether a payment was made because
          interest income is accrued every month.

Income and expense recognition for any month in a matter of seconds.

Audit and Exam schedules on demand

Debit and credit recap

General ledger entries

Special features
     •  Paydowns, curtailments
              Accelerated (additional, proportionate) fee recognition
     •  Payoff, sale
              Complete fee recognition

Original loan data or current balances
Calculate income and expense from
     •  Original payment dates forward
Or ....
     •  Preserve and amortize current balances
     •  Software will calculate remaining term and effective rate based on principal, note rate and payment
     •  No adjusting journal entries
     •  Start using FASB 91 today

About the software
  •  Written in Microsoft's .NET Framework
  •  Operates on any MS product line
  •  Install to PC or network sharing device

About our company
  •  In business since 1982
  •  Market niche is Amortization Software
  •  Added FASB 91 software in 1987
  •  On the Internet since 1995
  •  First page rankings on Google and Bing

FASB 91 amortization services
Need answers NOW?
Audit?  Due diligence?  What if question?
Income, expense projections?
Do what others have done:
  Send us a loan file   View our NDA
  Get fee recognition reports for
       Any month
       Range of months
       Any 12 month period
  More info  Support@fdssi.com  


Unique situation?  Unusual records?  New type of fees?
Different file layout?  File source?
Special internal or regulatory report?

Different configurations of the software or other products we offer may already meet your needs.
If not, we can write custom code and embed your private module within the existing nuts and bolts portion of the software.


Please contact us for:
     •  Software prices - operate on a PC or network sharing drive.
     •  File calculation services - send a file, receive a complete set of reports in Excel.  One time or recurring monthly basis.
     •  Free demo
     •  Other information


FASB 91 Loan Fee Amortization Software for Windows® PC, laptop, workstation and network sharing by
© 1995 - 2018 Financial Data Support Systems, Inc.
Home page        |        About us       |        Contact us       |        Site map

TRAC leases, Lease amortization, amortize lease fees, cost, FASB 91 lease, leasing