Cost Accounting Amortization Software  


 Financial Data Support Systems, Inc. 
Custom Software, Services
MBS, GNMA, LSBO packages
FASB 91 Loan fees
FASB 91 Dealer fees
Prospective, Retrospective
FASB ASC-310-20
FASB 91 - all products
Bond Purchasers - Level Yield
Bond Purchasers - Straight Line
Bond Issuers with issuance costs
  Prepaid Expenses, deferred charges
Deferred Income, revenue
Fixed Assets, FF&E  
Daily, weekly, weeks, 4+4+5
Home page
About, contact us
 
Hard to find

Accounting Software for





Prepaid expenses, deferred charges amortization

using monthly and date-to-date recognition methods

•  Monthly expense recognition for all records at the same time    Deferred Income, unearned revenue

•  Amortize from original begin dates or current conversion balances forward

•  Excel version:  Browse, import a worksheet, amortize any month, generate all reports

•  Excel days:  Browse, import a worksheet, amortize from any date to any date, generate all reports

•  Methods for full months, partial months and date-to-date "in service" recognition at the record level

•  Establish your own methods for unique circumstances such as specific monthly $ or % amounts

•  Expense distribution for selected records to multiple branch, cost center accounts

•  General ledger subsidiary listing, expense within asset accounts

•  Journal voucher recap with debit, credit columns

•  General ledger posting file

•  Account reconciliation - monthly, yearly beginning balances, activity, ending balances

l
   

Easy to evaluate
  •  Nothing to install
  •  Create a temporary folder
  •  Download a free demo
  •  Unzip a file
  •  Run the program
  •  View reports with demo records
  •  Add your records, run more reports
  •  Delete folder when done
     (or "roll" demo into a live system)
Scroll down to price page for demo
Prepaid expenses software

Track, manage, amortize ....
•  Prepaid expenses
•  Deferred charges
•  Capitalized costs, assets
•  Insurance policies, premiums
•  Maintenance agreements
•  Professional retainers
•  Intangible assets
•  Prepaid rent, occupancy 
•  Durable office supplies
•  Donations, gifts
•  Memberships
•  Security charges
•  License fees
•  Equipment
•  Taxes, certificates
•  Dues and subscriptions
•  Annual assessments
•  Software, programs
•  Hardware fees
•  Incorporation charges
•  Upgrade costs
•  Marketing, promotions
•  Excel records
•  Any expense over time

Scroll down for
     •  Highlights
     •  Price
     •  Free demo
 



















Regular monthly amortization or
tie expense recognition to an
actual "in service" period



Exception handling:
•  Delay amortizing to a future date
•  Catch up prior expense if set up late


Allocation:
•  Distribute amortized expense for
   selected records to multiple cost
   center accounts


Records:
•  Enter to the software database and
•  Import from Excel
 














































 
Free demo
  •  Nothing to install
  •  Create a temporary folder
  •  Unzip a file
  •  Run the program
  •  Delete folder when done


Free conversion
  •  For demo or live system
  •  Send a worksheet with records
  •  We'll convert to the software
  •  Preserve current book values
  •  Guaranteed balancing
  •  Get a turnkey system

              -  OR  -
 
 •  Send a sample file layout
  •  Include a few "test" records
  •  We'll set up a conversion table
  •  You import, convert your records 
 
 


 












Managing your records
     •  From within the software ....
               Add existing and new records using a data input screen with user assigned default values
               Instant amortization schedule helps verify data was entered correctly
               Edit records at any time for any purpose
               Adjust a record during the amortization term due to
                              Additional funding
                              Partial refunds
                              Early write-off
               Easily delete fully amortized records when you decide to purge the file
               No end-of-year chores, carry forward problems, file initialization ....

     •  Import records, too - several options
               Import records from a worksheet once, as a conversion
               Import all records every month
               Import new records each month

     •  Export records and reports to Excel and Adobe
  






First month's expense for a new record
Full and partial month recognition choices at the record level
     • Recognize entire month (default)
     • Utilize Half Month convention
     • Recognize actual remaining days in month. 9, 23, 4 ....
     • Defer recognizing until a future "in service" month
     • Include prior month(s) amortization if the record should have been set up a month or two ago


Existing records
     •  Preserve current book values or have the software calculate them
  






