Excel worksheet monthly amortization software  

Financial Data Support Systems, Inc. 
Amortization Software Products
Loan Files: FASB Effective interest method
Loan Packages: Effective interest method
Merchant Cash Advances
FASB 91: All products
Bond  Purchasers: Effective Interest Method
Bond  Issuers: Effective Interest Method
Prepaid Expenses, Deferred Charges    
Deferred Income, Unearned Revenue
Fixed Assets, FF&E Depreciation    
  Excel worksheet amortization
Home page
About, contact us
 
Excel worksheet amortization software
for monthly recognition periods   Non-monthly recognition periods
on your PC or network sharing system


Amortization, accounting reports and posting files for ....
Prepaids
  •  Prepaid, capitalized expenses
  •  Deferred charges, costs
  •  Insurance premiums
  •  Maintenance agreements

Fixed Assets
  •  Tangible assets
  •  FF&E
  •  Equipment
  •  Vehicles, accessories
Deferred income
  •  Unearned fees
  •  Deferred revenue
  •  Contracts
  •  Partial, interim receipts

Accrued Expenses
  • Taxes - Federal, state, county ....
  • Audit and regulatory fees
  • Assessments and reserves
  • Account for interim disbursements
Other records ....
Client files
Bond premiums and discounts
Loan fees
Virtually all accounting records
requiring amortization over any term

Highlights page with
Price
Free demo
Hard to find
Accounting
Software
supporting Windows
7,10,11












 Easy to use.

 From within software located on a PC or Network sharing system,

 browse for and select an Excel file ....













 Combine all records on a single worksheet or spread them out on multiple worksheets.

 Import one worksheet, some or all worksheets in a file.












 Generate monthly amortization reports in a matter of seconds ....












 Journal Voucher debit and credit postings source document

















 Amortization schedules on demand


































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


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 1 - 999 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



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 and account for your records.
                    Import one worksheet or multiple worksheets from the same file.
                    Import, amortize 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

        •  Easily handle adjustments due to partial refunds, additional payments

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



Includes three (3) different FASB, GAAP compliant amortization methods
     •  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



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



•  Allocation
     -  Direct post monthly amortized 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.

















Price page and free demo  ....

Click to open and view software
  Price page
     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 ....
  •  Prepaid expenses database software
  •  Deferred income and revenue database software
  •  Fixed assets, FF&E straight line depreciation database software
  •  Excel date to date amortization software
  •  Loan fees - effective interest method     Loans, packages with discounts
  •  Bond discounts - straight line and effective interest methods





 




 
Software for Windows® on a computer, laptop, shared network and cloud based systems
© 1995 - 2023 Financial Data Support Systems, Inc.
Home page        |        About us       |        Contact us       |        Site map

Top