Excel spreadsheet amortization software

                    SOFTWARE  PRODUCTS 
Financial Data Support Systems, Inc.
   Accounting
       Amortization
           Software
 
  Home page
  About, contact us
  FASB 91 - all products

  LOAN FILES - FASB 91 deferred fees income and expense amortization
  MBS, LSBO, LOAN PACKAGES - FASB 91 premiums, discounts amortization
  BOND ISSUERS - premiums, discounts, issuance costs amortization
  BOND PURCHASERS - effective interest method for premiums and discounts
  BOND PURCHASERS - straight line method for premiums and discounts
 
  PREPAID EXPENSES - monthly amortization and reporting
  DEFERRED INCOME - monthly amortization and reporting
  FIXED ASSETS, FF&E - monthly depreciation and reporting
  NON-MONTHLY - daily, days, weeks, other period amortization and reporting
  CLIENT FILES - amortization and reporting for client data
  l











Amortization
periods:
  1 day
  Days
  Week
  Weeks
  Month
  Other


Any date
to date
period.





















Send reports
to:
  Printer
  Excel
  Adobe
 
























































Maintain records in Excel.
  •  One worksheet
  •  Multiple worksheets
  •  Multiple files

Amortize from date to date periods

  •  Prepaids
  •  Deferred income
  •  Fixed assets
  •  Other amortizing records
  •  Recurring transactions

Copy all records.
  •  Your records
  •  Subsidiary records
  •  Client records

Hundreds, thousands, hundreds of thousands of records.

The software comes with 8
different Excel templates.

Allocate income, expense amortization
to multiple cost, revenue centers.

Paste to the software
  •  Click 2 dropdown calendar dates
  •  Set amortization period to:
          Any date to any date
          1 day.  Days.  Weekends.
          Week.  Weeks.
          Month - actual days
          Quarter.  Longer period.  Year.
          4-4-5, 13 weeks, 13 months
You define each/any amortization period

You can also
  •  Browse for, open a file
  •  Import one, some, all worksheets

Full set of reports
  •  Subsidiary ledger
  •  Journal voucher
  •  General ledger posting file
With reports:
  •  View reports
  •  Send to printer
  •  Archive in Adobe
  •  Export to Excel

Audit inquiry?
Internal request?
Servicing a client?
     email reports in Excel.











CURRENT BOOK VALUES
Retain current book values
     •  Recalculate records for/from prior periods
     OR
     •  Preserve current book values, deferral balances
        Start using the software now without any adjusting journal entries



GENERAL LEDGER
     •  Supports any general ledger chart of 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 for records can be posted to direct income and expense accounts



ALLOCATION COST ACCOUNTING
     •  Allocate and distribute monthly amortization for one or multiple records to:
               Branch accounts
               Department accounts
               Cost center accounts
               Other designations

     •  Distribute amortized income and 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 income or expense portion.
                         Create a single record for an expense to be distributed among branches.
                         If 5 branches, each receives 1/5 of monthly amortized income or 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 income or expense subtotal account number.
               An allocation method can be assigned to multiple subtotal account numbers.

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



 



 
 
 
 
 

Date To Date amortization software to
amortize, depreciate records over
     •  Daily periods
     •  Days
     •  Week, weeks, calendar and non-calendar
     •  4-4-5, 13 month
     •  Monthly - actual days
     •  Quarterly
     •  Annual
     •  Any and all date-to-date periods


Custom code
Unique situation?
Unusual records?
We can write custom code
and embed your private
module within the existing
nuts and bolts portion
of the software.
1-800-245-8444
Support@fdssi.com






  Software to import and account for ....
Prepaids
  •  Prepaid, capitalized expenses
  •  Deferred charges, costs
  •  Insurance premiums
  •  Maintenance agreements


Deferred income
  •  Unearned fees
  •  Deferred revenue
  •  Contracts
  •  Partial, interim receipts
Accrued Expenses
  • Taxes - Federal, state, county
  • Audit and regulatory fees
  • Assessments and reserves
  • Amortize any expense for future funding


Fixed Assets
  •  Tangible assets
  •  FF&E
  •  Equipment
  •  Vehicles, accessories
Other records ....
Virtually all accounting records
requiring amortization over any term

Amortization and totals for
  •  Daily
  •  Multiple days over any date range
  •  Weekly, weeks, any day to any day
  •  Quarterly, semi-annual, annual
  •  4-4-5, 13 month
  •  Any date to date period
 


 






METHOD = How a record is to be amortized over a Term in months or days

PERIOD = When you want to recognize amortization and book income or expense, such as monthly, weekly, daily ....




