Accounting Software
  Deferred Income, Revenue
Fixed Assets, FF&E
Accrued Expenses
FASB 91
Effective Interest Method
Bond Premiums, Discounts
Loan Fees
Effective Rate Schedule
Financial Data Support Systems, Inc.
Home Page
About Us
Contact Us
Technical FAQs
.
.
For
PC, laptop,
workstation and
shared devices
running Windows® 7,
Vista, XP, ME, NT and
other network versions
. 
Maintenance Agreement Software
Amortization and Reporting
.
.. 
 Track, manage, amortize ....
• Maintenance agreement fees
• Prepaid expenses
• Deferred charges
• Capitalized costs
• Insurance premiums
• Professional retainers
• Intangible assets
• Prepaid rent, occupancy		 • Durable office supplies
• Donations, gifts
• Memberships
• Security charges
• License fees
• Equipment, upgrade costs
• Taxes, certificates
• Dues and subscriptions		 • Software, programs
• Annual assessments
• Hardware fees
• Incorporation charges
• Marketing, promotions
• Recurring transactions
• Any expense over time
  Amortize to income
....
 
 A complete system - Comprehensive monthly and cumulative annual reporting
• FASB, GAAP compliant
• Full set of monthly reports
• Post current or prior month
• Terms for 1 to 999 months
• Monetary, editing history
• Expense allocation
• Calendar or fiscal year
• Notes and comments
• Tickler review/renew date		 • User defined reports
• Any chart of accounts
• No EOM or EOY tasks
• Export data and reports
• Account reconciliation
• General ledger upload file
• Enter and/or import data
• Adjustment handling
• Defer a start month		 • Capture prior month(s)
• Report filters
• Graphing functions
• Type classification
• Budget period projections
• Date range reporting
• Subtotal descriptions
• Documentation, Help, Tips
• 1-800, email USA support
...
.
 About your existing records
Conversion is easy!
  Three ways to convert existing records:
  1) Enter them directly into the software using the Editing screen.
          Afterward, enter new records using the same screen.
  2) Import Excel and other worksheet conversion data.
          Continue importing new records, too.
  3) Short on time?
          Send us a file and we'll convert your records.

Prior calculations:
  Preserve current Book Value and Accumulated.
  Or the software can recalculate everything in a consistent manner from the original date.

Import - How our clients use this feature:
  1) Most converted their spreadsheet records and now utilize the Editing screen.
  2) Some maintain all records in a spreadsheet and always import their entire file.
  3) Other clients converted, now use the Editing screen but also import new records:
        Files created at branch sites.
        Sent from their Accounts Payable (A/P) department.

Export, too.
  Copy any report and paste to a worksheet.
       Includes Book Value, Accumulated, Remaining Term
       Other calculated values "as of" any month.
  Copy all records.
  Use report filters to selectively choose and generate desired subtotals.
.
...
 History - Automatic data and report archiving
Save time when you need it the most!

Out of balance at end of month?
     •  Run the 'What's Changed' report.
          See what changes have occurred since last month.
     •  Isolate additions, deletions, modifications.
     •  Retrieve by/for each or a single general ledger account.

Automatically created History archive files.
     •  No more searching for old reports.
     •  Recall any report for any month.
     •  View and print.
     •  Export - copy an entire report to a worksheet.
     •  History allows you to go paperless.

All text changes plus monetary adjustments are maintained in activity logs.
     History tracks any changes made in Excel import files, too!

Lifetime amortization schedules - past and projected - along with critical memo Notes.

Recall monthly general ledger expense and offset account postings.

History allows for reports to span multiple months.
     Copy 12 month fiscal year recap to a worksheet, email to your auditor.
...
.
 Allocate monthly amortization
Generally, monthly amortization is posted directly to a general ledger expense account.

If need be, the software can create posting transactions for a single record to multiple:
     Branch, department, RC, cost center accounts.

Allocate using one or more Methods defined by you, such as:
     - Same percentage to each cost center (evenly).
     - A specific fixed percentage.
     - Varying percentage, based on:
           Workstation count, employee count, department square feet, revenue stream, asset dollars, more.
     - Which centers are to participate in an allocation Method.
     - Virtually any number of different Methods for any purpose that can be expressed numerically.