Single step monthly processing
     •  Expense amortization for the desired month - current, previous, other
                    Direct postings as well as branch, department, cost center accounts

     •  Subsidiary listing with subtotals for all expense and asset accounts
                    Supports any chart of accounts
                    Post to direct accounts and
                    Post to branch, department, cost center accounts

     •  Journal voucher with debit, credit column recap
                    Subtotals level or
                    At the record level
     •  Upload posting file for importing to any general ledger system

     •  Send reports to screen, local or network printer, Adobe.  Export to Excel.

     •  Find a big mistake?  Forgot to enter some records?
                    Simply fix the problem and rerun the reports.
                    Already updated the general ledger?
                              Run "Reversal" to undo.
                              Then fix the problem and rerun monthly reports.
  





Amortization Methods
     •  Multiple amortization methods assigned at the record level:
               30 day financial months (default method)
               365/366 actual days in each month
               Half month convention
               Sum-of-the-years-digits for accelerated recognition up front
               Daily amortization, days, weekly, 4-4-5, quarterly and other periods amortization software

     •  User defined recognition methods:
               Variable monthly percentage, such as 14% the first month, 11.25% the second month ....
               Specific dollar amounts each month, such as $400 the first month, $525 the second month ....
               Inventory take-down and others, where monthly recognition is cost X (number of units consumed / total beginning units)
  






Amortization Terms - Months or Days
    •  Assign an amortization term at the record level:
               1 month through 999 months (default term is 12 months)
               Partial months
               Actual date to any date period  (e.g., April 12th to June 6th = 19/55 days, 31/55 days, 5/55 days)
               Recurring amounts, fixed or variable

     •  Adjusting a term - single step procedure
               Use the record Adjustment screen to change the remaining term to any shorter or longer term

     •  Cancel, stop amortizing or write-off a record - single step procedure
               Use the record Adjustment screen and change the remaining term to 1 month
               The system will recognize remaining book value in full
  


 



Additional reporting capabilities
     •  Reconciliation Report, Auditor's Worksheet
                    Any month.  Range of months.  Entire year.
                    Columns:  Beginning balances plus New records minus Amortization equals Ending Balances
     •  Administrative reports with filter capabilities for internal purposes
     •  Tickler, review date reporting
     •  Vendor totals reporting
     •  Type, expense category reporting
     •  Consolidation totals regardless of expense account by project or purpose categories, such as IT
     •  User defined reports with subtotals at any level
     •  Expense, accumulated and book value (3 columns per month)
                    For a range of months prior or future months
                    For entire calendar or fiscal year
  





Retrieve old reports
     •  The system creates a historical archive file each month
     •  Run any report from any month and year at any time in the future
     •  A great tool to have during audits and examinations
  






Allocate (distribute) monthly expense
     •  Allocate one or more selected records
     •  Distribute amortized expense for one or more records to multiple branch, cost center accounts
     •  Use one or multiple allocation methods
  










PRICE PAGE with FREE DEMO
Click to open and view Price page
     Try a free demo, also available on the price page
               Download the free demo right now to get a feel for how the software operates.
               The demo is the live software and can be rolled into a permanent system.




OTHER VERSIONS
We also offer other versions of the software.
If you need something you don't see, please contact us with your requirements
and we'll let you know whether or not they can be met.
     Email  Other versions of the software








 




 

Features ....
•  Post "as of" any month
•  Span calendar and fiscal years
•  No monthly close out
•  No end of year chores
•  Amortize expense over 1 - 999 months
•  Multiple amortization methods
•  Defer amortizing to future month
•  Capture prior month(s) amortization
•  Windows 7, 8, 8.1 and 10 
•  1-800 and email support

•  Balance sheet reconciliation
•  General ledger transaction posting file
•  Records retention
•  Adjustment screen for changes
•  Allocate to multiple cost centers
•  Month by month expense projections
•  Tickler review/renew date calculation
•  Audit year 12 month recap recon
•  PC and network sharing versions
•  Instant amortization schedules

•  Report filters
•  Graphing functions
•  My Subtotals report
•  Type classification
•  Date range reporting
•  Export to Adobe and Excel
•  User defined allocation methods
•  Enter records and/or import records
•  Paper reports or go electronic
•  Documentation, Help, Tips


