FASB 91 Loan fee amortization software  

 Financial Data Support Systems, Inc. 
     -  Software Products  -
Prepaid Expenses Amortization  
Deferred Income Amortization
Fixed Assets, FF&E Depreciation  
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
ASC-310-20, Prospective, Retrospective
Excel Worksheet Amortization
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

Price page
Free demo - download right now from Price page

Hard to

Scroll down for Price page and free demo
     Download, evaluate a free software demo from the Price page right now.
          Simple zip file.  Nothing to install.
     Import sample loans from an Excel template that comes with the software.
     Run reports and see how easy it is to use.
            View reports
            Send to printer
            Export to Excel (normally for distribution, archiving)
            Export to Adobe (normally for archiving)
     Change amortization month
            See results for any month.  An entire year.

Supports all of these 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

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

Accrual Accounting
Accrual based fee recognition ties to interest income.
Not transaction based.

Available with an option to distribute monthly income and expense for all or selected loans to multiple revenue, cost center general ledger accounts.

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  

Custom Coding
Unique requirement?
Special loan type?  File?  Fee?
We offer custom coding services.
More info  Support@fdssi.com  


GAAP, FASB compliant

Amortize loan fees from
  •  Core system
  •  Service bureau
  •  In-house system
  •  Aires, regulatory reports
  •  A simple Excel file

Don't have a loan file?
  •  Use our Excel template
  •  Enter basic loan information once.
  •  Import the Excel file to the software.

Calculate income and expense from
Begin dates forward
Or ....
Preserve and amortize current balances.
For any month.  An entire year.

Operates on
  •  Your PC or
  •  Your network

FASB 91 loan fee recognition and reporting software 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

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)
               MBS loans, GNMAs, Loan Packages, other mortgage backed securities over actual life page
     •  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.


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.

File calculation services:
We can also calculate a file and provide recognition reports on a one time or recurring basis.

For more information, 1-800-245-8444 or email Support@fdssi.com


                                PRICE PAGE

Price page and free demo
Click to open and view Price page


Need a specific answer?

1-800-245-8444 or
email (modify) any of these questions initially posed by our clients

     MULTIPLE FEES:  Our loans have both income and expense with different general ledger numbers and we ....
     PRIOR YEARS:  I need to amortize loan fees under FASB 91 for previous years going back to ....
     CONVERT:  We're thinking about converting to FASB 91 but want to preserve ....
     EXCEL:  Can the software amortize loan fees in an Excel worksheet with ....
     CORE SYSTEMS:  I need to amortize deferred fees in a loan servicing system maintained by ....
     SHORT TERM LOANS:  We deal in relatively short term loans.  Can the software handle periods of 1 year or ....
     CAPITAL MANAGERS:  My loan file has some unusual, tailored loans.  Do you have FASB 91 software that can ....
     AVERAGE LIFE:  Can the software amortize fees over an average portfolio life using a contractual P&I for the full ....
     CURTAILMENTS:  If a customer makes a large paydown to principal, does the software recognize more of the deferral ....
       DELINQUENTS:  Does the software still recognize deferred fees if a payment is not made ....
      PROJECTIONS:  For budgeting and other purposes, can the software calculate fee recognition for a future ....
     FILE SERVICES:  I'm interested in having a loan file calculated for ....
     MY CLIENTS:  I need to amortize loan fees on behalf of a client ....
     CREDIT UNIONS:  Our AIRES report contains consumer loans with indirect lending dealer fees.  Can your software ....
     AUDIT:  Is there a way to verify software results?   I need to be able to ....
     NETWORKS:  More than one person needs to access the software.  How many ....
     CUSTOM:  I need FASB 91 software that may have to be customized in order to ....
     SPECIAL PROJECTS:  Can I get the software on a temporary or short term basis for ....
     CPR:  Instead of FASB 91, I want to amortize some unusual loans using conditional prepayment rates (CPR) of ....
     OUTSOURCING:  Instead of buying software, can I just outsource everything to you and get monthly reports in Excel ....
     Or, just ask a question

     •  Effective interest rates
        (also utilize straight line for designated loans)
     •  Effective interest method amortization of
           Fee expense and
           Fee income
     •  General ledger, journal voucher, monthly upload posting files
     •  Allocate income, expense to multiple cost, revenue centers
     •  Subsidiary account balance reporting
     •  Lifetime fee recognition audit schedules
     •  Prior period calculations
     •  Future income, expense projections
     •  FASB 91 Custom coding
     •  Custom reports
     •  One-time file calculation services
     •  Recognize current and prior periods
     •  Forecast future period recognition

