Home Page
 
Services for your file
Past, current, future calculations. Alternative methods. Modify values. Allocate. Posting files ....
 
Products
Database Software
Prepaid Expenses,
Deferred Charges and
Other Capitalized Assets
Deferred Income
Fixed Assets
Accrued Expenses

Excel Data Software
Amortize Excel records
Depreciate Excel records
Allocate cost, income
Allocate journal postings

Effective Interest
Method Software
FASB 91 page
Mortgage fees, cost
Balloon, callable loans
Dealer fees
Bonds, effective rate
Bonds, straight line
Schedules: FASB 91
Schedules: Other

Company
About Us
Contact Us
Technical FAQs

 

PREPAID EXPENSES SOFTWARE for
Prepaids, Deferred Charges and other Capitalized Assets
by Financial Data Support Systems, Inc.
for Windows® PC, laptop, workstation, networks
Database software to maintain
     •  Prepaid expenses
     •  Deferred charges
     •  Capitalized and other prepaid assets
     •  Monthly amortization, book value calculation - Several methods
     •  Allocate to branches, cost centers, departments, divisions
     •  Monthly History files - Archive records and reports for future retrieval 
 

Subsidiary ledgers with P&L, balance sheet reporting for
     •  Insurance premiums for 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
     •  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 
     •  Amortization terms from 1 to 999 months
     •  Begin amortizing immediately or
          Defer until a future month, then amortize or recognize all
     •  Also handles recurring expense and other debit with credit offset transactions
          (amount to amortize = monthly recurrence X recurring months)

Scroll down for highlights, samples, free demo and price.
.

..

 

 
 
 
 

 
 
 
 
.
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!
.


 
 
 
 
 
.
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 system
             Upload the file to your general ledger system
             Paste contents to a spreadsheet or elsewhere

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


 
 
 

 
 
 
 

 
 
 

 
 
 
 

 
 
 
 

 
 
 
 
.
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
The demos include a price list (amortize the cost for less than $7 a month).
To request prices via email, click support@fdssi.com
Download a free demo with prices
Click and save an underlined demo anywhere on your C: drive (the demo is not configured to operate on a network)
     Then double click the saved file to launch Microsoft's demo setup Wizard.
     Run the demo using the newly added FDSSI Desktop icon.  Add some of your records to the samples.
     When done, right click the icon to delete and remove everything.
Prepaid Expenses click to download this demo
Same, with cost center expense allocating click to download a demo with allocation methods
Reports only: Click to attach a file with your records and have us return sample reports in Excel.
.
Questions?  Not allowed to download software?
Toll free 1-800-245-8444 or email Support@FDSSI.com
Related Pages
Software to amortize, accrue Excel data
Services we offer for your existing file
Site Index
Top
Copyright © 1995 - 2008    Financial Data Support Systems, Inc.