Allocating is easy:
     - Merely substitute the cost center portion of a general ledger account number with a Method.
          Cost center identifiers can be of any length.
          They can be located at the beginning, middle or end of an account number.
     - A Method can even be shared among records having different base account numbers.

Audit trail:
     The system creates a report showing how each amount was allocated.
.

Scroll down for
Samples
Highlights
Price
Download a free demo

.
Software to recognize the cost of maintenance agreement and amortize other fees for any purpose on a monthly basis.

 
 


 
 

Tracking data
Record Layout		 • Enter your records into the software
• Import your records from a worksheet		 Usage
Description Alphanumeric description of the record Required (only 7 values required)
Additional Description More alphanumeric description Optional use - not required
Begin Date When purchased, obtained or established (Alternate Begin Date, below, can delay amortization) Required (defaults to today)
Cost Amount to amortize, up to 99,999,999.99.  Amortize negative amounts, too. Required
Calculation Method 1=Straight line monthly.  2=Date to date actual days.  3=Sum of the years digits....  5=Recurring entry Required (set a default method)
Term in Months 1-999 months.  0=do not amortize (perhaps "in service date" is unknown) Required (set a default term)
Debit Account General ledger expense account for posting file debit at individual record or Account subtotal level Required (set a common account)
Credit Account General ledger asset offset account for posting file credit at individual record or Account subtotal level Required (set a common account)
Control Account Group, subtotal and report multiple Credit accounts (typically used only by large organizations) Optional use - not required
Take Prior thru Date Include prior amortization expense in current month if a new record Begin Date is a prior month Optional use - not required
Type Code User defined codes for grouping and reporting records by type of expense finer than Debit Account Optional use - not required
Vendor Code User defined codes for grouping and reporting records by vendor, supplier Optional use - not required
Link Code User defined codes for grouping and reporting records by a common purpose or project Optional use - not required
Alternate Begin Date Defer amortization to a future month or effective month to begin amortizing a conversion book value Optional use - not required
Alternate Amount A new amount to amortize, used when adjusting Cost or preserving a conversion book value Optional use - not required
Alternate Term A new, remaining term in months (including "1" to write off) over which to amortize an Alternate Amount Optional use - not required
Notes Expanded text entry, typically for creating an exceptions and changes auditor note Optional use - not required
Amortized "as of" Month The most recent month for which amortization was calculated by the system (prior, current, future) Selected calculation month or months
Expense Amount Expense recognition for the Amortized Month Calculated by System 
Accumulated Accumulated expense through the Amortized Month Calculated by System
Book Value Non amortized portion of Cost yet to be expensed Calculated by System
Months Taken Number of months expensed through the Amortized Month Calculated by System
Months to Go Remaining number of months yet to be expensed Calculated by System
Months Past Number of months since amortization was finalized Calculated by System
Review/MaturityDate When amortization will be complete - for Tickler File reporting and renewal needs Calculated by System
ID Number Unique IDentification number to segregate, edit and retrieve amortization and editing history Assigned by system (or you)
Enter:
An editing screen with documentation and error checking features allows for entering new and editing existing records.		 Import:
Simply place worksheet column letters into a Record Layout Import Table.
"Description" might be your worksheet column "A" or "C" or ....
"Cost" might be your worksheet column "D" or "G" or ....
"Alternate Amount" might be your current Book Value column "E" or "R" or ....
     (the system can calculate Alternate [remaining] Term)
Import cell data values.  Also import values derived in formula cells..		 Export:
All Record Layout values, including calculated values, can be exported by copying a report (with or without subtotals) and pasting the report to a spreadsheet.  Export all records or use filters to select specific records.

 


 
 

Report Layout
 View reports on screen (set font size and style)    •    Send to local or network printer    •    Copy and paste to a worksheet    •    Recall an old report from History archive