"Thank you so much for your help.
  It’s so refreshing to talk to someone who understands!"

               Oakland, CA


"We have been using your software for some time.
  This system has always been so easy to utilize and we really appreciate the level of detail in the reports."

               Albemarle, NC












GENERAL LEDGER
     •  Supports any general ledger chart of accounts
     •  Supports direct posting to accounts and allocation to multiple cost center accounts
     •  Creates an upload posting file for any general ledger system
     •  The software can "break apart" account numbers and place specific portions into different columns.



DIRECT POSTING
     •  Monthly amortization can be posted to direct expense accounts



ALLOCATION - COST ACCOUNTING
     •  Monthly amortization for one or multiple records can be distributed to:
               Branch accounts
               Department accounts
               Cost center accounts
               Other internal designations

     •  Distribute amortized expense using:
               One allocation method
               Multiple allocation methods

     •  Define your own allocation methods, such as but not limited to:
               Branch, department, cost center count wherein each receives the same expense portion.
                         Create a single record for an expense to be distributed among branches.
                         If 5 branches, each receives 1/5 of monthly amortized expense.
               Participating branch, department, cost centers wherein only some receive a portion.
               Percentage.  Assign varying percentages to be allocated to each.
               Square feet, such as allocating to departments based upon space occupied.
               Employee count, wherein allocation is assigned based upon number of employees.
               Workstation count, allowing IT expenses to be allocated based upon assigned equipment.
               Other user defined allocation methods.

     •  A branch, department or cost center can be located anywhere within your account number.

     •  Assign an allocation method within the expense account number at the record level.
               An allocation method can be assigned to multiple records.

     •  The software replaces a method with as many branch, department, cost centers assigned to the method.
         Examples:  4000-MMMM might become 4000-0001, 4000-0002, 4000-0003 ....
                           01-MM-1655 might become 01-01-1655, 01-02-1655, 01-03-1655 ....
                           MMM8888 might become 0048888, 0078888, 0258888 ....
 











                                                                        REPORTS  LISTING


General ledger reports:
     •  Monthly Posting Report Stream: Trial Balance Subsidiary Listing + Journal Voucher + General Ledger Posting File
     •  Monthly Posting short version: Journal Voucher + General Ledger Posting File
     •  Trial Balance Subsidiary Listing: Group and subtotal by General Ledger Expense within Prepaid Asset Accounts
     •  Multiple Months: Expense Amortization for prior or future periods such as two months, a quarter, full year and other date ranges


Reconciliation reports for asset and expense accounts - 1 to 12 month range:
     •  History Audit Report: Posting activity for a range of months, including Reconciliation for the period
             Beginning balances, plus new records cost, minus amortization expense, plus or minus adjustments = Ending Balances
             Automatically create the annual schedule utilized by your CPA auditor in a matter of seconds.  Export to Excel.
     •  History Audit Report: Changes that would impact general ledger reconciliation


Administrative reports - Standard data:
     •  My Subtotals: Trial Balance Subsidiary Listing with subtotals for one or multiple sort values
     •  Special Reports: Create a one-time report containing records meeting specific date and other field value filters
     •  My Reports: Create reports to be run on a repetitive basis using your selection and subtotal requirements
               Example: Create a monthly report containing new records with cost greater than $2,000.00. Or Terms greater than 12 months.
     •  New Records Report: Records with Begin Date falling within a date range
     •  Review/Maturing Report: Records with Review/Maturity Date (calculated by the software) falling within the current or future month
     •  Method Report: Group and total by Calculation Method
     •  Alpha Report: List Records alphabetically by Description
               Calculate expense and balances for a month or multiple months. Export to Excel for internal/external purposes.


Administrative reports - User defined, optional entry data:
     •  Type Code Report: Group and subtotal by Type Code
     •  Record Link Key Report: Group and subtotal by Record Link Key
               Group and subtotal records based upon a common bond such as a special project
     •  Vendor Code Report: Group and subtotal by Vendor Code or Name


Allocation report:
     •  The system can distribute amortization expense for selected records to multiple branch, cost center accounts.
     •  The Allocation Report provides a detailed listing as to exactly how expense for each was distributed.


With reports:
     •  View on screen
     •  Send to local or network printer
     •  Send to Adobe
     •  Send to Excel











                                            ABOUT REPORTS

