FASB 91 Loan fee amortization software
 
     Financial Data Support Systems, Inc.
    Accounting Amortization
              Software
 
Home
About us
Contact us
Technical FAQs
               FASB 91 accounting software
 
  Loans - P&I amortizing, interest only, balloons
Loans - dealer fees, indirect lending charges
Omnibus - MBS mortgage backed securities, loan packages
LIBOR - loans tied to LIBOR, prime, other rate indexes
Merchant loans - cash advances, commissions, fees
FASB 91 - all software products listing
               General accounting software
 
Prepaid expenses, capitalized cost, deferred charges
Deferred income, unearned revenue recognition
Fixed assets, FF&E straight line depreciation
Excel - worksheet amortization software
                         All products
CPA, auditor tools - calculate, recalculate client files
             Bond accounting software
 
Bonds - effective interest method accounting
Bonds - OID original issue discount amortization
Bonds - variable rate, step bonds amortization
Bond issuers - issuance cost amortization
Bonds - straight line method accounting
Calculator suite - schedules for one bond at a time
 
 
 
 
Loans - P&I amortizing, interest only, balloons ....
 

  Automatically import a loan file such as this to the software .....
 


FASB 91 software to amortize deferred loan fees.
     •  Effective interest rate calculations
     •  Deferred fee income and expense amortization under FASB 91
     •  Amortize fees for thousands of loans at the same time
     •  Amortize multiple fees for thousands of loans at the same time
     •  Amortize fees over actual loan term or average portfolio life
     •  Loan file totals
          Total Income.  Total Expense.  Net:  Income minus Expense.
     •  User defined group totals

Complete monthly fee accounting and reporting for ....
     •  All monthly accounting reports
     •  Subsidiary ledger listing with subtotals by general ledger account
          P&L totals
          Balance sheet totals
     •  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 shedules for each loan
     •  View reports.  Print.  Export to Excel.

Applicable for
     •  Mortgage loans
     •  Notes
     •  Consumer loans
     •  Commercial
     •  P&I amortizing loans
     •  Interest only
     •  Balloons - as balloon payments or to amortize fees over average portfolio life
     •  Fixed rate
     •  Zero rate (typically for amortizing up front leasing charges)
     •  Variable, adjustable rate
     •  Fee income, points, discounts, expense, charges, closing costs, premiums

Individual loan fee recognition and totals for
     •  Current month
     •  Current period ranging from 1 to 12 months
     •  Prior months
     •  Prior accounting and audit periods up to a year.  Annual totals.
     •  Future months and period projections
     •  Calculate, recalculate a different period in seconds






  Available in 3 versions
     •  Calculate loan deferred fees in an Excel worksheet
               1 fee (income or expense) per loan
                Up to 4 fees per loan
     •  Calculate loans and deferred fees downloaded from a loan servicing system

Version 1 - Excel
Import Original Loan Balances in Excel, 1 fee and general ledger deferral accounts per loan:
Maintain records, rate changes, principal curtailments (large paydowns) and early payoff dates in Excel.
Automatically Import to the software.
     The software calculates current principal balance for P&I amortizing loans.
     Fee income and expense is amortized regardless of whether a payment was received.
     The software was designed for accrual basis accounting.  Even if a payment has not been made, interest income is still recognized.
     As such, the deferred loan fee(s) should be recognized.
Amortize one income or expense per loan.

Version 2 - Excel
Import Original Loan Balances in Excel, up to 4 fees and general ledger deferral accounts per loan:
Maintain records, rate changes, principal curtailments (large paydowns) and early payoff dates in Excel.
Automatically Import to the software.
     The software calculates current principal balance for P&I amortizing loans.
     Fee income and expense is amortized regardless of whether a payment was received.
     The software was designed for accrual basis accounting.  Even if a payment has not been made, interest income is still recognized.
     As such, the deferred loan fee(s) should be recognized.
Amortize up to 4 income or expenses per loan.

