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.
Your customer service is fantastic!
Have a great week.
Price page and free demo ....
open and view Loan Fees Price page
contains information regarding a free demo
system with your loans.
Price page also
contains download file record layouts and other
Don't see what you're looking for?
email on what you need.
Or call us at 1-800-245-8444
Actual life of each loan
Average portfolio life
Other derived, modified terms
Calculate and aggregate
monthly fee recognition
The software will calculate:
Hundreds of loans
Hundreds of thousands of
loans at the same time.
The software recognizes the remaining
other partial reductions
to loan balance
The software calculates a new effective interest rate.
The software accelerates fee recognition proportionate
to the reduction.
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
account balance sheet
ledger upload posting
original loan dates or
an "as of" begin date to
balances from having
used another process
||Schedules: Automatic lifetime
schedule for any loan
and other fiscal period
for audit and
unique situations, new
automatically import loan files
to the software for FASB 91 fee
• Loan servicing
• 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
Import all of your
• Existing loans with
• 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.
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
general ledger account numbers based on
loan type or code
• Find values within a record layout - sixth data
element imports as the required second
• Change a value: Import file interest rate
of .0375 to 3.75
• Other needs and requests
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
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
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
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
system compares its amortized principal
balance to the imported current balance.
imported balance is lower, the system
recognizes the deferral
by a proportionate amount
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.
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
• Loans which may have just "gone away".
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.
An unlimited number of fees
for the same loan can be addressed two ways :
1) Create multiple loan files. Import each
of them. Each file
would contain the same loans but each file would
contain a unique fee.
2) Or, the software can be tailored to import and
handle a single file containing all fees with
separate (or net sum) amortization and reporting for each
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.
• A free
demo available on the Price page, below,
includes both .txt (tab delimited) and
.xlsx files spanning three months.
• The demo files contain sample loans. Add
some of your loans to a file. Then
import your loans.
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
• 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
No general ledger adjustments necessary.
See how easy it is to amortize your own
Flexible output ....
• View results on screen
• Send to local or network printer
• Copy and paste results to an Excel worksheet
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 ....
• 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
and "on demand"
• Interest only
term (can also
be used as a
loans (and loans with unscheduled or periodic principal reductions)
• Loans your mainframe can't handle
• New products/loan offerings
• Unusual payback terms ....
The software can be modified to meet specific client needs
amortize leasing fees
over lease term.
as well as lease
Generate recognition and accounting reports
• Amortization and accretion
• Subsidiary listing with detail and totals
• General ledger accounting
Journal voucher posting source document
General ledger transaction posting upload file
mortgages with origination
fee income and
• Loan packages, purchased or sold
• Dealer fees, indirect lending costs
• Other conforming, non-conforming loans
• Custom calculations and routines for new lending programs, unique situations ....
Many of our clients are
CPA, accounting firms
• Asset management companies
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
- Loan fee
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.
Export reports to Excel.
Or save loan worksheets with a unique monthly name.
Import, calculate, report at any future date.
income and costs
of the above by
totals for a
As of a prior or
View a lifetime
month by month
schedule for any
Copy and paste
Put date and
in the file.
The system will
A percentage of
balance will be
portion of the
A new effective
on the new
paydowns for the
paydowns in the
Log paydowns 2
ways (or use
following a loan
date column to
full prior to
Put new rate and
effective date in the
Enter as many
calculates a new
changes 2 ways
(or use both):
following a loan
• FASB 91
- Net of
loan term or
• GAAP, FASB compliant
balances as of:
year end (fiscal
month or year
• Range of
by category or
post to any
selected or all
revenue and cost
1) Loans at the
- Interest only
2) Groups and
Held to term