Special Features ....

Multiple fees per loan

     •  Amortize from 1 to 4 deferred income and expense items per loan.

     •  Produce a month-by-month lifetime FASB 91 fee recognition schedule
        for each income or expense fee.  A handy feature at audit time.

     •  Each fee can have its own set of general ledger account numbers.
        Or, leave account numbers blank and the system will assign default values.

     •  Amortize one set of fees at a time.
        Amortize all fees at the same time.

Interest rate changes

     •  The system calculates a new effective interest rate.

     •  The system calculates a new P&I.

Reductions to principal in excess of P&I amortization

     •  Typically due to principal paydowns and curtailments.
     •  The system recognizes an additional portion of the deferred
        income or expense for each of the 1 to 4 deferred fees.

     •  The system adjusts deferred income and expense balances
         plus principal and book value accordingly.

Early payoff.  Sale of loan.  Principal drops to zero.

     •  The system recognizes any remaining deferred income or
         expense balance for each of the 1 to 4 deferred fees.

Delinquents, non-payment:

     •  The software continues the payment stream regardless of non-payment activity.
               (this is accrual based and not a transaction based fee recognition system)
     •  Deferred fee recognition continues to occur.
             This logic remains consistent with loan interest income being accrued (earned).
             The software will continue recognizing a deferral on a delinquent loan until overt, other action is taken.


FASB, GAAP compliance for:
  •  Current month
  •  Prior months, restatements
  •  Future months, projections
  •  Monthly and annual totals
  •  Calendar and fiscal years

Deferred fees accounting:
  •  Effective interest rates
  •  FASB 91 recognition
  •  Expense amortization
  •  Income amortization
  •  Accumulated
  •  Deferral balances
  •  Principal balances
  •  Book value
  •  Totals for all

  •  Rate changes
  •  Paydown curtailments
  •  Early payoff, sale

General ledger:
  •  Subsidiary account listing
  •  Schedule with totals
  •  Journal voucher
  •  Posting totals

Excel interface:
  •  Export loans, reports
  •  Email loans, reports
  •  Archive as pdf, too

  •  Software training
  •  Documentation
  •  Customization available

Install to your computer:
  •  Windows 7, 8, 8.1, NT, 10
  •  PC, laptop, workstation
  •  Shared network drive

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

We have been utilizing FDSSI software to the fullest and we are so excited that we have it to do the calculations for us!

I'm not technically inclined but was able to install your software without any problems.
Then I imported my loan file.
Your software performed all the calculations and totals we need in a matter of seconds.
I can't believe how much work it's going to save us each month.

A HUGE thank you for going the extra mile plus!!!!!!!

Thanks.  Your customer service is fantastic!  Have a great week.

More about ....

     •  Individual loan schedules:
               Automatically generate a lifetime fee recognition schedule for any loan at any time.
               View, print, save in Adobe, save in Excel

     •  Multiple fees:
               From 1 to 4 unique fee income or expense items per loan.
               Each fee can be assigned its own set of general ledger debit and credit accounts (or default to system generated numbers).

     •  Partial paydowns, curtailments:
               The software recognizes an additional portion of deferred income, expense balance attributable to the principal reduction.

     •  Early payoffs:
               The software will recognize deferred fee balances in full when
                    Principal balance goes to zero or
                    An "Early payoff date" is encountered or
                    When importing from a loan servicing system, the loan is "gone" (for which a report will be provided and loans flagged accordingly).

     •  Rate changes:
               The software calculates a new effective interest rate.
               The software calculates a new payment.

     •  Months to calculate fee recognition:
               Ability to
                    Recognize deferred fees for a single month and
                    Recognize deferred fees for a span of 2 months through 12 months.
                    Begin a period with any current, prior or future month/year

     •  Expense:
               A display option can show expense recognition as negative in order to readily distinguish between expense and income

Existing loans and deferred fee balances:

Option 1
        Preserve your existing book values.
        No adjusting journal entries.
        The software can begin amortizing deferred fee income and
        expense balances using current loan information.

Option 2
         Calculate prior and current book values.
         The software can amortize deferred fee income and expense
         from original dates using original loan information.

