Home Page
 
 

Database Software
Prepaid Expenses, Deferred Charges, Capitalized Costs
page with
Highlights
Report samples
Price
Free demo
Fixed Assets, FF&E
Deferred Income, Revenue
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
Prepaids, Deferred Charges and other Capitalized Assets
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
     •  Insurance premiums for hazard, fire, flood, auto, life, D&O, health, bonds, other
     •  Maintenance agreements covering hardware, software
     •  Capitalized expenses 
     •  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
     •  Loan charges, dealer reserves, indirect lending fees
     •  Leases, rents, other prepaid occupancy and security costs
     •  Donations, gifts
     •  REO, other capitalized property expenses
     •  Other prepaid expenses and deferred charges
     •  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 expense, accumulated and book value calculations
     •  View reports.  Print reports.  Copy to Excel (send to your auditor in an email).
     •  General ledger posting with direct expense to any chart of accounts plus
     •  Allocate selected expense to multiple branch, cost center, department accounts
 

Exception handling
     •  Capture prior amortization expense if not set up during initial month
     •  Defer calculations to begin in a future known or as of yet unknown month
     •  Single step book value 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 cost, monthly expense, accumulated and book value
      Subtotals provided for each:
             General ledger expense account including branch, department, other centers
             General ledger prepaid asset
             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 expense to several branches or departments?
     The Allocation module distributes expense using one or more methods.
 

Features not found in many other systems
Easy to use set up screen with field entry documentation
Automatic Review/Maturity date calculation for tickler file reporting
System generated ID numbers.  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 expense
User defined codes can be used for Vendor, Type and other reporting
     Link records to aggregate by common purpose
Tables for meaningful subtotal descriptions, such as Vendor 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 cost > $1,000.00.
     Report all records in three expense 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
     - Vendor 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
          •  Vendor 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.
Supports any general ledger chart of accounts
We can convert your existing data records
FASB and GAAP compliant.


Allocating
Allocate monthly amortized expense to branch, department, cost center accounts.
      - Post as direct expense, 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 the cost center portion of a general ledger account number with a Method.
        Cost 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 cost 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.