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  Issuers: Effective Interest 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
Effective Rate and NPV calculations at the loan level:

     Originated loans
     Purchased Loans at the individual loan level

Scroll down for
     Highlights,  Price page and  free demo

Hard to find
(including custom)
GAAP
Amortization
Software to run on a
PC,
Network sharing or
Cloud based system
supporting Windows


MCA - Merchant Cash Advances discount amortization software








































































Existing loans:

 Use a Conversion file to preserve fee income and expense balances as of the conversion month:

     •  Convert at any time:
     •  Convert as of last month, end of prior fiscal year, some other month.


  No Conversion fee balances?
     •   The software can amortize fees from the loan's original date forward.


 Been using straight line or another method on a Gross monthly fees basis?
     •  The software can distribute gross deferral balances to individual loans using Dollar Weighted principal balances.

 











Available in these Configurations ....


Configuration 1
Loans are on a service bureau or core system.
Originated loans.  Serviced loans.


Download/create an extract file in Excel each month.
     Existing loans can be converted as of the current date
     or a prior date.  Deferral balances can be preserved.

Deferred fee income and expense can be:
      A)  In the extract file.
      B)  In a separate Excel "Fees" file which the software will
           also import and "match" fees to loans.
      C)  As a "Gross" amount for new loans which the software
           will distribute on a dollar weighted basis to new loans.

Multiple fees per loan.
      Supports 1 or more different fees per loan.  

Automatically import the Excel file to the software.
     Amortize 1 deferral at a time.
     Amortize all deferrals at the same time.

Effective Interest Rates:
     Calculates Effective Interest Rates for all loans
     and each deferral.

Totals provided for:
     Original Deferrals
     Current month income and expense recognition
     Accumulated recognition
     Deferral balances
     Book Value NPV (Net Present Value)

Verify results.
     Create lifetime Deferral recognition schedule for any loan.
     Export to Excel.

Recalculation of Effective Interest Rate and NPV:
     The software maintains a History file for prior months,
     allowing it to detect and adjust for:
     Rate changes.
     The software changes the rate, calculates a new
     payment and Effective Interest Rate
     Excess principal reductions.
          Software recognizes additional portion of deferral and
          calculates a new Effective Interest Rate and NPV.
     Payoff date or principal balance to 0.00.
          Software recognizes remaining deferral balance.

Missed, late payments:
     The software operates on an accrual basis and thus
     "makes" a payment and recognizes a deferral
     as if a payment had been made even if Principal balance
     has not changed from last month's History file balance.

Monthly accounting reports:
     General ledger subsidiary listing.
     Journal voucher posting document.
     General ledger upload posting file.
     Export to Excel, Adobe.

Note:
Some clients send us their monthly file and we return their reports in Excel. 


Configuration 2
Loans are maintained in an Excel file



Enter loans and deferred fees in an Excel file we provide.
    The software operates on an accrual basis and thus
     "makes" a payment and recognizes a deferral
     as if a payment had been made.
     Principal balances do not need to be updated each month.

Multiple fees per loan.
      Supports 1 or more different fees per loan.  

Automatically import the Excel file to the software.
     Amortize 1 deferral at a time.
     Amortize all deferrals at the same time.

Effective Interest Rates:
     Calculates Effective Interest Rates for all loans
     and each deferral.

Totals provided for:
     Original Deferrals
     Current month income and expense recognition
     Accumulated recognition
     Deferral balances
     Book Value NPV (Net Present Value)

Verify results.
     Create lifetime Deferral recognition schedule for any loan.
     Export to Excel.

Recalculation of Effective Interest Rate and NPV:
     Enter changes to the Excel file when a rate changes,
     unusual reduction to Principal or Payoff.
     Rate changes.
     The software changes the rate, calculates a new
     payment and Effective Interest Rate
     Excess principal reductions.
          Software recognizes additional portion of deferral and
          calculates a new Effective Interest Rate and NPV.
     Payoff date or principal balance to 0.00.
          Software recognizes remaining deferral balance.

Missed, late payments:
     The software operates on an accrual basis and thus
     "makes" a payment and recognizes a deferral
     as if a payment had been made even if Principal balance
     has not changed from last month's History file balance.
     You do not need to update Principal balances each month.

