Excel worksheet monthly amortization software  

 Financial Data Support Systems, Inc. 
FASB 91 File Import - Loan fees
FASB 91 File Import - Dealer fees
FASB 91 Calculator
FASB 91 - all products page
FASB ASC-310-20
FASB File Import - MBS using CPR
Bond Calculator
Bond File Import - Purchasers,  Level Yield
Bond File Import - Purchasers,  Straight Line
Bond File Import - Issuers
General Accounting - Prepaid Expenses  
General Accounting - Deferred Income
General Accounting - Fixed Assets  
General Accounting - Excel Worksheets
Home page
About, contact us
Excel worksheet GAAP amortization software for

monthly amortization periods  
Non-monthly periods

Free demo - download now from the Price page, below

•  Expense, income recognition for all records at the same time

•  Amortization methods:

          30 day financial months for any term - 1 month to 999 months

          30 day financial months with partial months at beginning and end (supports half-month convention)

          365 day actual begin date to ending date "in service" recognition at the record level

•  From original begin dates or current  balances forward

•  P&L account listing, blance sheet subsidiary listing

•  Allocate selected income, expense amortization to multiple account numbers

•  Journal voucher recap with debit, credit columns

•  Posting files for any general ledger system:

           .csv, .txt, .xlsx, tab-delimited, fixed length and others

•  Detail audit schedule for each record

Hard to find

Accounting Software

Complete accounting for:
  •  Prepaid expenses
  •  Deferred income and revenue
  •  Fixed assets
  •  Accrued expenses
  •  Other amortizing records

Stand alone PC and network sharing versions

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

Browse and automatically import or
copy and paste all records to the software
  •  Your records
  •  Subsidiary records
  •  Client records

Import one or more worksheets or
paste what you copied to the software.
  •  Amortize for any month, any year

Allocate amortized income or expense
for selected records to multiple general ledger accounts.

Full set of reports
  •  Subsidiary ledger
  •  Journal voucher
  •  General ledger posting file
  •  Administrative reports

With reports:
  •  View reports
  •  Send to printer
Click an icon to automatically
  •  Archive in Adobe
  •  Export to Excel

Monthly Excel worksheet import
amortization and reporting software
     Non-monthly periods

  •  Prepaid, capitalized expenses
  •  Deferred charges, costs
  •  Insurance premiums
  •  Maintenance agreements

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

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

If you know how to use Excel, there's nothing to learn.

Amortize, generate accounting reports and general ledger posting files for
     •  Your records
     •  Client records
     •  Dozens, hundreds, thousands, hundreds of thousands of records

Minimal information required
     •  Description
     •  Amount
     •  Date
     •  Term (in months or from any date to any date)

Maintain, update records at
     •  Your site
     •  Client site
     •  Transfer client data and reports utilizing Excel worksheets
     •  Process an entire file in a matter of seconds

Complete accounting
     •  Amortize records using 1 or all 3 amortization methods
     •  Generate all accounting reports
     •  Create general ledger posting files

Amortize, depreciate records over
     •  30 day months - all months and days are 30 days in the month
     •  30 day months - partial first and last months
     •  Actual days in each month

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

        •  Copy/paste or browse/import all records from Excel and other spreadsheet programs to the software
                    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
                    Begin date

        •  Easily handle adjustments due to partial refunds, additional payments

        •  Amortize income or expense for any period

        •  Multiple amortization methods

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

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

        •  General ledger posting file
                    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

Includes three (3) different amortization methods
All are FASB, GAAP compliant ....

     •  Monthly amortization, all months are 30 day financial months.  Terms are in months.
             First and last month for a record are also full 30 day month.

     •  Monthly amortization, all months are 30 day financial months.  Terms are date to date.
            First and last month for a record can be actual days.  Supports 1/2 month convention.

     •  Monthly amortization, actual days in each month - 28, 29, 30 and 31.  Terms are date to date.
             First and last month for a record are typically actual days.

All general ledger accounting reports
     •  Supports any general ledger chart of accounts
     •  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

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 on screen
     •  Send to local or network printer
     •  Send 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

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

Software includes
  •  Free system replacement in the event of a loss
  •  Free 1-800 support
  •  Free email support
  •  Free software enhancement updates

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

Existing records
  •  Preserve current balances
  •  No conversion journal adjustments
  •  Start using the software at any time

  •  Distribute amortization for selected records to multiple accounts

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.

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

Related software accounting system pages ....
  •  Excel date to date amortization software
  •  Prepaid expenses database software
  •  Deferred income and revenue database software
  •  Fixed assets, FF&E straight line depreciation database software
  •  Loan fees - effective interest method     Loans, packages with discounts
  •  Bond discounts - straight line and effective interest methods


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