Version 3 - Loan servicing files
Import Current Loan Balances, up to 4 fees and general ledger deferral accounts per loan:
Typically, the file is downloaded monthly from a loan servicing system, core processing or other external system.
Automatically import any of the following type of files to the software each month:
     .txt  (tab delimited, other delimiters or fixed length)
     .csv
     .xlsx (many loan systems already support extracting or downloading a loan file to Excel)
     Other type files
The software calculates current principal balance for P&I amortizing loans.
     Fee income and expense is amortized regardless of whether a payment was received.
     The software was designed for accrual basis accounting.  Even if a payment has not been made, interest income is still recognized.
     As such, the deferred loan fee(s) should be recognized.
The software will automatically adjust for changes from a prior month to the current month.  Changes such as:
     •  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.
     •  Reduced principal balance other than through normal P&I amortization, such as paydown curtailments.
        The system will accelerate deferral recognition by a proportionate amount.
     •  New loans during the current month. An effective interest rate will be calculated.
     •  Paid off loans, including those with principal that went to 0.00. The system will recognize deferral balance in full.
     •  Loans which may have just "gone away". Many times, paid off loans are purged from the servicing file only at year end.
        The system will exclude these loans when creating the current month's Master File.
Records retention:
     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.

 


















Price ....

Amortized prices to satisfy FASB 91 requirements begin at less than $20.00 a month
                    -  Purchase the software
                    -  License for a 6 month period with optional renewals
                    -  License for a 1 month period - great for special projects, short term needs


Please contact us for ....

     •  More information or questions regarding the software

     •  Pricing

     •  Third party processing, client servicing features

     •  PC, workstation and network sharing systems

     •  Windows 7, 8, 8.1 and 10

     •  Free trial system - calculate your loan fees using a live version of the software

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





 Client testimonials ....

 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.
                              Long Island, NY


 I'm not technically inclined but was able to install your software without any problems.
 Then I imported a worksheet containing our loans.
 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.
                            San Antonio, Texas

 Thanks a lot!
 This program has just made my life so much easier.
                              Atlanta, GA

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





                                           Need something unique?
The software can be modified to meet specific client requirements.
For more information, call 1-800-245-8444
or email Support@fdssi.com







  FASB, GAAP compliant
   •  Business
   •  Government
   •  Services
   •  Financial institutions
   •  Accounting firms
   •  Financial advisors


Special features
   •  Reports
        View
        Print
        Archive
        Export to Excel
   •  Audit year reconciliation
   •  1-800 and email support


Monthly, annual reports
   •  Your records
   •  Client records
   •  Any month
   •  Any year

PC,
laptop,
workstation and
shared network devices
running Windows®


Client testimonials ....
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.
     Long Island, NY

Thanks for your help today.  Your software is as advertised and will be most useful.
     Houston, TX






 

Amortization terms:
     Actual life of each loan
     Average portfolio life
     Other derived, modified terms   
 Calculate and aggregate monthly fee recognition to
     Income
     Expense
The software will calculate:
     Hundreds of loans
     Thousands
     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).

Changes
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
          Amortizing
          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.
     Request a free trial system.
     See how easy it is to amortize your own loan fees.



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

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

Payoffs
  •  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



Methods
  •  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
          Accumulated
          Balances
  •  General ledger accounting
          Journal voucher posting source document
          General ledger transaction posting upload file
 


Types
  •  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!
  Worksheets:
      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
    Provides:
          Monthly fee income and costs amortization
          Calendar date selection determines effective month.
     For each record:
          Monthly recognition
          Accumulated
          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
          Month
          Quarter
          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

Paydowns:
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.

Payoffs:
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

Calculations
•  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

Reports:
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
          Participations
     -  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
 

 
Questions?
Don't see what you need?
     We have other software not featured on our website.
     We can also tailor and customize the software.

1-800-245-8444
email Support@fdssi.com
Other pages of interest ....
FASB 91 products page
Omnibus - Loan, bond packages FASB 91 amortization
Bond accounting FASB 91 amortization
Bond accounting straight line amortization
Bond issue costs FASB 91 amortization
Enter, calculate one record at a time calculator suite
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 - 2016 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