Home Page
 
 

Database Software
Prepaid Expenses
Fixed Assets, FF&E
Deferred Income
and Revenue
page with
Highlights
Report samples
Price
Free demo
Accrued Expenses

Excel Data Software
Amortize, Depreciate
Allocate General Ledger
Premiums and Discounts

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

Calculation Examples
Methods
 

Company
About Us
Contact Us

 

 
DATABASE SOFTWARE for
Deferred Income and Revenue
by Financial Data Support Systems, Inc.
for Windows® PC, laptop, workstation, networks
On this page
     •  Highlights
     •  Report samples
     •  Price
     •  Download a free demo

Accounting software to
maintain, amortize, report, upload, archive
     •  Deferred Revenue
     •  Deferred Income
     •  Prepaid, unearned fees 
     •  Partial, whole, interim receipts which can't be immediately booked as income
     •  Leases, rents, other prepaid occupancy charges received
     •  Maintenance agreements covering hardware, software, professional services
     •  Bond and investment discounts
     •  Memberships, licenses, dues, fees
     •  Loan fees, direct and indirect lending fees as income
     •  Amortization terms from 1 to 999 months
     •  Begin amortizing immediately or
          Defer until a future month, then amortize or recognize all
     •  Also handles recurring transactions, with or without allocating
          Constant monthly amount
          Variable amount
 
 

About your existing data records ....
     •  We have software utilities to import random column data from Excel and other file types.
     •  Current general ledger balances can be preserved - no journal adjustment required.
     •  Be up and running with a complete system by tomorrow.
.

Monthly income, accumulated and deferral balance calculations
     •  View reports.  Print reports.  Copy to Excel (send to your auditor in an email).
     •  General ledger posting with direct income to any chart of accounts plus
     •  Allocate selected income to multiple branch, RC, revenue center, department accounts
 

Exception handling
     •  Capture prior amortization income if not set up during initial month
     •  Defer calculations to begin in a future known or as of yet unknown month
     •  Single step deferral balance adjustment for additional payment or refund 
 

History - Never lose a report again
     •  Automatic record and report archiving for retrieval at a future date
     •  Recall any prior month report on demand
     •  Review all changes made (old value, new value) to a record during its entire term
 

Multiple amortization methods
     •  Financial months
             All months have 30 days.  Amortize an item evenly over 1 thru 999 months.
     •  Actual days in each month.  First and last can be partial months
             Amortize an item for the actual date to date "in-service" days.
     •  Sum of the years digits
             Recognize greater amounts during earlier months, gradually taper down.
.

..

 
 

 
 
 
 

 
 
 
Complete monthly processing in a single step!

•  Trial Balance report for reconciling to general ledger
      Record listing in date order with amortization calculations
      Subtotals for receipts, monthly income, accumulated and deferral balance
      Subtotals provided for each:
             General ledger income account including branch, department, revenue center, others
             General ledger deferred liability accounts
             Report totals
      View and print:
             Records and subtotals
             Subtotals only

•  Journal Voucher debit and credit column posting source document
       Posting transactions can be:
             General ledger subtotals or
             Individual records
       Transactions can be created:
             For current or a previous month
             More than once
             As reversal entries (undo)

•  General ledger posting file
       Transactions can be formatted for any general ledger system
             Upload the file to your general ledger
             Paste contents to a spreadsheet or elsewhere
       Transactions can also be formated for ACH, NACHA processing
 

No close out required.
     Discover an error afterward?  Merely fix and rerun.
.


 

.

Do you ever have to ....
Increase or decrease the amount being amortized?
     The Adjustment Screen automatically handles additional payments and refunds.

Add a record that should have been added last month?
     Prior month expense for a record can be included with the current month.

Add a record that shouldn't begin amortizing right away?
     An alternate begin date defers amortizing to a future "in service" month.

Change a term?  Write off immediately?
     The Adjustment screen automatically handles these, too.

Allocate income to several branches or departments?
     The Allocation module distributes income using one or more methods.
 

Features not found in many other systems
Easy to use set up screen with field entry documentation
System generated ID number or assign your own
Terms of 1 through 999 months
"How" the record will amortize is displayed as data is entered
     Description, date, amount and term are the only items needed