Option 3
          Begin amortizing from an "as of" date.
         Typically the beginning of a calendar or fiscal year using
         prior EOY balances. 

                                PRICE PAGE

Price page
Click to open and view Price page





LOAN FILES - FASB 91 deferred fees, income and expense amortization software
Dealer fees, FASB 91 indirect lending page

FASB 91 amortization for hundreds, thousands of loans with deferred fees from a

     •  Loan servicing system

     •  Core, in-house computer

     •  Service bureau

     •  Excel worksheet
               Typically for smaller files, manually serviced loans, non-automated processing

     •  Other spreadsheets and file types

     •  Custom files and programming requirements

     •  Fee income
     •  Points
     •  Discounts
     •  Expense
     •  Charges
     •  Indirect lending dealer fees
     •  Closing costs
     •  Premiums
     •  Other deferred items

Effective interest rate calculation for each loan

Recognition of deferred fee income and expense under FASB 91
     •  Current month
     •  Prior months and years
     •  Future months
     •  Annual projections

Detail schedules
     •  Month by month recognition for the life of a loan
     •  Support for auditor, examiner queries

Account for multiple fees
     •  Up to four (4) distinct fees per loan

Start amortizing "as of" whatever month you want
     •  Start "as of" now
               Preserve your existing deferred fee income and expense general ledger balances
               No adjusting journal entries
     •  Start "as of" a prior month, prior year
               Recalculate income, expense and deferral balances from a prior period forward

Accrual accounting - not a transaction based system
     •  Monthly fee recognition is tied to loan interest income
               Interest received and
               Interest accrued
               Fee recognition occurs every month

Effective rate recalculation for rate changes

Accelerated recognition of deferral balance due to
     •  Principal reductions due to paydowns, curtailments
     •  Early payoffs

Loan file totals
     •  Total fee income - monthly and annual
     •  Total fee expense - monthly and annual
     •  Net:  Income minus Expense

Subsidiary account balancing

General ledger
     •  Journal voucher
     •  Upload transaction posting file

Need FASB 91 loan calculations NOW?

Don't want to buy software?

Do what others have done:
     •  Send your file attached to a secure email
     •  We can
               Import your loans to the software
               Perform any necessary changes or file clean-up
               Amortize deferred loan fees for any period
               Return a complete set of reports in Excel
     •  Reports can be generated
               One time basis
               Recurring basis

Please call 1-800-245-8444
or email

An affordable, proven system for small and large loan files

•  Different versions to meet different operational needs

•  Evaluate the software with your loans at no charge

•  Qualified assistance regarding unusual requirements

•  Software customization for unique needs

•  FASB, GAAP compliance without spending a fortune

Amortize deferred income and expense for

•  Mortgage loans

•  Consumer loans

•  Commercial loans, notes

•  P&I amortizing loans

•  Balloons as interest only with a balloon payment

•  Balloons with partial P&I amortization at a longer term during the balloon term (supports average portfolio life fee amortization)

•  Interest only loans

•  Interest only with periodic constant amount reductions to principal such as scheduled quarterly principal repayments

•  Fixed rate

•  Zero rate (typically for amortizing up front leasing charges)

•  Variable, adjustable rate
          Effective rate recalculation with each rate change

•  Interest calculations at 360, 365, 366 actual days, 365/360 ....

•  Full recognition due to early payoff

•  Paydown, curtailment accelerated fee recognition

•  Effective interest rate recalculation due to paydown reduction

Complete monthly fee accounting and reporting for ....

•  All monthly financial and accounting reports

•  Subsidiary ledger listing with subtotals by general ledger account
          P&L totals for each distinct fee
          Balance sheet totals for each distinct fee

•  Debit and credit column journal voucher

•  General ledger posting file

•  Complete monthly reporting and accounting in a matter of seconds

•  Lifetime month by month amortization and fee recognition schedules for each loan

•  View schedules and reports

•  Send to local or network printer

•  Export schedules and reports to Excel

Loan fee recognition and totals for

•  Current month

•  Current period ranging from 1 to 12 months

•  Prior months

•  Prior accounting and audit periods.  Annual totals.

•  Future months and period projections

•  Calculate, recalculate a different period in seconds

Your existing loans

•  The software can amortize fees from original dates or

•  Current general ledger and deferred fee balances can be preserved

Price page

Click the link to open and view price page.
Price page