•  Include all records or use filters to select only the records you want

•  Subtotal on any value, multiple values

•  Amortized expense, book values and totals.  Any month.  Any year.  Any period.

•  Calculate expense amortization and book values for multiple months, an entire year.
          Display monthly expense in a single column or multiple, month by month columns.

•  View reports

•  Send to local or network printer



                              EXPORT DATA and REPORTS

•  EXCEL - Export to Excel - format and populate a worksheet with a single click

•  ADOBE - Archive to Adobe, create a .pdf file with a single click



                               COPY DATA and REPORTS

•  Use the Copy feature to copy and paste reports elsewhere

•  Copy also creates a Tab-Delimited text file which can be imported to other programs

 









                    Options for existing records and book values
Option 1
               Preserve existing book values.
               No need for any adjusting journal entries.
Option 2
               Calculate prior and current book values.
               The software can amortize costs from original dates.
Option 3
               Begin amortizing from an "as of" date.
               Typically the beginning of a calendar or fiscal year using prior EOY balances.


                    Options for managing records
Option 1
               Enter records directly into the software.
               An easy to use setup screen and documentation guide you.
               View an instant amortization schedule verifying what was entered.
Option 2
               Import Excel records once.
               Import one or more worksheets as a conversion to the software.
Option 3
               Always import all records from an Excel worksheet.
               Maintain records in Excel.
               Import to the software at any time for monthly amortization and reporting.
Option 4
               Combinations of the above.
               Enter records to the software.  Import new records from Excel.
 

Amortization and reporting for
     •  Your records
     •  Subsidiary records
     •  Client records - Maintain or import client records from Excel.
        Amortize records and provide a monthly set of reports in Adobe or Excel.
 




  Prepaid expenses amortization
  •  Enter records to the software and
  •  Import records from Excel










"We have been using your software for some time.  This system has always been so easy to utilize and we really appreciate the level of detail in the reports."
               North Carolina



 











Custom


The software can be modified to meet the needs of a specific client.

Modifications typically fall into these areas:
     •  Importing, scrubbing files and records to the software
     •  Unique subtotals and totals
     •  Special reports
     •  Exporting records, reports, other results to Excel

For more information about customizing, email  Support@fdssi.com
 
 




 











Need a specific answer?
email (modify) any of these questions initially posed by our clients
     NETWORKS:  We have several people who need to be able to access the software.  What is the maximum ....
     MY CLIENTS:  I'm a CPA who needs to amortize records for my clients each month and send them ....
     RECONCILIATION:  I need to reconcile general ledger accounts covering the period  ....
     AMORTIZATION METHODS:  In addition to 30 day financial months, I want to amortize some records using ....
     AUDIT:  Is there a way to verify monthly amortization results?   I need to be able to ....
     ODD TERMS:  I have some records with relatively short terms that need to begin amortizing as of specific dates for terms of ....
     EXCEL:  My records are in Excel and I need to keep using my worksheet(s) for ....
     ALLOCATION:  Will your software distribute monthly expense for some records to multiple cost centers using these allocation methods ....
     PURPOSE TOTALS:  Can I get a report linking the cost of records with totals by purpose, such as IT expense or  ....
     BIG FILES:  We have more than four hundred thousand records to amortize each month and need an easy way to ....
     4+4+5:  We are on a 13 week accounting basis.  Amortization posting for each period must cover ....
     DAILY AMORTIZATION:  Can your software amortize records for a single day?  For a couple of days?  For ....
     CUSTOM:  Can you customize the software to ....
     MY REPORTS:  I want to be able to create some of my own reports using Excel, such as ....
     Or, just ask a question ....









                                      HANDY FEATURES

Delete:
An easy process to use whenever you want to clear out old records.
     •  Sort records by current Book Value.
     •  Records with a 0.00 Book Value will be at the top of the listing.
     •  Select some or all with a Book Value of 0.00.
     •  Selected records will be deleted in a single step.


Quick Totals:
Let's say you just added a bunch of new records.
Are you in balance with your general ledger?
Run Quick Totals:
     •  Select totals by Prepaid Asset Accounts.
     •  Old records:  Book Value will be as of prior month end.
     •  New records:  Book Value will be Cost.
     •  The system will combine both into a single Total amount.
     •  Each Prepaid Asset Account Total on the report should tie to the general ledger.