Default values create new records quickly and consistently
Copy (dupe) an existing record - only change values that differ
               ( very handy when setting up renewals )
Copy a single field value from all existing values
Calculation Methods at the record level (defaults to your preference):
     Straight line method
     Sum of the years digits, Rule of 78's for any term
     Actual date to date (partial first and last months)
     Non amortizing recurring income
View and copy amortization income for future months, fiscal or calendar year
     Send all or selected results to Excel
User defined codes can be used for Payer, Type and other reporting
     Link records to aggregate by common purpose
Tables for meaningful subtotal descriptions, such as Payer names
 

Convert Your Records
Even if you inherited a junker file, we can probably convert your existing records.
     Retain current balances or
     Recalculate current balances from day one
We have Excel import routines with random column conversion factors
Be up and running with a solid system by tomorrow!
.


 
 

..

History and File Archiving
View and print reports for any prior month and year.
       Reports can be sent to Excel.  Email requested information to your CPA/auditor.
       Reports can span a year and show general ledger annual expense for each month.

Exception handling
Are you ever out of balance?
     The History Audit Report shows monthly changes to each general ledger account.

On Demand Reports
Calculate amortized results:
     As of any month or year end period
     For a range of future months
Include:
     All records
     Selected records
          Select records using filters available for all fields and values
          Sort and create subtotals on desired field values
Examples:
     Report all records that will have a zero balance as of December 31st.
     Report all new records for the previous quarter with original deferral  > $1,000.00.
     Report all records in three income accounts, send report to Excel.
 

More highlights
Maintain up to 99,999 records
Full set of accounting and managerial reports
     - Trial Balance
     - Journal Voucher
     - Undo.  Reverse a previously created debit/credit upload posting file
     - New records report
     - Maturity/Review date report (tickler file)
     - Type report by user defined codes
     - Payer report by user defined codes
     - Record link report (aggregate records by a common purpose)
     - Alpha list of records in Description order
     - MySubtotals report. Filter and group by selected fields on the fly
     - MyReports. Create and retain your own commonly used reports
     - Export. Copy/paste reports to a spreadsheet
     - Description files. Maintain names for:
          •  General ledger accounts
          •  Type codes
          •  Payer codes
          •  Record link codes
Use this database version or maintain records in an Excel template
History and archiving:
     - Historical month by month for each record - calculations and edit change activity.
     - Reproduce any report from a previous month or year.
     - Audit Report of add, edit, delete by general ledger account.
     - Annual reporting for entire year - copy to Excel, email to auditors.
     -  Go Electronic!
          Monthly history files allow you to print reports only when necessary.
We can convert your existing data records
FASB and GAAP compliant.
 

Allocating
Allocate monthly amortized income to branch, department, cost center accounts.
      - Post as direct income, allocate selected records, allocate all records.
      - Allocate using one or more Methods you establish, such as:
      - Same percentage to each branch (evenly).
      - Percentage you've determined.
      - Varying percentage by branch and which branches are included.
      - Workstation count, number of employees, square feet, revenue, other.
      - Unlimited methods of any type that can be expressed as numbers.
       - Share a method between records and different general ledger accounts.
      - Allocating is simple:
        Merely substitute revenue center portion of general ledger account number with a Method.
        Revenue centers can be located at the beginning, middle or end of an account number.
 

Partial list of clients using one or more of our software products ....
 

.


 

Price
Click to view price page.

Download a free demo now (install, uninstall in less than a minute)
Click an underlined demo.
     Save anywhere on your C: drive (demo is not configured to operate on a network)
     Then double click the saved file to launch Microsoft's setup Wizard.
     Run the demo using the newly added FDSSI Desktop icon.
         Add some of your records using your chart of accounts to the samples.
     When done, simply right click the desktop icon to delete and remove everything.
     Click to download the demo
     Click to download the demo with revenue center allocation..
.
.

Questions?  Not allowed to download software?
Want to try a demo containing your data records?
Toll free 1-800-245-8444 or email Support@FDSSI.com
.
Top
Copyright © 1995 - 2008    Financial Data Support Systems, Inc.