Excel Accrued Expenses software
 
logo
         Excel
  Accounting
   Software
 

Straight line method
Monthly, date to date, 4-4-5
Prepaid expenses amortization
Deferred income, revenue amortization
Fixed assets, FF&E depreciation

Excel Accrued Expenses
Software
Price
Free demo

Effective interest method

FASB 91 products home page
FASB 91 custom software, services
                       - Calculators -
Calculator Suite - all calculators as a package
Loan effective rate calculator - fee amortization
Bond effective rate calculator - amortization schedule
Bond straight line calculator - amortization schedule
Bond comparer - straight line vs. effective interest
               - Monthly recognition, journal entries -
Loan effective rate file - accounting reports
Bond effective rate file - accounting reports
Bond straight line file - accounting reports
Omnibus - par paydowns, effective rate recalculation
Financial Data Support Systems, Inc.
Home page
About us
Contact us
Technical FAQs

 
PC, laptop, workstation and
shared network devices
running Windows®

Business, government, financial institutions, accounting firms ....
 



 
Excel Accrued Expenses
amortization software


A single system to amortize, generate accounting reports and journal postings
for all of your accounting worksheet records ....


ACCRUED EXPENSES ....
   • Taxes - Federal, state, county
   • Audit and regulatory fees
   • Assessments and reserves
   • Amortize any expense for future funding
     -  Terms for 1 through 999 months
     -  Span calendar/fiscal years
     -  Supports any chart of accounts
     -  Adjustment/revision handling
     -  Monthly expense, remaining balances
     -  Accounting reports
     -  General ledger posting file
     -  User defined subcode reports
     -  Export all reports to Excel

The same software also amortizes
PREPAIDS ....
   •  Prepaid, capitalized expenses
   •  Deferred charges, costs
   •  Insurance premiums
   •  Maintenance agreements
   •  Deferred loan fee income and expense

DEFERRALS ....
   •  Deferred income, revenue
   •  Unearned fees
   •  Partial, interim receipts

FIXED ASSETS ....
   •  Tangible assets
   •   FF&E
   •   Property, equipment

BONDS ....
   •  Bond premiums
   •  Bond discounts
   •  Amortization and accretion

OTHER ....
Other records requiring amortized recognition over 1 to 999 months

Copy worksheet records to the software for calculations and reporting at any time.

     -  Use as many different general ledger account numbers as required
        The software generates Debit and Credit subtotals
              Posting amounts with offsets
              Balance sheet totals
     -  Supports any chart of accounts

Click to open an Excel worksheet with sample records and reports ....

Accrued Expenses Amortization
- FDSSI-USC15-ACR.xls

Prepaids - FDSSI-USC15-PPQ.xls      (or view database verision)

Deferrals - FDSSI-USC15-DEQ.xls       (or view database verision)

Fixed Assets - FDSSI-USC15-FXQ-xls    (or view database verision)

Scroll down or click here for price pages and to download a free demo

CPA?  Accounting services firm?
     •  Use the software to calculate your client files
     •  Have client email their data to you in Excel worksheets
     •  Import their worksheet to the software
     •  Calculate, amortize and generate accounting reports and schedules
          -  Monthly basis
          -  Quarterly
          -  Calendar or fiscal year
     •  Return file to the client with Excel worksheets:
          -  Accounting reports
          -  Journal voucher posting source document
          -  General ledger upload posting files

Available in 2 calculation versions
1) Term is in months, includes these three methods:
     •  30 day financial months
     •  Actual days in each month, including partial first and last months
     •  Accelerated sum of the years digits (more is recognized during earlier months)
2) Term is from a date to a maturity or ending date
Calculation periods are from a date to a date.
Set any beginning and ending date. Amortize for
     •  Daily periods (day to day, such as recognizing amortization each day of the month) plus
     •  Multiple days or date range to include the weekend
     •  Weekly, multiple weeks
     •  4-4-5
     •  Monthly (actual days in month - 31, 30, 28)
     •  Quarterly
     •  Any other date to date periods


Simply copy and paste worksheet records to the software
Paste dozens, hundred, thousands of records.
     •  A flexible, easy to use accounting system your auditors will appreciate
     •  Complete reporting capabilities
     •  Span calendar/fiscal years
          No "end of year" hassles or initialization or need to create new worksheets
     •  Supports any general ledger chart of accounts.
     •  Adjust for partial refunds, additional disbursements
     •  Generate monthly accounting and posting reports
     •  Additional reporting available for up to 4 separate user defined code values
     •  View.  Print.  Export all reports to Excel.
     •  The software comes with a complete set of templates.  Or keep all records in a single worksheet.

Maintain other accounting records in worksheets, too
     •  Any amounts needing to be amortized over 1 to 999 months requiring general ledger balancing, posting and reporting


How it works

Amortize and run reports at any time.
Simply
•  Copy an entire worksheet as if copying to another worksheet
     Worksheet rows contain:
          - Description
          - Begin date
          - Amount to calculate
          - End of term date or a term in months
          - 4 more columns for user defined codes and reporting
          - General ledger account numbers to be debited and credited
•  Click "Paste" on software's import window
     Set calendar dates to amortization calculation period
     View, print, even export (copy/paste) all reports
     Create general ledger posting file
     Direct post or allocate to branch, cost, RC accounts


 





 
 
Price
Price pages include ....
     •  Stand alone and network sharing software prices.
     •  Free demo with sample records.

Available in 2 calculation versions:
     1)  Amortization Term is 1 thru 999 months.
          Calculation methods supported:
          -  Straight line 30 day financial months
          -  Straight line, actual days in each month with partial first and last months
          -  Accelerated sum of the years digits
          Click to view price page with link to download a free demo


     2)  Amortization Term is from a Beginning date to a Maturity or Calculate To date.
          Calculation periods are from any date to any date
               -  Daily, days, week, weekly, 4-4-5, monthly (actual calendar days).
          Click to view price page with link to download a free demo


Questions? 1-800-245-8444 or
email Support@fdssi.com
 
 
 
Excel Accrued Expenses Software for
 Windows® PC, laptop, workstation and network sharing
© 1995 - 2012 Financial Data Support Systems, Inc.
Home page       |        About us      |        Contact us       |        Site map

Top
d