Calculate hundreds, thousands of records
for any period on demand ....


        •  Copy and paste all records from Excel and other spreadsheet programs to the software (a worksheet or spreadsheet is the database)
                    Import, amortize or depreciate and account for your records
                    Import, amortize or depreciation and account for client records
                              Client records can be maintained in Excel by you
                              Client records can be maintained in Excel by the client and sent to you for processing

        •  Requires basic information only
                    Amount
                    Begin date
                    Term

        •  Easily handle adjustments due to partial refunds, additional payments

        •  Amortize income or expense for any period

        •  Multiple amortization methods

        •  Subsidiary ledger account balancing report
                    View
                    Send to printer
                    Copy, paste to Excel and other spreadsheets

        •  Journal voucher source document with debit, credit columns
                     View
                    Send to printer
                    Copy, paste to Excel and other spreadsheets

        •  General ledger posting file
                    View
                    Send to printer
                    Copy, paste to Excel and other spreadsheets

        •  Detail amortization schedules for any record for audit purposes

        •  Cross over month end and year end without doing anything

        •  Complete accounting and reporting in a matter of seconds







All general ledger accounting reports
     •  Subsidiary ledger trial balance
               P&L income and expense account totals
               Balance sheet account totals
     •  Journal voucher posting source document
     •  General ledger journal upload import posting file


Calculations for any accounting period
               Daily, days
               Weekly, weeks, any day to any day
               Quarterly, semi-annual, annual
               Monthly, actual days
               4-4-5, 13 month, other
      •  Reporting
      •  General ledger posting files
      •  Hundreds of records.  Thousands of records
      •  Really big Excel files with hundreds of thousands of records
      •  Automatically import a single worksheet
      •  Automatically import one, some or all worksheets at the same time


You control subtotals and general ledger postings:
SD rows instruct the software to generate a Subtotal Debit for the applicable account number
SC rows generate a Subtotal Credit


Cross over fiscal and calendar year ends
   •  No monthly close-out
   •  No annual close-out or end of year requirements
   •  The software crosses from one year to the next without the need to do anything


With reports
     •  View
     •  Print
     •  Copy report and paste to Excel


Eliminate these accounting headaches
   •  Early setup of a record:  Ability to defer amortization to a future start month.
   •  Late setup:  Ability to catch up and combine prior month(s) amortization in the setup month.


Your existing records
The system can
          Calculate current balances or
          Preserve your current balances


Automatically import and amortize
     •  Thousands of records
     •  Hundreds of thousands
     •  55 seconds to
               Import six worksheets at the same time from an Excel file
               Amortize all records
               Generate totals for 401,698 records
 





 


Price page and free demo  ....

Click to open and view software
  Price page
Stand alone and network sharing prices.
Evaluate the software with a free demo available on price page.






More Highlights ....

•  Accounting, reporting, balancing, schedules ....
     -  The software manages dozens, hundreds, thousands of records
     -  Cross over EOY, BOY periods without doing anything
     -  Show your auditor exactly how you arrived at your numbers
               Detailed reports show every transaction for a month, quarter and calendar or fiscal year
     -  Trial Balance subsidiary ledger listing with subtotals for each general ledger account number
               Subtotals consist of:
                        •  Monthly recognition/amortization
                        •  Accumulated recognition
                        •  Book value balances 
 
•  General ledger
     -  The software creates a Journal Voucher debit and credit column source document for the above and
     -  Creates a general ledger transaction posting file
     -  Posting file descriptions can be at the
               -  General ledger account subtotal level or
               -  Individual record level
     -  Supports any chart of accounts

•  Adjustments during term - after amortization has begun
     -  Increase amount
     -  Decrease amount

•  Budget projections, forecasting
     -  Calculate expense and income amortization, with ending balances, for a future month, quarter, year.

•  Allocation software option
     -  Direct post monthly amortized income or expense for a record to a single account
     -  and distribute selected records amortized income or expense to multiple branch, department, cost center, revenue center accounts
     -  Allocate one/some/all records using user defined methods
     -  Allocate using multiple methods (percentage, branches, departments, people count, workstation count ....)
     -  Allocated records flow into the journal voucher and posting file for automatically updating the general ledger

•  Administrative reporting
     -  4 user defined sorting and subtotal categories.

•  Export data and calculations
     -  Copy screens and reports, paste to Excel worksheet




Related monthly accounting software system pages ....
  •  Excel import, monthly basis
  •  Prepaid expenses database software
  •  Deferred income and revenue database software
  •  Fixed assets, FF&E straight line depreciation database software
  •  Loan fees - effective interest method software
  •  Dealer fees, indirect lending charges - effective interest method software
  •  MBS, loan packages software
  •  Bond premium discount amortization software


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

 










 
 
 
Prepaid Expenses, Date to Date Spreadsheet Amortization Software for
 Windows® PC, laptop, workstation and network sharing
© 1995 - 2017 Financial Data Support Systems, Inc.
Home page       |        About us      |        Contact us       |        Site map

Top
Excel amortization, straight line accounting, straight line amortization, straight line amortize, straight line amortizes straight line amortizing, straight line calculate, straight line calculates, straight line calculation, straight line calculations, straight line method straight line recognition, straight line
recognize, straight line recognizing, straight line software