My Subtotals Report:
Generate an amortization report as of any month.
     •  Select all records or use filters to limit which should appear on the report.
     •  Generate subtotals for up to five (5) different values.
     •  The report can include records or, for a shorter report, subtotal rows only.
Example 1:
     •  Select all records with a Begin Date on or after the 1st of the year.
     •  Sort records by Begin Month.
     •  Obtain Cost subtotals for each month. 
Example 2:
     •  Select all records with a remaining Book Value greater than $5,000.00.
     •  Sort records by Prepaid Asset account.
     •  Obtain Book Value subtotals for each Prepaid Asset account.


Export to Excel:
Perhaps a My Subtotals Report (above) has to be sent to someone who requested it.
While viewing it or any other report,
     •  Click a single icon to populate a worksheet.
     •  The system automatically copies all columns and rows, formats a worksheet,
         then opens an Excel file with the formatted worksheet and data.
     •  Save the Excel file under any assigned name.
     •  If applicable, send the Excel file attached to an email.





 
 




About us:
  •  In business since 1982
  •  On the Internet since 1995
  •  Our market niche is Amortization Software
  •  First page rankings on Google and Bing



About the software:
  •  Written in Microsoft's .NET Framework
  •  Operates on any MS product line
  •  Install to PC or network sharing device


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






 



PRICE PAGE with FREE DEMO
Click to open and view Price page
     Try a free demo, also available on the price page.
               Download the free demo right now to get a feel for how the software operates.
               The demo is the live software and can be rolled into a permanent system.




OTHER VERSIONS
We also offer other versions of the software.
If you need something you don't see, please contact us with your requirements
and we'll let you know whether or not they can be met.
     Email  Other versions of the software



 



 
 
 
 
 




 

 Client testimonials ....

  This is just a quick note to let you know that the software is up and running.
  More importantly, we love the software!
  Thank you so much for your help and we look forward to working with your company in the future.

               Hollywood, FL


  Thanks for your help today.  We imported all of our records and current balances without a problem.
  Your software is as advertised and will be most useful.
               Houston, TX


  We have been using your software for some time.
  This system has always been so easy to utilize and we really appreciate the level of detail in the reports.

               Albemarle, NC


  Thank you so much for your help.
  It’s so refreshing to talk to someone who understands! 

               Oakland, CA


  We just installed your software last month.
  The software has already saved me hours for forecasting models.
               Paducah, KY


  Thanks.
  Your customer service is fantastic!
  Have a great week.

               Redmond, WA








Why others chose our software ....

•  Customizing
   The needs of most clients can be met with capabilities and features already found within the software but
   some had us write special programming, reports or export routines to meet their unique requirements


•  Expense allocation
   Selectively distribute monthly amortized expense for a single record to multiple branch or cost center accounts


•  Reconciliation report
    Determine all changes to general ledger accounts for a month.  For entire audit year.


•  Single step adjustment screen
    Increase book value, decrease book value, change remaining term with a single entry