My Company Name General Ledger Subsidiary Trial Balance
Expense Accounts sorted and grouped within Prepaid Asset Accounts 		 5/28/2010    Page 1
Description Additional Description ID Begin Cost May'10Exp Accumulated BookValue Term ToGo Review
MyRecord A Inv #12345 1 11/1/2009 3600.01 300.00    2,100.01    1,500.00 12 5 11/1/2010
MyRecord C 4 1/5/2010 4,654.23 258.57 1,292.82 3,361.41 18 13 7/5/2011
MyRecord D Approved by G Gray 3 2/17/2010 563.22 46.94 187.70 375.52 12 8 2/17/2011
My First Expense Account Number GL Debit 3 records 8,817.46 605.51 3,580.53 5,236.93      
               
                   
MyRecord B Check# 789012 2 12/1/2009 1,250.00 69.44 416.72 833.28 18 12 6/1/2011
MyRecord E 5 2/12/2010 771.99 96.50 385.99 386.00 8 4 10/12/2010
MyRecord F P/O 9876 6 3/15/2010 14,536.66 1,211.39 3,634.15 10,902.51 12 9 3/15/2011
MyRecord G 7 5/7/2010 1,234.56 102.88 102.88 1,131.68 12 11 5/7/2011
My Second Expense Account Number GL Debit 4 records 17,793.21 1,480.21 4,539.74 13,253.47      
               
                   
My First Prepaid Asset Account Number GL Credit 7 records 26,610.67 2,085.72 8,120.27 18,490.40      
      Posting file debits and credits   General Ledger Balance    
 .... continues with your next set of Expense Accounts for your next Prepaid Asset Account.
     The "Monthly Posting" report stream then provides a Journal Voucher report and creates a posting file for updating the general ledger.
 The software comes with a complete set of managerial and accounting reports plus "MyReports" and "MySubtotals" for any additional needs. 
 Reports, filters, sorting and subtotals can be created using any Record Layout value(s).
 Results can be evaluated in a Graph mode.  Example: Cost dollar amount by Review month to graph anticipated cash flow and budgeting for renewals.
 Expense, Accumulated and Book Value can be reported for any month or range of months (as a period total or in multiple sets of columns for each month in the range).
 Report columns can be expanded to include all Record Layout values, ideal when exporting to a spreadsheet, especially for audit purposes.

 
 
 
 
Software Highlights
.
 Monthly Report Stream
Trial Balance report for reconciling to general ledger
      Supports any general ledger chart of accounts
      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 formatted for ACH, NACHA processing

No close out required.
     Discover an error afterward?  Merely fix and rerun.
...
.
 Features not found in many other systems
Easy to use set up screen with field entry documentation
     Plus, import data from Excel and other spreadsheets
Automatic Review/Maturity date calculation for tickler file reporting
System generated ID numbers.  Or assign your own
Terms of 1 through 999 months
Maintain up to 99,999 records
"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
Notes
     •  Maintain important and other information about a record
     •  View, print and even include Notes on a report
     •  Retrieve old Notes from a prior month History file
Edit Several
     •  Walk through records while editing
     •  Advance to next or previous
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.
     •  Non amortizing recurring expense, fixed or monthly variable
User defined codes for Vendor, Type and other reporting
     •  Link records to aggregate by common purpose
     •  Tables for meaningful subtotal descriptions, such as Vendor names
GAAP, AICPA, FASB compliant.
...
.
 Applicable for these records and more
     •  Prepaid expenses
     •  Capitalized cost and other prepaid assets
     •  Deferred charges
     •  Insurance premiums for
               Hazard, fire, flood, auto, life, D&O, health, bonds, other
     •  Maintenance agreements: Hardware, software, other 
     •  Office, building, branch supplies having a shelf life
     •  Equipment and upgrades
     •  Bond and investment premiums, 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
     •  Leasehold improvements
     •  Donations, gifts
     •  Capitalized, fiduciary property upkeep
     •  Other prepaid expenses and deferred charges
     •  Recurring transactions
         Fixed amount
          Variable amount
     •  Any amortizing record with a monthly debit and offsetting credit
...
..
 Exception handling
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.

Are you ever out of balance?
     The History Audit Report shows monthly changes to each general ledger account.
...
..
 Reporting Features
Full set of accounting and managerial reports:
     - Trial Balance
          Subtotals and report totals for count and amount
     - Journal Voucher
          Undo.  Reverse a previously created debit/credit upload posting file
     - New records report
          For the prior month, year to date or other time period
     - Maturity/Review date report (tickler file)
          Which records will finish their term this month, next month or other time period
     - 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
     - Description files to provide meaningful information at report subtotal levels:
               • General ledger chart of account names
               • Type codes
               • Vendor codes
               • Record link codes
               • Enter descriptions into the software or copy/paste from another source.
     - Apply filters, date selections and set calculation month, range of months and year end periods
     - Export reports
          Copy and paste any report to a spreadsheet
          Copy column headings, records, calculated values and subtotals