Monthly accounting reports:
     General ledger subsidiary listing.
     Journal voucher posting document.
     General ledger upload posting file.
     Export to Excel, Adobe.

 


Don't see what you need?
We have other software and also support
custom requests.
1-800-245-8444      email  Support@fdssi.com  


Configuration 3
Purchased loans in a Servicer Remittance File



Remittance file needs to be in or copied to Excel.

Typical changes needing to be made to the file:
     Insert 1 or more deferred fees for newly added loans.
     (the software's History feature contains prior month fees)

Automatically import the Excel file to the software.

From that point on is the same as Configuration 1.


Multiple fees per loan.
      Supports 1 or more different fees per loan.  

Automatically import the Excel file to the software.
     Amortize 1 deferral at a time.
     Amortize all deferrals at the same time.

Effective Interest Rates:
     Calculates Effective Interest Rates for all loans
     and each deferral.

Totals provided for:
     Original Deferrals
     Current month income and expense recognition
     Accumulated recognition
     Deferral balances
     Book Value NPV (Net Present Value)

Verify results.
     Create lifetime Deferral recognition schedule for any loan.
     Export to Excel.

Recalculation of Effective Interest Rate and NPV:
     The software maintains a History file for prior months,
     allowing it to detect and adjust for:
     Rate changes.
     The software changes the rate, calculates a new
     payment and Effective Interest Rate
     Excess principal reductions.
          Software recognizes additional portion of deferral and
          calculates a new Effective Interest Rate and NPV.
     Payoff date or principal balance to 0.00.
          Software recognizes remaining deferral balance.

Missed, late payments:
     The software operates on an accrual basis and thus
     "makes" a payment and recognizes a deferral
     as if a payment had been made even if Principal balance
     has not changed from last month's History file balance.

Monthly accounting reports:
     General ledger subsidiary listing.
     Journal voucher posting document.
     General ledger upload posting file.
     Export to Excel, Adobe.

Note:
Some clients send us their monthly file and we return their reports in Excel.








  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.
1-800-245-8444
Support@fdssi.com










Loan files can be:
     Excel worksheet
     Service bureau extract
     Core system download
     Seller service remittance report ...



New 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 can be:
A)  Known amounts which are included in the loan file.

B)  Known amounts which are not included in the loan file.
          The software can "match" Fees from an Excel file and assign them to each loan during the import process.

C)  Gross amounts which need to be assigned to each loan:
          Some fees might be billed to you 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)  Combinations of the above.













Need FASB results today?

We can send you effective interest method reports covering:
     Prior months
     Prior years
     Current month - once or continual basis


Many clients outsource their FASB, GAAP requirements to us for
     •  One time calculations
     •  Straight line "What if?" compared to effective interest method
     •  Conversions
     •  Due diligence
     •  Custom requirements
     •  Recurring monthly fee amortization, accounting and general ledger reports


Simply send a file attached to an email or secure service.
We'll process your loans and return an Excel Reports file with:
     •  Fee income and expense recognition using effective interest method.
     •  Detail and totals.
     •  Subsidiary listing with subtotals by general ledger account, loan type or other category.
     •  Journal voucher and general ledger posting file.
     •  Lifetime loan fee recognition schedules.


Let us know what you need:  1-800-245-8444      email  Support@fdssi.com







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
     •  1 or more 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
  •  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
    •  Fixed rate
     •  Zero rate
     •  Variable rate
     •  360, 365, 366, 365/360
     •  FASB, GAAP compliant
     •  Customization available  


Amortize 1 or more 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
               or
               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.
  











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:
     Income
     Expense
     Discounts
     Premiums
     With multiple 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.
1-800-245-8444
Support@fdssi.com

Sample Reports Packet

Request a free software overview containing:
     Sample reports
     Screen images
     Price
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.
     Services:
     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 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.











  Prices



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



Or contact us with any questions.
1-800-245-8444
Support@fdssi.com



 
FASB 91 Loan Fee Amortization
 Software for Windows® on a computer, laptop, shared network and cloud based systems
© 1995 - 2023 Financial Data Support Systems, Inc.
Home page        |        About us       |        Contact us       |        Site map

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