•  Defer amortization to an "in service" date
    Delay recognizing an expense until a future month (also, catch up for prior months if the record wasn't set up on time)


•  Export
   Copy all reports to Excel.  Copy all records or filtered (selected) records to Excel. 





Importing records from Excel

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.







Reports

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
     - Records only
          Create a file amortized for any period consisting of all or filtered records
     - View, print, export reports to Excel







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.







General ledger systems

Supports any chart of accounts.
Post as:
     Direct expense and
     Allocation:
     Monthly amortized expense for a record can be distributed to multiple expense accounts.
          •  Allocate using different methods:
                    You define each method
                    Percentage, square feet, number of employees, workstation count ....
          •  Allocated amounts flow into the journal voucher and posting file for automatically updating the general ledger

Format monthly postings as a:
     Disk file and
     Excel export. Standard worksheet format with ability to meet special column layout requirements at no extra charge
     ("break up" general ledger account into multiple columns, single or dual debit/credit columns, header row, other needs) 

General ledger posting ....
The software can format transactions for posting to any general ledger system.
Output to disk file, Excel worksheet, other.
          Columns and data layout in any order (including blank, filler and generated values)
          Transaction codes
          Prior month backdating (ex: post in May with effective date of April)
          Header, trailer and totals records
          Multiple debit, credit columns or a single column with credits identified by "-" or "( )"
          Undo (reversal)
Generate debit and credit transactions as:
     Summary totals for each general ledger account or
     Individual transactions for each record
Monthly amortization can be:
     A direct posting to an expense account or
     Allocated (distributed) to multiple general ledger cost center accounts
General ledger account numbers can be:
     Uploaded as entered or
     Split into multiple posting file columns in any order (account number, company code, cost center, department, region, sub coding ....)







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?  Defer amortizing to a future date?
     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.






History - Automatic data and report archiving

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







Account reconciliation report - monthly, annual

Reconcile your prepaid asset accounts.  In seconds!
Reconciliation Report columns:
          Beginning balance for each record (the previous month ending balance)
          +  New record amount if the record was added during the period (Beginning balance would be zero)
          -  Amortized expense
          -  Partial refund if an adjustment was made, funds returned
          +  Additional receipts, partial increase
          =  Ending balance
                   Column totals for all records within each prepaid asset account
Out of balance?
     Simply compare the Reconciliation Report to your general ledger asset account activity.
     Run the report for a single general ledger account or all accounts.
Reconcile a single month or range of months.
Reconcile an entire year - great when auditors want to see annual changes to your prepaid asset accounts.






How our clients handled their existing records

  •  Some entered their records directly to the software, doing a "clean up" as they went along.

  •  Some imported and converted their records to the software from an Excel worksheet or other spreadsheet.

  •  Some imported and converted existing records. And, they continue to import new records each month
      from Excel worksheets created at branch sites.

  •  Some never converted.
     They began entering new records to the software and allowed existing records to finish amortizing the "old" way.

  •  Others never converted.
      They always import all of their existing plus newly added records to the software each month from Excel.






Supports all of these amortization recognition methods at the record level

  •  Straight line monthly, 30 day financial months (typical recognition method)

  •  Straight line monthly, actual days in month with start and end dates

  •  Half month convention

  •  Partial first month and or last month

  •  Time:  Hours, days ....
      Recognize professional and other prepaid fees and retainers by actual hours or other time
      periods (including zero) performed each month

  •  Dollars
     Assign the specific dollar amount (including zero) to be recognized each month in advance or as it becomes known

  •  Percent
     Assign the percentage  to be recognized each month (including zero) in advance or as it becomes known

  •  Count
     Inventory, office supplies - recognition is based upon monthly usage so book value represents actual value of items on hand
     If inventory count remains at the end of anticipated term, simply extend the term

  •  Products
     Recognize expense based upon the receipt of a prepaid product delivered over a staggered interval

  •  Services
     Recognize expense based upon the delivery of a prepaid service delivered over a staggered interval

  •  On demand
     Enter the amount you want to recognize this month based on external factors

  •  Frequency, non-monthly
     Recognize expense in certain months only, such as quarterly or any other calendar or fractional period

  •  Units, other
     Establish your own definition of units to determine monthly and non-monthly recognition



 





  Price page and free demo  ....

Click to open and view  Price page
Stand alone and network sharing prices.
Evaluate the software with a free demo available on price page.
       The demo is the live software and any records added can be rolled into a permanent system.


Excel template:
Request a free Excel template via email
     View information regarding records.
Free reports:
If desired, return the Excel template with two or three actual or sample records.
We'll import, generate and return the same file with a set of monthly reports.




  Customizing the software ....
Need something unique to your operation?
We wrote the software so we could modify it to meet client requirements,
typically through an import, export process:
     1)  IMPORT
               You import an Excel worksheet(s) containing your records.
               The software can modify data values.
               Perform "if this, then that" routines.
               Table lookup data assignments.
               Other requirements.
     2)  EXPORT
                Export calculations and reports to Excel.
                Export all or filtered records meeting your selection criteria.
                Modify data values during the export process.
                Specific column headings and column order.
                Other requirements you may have.

To find out more about customizing the software for your needs,
please contact us at your convenience.







More about the software ....

Monthly amortization and expense recognition for terms of 1 month up to 999 months
          Straight line, 30 day financial months
          Half month convention, 30 day financial months
          Partial month amortization, 365 actual days in each month
          Actual in-service date to date, 365 actual days in each month
          Alternative methods - percentages, designated dollar amounts, take down usage and more

