Excel worksheet non-monthly amortization software  

Financial Data Support Systems, Inc. 
Amortization Software Products
FASB 91 Originated Loans
FASB 91 Servicer Remittances LSBO
FASB 91 Indirect Lending Dealer Fees
FASB 91 MBS Packaged Loans
FASB 91 Merchant Cash Advances
FASB 91 Products Page
Bond  Purchasers, Effective Interest Method
Bond Purchasers,  Straight Line Method
Bond Issuers, Level Yield or Straight Line
Prepaid Expenses, Deferred Charges    
Deferred Income, Unearned Revenue
Fixed Assets, FF&E Depreciation    
Allocation to Cost Centers
  Excel worksheet amortization
Home page
About, contact us
Excel worksheet amortization software
for daily, days, weekly, weeks, 4+4+5, any date-to-date accounting recognition period   Monthly recognition periods
on your PC or network sharing system

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

Accrued Expenses
  • Taxes - Federal, state, county ....
  • Audit and regulatory fees
  • Assessments and reserves
  • Account for interim disbursements
Deferred income
  •  Unearned fees
  •  Deferred revenue
  •  Contracts
  •  Partial, interim receipts

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

Highlights page with
Free demo
Hard to find
Accounting Software

About Journal Entries ....
NO charge to format Journal Entries for Quickbooks and all other general ledger systems
Debits and credits
               •  Disk file - tab delimited, split column, fixed length, comma delimited, txt, csv, xlsx, iif
               •  Worksheet - generate columns and rows, launch Excel
               •  File copy to Clipboard - paste to any destination
               •  Other output, layouts, file extensions
               •  At the account number summary level or each record

Debit and credit postings can be formatted for ANY general ledger system at no extra charge.

Daily, days, weekly, weeks, 4+4+5
Excel worksheet import
amortization and reporting software for non-monthly periods
     Monthly periods

Amortize records for any/all of these and other accounting periods:
•  Daily
•  Days
•  Week
•  Weeks
•  4-4-5, 13 month
•  Monthly
•  Quarterly
•  Annual
Any and all date-to-date periods

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

Complete accounting for:
  •  Prepaid fees, charges and expenses
  •  Deferred income and revenue
  •  Fixed assets
  •  Accrued expenses
  •  Other amortizing 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

Do everything in a matter of seconds
     •  Amortize, depreciate records
     •  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 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

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

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 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 any future period.

•  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
     -  New!  Software to allocate income, expense from other sources, such as Excel and other software.  Create journal entries, too.  Learn more.

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

Debit and credit postings to update ANY General Ledger System.   Quickbooks.  Fiserv.  In-houseAny general ledger.

A default general ledger layout comes with the software.
If yours is different, we will match your layout including requirements such as:
     •  File type
                 Core system, in-house, service bureau, commercial software
                 As a disk file or copy/paste
                 Tab-delimited (often for Excel)
                 Fixed length
                 Variable length
                 Csv, txt, xlsx, other delimiters, other requirements
     •  Header record, if required
                 Descriptive headings
                 Company/customer identifier
                 Single or multiple lines
     •  Posting transaction layout:
                 Db and Cr designators as D and C, signed amounts, 1 and 2, other values
                 Date formats
                 Account number splitting into separate columns
                 If this, then that testing
                 Table lookup
                 $ postings as:
                      General ledger account number summaries or
                      Each individual record's amount and description
      •  Trailer record(s), if required
                 End of file marker
                 File contents, count, amount
      •  Other requirements

Simply tell or show us what you need.
We will provide an example prior to any commitment on your part.
No additional charge involved.


CPA, client accounting firms ....
Utilize the software's Import and Export features
     •  Import an Excel file with client records to the software at any time
          Service one client or
          Multiple clients
     •  Generate all monthly accounting reports
     •  Export reports to Excel or Adobe
     •  Process accounting functions and/or send reports file to client
     •  Import client file, generate all reports, export in a matter of seconds

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  
     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
  •  Loan fees - effective interest method     Loans, packages with premiumes and discounts
  •  Bond premiums and discounts - straight line and effective interest methods


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

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