| The
fast and easy way to amortize Excel data.
Amortize
• Insurance premiums:
Hazard, fire, flood, auto, life, D&O, health, bonds, other
• Maintenance
agreements covering hardware, software
• Capitalized
expenses
• Loan charges,
dealer reserves, indirect lending fees
• Leases, rents,
other prepaid occupancy and security costs
• Office, building,
branch supplies having a shelf life
• Equipment and
upgrades
• Bond and investment
premiums and discounts
• Memberships,
licenses, dues and subscriptions
• Incorporation
and set up charges
• Professional
service fees, retainers
• Taxes, tangible
and intangible, parcels, certificates
• Advertising,
marketing, promotional items
• Donations, gifts
• REO, other short
term property capitalized expenses
• Begin amortizing
immediately or
Defer until a future month, then amortize or recognize all
• Recurring expense
and other debit with credit offset transactions
On this page
• Highlights
• Screen and report
samples
• Price
• Download a free demo with Excel templates
It couldn't be simpler!
1) Copy these four data columns from Excel
or other spreadsheet
• Description
• Begin
date
• Cost (amount
to amortize)
• Term
2) Paste to the software
Calculate amortization,
accumulated and book value 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 expense 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 expense, 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
. |