Excel worksheet monthly amortization software

Financial Data Support Systems, Inc.  
Accounting Amortization Software for:
Loan Files: FASB for originated, purchased loans
MBS loan Packages premiums, discounts amortization
MCA Merchant Cash Advance discounts
FASB 91: All products
Bond  Purchasers, premiums and discounts amortization
Bond  Issuers, premiums and discounts amortization
Corporate Debt  Issuers GAAP costs amortization
Prepaid Expenses, Deferred Charges amortization
Deferred Income, Unearned Revenue amortization
Fixed Assets, FF&E Straight Line depreciation    
  Excel import amortization, depreciation software
4+4+5, daily, weekly, any date-to-date amortization
Home page
About, contact us







FASB, GAAP compliant software
for a PC,
Shared network and
Cloud based system supporting
Windows 7,10,11
 


Excel import amortization and depreciation software

Import records from Excel, amortize, generate reports to Excel



Scroll down for
     Highlights and sample reports
     Price page
     Free demo



Hard to find
Accounting
Amortization
Software





Monthly recognition and reporting for any or all ....

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

Fixed Assets Straight Line Depreciation
  •  Tangible assets
  •  FF&E
  •  Equipment
  •  Vehicles, accessories


Accrued Expenses
  • Taxes - Federal, state, county ....
  • Audit and regulatory fees
  • Assessments and reserves
  • Account for interim disbursements

Deferred income, Unearned Revenue
  •  Unearned fees
  •  Deferred revenue
  •  Contracts
  •  Partial, interim receipts














 





Excel Import Accounting Software to
     Amortize Prepaid Expenses
           Also handles Accrued Expenses including remaining payable due for interim disbursements
     Depreciate Fixed Assets, FF&E
     Amortize Deferred Income
Import records from an Excel file, generate monthly recognition, accounting reports and posting files in a matter of minutes.


Scroll down and
     View Price page
     Download a free demo zip file right now


We use the word "Client" to distinguish multiple files from one another, applicable for
     CPA,  Accounting firms providing accounting services to their clients
     Parent Companies servicing subs where a sub is the client
     Holding Companies servicing various entities as clients
     Your own Company for one or multiple files



About Excel files
     Records can be maintained by Client and emailed each month
     Records can be maintained by your organization
     They can also be your own records stored in one or multiple Excel files.  Or span several applications, such as Prepaids and Fixed Assets.


Minimal information required for a record
     Description
     Amount
     Date
     Term (in 1 - 999 months or from any date to any date)
     Debit account number
     Credit account number
     Other features available, such as deferring calculations to a future date.  Or "catching up" on previous monthly recognition.
     Supports any chart of accounts.



Recognition methods
     Straight line, 30 day months
          Terms from 1 to 999 months
     Half month convention
     Sum of the years digits
     Recurring item
          Take an amount each month.  Amount can be changed from month to month.
     From a date to a date as
          30 day months
          Actual days in each month
     Metthod 6, do it your way.
          Set each month's recognition as a Dollar Amount, Percentage, Units consumed, such as supplies inventory reductions.
          Set recognition to occur monthly, quarter, semi-annually or any other frequency.
          Also use for recurring items when future recognition is unknown.  Simply update Method 6 when amount becomes available.
    


Supports Calendar and other Fiscal periods
     No monthly close-out
     No annual close-out or end of year requirements
     Cross 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
     Send to Adobe



Existing records.  The software 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.
    Get accumulated and ending balances as of endind date or include month-to-month activity.



Allocate, split, distribute income or expense for a single record to multiple accounts
     Allocate one/some/all records using the same method.
     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
















Can't download the Excel Sample Reports file?
Request it be sent attached to an email:
Support@fdssi.com













Price page and free demo  ....

Click to open and view software
  Price page
     Free demo:
     Evaluate the software right now with a free zip file demo available on the Price page.


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



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

Top