Free set of monthly reports - your loans
Send an email requesting a free Excel template.
     Add a few of your loans to the file (exclude proprietary data).
     Return the file to us.
     We'll calculate your loans, generate reports and return the same file with
     multiple worksheets demonstrating various capabilities of the system.
     Email  free Excel template

Loan fees file calculation services
We can calculate a file on a one-time basis.
Deferred fee income and expense amortization for a month.
For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
For more information, Email  Loan file calculation services

Amortization terms:
     Actual life of each loan
     Average portfolio life
     Other derived, modified terms   
 Calculate and aggregate monthly fee recognition to
The software will calculate:
     Hundreds of loans
     Hundreds of thousands of loans at the same time.
Early payoffs:
     The software recognizes the remaining deferral amount.
Curtailment, paydown, other partial reductions to loan balance principal:
     The software calculates a new effective interest rate.
     The software accelerates fee recognition proportionate to the reduction.
Rate changes:
     The software calculates a new effective interest rate.
     The software calculates a new payment.
Generate fee income and expense totals:
     For any month, year
     For any calendar or fiscal entire year
     For audit and examination periods
Loan ledger subsidiary account balance sheet report
General ledger upload posting file
Calculate from original loan dates or an "as of" begin date to preserve deferral balances from having used another process
Schedules:  Automatic lifetime fee amortization schedule for any loan
Audits:  Annual and other fiscal period reporting for audit and examinations
Customizing available for unique situations, new lending programs

Import all of your
     •  Existing loans with
            Current balances and
            Current rates
     •  New loans
     •  Early payoffs
     •  Sold loans, participations

Import file types
     •  .txt  (Tab delimited.  Other delimiters.  Field position, fixed length.)
     •  .csv  (comma delimited)
     •  .xlsx (Excel.  Many loan servicing systems already support extracting or downloading a loan file to Excel.)
     •  Other type files.  Flexible record layouts.

Modify a file
A "front end" module in the software allows for adjustments and customization, such as
     •  Set deferral amortization term to an average or experienced portfolio life instead of actual loan term
     •  Insert general ledger account numbers based on loan type or code
     •  Find values within a record layout - sixth data element imports as the required second element
     •  Change a value:  Import file interest rate of .0375 to 3.75
     •  Other needs and requests

How it works
The software calculates effective interest rates and amortizes deferred fee income and expense under FASB 91.
     Current principal balance for P&I amortizing loans is also calculated in order to determine loan interest income.
          Fee income and expense is amortized regardless of whether a payment is actually received.
     The software was designed for those on an accounting accrual basis:
          Whether a payment has been made or not, loan interest income is earned and recognized each month.
          As such, deferred loan fees should also be recognized (as opposed to recognition based on cash flow or transaction activity).

The software will automatically adjust for changes from a prior month to the current month.
     •  Different interest rate.
             The system will calculate a new effective interest rate and, for amortizing loans
             a new P&I payment using current balance, current rate and remaining term.
     •  Principal balance reduction other than through normal P&I amortization, such as paydown curtailments.
             The system compares its amortized principal balance to the imported current balance.
             If the imported balance is lower, the system recognizes the deferral by a proportionate amount
             and begins utilizing the imported current loan balance.  A new effective interest rate is also calculated due to a shorter payout term.
     •  New loans during the current month.
             An effective interest rate will be calculated for each new loan.
     •  Paid off loans, sold loans, participations sold.
             The system will recognize deferral balance in full or, for participation sold, a proportionate amount of the deferred fee.
     •  Loans which may have just "gone away".
             Many times, paid off loans are purged from the servicing file only at year end.
             Regardless of why a loan goes away, If any fee remains the system will recognize the deferral balance in full.

Records retention, audit and exam compliance
The software maintains a monthly Master File which will be saved for the current month.
     Master Files are used for comparing an import file to the previous month's file status.
     Master Files can also be imported at a future date to facilitate reporting for internal purposes, audits and exams.

 Effective interest rate calculation and accounting for an entire loan file

  •  Fee income amortization

  •  Cost, expense amortization

  •  Portfolio totals in a matter of seconds
          Total fee income
          Total fee expense
          For a month.  Quarter.  Calendar or fiscal year.
          Current, past and future periods

  •  Detail audit schedules
          Lifetime amortization and fee recognition schedule for any loan on demand

  •  Amortizing loans

  •  Interest only loans

  •  Balloon loans
          Interest only

  •  Loan amortization periods
          Recognize fees over the full term of the loan
          Recognize fees over an average life
               Amortize loans over an average life instead of a full term
               Apply to some loans or all loans

  •  Zero interest rate
          Some clients use this feature to amortize leasing fees

  •  No data maintenance or updating necessary

  •  Operates on
          Original loan and deferral balances
          Current loan and deferral balances

  •  Variable rates
          Supports rate changes

  •  Principal paydowns, curtailments
          Accelerated fee recognition due to paydown/curtailment/payoff

  Currently using another method?  Another system?  No system?
     The software can recalculate deferral balances for current and prior periods.
     Or, the software can preserve your current deferral balances.
               No general ledger adjustments necessary.