•  New records:  Exceptions
          Defer amortizing a record until a future begin date
          Catch up amortization from a prior month(s) when not set up when it should have been

•  Amortizing records:  Adjustments during term
    Single step adjustment screen to handle changes during amortization term
          Increase or decrease amount being amortized at any time
          Write off the record immediately without deleting it
          Extend or shorten a term

•  Span calendar and fiscal amortization years
          Cross over EOM, EOY periods without doing anything
          No monthly or annual close-out involved
          Cross over EOM, EOY periods without doing anything
          No monthly or annual close-out involved

•  Historical archive reporting
          Generate any report from any prior month at any time

•  Prepaid Asset account reconciliation
          Compare balances and activity for one or more general ledger accounts over one or more months.
          Pinpoint any out-of-balance conditions.
               Beginning balances.  New additions.  Amortization.  Adjustments.  Ending balances.  Net activity.
          Audit schedule preparation.
               Provide detail activity from beginning of through end of calendar or fiscal year.

•  Audit and examination support
          1-800 and email assistance
          Many of our clients are CPA and accounting firms
                    Some import and calculate files for their clients

•  Allocation
          Post as direct expense and
          Allocate one/some/all records to multiple expense accounts - branch, cost center, department ....
                    Use a single or multiple user-defined methods

•  Multi-company operations
          Parent
          Subsidiaries
          Other relationships
          Same or different general ledger systems



Click.  Click.  All monthly reports with two mouse clicks!


•  Trial Balance report for reconciling to general ledger
     Supports any general ledger chart of accounts
     Records listed 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

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


About your existing records ....
Getting started ....
Three ways to address your 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.

Even if you inherited a junker file, your existing records can be converted to the software.
     Unique data conversion values can be incorporated, too.
     Be up and running with a solid system today!

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.


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.


Calculate amortization for ANY month (expense and book values for a previous month, current month, future month, end of next year ....)
and ANY range of months (month by month expense and book values for any period - three months, an entire year, even longer)
at ANY time (now or "as of" now but five years down the road)
and generate ANY system report (standard, filtered, user defined)
to ANY output device (screen, printer, Excel worksheet or other spreadsheet)


A complete software system ....
     •  Enter records, edit records within the software.
          Import Excel, too.
               Unique option to convert worksheet records or always import and generate reports on demand.
     •  View, print, export reports.
     •  Direct post to general ledger accounts.  Allocate selected records to multiple centers.
     •  Upload posting file for any general ledger system.
          The software builds a posting file conforming to any column format, any file layout.  Undo reversal.
          Backdate entries to a prior month.


•  Data records
     - Enter, edit, add your accounting records to the software database using an input screen.
          • Immediate amortization schedule helps verify correct entry.
          • Documentation, screen Tips, dupe function, rollover/renew ability, posting history.
          • Notes. Log reasons for changing and other critical information regarding a specific record.
     - Defer - Postpone amortization to a future "in service" month.
     - Catch up - Include prior month(s) amortized expense in current month when setup was late.
     - Adjustment - Single step adjustment screen simplifies partial refund, additional payment,
       change to remaining term or immediate write off.
     - Your existing records - Retain current balance for existing records or the software can calculate from each begin date.


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



•  Amortization methods at the record level ....
    1)  Straight line monthly
     -  30 day financial months
     -  Most commonly used
    2)  Accelerated
     -  More is taken during early months
    3)  Actual calendar days
     -  Amortization is from a start date to an ending date
     -  In-service, contractual term
     -  Full months
     -  Partial months
     -  Half month convention (first month only or first month and final month)
   4)  User defined Alternate methods
     -  Recognition based upon multiple factors


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.


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.




Price ....

Click to open and view  Price page
Stand alone and network sharing prices.
Evaluate the software with a free demo available on price page.
       The demo is the live software and any records added can be rolled into a permanent system.



Questions? 1-800-245-8444 or
email Support@fdssi.com


 






 
Cost Accounting Amortization Software software for
 Windows® PC, laptop, workstation and network sharing
© 1995 - 2018 Financial Data Support Systems, Inc.
Home page       |        About us       |        Contact us       |        Site map

Top