FASB 91 Loan fee amortization software  

Financial Data Support Systems, Inc. 
Amortization Software Products
 Loan files: FASB Effective interest method
Loan Packages: Effective interest method
Merchant Cash Advances
FASB 91: All products
Bond  Purchasers: Effective Interest Method
Bond Purchasers:  Straight Line Method
Prepaid Expenses, Deferred Charges    
Deferred Income, Unearned Revenue
Fixed Assets, FF&E Depreciation    
Home page
About, contact us

FASB, GAAP compliant software
for a PC,
Shared network and
Cloud services supporting Windows


Loan Files:  FASB 91 Effective interest method software. 
Deferred fee income and expense amortization, NPV calculations
at the individual loan level for a file:
     Originated loans
     Purchased Loans
     Sold loans

      Loan Packages:  MBS, CMO, LSBO Packaged Loans page
      Merchant Cash Advances:  GAAP, FASB for MCA Daily Payments page

Generate GAAP, FASB income and expense recognition for any month

Loan Files
A loan file might be an Excel worksheet, service bureau extract, core system download, seller service remittance report ...
     Automatically import a loan file to software on your PC, shared network or a cloud based system running Windows.

New loans and Existing loans
For existing loans:
     Retain existing deferral balances and start using effective interest method forward.
          Start now or as of a prior date.
          Calculate income and expense recognition for prior month(s), prior year(s).

Loan Fee Income and Expense
A)  One or more fees for each loan can be known amounts which are included in the loan file.


B)  Fees for each loan are known amounts but not included within the loan file.
          The software can "match" Fees from an Excel file and assign them to each loan.

C)  Fees can be gross amounts which need to be assigned to each loan:
          Some costs might be billed as a single amount covering all services for the month (not broken down by individual loan).
          Simply assign a single amount to be distributed to some or all new loans.
          The software will calculate a Dollar Weighted Average for the sum of principal and
          distribute the percentage of applicable loan's principal divided by sum and assign the result.

D)  Use combinations of the above.

Scroll down for
     Price page with free demo.
          Evaluate the live software right now.
          Sample records.
          Your records.

1-800-245-8444 or Support@fdssi.com

     •  Automatically import an Excel file to the software

     •  Set Calculation Month

     •  View results.  Run reports.

     •  Automatically export to Excel

About the software ….

Operates on laptop, PC, workstations, network sharing devices and Cloud based systems running Windows.
Developed in Microsoft .NET Framework Visual Studio within Azure.

Operates on Macs with Parallels.
Parallels is a third party app that allows Macs to run Windows software.

FASB 91 loan fee recognition and reporting software for hundreds,
thousands of originated loans at the same time

     •  Originated, purchased and sold loans, new and existing         MBS, CMOs Packaged Loans
     •  Effective Interest Rate Calculation for all loans at the same time
     •  Up to 4 user defined 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 with recalculation of NPV (Net Present Value)
               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  

Amortize 1 to 4 deferrals
     •  Fee income
     •  Points
     •  Discounts
     •  Expense
     •  Closing costs
     •  Indirect lending charges
     •  Dealer fees
     •  Other deferred items

Import and amortize loan fees from
     •  Core system, service bureau
               Download your loan file with current balances to the software each month
     •  Seller servicer remittance reports
     •  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.

Available in a configuration to meet your needs ....

Configuration A:
Loans are NOT on a servicing system.

          Place loans and fees into an Excel template that comes with the software.
          Automatically import the Excel file with loans and up to 4 income and expense fees to the software.
          The software amortizes loan balances and fee recognition for the desired month.

Configuration B:
Loans and fees are both on a servicing system.

          Create an extract file from the servicing system each month containing loans and fees.
          Automatically import loans and up to 4 income and expense fees for each loan to the software.

Configuration C:
Loans are on a servicing system.
Loan fees are NOT on the servicing system.

          Create an extract file from the servicing system each month containing loans.
          Place loan numbers and up to 4 income and expense fees in an Excel Fees template that comes with the software.
                    The Excel Fees file can also contain debit and credit general ledger account numbers for each fee.
          Automatically import both loan file and Excel Fees file to the software which "matches"  loans and fees.
          More than 4 fees per loan?  The software can handle that, too.

Configuration D:
Loans and SOME fees are on a servicing system.
Additional fees are not.

          Create an extract file from the servicing system each month containing loans and whatever fees are on the servicing system.
          (if your loan servicing system handles FASB 91 amortization for some or all of its fees, exclude them from the extract file)
          Place loan numbers and additional income and expense fees in an Excel Fees template that comes with the software.
          Automatically import both loan file with some fees and Excel Fees file to the software which "matches"  loans and additional fees.

As a special APP
          Perhaps you just need FASB 91 software to provide some kind of interactive or unattended function during loan processing or servicing.
          You generate input data.  Launch APP which reads data and returns output for your processing.  APP opens and closes without intervention.

Other needs
    New loan type.  Software customization.
         The software is flexible with respect to processing and operational needs.
         Please contact us to discuss yours.
         1-800-245-8444 or
         email:   Support@fdssi.com

We offer ....

1)  Software
Fee amortization and accounting reports.
Scroll down for more information, price page and free demo.

2)  Outsourcing
Send a loan file.  Have us:
     Calculate effective interest rates, amortize fees and return a set of financial reports,
               One-time basis for current and prior periods or
               Recurring monthly basis
Request more information  Support@fdssi.com   or  1-800-245-8444

3)  Client Modules
Need something unique?
Special interface?
New loan product?
Recognition method?
Interactive App?
Something else?
No matter what kind of deferrals you need to amortize using the effective interest method:
     With up to 4 deferred amounts per record.
     We can create a dedicated module to meet your requirements.
Request more information  Support@fdssi.com   or  1-800-245-8444

  Price and free demo

Click to open and view Price page
Download a free demo from the Price page which includes:
     •  A live version of the software
     •  Sample records
     •  Ability to run all reports

Or contact us with any questions.

Sample Reports Packet

Request a free software overview containing:
     Sample reports
     Screen images
Mention any "must have" features and we'll include them with the samples.

Send request to Support@fdssi.com

Already amortizing deferred fees?
     The software can preserve current income and expense deferral balances.
     No adjusting journal entries.
 The software can also amortize deferred fees from original loan dates.

Customization available
Need something just for your operation?
Many of our clients had us modify the software to satisfy:
     •  Hybrid lending products
     •  Special interface requirements
     •  Read this, export that functions
               Use the software as a "background tool" to facilitate an internal processing function
     •  New loan programs
     •  Unique repayment methods
     •  Auditor requests
     •  Other proprietary, industry and competitive needs
Click here to Learn more



Free sample reports for YOUR loans

     •  We can provide you with free report samples for up to 15 of your loans

     •  Request our Excel loan data layout file

     •  Email the file

     •  We will generate and return an email with an Excel file containing your reports

Click to request the Excel loan file via email:  Support@fdssi.com

Our clients needed a FASB 91 solution for ....

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.


Click to open and view Price page
     Download a free demo from the Price page, too.

Or contact us with any questions.

FASB 91 Loan Fee Amortization
 Software for Windows® on a computer, laptop, shared network and cloud based systems
© 1995 - 2022 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