Flexible output ....
     •  View results on screen
     •  Send to local or network printer
     •  Copy and paste results to an Excel worksheet

Principal Balances
The system calculates the current principal balances for amortizing
loans "as of" the requested amortization month or period  (for MBS, pooled loans, syndicated packages, view this page)

Effective interest rate
The system calculates an effective interest rate under FASB 91 for each loan and
calculates a new effective rate for a rate change

Fee income and expense amortization
  •  Individual loan level
  •  File totals by category
  •  Lifetime amortization schedule for a loan

General ledger posting
  •  Subsidiary reports
  •  Journal voucher posting source document
  •  General ledger upload posting file

                            CHANGES during term ....
Rate changes
  •  Supports interest rate changes
  •  Effective interest rate recalculation due to a rate change
  •  The software calculates the new payment

  •  Supports partial paydowns and curtailments
  •  Accelerated recognition of deferral corresponding to reduction of principal

  •  Supports early payoffs
  •  Recognize deferred fee balance in full
  •  For payoff, sale, or otherwise disposed

New and existing loans
  •  New loans:  The system performs calculations using original loan information.
  •  Existing loans:
          1)  The system can "bring loans current" if original loan information is available.
                    Calculate a file for current and prior periods.
          2)  Or, the system can use current loan balances, current deferred fee balances and so forth.
                    The system can calculate a remaining term based on loan balance, rate and payment.

Amortize, recognize, account for and post
  •  Deferred loan fee income
  •  Cost, expense
  •  Finance charges
  •  Discounts and premiums 
        Interchange premiums and discounts with income and expense depending upon which they are to you

  •  Fixed rate
  •  Adjustable, variable rate (scheduled and "on demand" rate changes)
  •  Interest only
  •  Balloon term (can also be used as a portfolio average life term)
  •  Zero interest rate
  •  Non-amortizing loans (and loans with unscheduled or periodic principal reductions)

Unusual loans
  •  Loans your mainframe can't handle
  •  New products/loan offerings
  •  Unusual payback terms ....
        The software can be modified to meet specific client needs

Leases, too
  •  Utilize balloon and non-amortizing features to amortize leasing fees over lease term.
  •  Accommodates both zero interest rate as well as lease payments incorporating an interest rate.

Generate recognition and accounting reports
  •  Amortization and accretion
  •  Subsidiary listing with detail and totals
          Monthly recognition
  •  General ledger accounting
          Journal voucher posting source document
          General ledger transaction posting upload file

  •  Residential mortgages with origination fee income and expense
  •  Commercial loans, paper
  •  Loan packages, purchased or sold
  •  Consumer loans, automobile, other vehicles
  •  Dealer fees, indirect lending costs
  •  Other conforming, non-conforming loans

Custom modifications
  • Custom calculations and routines for new lending programs, unique situations ....

Many of our clients are
     •  CPA, accounting firms
     •  Auditors
     •  Asset management companies
     •  Financial advisors
View this page to see how they utilize the software
to calculate, audit or provide accounting services for client files

Simple to operate.
For monthly reporting:

1)  Import a file

2)  Calculate:
     -  Loan fee income and expense recognition for an entire file
     -  FASB 91 calculations and compliance
     -  All monthly accounting reports
     -  General ledger postings
     -  Lifetime amortization schedule for any loan
     -  In a matter of seconds!
      Enter loan data and fees.
      Download loan data from a mainframe.

 Export calculation results and reports to Excel.
      For internal use.
      Email to outside auditors.

 Records retention.
      Export reports to Excel.
      Or save loan worksheets with a unique monthly name.
           Import, calculate, report at any future date.