User defined reports:
     - MySubtotals report. Filter and group by selected fields on the fly.
     - MyReports. Create and retain your own commonly used reports.
     - View, print, export these reports, too.
...
..
 On Demand Reports
Calculate amortized results:
     As of any month or year end period
     For a range of future months
     For a historical month, range of months, entire fiscal year
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 book value 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.
...
.
 Converting your records (or import, below)
Even if you inherited a junker file, your existing records can be converted to the software.
     Retain current accumulated and book value or
     Recalculate accumulated and book value from day one
Unique data conversion values can be incorporated, too.
Be up and running with a solid system today!
...
.
 Excel import

The software comes with complete record handling capabilities:
     Add, edit, delete records.
     List, sort, export and more.
     Nothing else is required to manage your data records.

Additionally, the software can import data from Excel and other spreadsheet files.
Importing allows you to add records from another source to the software.
     Import dozens, hundreds, even thousands of records.
     Import once as a conversion and/or
     Import on an ongoing basis.
          Always import your entire worksheet or
          Add new records from a file that was created at another source.
     The software verifies data values are of a correct format and lists any conflicts or errors.
     And automatically calculates a maturity/review/tickler file reporting date.
     Current accumulated and book value for existing records can be preserved or calculated by the system.

Importing a file is easy:
     1)  Copy an entire worksheet or highlight and select desired rows.
     2)  Click the Paste icon on the software's Import screen.
          That's all it takes!
     An Import Table maintains worksheet Column Letter cell values.
          Example:  "Description" might be your worksheet column "A" or "C" or ....
          An option switch allows you to replace all existing records or add (append) new records.
     The "Copy from" source can be an Excel worksheet, other spreadsheet program or any tab-delimited file.
...
.
 History and File Archiving
Never lose a report again:
     •  Automatic record and report archiving for retrieval at a future date
     •  Review all changes made (old value, new value) to a record during its entire term
     •  View and print reports for any prior month and year.
            Send reports to Excel.  Email requested information to your CPA/auditor.
            Span fiscal year - display general ledger annual expense for each month.
     •  Go Electronic!
           Monthly history files allow you to print reports only when necessary.

.

 Partial list of clients using one or more of our software products....
Bank of New York
Honeywell
NBC Universal
SafeAmerica CU
Canon USA
Medcenter One, Inc.
Arrowhead
xpient Solutions
Integrated Production 
Penncro Associates
Legacy Texas Insurance
NBRS Financial
Credit Factor Corp
RAF Technology
Roanoke County
Cracker Barrel		 Houghton Mifflin
Air Force Federal
First Tennessee
Metavante
Iowa HSAA
Baptist Health System
Carolina Alliance
United Community
Mecca, Inc
Safra National
MemberSource
US Global
Cloister Wash & Lube
Damariscotta B&T
Integrity
Hostelling International		 First Horizon
ViDeOnline Inc.
Tioga County
Ektettab
Carthage Area Hospital
National Council
Equity Plus
Pullman Memorial
Franklin Savings
D&A Mortgage Funds
West Georgia Health
Axxya Systems
Midland Community
First American
Electro Savings
Omni Capital		 Alliance Imaging
Crescent Bank
EUP Property Investment
West Point Underwriters
OST
Progressive Gaming
Holy Spirit Hospital
TELUS
Thomson Financial
Clark Nuber, PA
McCombs Enterprises
WESLA FCU
Seaway National
Mindworks, LTD
Cross County
Atlantis Marine World
.
.
 Price and Free demo
Price page contains a link at the bottom of the page to download the free demo.

Click to open and view price page.

Questions?  1-800-245-8444 or
email Support@FDSSI.com
Site Index
About us
Contact us
Top
Maintenance Agreement Software for Windows® PC, laptop, workstation and network sharing by
Financial Data Support Systems, Inc.  Copyright © 1995 - 2010 
maintenance fee amortization software, maintenance cost allocation, maintenance amortize, maintenance cost software, maintenance costs software, maintenance agreement software, maintenance agreements software, maintenance expense software, maintenance income software, allocate maintenance fee, allocating maintenance fees