| The
fast and easy way to amortize Excel data.
Amortize
• Deferred income
and revenue including
• Prepaid fees,
sales, receipts
• Partial, whole,
interim receipts which can't be immediately booked as income
• Leases, rents,
other prepaid occupancy charges received
• Loan fees, direct
and indirect lending fees as income
• Maintenance
agreements covering hardware, software, professional services
• Bond and investment
premiums and discounts
• Memberships,
licenses, dues, fees
• Begin amortizing
immediately or
Defer until a future month, then amortize or recognize all
• Also handles
recurring income and other credit with debit offset transactions
(amount to amortize = monthly recurrence X recurring months)
On this page
• Highlights
• Screen and report
samples
• Price
• Download a free demo with Excel templates
It couldn't be simpler!
1) Copy four data columns from Excel
• Description
• Begin
date
• Deferral
(amount to amortize)
• Term
2) Paste to the software
Calculate recognition,
accumulated and balance as of
• Any prior month or year end
• Current month or date-to-date accounting period
• Any future month or year end
Prepare all accounting reports in seconds
• Subsidiary ledger
Trial Balance
Amortization results for each record
View a record's lifetime monthly schedule
Calculated subtotals for each general ledger account
Includes branch, department, cost and revenue center accounts
• Journal Voucher
debit and credit posting source document
Optionally allocate amortized income to your chart of accounts
• Export file
for general ledger posting
• View reports.
Send reports to printer. Copy to Excel.
• If desired,
copy amortization results back to your file:
Paste income, accumulated and book value columns
Maintain annual or longer period calculations in a single file
Flexible
Use this same software for files containing
• Prepaid and deferred expenses
• Fixed assets, FF&E
• Deferred income, revenue, unearned
fees
• Expense accruals
• Bond, other investment premiums and
discounts
• Other types of records requiring amortization
Calculation Methods Supported
Terms of 1 to 999 months (1 month term recognizes
entire amount)
1) Monthly: Straight line
2) Monthly: In service, date to date, actual
days in month with partial first and last months
3) Monthly accelerated: Sum of the years
digits, Rule of 78's for any term in months
4) Calendar date: Accounting periods are
day, days, week, weeks, 4-4-5, any date-to-date
. |