Download, automatically import loan files
to the software for FASB 91 fee amortization from

     •  Loan servicing systems
     •  Core processing mainframes
     •  Service bureaus
     •  "Off the books" manually serviced loans
     •  Other internal or external sources
         including premiums and discounts for purchased loans, packages serviced by others

During import, the software:
    Calculates effective interest rates
          Monthly fee income and costs amortization
          Calendar date selection determines effective month.
     For each record:
          Monthly recognition
          Deferral balance
          Book value carrying balance
          Summary totals of the above by category:
               Fee income totals
               Cost/expense totals

You can also:
     Generate amortized income and expense totals for a
          Calendar or fiscal year
          As of a prior or future period
     View a lifetime month by month amortization and fee recognition schedule for any record
     Copy and paste results elsewhere

Supports single or multiple paydowns.
     Curtailments, paydowns, participation sales.
     Put date and paydown amount in the file.
          The system will automatically accelerate deferred fee recognition for the paydown amount.
          A percentage of the paydown/loan balance will be used to recognize that portion of the deferral.
          A new effective interest rate will be calculated based on the new remaining term.
     Accepts multiple paydowns for the same loan.
          Including separate, multiple paydowns in the same month.
     Log paydowns 2 ways (or use both):
          Immediately following a loan number row.
          Grouped together within a "Changes" section.

Early payoff date column to recognize in full prior to end of anticipated term.

Rate changes:
     The software supports one rate adjustment.
      It also supports multiple rate changes.
          Put new rate and effective date in the file.
               Enter as many changes as occur.
          The system calculates a new payment and recalculates the effective interest rate.
     Log rate changes 2 ways (or use both):
          Immediately following a loan number row.
          Grouped together within a "Changes" section.

Loan types
     -  Fixed rate
     -  Adjustable
     -  Amortizing
     -  Interest only
     -  Balloon
     -  Zero interest
     -  Non-amortizing

Payment frequencies
     -  Monthly
     -  Quarterly
     -  Semi-annual and annual

•  FASB 91 Effective interest rate
•  Deferral amortization recognition
     -  Fee income
     -  Fee expense, cost
     -  Net of both when applicable
     -  For loan term or average life
•  All monthly accounting reports
•  GAAP, FASB compliant

Calculate deferral recognition and balances as of:
•  Current month
•  Prior month
•  Prior year end (fiscal or calendar)
•  Future month or year end
•  Range of future months for annual budget/forecasting

Trial Balance subsidiary ledger report
Detail and totals for
     •  Income
     •  Expense
     •  Accumulated
     •  Deferral balance
     •  Carrying amount (Accretion balance)
     •  Totals by category or general ledger account numbers

General ledger
     •  Journal Voucher posting source document
     •  Upload posting file
     •  Direct post to any chart of accounts
     •  Allocate selected or all recognition to revenue and cost centers

FASB 91 detail schedules
     •  Lifetime effective interest method amortization for each record

Available for
1) Loans at the individual loan level:
     -  Fixed rate, adjustable, amortizing, interest only (non amortizing) and balloon loans
     -  Monthly, quarterly, semi-annual and annual payment frequencies
     -  Mortgages
     -  Dealer fees, holdbacks, indirect auto lending expense
     -  P&I amortizing loans
     -  Balloon
     -  Interest only
     -  Average life term
     -  Callable

2) Groups and packages (fees treated as premium or discount using our Omnibus software):
     -  Individual rates, composite, dollar weighted
     -  Mortgage backed securities
     -  LSBOs
          Purchased loans
     -  Other packaged loans
          Held to term
          Average life
     -  Amortizing
     -  Irregular principal receipts stream
          Variable amounts
          Curtailments, payoffs
          Partial sales
     -  Weighted rate changes
     -  Interest only
     -  Monthly bulk origination, aggregate

Click to open  Price page

Loan fees file calculation services
We can calculate a file on a one-time basis.
Deferred fee income and expense amortization for a month.
For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
For more information, Email  Loan file calculation services

Just gathering information?
Our customer support department would be glad to answer your questions.
Call 1-800-245-8444 or email Support@fdssi.com
Other pages of interest ....
FASB 91 products page
Omnibus - Loan, bond packages FASB amortization
Bond accounting FASB 91 amortization
Bond accounting straight line amortization
Bond issue costs FASB 91 amortization
Enter, calculate one loan at a time calculator
CPA, auditor, financial advisor FASB 91 page
FASB 91 custom system
FASB 91 services offered

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