Home Page
 
 

Excel Template Software
Prepaid Expenses
Fixed Assets, FF&E
 
Deferred Income
and Revenue
Accrued Expenses
Premiums and Discounts

Database Software
Prepaid Expenses
Fixed Assets, FF&E
Deferred Income, Revenue
Accrued Expenses

Allocation Software
Allocate Cost, Income
Allocate Journals

Schedules
Straight line
Rule of 78s
Sum of the years digits
FASB 91
Effective Interest Method

Calculation Examples
Methods
 

Company
About Us
Contact Us

 

 
EXCEL TEMPLATE SOFTWARE for
Deferred Income and Revenue
by Financial Data Support Systems, Inc.
for Windows® PC, laptop, workstation, networks
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
.

..


 


 
 
 

 
 
 
 

 
 
 
 

 
 
 
 

 
 
 
 

 
 
 
 
 

 


 

    FREE DEMO
Calculation Method A:  Straight line, same amount each month.  Accounting periods:  Monthly.
     Example: $1,200.00 for 12 months = $100.00 per month
Click to view price and order page.  Click to download the demo

Method B:  Straight line in service term, actual days in month, partial first and last months.  Accounting periods:  Monthly.
     Example: $610.00 from June 15, yyyy to August 15, yyyy:  June = $160.00, July = $310.00, August = $140.00
Click to view price and order page.  Click to download the demo

Method C:  Straight line daily.  Accounting periods:  Day, days, week, weeks, 4-4-5, any date to date period.
     Example: $365.00 for a term of 1 year:  Two weeks = $14.00, three days = $3.00, four weeks = $28.00
Click to view price and order page.  Click to download the demo

Method D:  Accelerated sum of the years digits, Rule of 78s for any term in months.  Accounting periods:  Monthly.
     Example: $345.00 from June, yyyy thru August, yyyy:  June = $172.50, July = $115.00, August = $57.50
Click to view price and order page.  Click to download the demo

Base price for each method: $29.95
Try a free demo (install and uninstall in less than a minute - each contains Excel templates with multiple record types)
     •  Click and save an above demo file anywhere on your C: drive (demos are not configured for network operation). 
     •  Double click the saved file to launch Microsoft's demo setup Wizard.
     •  Double click the newly added FDSSI Desktop icon to run  (when done, right click the icon to delete and remove demo)
..

Questions?  Not allowed to download software?
Toll free 1-800-245-8444 or email Support@FDSSI.com
Contact us
Top
Copyright © 1995 - 2008    Financial Data Support Systems, Inc.