Straight line method bond accounting software  

Financial Data Support Systems, Inc. 
Amortization Software Products
Loan Files: FASB Effective interest method
Loan Pool Packages: FASB CPR, SMM
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    
Home page
About, contact us





GAAP compliant
 

Bond accounting software for purchased
bonds and other investments using

     •  Straight Line Method
  Bond Issuers page 
  Bond purchasers Effective Interest Method page




Generate straight line discount accretion, premium amortization for any month, year




Scroll down for
     Highlights
     Images
     Price page with free demo.
          Evaluate the live software right now.




Hard to find
GAAP
Amortization
Software to run on a
PC,
Network sharing or
Cloud based system
supporting Windows

























































Easily manage dozens, hundreds, thousands of investments
     •  Premium amortization
     •  Discount accretion
     •  OID for applicable bonds


Coupon interest
     •  Total cash due this month
     •  Total earned since previous payment
     •  Monthly accrued interest


Individual bond + file totals for
     •  Any month
     •  Entire calendar or fiscal year
     •  Other periods from any month ranging up to 60 months
     •  Generate results in a matter of seconds


Account for
     Corporate bonds
     Municipal bonds
     Callable and non-callable bonds:
          With or without a call price
          With or without OID (original issue discount also amortized by the software)
          Partial calls, early redemptions, partial sales
     Convertible bonds
          The software calculates a constant rate to maturity using initial and convertible rates
     Hospital bonds
     Agencies
     Treasuries
     Bills
     Notes
     GNMAs, MBS, CMOs - account for declining par balances (for more robust accounting, see our FASB 91 version)
          The software recognizes a proportionate amount of premium or discount based upon the dollar reduction to Par
     Special issues
     Other investments with or without reductions to par



Virtually any premium or discount instrument having
     Fixed rate
     Variable rate
     Zero rate
     Convertible rate
     360, 365, 366 day basis



Monthly and yearly straight line
     Premium amortization
     Discount accretion
     Earned interest
          360 day years (default) and 365, 366 day basis at the record level
     Monthly totals
     Yearly totals
     Calendar and fiscal period book values, cost basis, carrying balances
     Monthly reports
     Annual reports
     Detail month-by-month audit recognition schedule for any record on demand



Already amortizing premiums and discounts?
     The software can preserve current income and expense deferral balances.
     No adjusting journal entries.
The software can also amortize premiums and discounts from original begin dates.
 
 








About the software ….

Windows
Operates on laptop, PC, workstations, network sharing devices and Cloud based systems running Windows.
Developed in Microsoft .NET Framework Visual Studio within Azure.

Macs
Operates on Macs with Parallels.
Parallels is a third party app that allows Macs to run Windows software.








Reports ....


User defined subtotals listing
     Discounts:
          All bonds with discounts and subtotals by desired category
          Par, Original Discount, Discount Accretion, Discount Balance, Cost Basis Book Value
     Premiums:
          All bonds with premiums and subtotals by desired category
          Par, Original Premium, Premium Amortization, Premium Balance, Cost Basis Book Value
     Portfolio totals


Cash Due report each month showing
     Coupon interest due on:
          1st of month
          15th of month
          Other due dates
     Purchased interest due
     Par due as a result of:
          Maturities
          Sales
          Calls:
                Call date reached
                Early call, redemption
                Partial call, redemption


Coupon Interest status report
     Total amount earned to date
      Interest earned but not yet due


Net Earnings Recap
     Earned interest
     Premium amortization
     Discount accretion
     Net earnings


Finalized Report for all bonds
     Matured
     Called
     Sold


Reconciliation Report
     Beginning period balances:
               Par
               Premium balance
               Discount balances
     Activity for period
               New additions
                Reductions to par
                Premium amortization
                Discount accretion
     Net activity
     Ending balances for all bonds and investments
     Recap of interest earned


Market Position report as of a given day
     Cost Basis, Book Value compared to Market Value
     Cost Basis, Book Value calculated as of any day    




With reports
     View
     Send to printer
     Send to Adobe
     Send to Excel




General Ledger version also includes

Subsidiary Ledger report
     Subtotals by user defined category, such as general ledger account


Accrued Interest report
     Interest earned for the month with journal voucher and general ledger posting file


Journal Vouchers


General ledger posting files for:
     Premium and discount postings
     Interest accrual postings









 
Configurations and settings for ....

 
Bond holders, individuals, investors, foundations, active traders
     Discount accretion income, premium amortization expense:
               Totals for each category
               $Dollar weighted rates by category plus portfolio
               Group totals for any user-defined purpose
               Portfolio Net Earnings:
                    Interest
                    + Discount Income
                    - Premium Expense
                    = Net
     Lifetime month-by-month schedule for each bond:
               Audit detail amortization, accretion schedule for each record.
     Cash due reporting:
               Coupon interest plus Par due from maturities, calls and sales.
     Annual reconciliation report:
               Beginning balances, all activity, net activity, ending balances. 
 

Client servicers, financial advisors, CPA accounting firms
     Calculate all of the above for your clients.
     Export reports covering:
               Current month and year
               Prior months and years
               Future months and years
     Amortization and accretion reports can span 1 to 60 months beginning with any month.
               View reports
               Send to printer
               Send to Adobe
               Send to Excel 
 

Business - Add the General Ledger Module for
     Subsidiary ledger account listing with:
               Monthly recognition
               Accumulated
               Book value
               Par, principal
               Balances and totals by each account
     Interest accruals:
               Monthly earned income
               Accrued receivable balance
     Journal vouchers:
               Debit, credit columns with totals
     General ledger posting files:
               Transactions formatted for posting to any general ledger system
               Postings in a disk file or automatically exported to Excel
















  Price page and free demo  ....

Effective Interest Method
Click to open and view Price page
Download a free demo from the Price page which includes:
     •  A live version of the software
     •  Sample records
     •  Run reports


Straight Line Method
Click to open and view Price page
Download a free demo from the Price page which includes:
     •  A live version of the software
     •  Sample records
     •  Run reports

















Accounting software for bond purchasers using
     •  Straight line method
  Bond Issuers 
  Effective Interest Method




Easily manage dozens, hundreds, thousands of investments
     •  Premium amortization
     •  Discount accretion
     •  OID for applicable bonds


Coupon interest
     •  Total cash due this month
     •  Total earned since previous payment


Individual bond + file totals for
     •  Any month
     •  Entire calendar or fiscal year
     •  Other periods from any month ranging up to 60 months
     •  Generate results in a matter of seconds



Account for
     Corporate bonds
     Municipal bonds
     Callable and non-callable bonds:
          With or without a call price
          With or without OID (original issue discount also amortized by the software)
          Partial calls, early redemptions, partial sales
     Convertible bonds
          The software calculates a constant rate to maturity using initial and convertible rates
     Hospital bonds
     Agencies
     Treasuries
     Bills
     Notes
     GNMAs, MBS, CMOs - account for declining par balances (or use ASC-310-20 amortization)
          The software recognizes a proportionate amount of premium or discount based upon the dollar reduction to Par
     Special issues
     Other investments with or without reductions to par



Virtually any premium or discount instrument having
     Fixed rate
     Variable rate
     Zero rate
     Convertible rate
     360, 365, 366 day basis



Monthly and yearly
     Premium amortization
     Discount accretion
     Earned interest
          360 day years (default) and 365, 366 day basis at the record level
     Monthly totals
     Yearly totals
     Calendar and fiscal period book values, cost basis, carrying balances
     Monthly reports
     Annual reports
     GAAP, FASB compliant straight line amortization
     Detail month-by-month audit recognition schedule for any record on demand



Already amortizing premiums and discounts?
     The software can preserve current income and expense deferral balances.
     No adjusting journal entries.
The software can also amortize premiums and discounts from original begin dates.
 
 















































Reports ....


User defined subtotals listing
     Discounts:
          All bonds with discounts and subtotals by desired category
          Par, Original Discount, Discount Accretion, Discount Balance, Cost Basis Book Value
     Premiums:
          All bonds with premiums and subtotals by desired category
          Par, Original Premium, Premium Amortization, Premium Balance, Cost Basis Book Value
     Portfolio totals


Cash Due report each month showing
     Coupon interest due on:
          1st of month
          15th of month
          Other due dates
     Purchased interest due
     Par due as a result of:
          Maturities
          Sales
          Calls:
                Call date reached
                Early call, redemption
                Partial call, redemption


Coupon Interest status report
     Total amount earned to date
      Interest earned but not yet due


Net Earnings Recap
     Earned interest
     Premium amortization
     Discount accretion
     Net earnings


Finalized Report for all bonds
     Matured
     Called
     Sold


Reconciliation Report
     Beginning period balances:
               Par
               Premium balance
               Discount balances
     Activity for period
               New additions
                Reductions to par
                Premium amortization
                Discount accretion
     Net activity
     Ending balances for all bonds and investments
     Recap of interest earned


Market Position report as of a given day
     Cost Basis, Book Value compared to Market Value
     Cost Basis, Book Value calculated as of any day    




With reports
     View
     Send to printer
     Send to Adobe
     Send to Excel




General Ledger version also includes

Subsidiary Ledger report
     Subtotals by user defined category, such as general ledger account


Accrued Interest report
     Interest earned for the month with journal voucher and general ledger posting file


Journal Vouchers


General ledger posting files for:
     Premium and discount postings
     Interest accrual postings









 
Configurations and settings for ....

 
Bond holders, individuals, investors, active traders
     Discount accretion income, premium amortization expense:
               Totals for each category
               $Dollar weighted rates by category plus portfolio
               Group totals for any user-defined purpose
               Portfolio Net Earnings:
                    Interest
                    + Discount Income
                    - Premium Expense
                    = Net
     Lifetime month-by-month schedule for each bond:
               Audit detail amortization, accretion schedule for each record.
     Cash due reporting:
               Coupon interest plus Par due from maturities, calls and sales.
     Annual reconciliation report:
               Beginning balances, all activity, net activity, ending balances. 
 

Client servicers, financial advisors, CPA accounting firms
     Calculate all of the above for your clients.
     Export reports covering:
               Current month and year
               Prior months and years
               Future months and years
     Amortization and accretion reports can span 1 to 60 months beginning with any month.
               View reports
               Send to printer
               Send to Adobe
               Send to Excel 
 

Business - Add the General Ledger Module for
     Subsidiary ledger account listing with:
               Monthly recognition
               Accumulated
               Book value
               Par, principal
               Balances and totals by each account
     Interest accruals:
               Monthly earned income
               Accrued receivable balance
     Journal vouchers:
               Debit, credit columns with totals
     General ledger posting files:
               Transactions formatted for posting to any general ledger system
               Postings in a disk file or automatically exported to Excel















  Price page and free demo  ....


Straight Line Method
Click to open and view Price page
Download a free demo from the Price page which includes:
     •  A live version of the software
     •  Sample records
     •  Run reports


Effective Interest Method
Click to open and view Price page
Download a free demo from the Price page which includes:
     •  A live version of the software
     •  Sample records
     •  Run reports











Amortization periods
     Any prior, current, future:
          Month
          Year
          Multiple years, calendar or fiscal for
                    Each bond
                    Totals for all bonds
                    User defined Group totals
                    Multiple bond files



Interest and rate calculations:
     Purchased interest:  Track and account for interest paid at time of purchase but not yet due
     Accrued interest:  Current month income posting plus Accrued Receivable Account balances (for business)
     Coupon interest:  Cash due this month:
                                         Coupon interest
                                         Purchased interest
                                         Par due to sale, maturity, call
                                         Total amount of coupon and purchased interest owed but not yet due
     Earned interest:  Coupon rate earnings for a period irrespective of accrual or cash activity
     Portfolio rate:  Dollar weighted average coupon and effective rates for all investments



Amortize your investments
     Software and bonds reside on your computer
Amortize client investments
     Import and calculate a file for/from one or more clients
     Prior periods.  Current.  Future projections.



GROUP
     Group your bonds to get subtotals by any category.
     Examples:
               Group = Lot 123 (get subtotals for each lot)
               Group = California (get subtotals by each issuance state)
               Group = Broker name (get subtotals by each different broker)
               Group = 2019 (get subtotals by each year of purchase)
               Group = Any category for which you require subtotals of all bonds within each Group



Call dates:
     Amortize to Maturity date or
     Amortize to a Call date including
               Call price other than Par
               Callable but not called
               Partial calls, early redemptions



Administrative:
     Reconciliation worksheet for audits and exams
              Beginning balances for Par, Premiums and Discounts
              + Additions for the period
              -  Activity for amortization, accretion, reductions to Par
              =  Ending Balances
                  Net Change summation
     Mark to Market report - Book Value vs. Market Value position
     Portfolio value as of any given day














REPORTS ....

     •  View
     •  Send to local or network printer
     •  Automatically export to Adobe
     •  Automatically export to Excel



Report 1:   Enlarged view of the software import screen listing
Another view of the Import screen, primarily so you can sort records by desired values, such as Coupon rate, Maturity date and more.



Report 2:  Trial Balance report
Premium, Discount recognition report.  Includes Journal Voucher and General Ledger Posting file.

Typically for General Ledger Business Version.
Premium amortization and discount accretion will be recognized for the selected calendar calculation month. Records will be sorted by the values in spreadsheet column U general ledger accounts. Totals will be provided for each account. Totals will be grouped within Discount and Premium categories.
A Journal Voucher and General Ledger posting file will also be created.
For non-business purposes, spreadsheet column U values can be used to generate subtotals for other purposes dealing with premiums and discounts.



Report 3:  Net recap report for calendar month or period
CASH interest +/- Discount, Premium amortization +/- Net Gain on sale.

Cash coupon interest received during the report period (the calendar month or number of months) plus Discount recognition and minus Premium recognition. The result is NET earnings for the period based on coupon cash receipts.



Report 4:  Finalized records report
Net Gain or Loss for All records which have matured or otherwise ended their term.

All records which have reached Maturity date, Call date, have been Sold, Paid Down to zero, Redeemed in full or otherwise finished their term.
Report consists of Net Gain or Loss based on spreadsheet column M, Gain/Loss on sale and/or column O, Sale Proceeds.
This report can also be used as a purge list when beginning a new year. Create a new spreadsheet with a file name dated for the new year. Delete records appearing on this report through the prior year end.
Records will appear in the order they appear in the spreadsheet in order to facilitate the above.



ABOUT COUPON INTEREST:  CASH vs. EARNED ....
CASH:
CASH and coupon interest due represent interest from one coupon payment date to the next.
Actual cash activity and dates need not be logged (see the following regarding differences between calculated earned and cash interest receipts). The system "moves" spreadsheet column R Payment Due date, along with a prior due/accrue from date, forward and backward based on the calendar calculation month.
EARNED:
EARNED interest is the amount to which you are entitled, typically representing full month periods but also spanning the entire life of the record. Interest is always being earned regardless of whether or not interest is received as cash (whether it be cash, check, direct deposit and otherwise). Think of Earned Interest as having a job where you get paid on Friday. Come Thursday evening, you have earned 4 days worth of your pay even though you won't get the cash until Friday.
This system calculates all interest based on spreadsheet values as they exist when imported. No calculations, report values or other results are ever saved from one import to another.
Penny differences will likely arise between actual cash received and what is calculated by the system. Substantial differences may need to be investigated.
Furthermore, coupon interest calculations in this software should never be used for tax or other reporting purposes. Instead, obtain and use the figures provided by the entity responsible for coupon payment disbursements.



Report 5:  Net recap report for calendar month or period
EARNED interest +/- Discount, Premium amortization +/- Net Gain on sale.

Earned interest for the report period (the calendar month or number of months) plus Discount recognition and minus Premium recognition. The result is NET earnings for the period.



About CASH INTEREST ....
The system "moves" spreadsheet column R Payment Due date, along with Accrue From date, forward and backward based on the calendar calculation month.
Actual cash activity and dates need not be logged.  Simply enter any Coupon due date and frequency for the system to adjust as needed.



Report 6:  Coupon Interest Status report
All coupon interest due since previous payment minus Cash Due this month.

Requires values in spreadsheet columns R and S (if columns R and S are blank, records will be flagged as missing required values).
The system determines the amount of coupon interest earned through this month including cash interest due. This furnishes everything earned and due since prior coupon payment dates. Records will be sorted by the values in spreadsheet column T general ledger accounts. Totals will be provided for each value in spreadsheet column T.
The report consists of records with a Begin Date equal to or earlier than the calendar month.



Report 7:  Cash Due this month report
Coupon interest payments plus any par reductions, sales, maturities occurring this month.

Requires values in spreadsheet columns R and S (otherwise, records will be flagged as missing required values) .
The report includes records having a coupon payment due date matching the selected calendar calculation month. The report will also include interest plus Par for records with a Maturity date, Sale date or other finalized reason date falling within the calendar month. Also included are any Net gain for sold bonds as well as Par for reductions to Par for the month.
Subtotals are provided based on values in spreadsheet column T.
The report can be printed and/or exported to Excel or another spreadsheet, enabling you to "tick off" cash receivables as they come in (it is not necessary to update the system with cash receipts).
Records with a Begin Date later than the calendar month will be excluded. Records which have finalized, such as matured or called, in months PRIOR to the calendar month will be excluded.



Report 8:  Accrued Interest report (requires General ledger module)
What was Earned this month.  Includes Journal Voucher and General Ledger Posting File.

Requires values in spreadsheet columns R, S and T (if columns R and S are blank, records will be flagged as missing required values).
Typically for business (running this report is optional and not required for the system to operate).
The system determines the amount of coupon interest to accrue for the selected calendar calculation month. Also provides a "Total Accrued" which includes applicable Purchased Interest for balancing to receivable accounts. Records will be sorted by the values in spreadsheet column T general ledger accounts. Totals will be provided for each account. A Journal Voucher and General Ledger posting file will also be created.
The report consists of records with a Begin Date equal to or earlier than the calendar month. Records which have finalized, such as matured or called, in or prior to the calendar month will be excluded.

RECONCILING RECEIVABLE ACCOUNTS: The Accrued Interest Report provides a subsidiary listing for general ledger receivable accounts.
CASH INTEREST RECEIVED: Interest receipts can be posted directly to income.
The Accrued Interest report and Accrued Interest Reversal report (below) eliminate the need to reconcile cash receipts to receivable accounts each month.




Report 9:  Accrued Interest Reversal report (requires General ledger module)
Reverse accruals for Cash Due that has been received.  Includes Journal Voucher and General Ledger Posting File.

Requires values in spreadsheet columns R, S and T (if columns R and S are blank, records will not appear on this report).
Typically for business (running this report is optional and not required for the system to operate).
The system determines the amount of accrued interest to reverse for the selected calendar calculation month.
Subtotals are provided based on values in spreadsheet column T.
Prior month accruals are NOT being reversed.
Reversals are created ONLY for records having a coupon payment due plus Matured, Called, Sold and records which Paid off in the selected reversal month.
Reversal amount consists of accrued interest previously posted by the system for these records for ALL months, including Purchased Interest posted by you.
The system calculates running accrual for bonds through the preceding month to determine the amount to reverse (bonds with accrued interest should not be deleted from the spreadsheet until reversals have been done).
Records will be sorted by the values in spreadsheet column T general ledger accounts. Totals will be provided for each account. A Journal Voucher and General Ledger posting file will also be created.
The report consists of records with a Begin Date equal to or earlier than the calendar month. Records must also have a Coupon Due date in spreadsheet column R and a column S code greater than 0. Records which have finalized, such as matured or called, in months PRIOR to the calendar month will be excluded.



Report 11:  Market Position Quote report. Compare Market Quote to Cost Basis calculated as of calendar 'dd' day.
Requires values in spreadsheet column V and also uses optional values in columns W and X
The system will compare a Market Quote for a bond to the Cost Basis calculated as of (TO) the 'dd' date portion of the calendar date. Premiums and discounts are not recognized for the 'dd' date.
Determine your portfolio position for each bond, with a total for all bonds.
The report excludes these bonds:
Blank column V value
Matured or otherwise finalized












  Price page and free demo  ....


Straight Line Method
     Click to open and view Price page
     and download a free demo right now


Effective Interest Method

     Click to open and view Price page
     and download a free demo right now



Bond file calculation services
We can calculate a bond file on a one-time basis.
Premium and discount amortization for a month.
     For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
For more information, Email  Bond file calculation services





    
 







If you don't see what you need ....
Special project?  Pressed for time?
We offer
     •  Bond calculation services on a one-time or recurring basis
     •  Software customization
     •  Other amortization software products

For more information,
email Support@fdssi.com
  





Amortize all bonds at the same time
     •  Straight line method
     •  Premium amortization
     •  Discount accretion
     •  Book Values, Cost Basis as of any month/year
     •  Monthly Totals
     •  Yearly (calendar or fiscal) Totals
     •  Prior months and years
     •  Future projections
     •  Coupon interest status report
               Total amount owed to you
     •  Cash due this month report
               Coupon interest due, purchased interest, par due to sale, maturity ....
     •  Reconciliation report for any month, entire year
               Beginning balances, new bonds, amortization activity, ending balances
     •  Gains and losses on sales, early calls
     •  OID (original issue discount) amortization for applicable bonds
     •  Audit and exams
               Month-by-month lifetime bond recognition schedules
     •  $ Dollar weighted portfolio rates
     •  FASB, GAAP compliant
  





Reports
     •  Import screen with ability to change reporting dates and periods (any month, several months, entire year ....)
     •  Lifetime month-by-month recognition schedule for any bond
     •  Subsidiary listing - discounts and premiums by category
     •  Coupon interest status report - total earned for all bonds
     •  Cash due this month: Interest, maturing par, sales ....
     •  CPA auditor "workpaper" annual reconciliation report
     •  Portfolio cost basis, book value "as of" any DAY
     •  View reports.  Print reports.
     •  Export reports to Excel and Adobe for distribution to others
   






General Ledger Module
     •  Trial Balance subsidiary listing report - par, book value, premium and discount balances within each account
     •  Journal Voucher with debit, credit posting columns
     •  Accrued interest calculations and reports
     •  Auditor worksheet - Reconciliation Report for any month or entire year:
     •  Balance Sheet:  Beginning balances, new additions, reductions, recognition, ending balances
     •  P&L:  Interest, premium expense, discount income, gain/loss on sales, net income for the period
     •  Each bond plus File Totals Recap
  






Records retention
     •  No need to save reports or schedules on paper
     •  Hard copy retention can be eliminated
     •  Whenever a report is needed for any prior month, year or other period:
              1)  Import the applicable Excel file containing your bond portfolio at that time
                    Many clients "save as" and create a new file each year, and then delete matured and sold bonds from the new file.
              2)  Set the software dropdown calendar date to the desired reporting month, year
              3)  Run reports and schedules
  





Supports both
     •  Cost Basis (typically individuals):
              Sale of a bond retains unamortized premium, discount
     •  Book Value (typically business):
              Sale of a bond recognizes unamortized premium, discount




Daily cost basis, book value
     •  Current portfolio value
     •  Comparison of Cost Basis/Book Values to Market quotes as of a given day
               Enter market quotes or
               Retrieve using Excel's RTD function to obtain quotes from an on-line source
     •  Gain or loss if sold column
     •  Each bond
     •  Portfolio totals
     •  Daily Cost Basis/Book Value listing for any date
     •  EOM Mark to Market reporting
 






 Accounting services firm?  Financial advisor?
Do you prepare amortization reports for another party?
     •  Import client bond file to the software
                    File can be maintained by you or
                    File can be maintained by client and emailed to you
     •  Generate monthly, yearly bond amortization and other reports
     •  Export results to Excel
     •  Email to clients
 





                                Supports both
  •  Cost Basis (typically individuals):
         Sale of a bond retains unamortized premium, discount
  •  Book Value (typically business):
         Sale of a bond recognizes unamortized premium, discount

                                  Versions
  •  Effective interest method, level yield, constant yield
  •  Straight line method

                                       Excel
 An Excel file and worksheet template come with the software.
  •  Maintain bonds in 1 worksheet or multiple worksheets
  •  Segregate, aggregate, Group bonds by/for any purpose
  •  Import 1 worksheet, some or all worksheets at the same time
  •  Browse, open a file, select worksheet(s) from a list

                                    Clients?
 Using Excel allows bonds and reports to be shared between:
  •  Client and CPA accounting firm via email
  •  Financial advisors - calculate a portfolio in a few seconds
  •  Service providers:
          Import client bonds from Excel
          Export reports and schedules to Excel with a single click
 
 
                                   Software Reports
     •  Import screen, above (copy/paste bonds or browse/open file)
     •  Lifetime month-by-month recognition schedule for any bond
     •  Subsidiary listing - discounts and premiums by category
     •  Coupon interest status report - total earned for all bonds
     •  Cash due this month: Interest, maturing par, sales ....
     •  CPA auditor "workpaper" annual reconciliation report
     •  Portfolio cost basis, book value "as of" any DAY
     •  View reports.  Print reports.
     •  Export reports to Excel and Adobe for distribution to others



                           General ledger module
     •  Accrued interest report - this month plus total accrued
     •  Accrued interest reversals in "cash due" month
               Reversals eliminate receivable penny problems
     •  Journal vouchers - debit, credit column recaps
     •  General ledger posting files
     •  Mark to market report

 










  Price page and free demo  ....


Straight Line Method
     Click to open and view Price page
     and download a free demo right now


Effective Interest Method

     Click to open and view Price page
     and download a free demo right now



Bond file calculation services
We can calculate a bond file on a one-time basis.
Premium and discount amortization for a month.
     For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
For more information, Email  Bond file calculation services








Need a specific answer?
email (modify) any of these questions initially posed by our clients

     MIXED INVESTMENTS:  I have municipal bonds, corporate bonds and a few others.  Can the software ....
     PREVIOUS YEARS:  I need to amortize bonds using the straight line method for previous years going back to ....
     FIDUCIARY:  I have to amortize client bonds on a recurring basis and send them ....
     SPECIAL PROJECTS:  Can I get the software on a temporary or short term basis for ....
     CALLABLE:  Many of my callable bonds do not get called on the call date.  Can the software keep ....
     GENERAL LEDGER:  We use separate accounts for premiums, discounts and accruals.  Does the software ....
     ACCRUALS:  Does the software provide interest accruals as well as cash due each month including ....
     NETWORKS:  More than one person needs to access the software.  How many ....
     AUDIT:  Is there a way to verify software results?   I need to be able to ....
     YEARLY:  I need to be able to recap a fiscal year - beginning balances, new par, income, expense, maturities, ending balances ....
      PROJECTIONS:  For budgeting and other purposes, can the software calculate premium, discount recognition for a future ....
     RATE CHANGES:  My portfolio has bonds with rate changes, reductions to par and  ....
     FILE SERVICES:  I just want bonds calculated once and get reports for ....
     CUSTOM:  I need bond accounting software that may have to be customized in order to ....
     OUTSOURCING:  Instead of buying software, can I just outsource everything to you and get the reports I need in Excel ....
     Or, just ask a question
 


 









FASB, GAAP compliance for:
  •  Current month, future months
  •  Prior months, restatements
  •  Monthly and annual totals
  •  Calendar and fiscal years

Premiums and discounts:
  •  Straight line calculations
  •  Premium expense
  •  Discount income
  •  Balances
  •  Par
  •  Cost basis, book value
  •  Earned interest
  •  OID amortization
  •  Totals for all
  •  NET earnings recap

Interest:
  •  Cash due this month
          Coupon interest
          Purchased interest
          Par for maturity, call, sale
          Gain or loss on sale
  •  Cash due status for all bonds

Changes:
  •  Rate change
  •  Reduction to par
  •  Early call, redemption

General ledger:
  •  Subsidiary account listing
  •  Schedule with totals
  •  Journal voucher
  •  Posting totals

Balance sheet recognition report:
  •  Beginning balances
  •  Activity
  •  Ending balances
  •  Net change
  •  Month
  •  Year








SPECIAL FEATURES

     •  Individual bond schedules:
               Automatically generate a lifetime premium or discount recognition schedule for any bond at any time.
               View, print, save in Adobe, save in Excel

     •  Partial calls:
               Additional recognition of premium, discount balance attributable to the partial call amount

     •  Partial sales:
               Additional recognition of premium, discount balance attributable to the partial sale amount

     •  Sale of a bond:
               Ability to
               Retain premium and discount balances as part of Cost Basis or
               Recognize premium and discount balances in full

    •  Callable, non-callable bonds
               Ability to "keep a callable bond going" if not called
               Honors partial calls and early calls

     •  Months to calculate:
               Ability to
               Recognize premiums and discounts for a single month and
               Recognize premiums and discounts for a span of 2 months through 12 months.
               Begin a period with any current, prior or future month/year

     •  Market Position Report:
               Compare Cost Basis/Book Value as of a given DAY to market quotes.
               Determine plus/minus position for entire portfolio.

     •  Premiums:
               A display option can show premium recognition as negative in order to readily distinguish between premiums and discount

     •  Mortgage Backed Securities (MBS), other packaged loans:
               Please view this page





  Related Products ....
  BOND PURCHASERS - effective interest method
  BOND ISSUERS - premiums, discounts, issuance costs
  MBS, GNMA, LSBO, LOAN PACKAGES - FASB premiums, discounts amortization


 

 















GENERAL LEDGER:

     •  Subsidiary ledger listing of premium, discount amortization with totals by account number

     •  Premium, discount recognition journal voucher

     •  Premium, discount general ledger upload posting file

     •  Accrued interest report

     •  Accrued interest journal voucher

     •  Accrued interest general ledger upload posting file

     •  Accrued interest reversal report for records with cash payments due
        Eliminate reconciliation headaches associated with the Accrued Interest account
   






Options for existing premium and discount balances


Option 1
        Preserve your existing cost basis book values.
        No restatement or adjusting journal entries necessary.
        The software can begin amortizing current premium and discount balances.
"Thank you!
This program has just made my life so much easier.
I can finally stop adding up all of my amortization schedules!"
                    Georgia


Option 2
         Calculate prior and current cost basis book values.
         The software can amortize premiums and discounts from original dates
         using original information.
Amortize all bonds at the same time.
Get monthly, yearly totals in a few seconds.



Option 3
          Begin amortizing from an "as of" date.
         Typically the beginning of a calendar or fiscal year using balances at year end. 

"We installed your software and just used it for the first time.
I can't believe how much work it will save us each month.
What used to take hours is now done in a matter of minutes.
Your product performs exactly as advertised!"
                    Texas











 


Price and free demo

Effective Interest Method

     Click to open and view Price page
     and download a free demo right now

Straight Line Method
     Click to open and view Price page
     and download a free demo right now


Bond file calculation services
We can calculate a bond file on a one-time basis.
Premium and discount amortization for a month.
     For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
For more information, Email  Bond file calculation services

 





 






 
 
 
 
 



Bond purchasers
Straight line method bond accounting software

Related pages:
Bond issuers
page
Bond purchasers, effective interest method
page





Software to calculate monthly and yearly
     •  Premium amortization
     •  Discount accretion
     •  Cost basis and book value determination for
     •  Municipal bonds
     •  Corporate bonds
     •  Governments
     •  Notes
     •  Bills
     •  Agencies
     •  GNMA's, other mortgage backed securities with monthly reductions to Par

Amortize virtually all premium and discount instruments
     •  Amortize multiple files within a portfolio
               Combine and amortize all at the same time
               Amortize each file individually
     •  Calendar and fiscal year reporting
     •  OID amortization for individuals living in states allowing recognition tied to Original Issue Discount amortization
               Amortize your discount at time of purchase and also amortize the bond's original discount at time of issue
               Amortize both discounts
                     For any month and
                     For an entire year




Amortize and account for ALL bonds the same time
     •  Fixed rate bonds
     •  Variable rate, step bonds, adjustable, floating rate
     •  Zero rate
     •  Convertible
            The software calculates a blended, constant rate from which to derive monthly recognition
     •  Callable - with a call price
     •  Callable - without a price



Coupon interest tracking and reporting
     •  Purchased interest tracking until received
     •  Earned interest and totals
     •  Cash interest income received and totals
     •  Monthly Cash due tickler report showing
               Coupon interest
               Purchased interest
               Par receivable due to maturity, sale or call
               Subtotals by bond management company/brokerage firm/depository



Special features
     •  Callable bond continuation if the bond is not called
            Premium, discount recognition is finalized as of the call date
            Coupon interest continues to the bond's maturity date

     •  Variable rates and
            Rate changes due to any reason
            Recalculation of the effective interest rate
            Coupon interest calculation at the new rate as of the change date

     •  Reductions to Par
            Early call, redemption
            Partial call, redemption
            Partial sale
            Reductions to par for any reason
            A reduction to par generates a proportionate recognition of premium or discount balance

     •  Group totals
            Group bonds and obtain recognition totals by as many different categories as desired

     •  Export
            Copy bonds, calculations and totals for desired period and paste to a spreadsheet
            Automatically create an Adobe pdf file for permanent storage



  
Use the software to
 
     •  Amortize your bonds

     •  Amortize client bonds

        Many of our clients are CPA, accounting
        firms and financial advisors







Client testimonials ....

Thank you!
This program has just made my life so much easier.
I can finally stop adding up all of my amortization schedules!
                    Georgia



We installed your software and just used it for the first time.
I can't believe how much work it will save us each month.
What used to take hours is now done in a matter of minutes.
Your product performs exactly as advertised!
                    Texas


Thanks.
Your customer service is fantastic!
Have a great week.
                    Washington


Our outside accountants just completed their audit.
This is the first year we've been using your software AND
the first year we received a clean audit report.
                    New York


I'm a partner in a small CPA firm.
We were recently engaged to audit municipal bonds issued by a local agency.
Bond discounts needed to be recalculated using the effective interest method.
Calculations with annual reports had to be provided for each of the past seven years.
I can't believe how easily your software allowed us to finish the entire job in such a short period of time.
                    New Mexico
 

Many thanks for the excellent help and support.
I was really not expecting feedback so quickly.
                    Tennessee




Price and free demo  ....


                                                      Prices
Effective Interest Method
     Click to open and view Price page
     and obtain a free demo.

Straight Line Method
     Click to open and view Price page
     and obtain a free demo.


Bond file calculation services
We can calculate a bond file on a one-time basis.
Premium and discount amortization for a month.  For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
For more information, Email  Bond file calculation services




Highlights ....


Compliance for all bonds
simply by placing them into a spreadsheet file with these columns:
     •  Cusip or other identifier
     •  Par
     •  Begin/settlement date
     •  Maturity date
     •  Coupon rate
     •  Price (as $amount or %)
     •  Other values applicable to your bonds such as Call date, any Call price, Convertible date and price ....
Create the file once.
The software does everything else.



Account for dozens, hundreds, thousands of bonds
     •  Current period
     •  Prior periods
     •  Future periods




Straight line amortization for each bond
     •  Fixed rate bonds
     •  Variable rate, steps
     •  Callable bonds
     •  Convertible rate bonds requiring the calculation of constant rate
     •  Virtually any premium, discount instrument



Premium amortization
     •  Monthly expense totals
     •  Yearly totals



Discount accretion
     •  Monthly income totals
     •  Yearly totals.



OID for investors in need of corresponding recognition
     •  Original issue discount amortization
     •  Monthly totals
     •  Yearly totals



Coupon interest tracking
     •  Both Cash and Earned (accrued) interest
     •  Interest due status for all bonds
     •  Earned interest income
     •  Interest accruals
               Accrual reversals
               Asset receivable balances



Cash due reporting
     •  A list of everybody and how much they owe you
     •  Cash interest due this month
     •  Uncollected purchased interest due
     •  Cash due for par resulting from maturity, sales, partial redemptions and calls



Gains, losses on sale to provide net position



Subsidiary schedules
     •  Detail and totals within general ledger account
     •  Detail and totals using other subtotal categories



Monthly reports
     •  Premium, discount recognition.  Balances.
     •  Cost basis.  Book Values.



Annual reports
     •  Calendar and fiscal year recaps
     •  Cash received interest +/- discount and premium recognition
     •  Earned interest +/- discount and premium recognition



Finalized records report
     •  All matured, sold and called bonds



Bond schedules
     •  Audit and exam detail support lifetime schedule for each bond



Client accounting
     •  Import your client bonds to the software
     •  Amortize bonds for any month, any year
     •  Generate reports
     •  Export results



1-800 and email software support



Export bonds, current and prior period recognition, schedules and reports to Excel



A proven system in use by business, individuals, accounting firms and other organizations throughout the country





  Currently using another method?  Another system?  No system?
     The software can recalculate premium and discount balances for current and prior periods.
     Or, the software can preserve your current premium and discount balances.
             No book value, cost basis adjustments necessary.
     Try the free demo available on the Price page, below.
     See how easy it is to amortize your own premium and discounts.



Nothing to learn
     •  Enter basic information about bonds to a spreadsheet
     •  Automatically import bonds to software at any time
          -  Copy all worksheet bonds
          -  Paste to the software
           - Copy.  Paste.  Done.
           -  Monthly straight line calculations
           -  Yearly straight line calculations
     •  View results.  Print results.
     •  Export bonds, balances and totals to a spreadsheet



  Business, other organizations requiring general ledger reporting
     •  Accrual basis accounting
     •  Premium amortization, discount accretion
     •  General ledger posting files for premium and discount recognition
               With subsidiary ledger Balance Sheet account(s) listing
     •  Monthly accrued interest with general ledger posting file
               With subsidiary listing for Accrued Interest Receivable asset account(s)
     •  Accrued interest reversal file with general ledger posting file
               Accrued interest through prior months is reversed for bonds with cash due this month
     •  Coupon interest status report showing who owes you how much
               With subtotals by income account
     •  Cash Due report (a tickler file of who owes you money) listing all funds due each month including
               Coupon interest
               Purchased interest not yet received
               Par due to maturities, sales, calls, reductions for other reasons
               Adjusted for any gain or loss on sale
   •  A free standing calculator to generate a schedule for other bonds

    •  CPA and accounting firms.  Financial advisors.
              Business, government, individual investor clients
              Import, calculate recognition for their bond files
                   Monthly, quarterly totals
                   Calendar and fiscal year totals
              Recalculate a file for prior years
                   Audit
                   Due diligence
              Export, archive calculations and reports to Excel and other spreadsheets
              Exclude bonds which were added after a desired calculation time period
                  Example:  A worksheet contains bonds from 2013, 2014, 2015, 2016 and 2017
                  When working with the year 2016, you can exclude the 2017 bonds from calculations and view.
              Client servicing
                   Import and calculate worksheet bonds on behalf of a client for any period
                   Export results and file totals to a spreadsheet











Enhanced capabilities for business ....
General Ledger Posting and Reporting Module includes
     •  General ledger journal voucher and posting file for premium, discount recognition
               Asset and liability general ledger account numbers
               Income and expense general ledger account numbers

     •  Subsidiary listing Trial Balance with totals by each set of general ledger accounts
               Income and expense totals
               Premium and discount balance totals
               Book value totals
               For any month, quarter or year

     •  Interest accruals with journal voucher and general ledger posting file
               Purchasers:  Income and receivable general ledger account numbers
               Issuers:  Expense and liability account numbers

     •  General ledger posting files for all of the above 
               Postings have an Undo function to reverse a posting made in error
               Postings can be formatted for uploading to any general ledger system

     •  Bond issuers:
               Separate amortization of bond acquisition charges, issue costs



Calculate premium and discount recognition for
     •  Purchased or Issued
               -  Municipal bonds
               -  Agencies
               -  Corporate, government, notes, bills, debentures ....
               -  Virtually any instrument having a premium or discount
   
     •  Premium amortization using the straight line interest method
               Amortization for each bond plus a detailed, lifetime schedule
               Amortization and balance totals for all bonds with a premium

     •  Discount accretion using the straight line method
               Accretion for each bond plus a detailed, lifetime schedule
               Accretion and balance totals for all bonds with a discount

     •  Coupon rate interest calculation for each bond, plus a total for all bonds
               Interest accruals with general ledger posting file

     •  Calculate
               Dozens, hundreds, thousands of bonds at the same time
               Monthly.  Quarterly.  Range of months.  Calendar and fiscal year totals.
               Current period.  Prior periods.  Future periods.

     •  Fixed rate bonds plus

     •  Convertible bonds
     
     •  Zero rate bonds, convertible or otherwise

     •  Variable rate bonds, floating rate, steps
    
     •  Call dates, with or without a call price
               Premium, discount calculations to a call date Cost Basis, Book Value

     •  Reductions
               Bonds with reductions to par, such as a partial sale, recall, paydown
               Accelerated recognition of premium or discount balance proportionate to reduction in par

     •  Existing bonds
              Two solutions:
              Recalculate existing bonds using original dates
              or
              Retain current cost basis, book value.  Convert existing bonds and balances with no journal adjustments.

 

Simple to use
      Basic information for a bond portfolio is maintained
      in one or more spreadsheets
               Par, settlement, maturity, coupon rate ....

      Worksheet templates with headers and column
      documentation come with the software
               Enter bond data and
               Copy/paste bonds from existing worksheets
               Add/insert new bonds at any time

      User defined Group categories to segregate bonds
      and provide totals by/for any purpose.

      The software automatically imports a worksheet
      and performs required calculations
              Premium amortization
              Discount accretion and more
              Import and calculate dozens, hundreds,
              thousands of bonds in a matter of seconds




Portfolio NET totals consisting of
     Coupon rate interest
     + Discount Accretion
     - Premium Amortization
     = NET for any Month.  Quarter.  Calendar or fiscal year.  Go back in time.  Go forward in time.




Bonds consist of loan packages?  View our Omnibus FASB 91 premium and discount amortization software for
  •  MBS, GNMAs, syndicated packages, LSBO, secondary market, grouped originations, bundled loans, bonds with monthly par reductions and more.


Premium and discount portfolio accounting
  •  Generate income and expense detail plus totals for:
  •  Any month
  •  Any quarter
  •  Any annual, yearly period - calendar or fiscal
  •  Historical - view a portfolio as it was at any time in the past
  •  360/365/366 days in a year basis at the bond level matches coupon interest basis
  •  User defined Group totals



Purchased bonds
     •  Investors, traders, business, institutions, trust departments, client accounting services ....
     •  Calculate discount income, premium expense on a monthly, quarterly, annual basis for all bonds at the same time



Issued bonds
     •  Municipalities, taxing districts, corporate .... (amortize bond issuance costs, too)
     •  Calculate discount expense, premium income on a monthly, quarterly, annual basis for all bonds at the same time
     •  Amortize original issue, debt issuance amounts, too



Variable rate instruments, such as Steps
     •  The system switches to calculating coupon interest at the new rate as of the actual rate change day


Convertible rate bonds
     •  The system switches to calculating coupon rate interest at the convertible rate on the convertible date


Call Dates
     •  Premium and discount recognition to a Call Date


Call Prices
     •  Premium, discount recognition to a Cost Basis Call Price
     •  Example:  Purchase 100,000 at 97 with a Call at 102 and the system accretes 5,000 to a Cost Basis 102,000
     •  Example:  Purchase 100,000 at 103 with a Call at 101 and the system amortizes 2,000 to a Cost Basis of 101,000


Sale or early call, redemption date
     •  The system recognizes the remaining premium, discount balance in full
     •   If a Call Price is involved, the system makes all necessary adjustments, including the recapture of any recognized portion of the Call


Partial sale, early call, redemption
     •  The system accelerates premium, discount recognition by the percentage of: ReductionToPar / Par
     •  Remaining premium or discount is calculated over the remaining term
     •  If a Call Price is involved, the system makes all necessary adjustments, including the percentage recapture of any recognized portion of the Call


Reductions to Par
  •  Accelerated recognition of premium and discount balances for
  •  Partial and complete sales
  •  Partial and complete recalls
  •  Other reductions to Par for any reason



Easily account for exceptions arising from ....
     •  Early calls, redemption  (the software recognizes premium, discount balance in full)
     •  Partial calls, redemption  (the software accelerates premium, discount recognition by the call amount percentage)
     •  Sales  (the software recognizes premium, discount balance in full)
     •  Partial sales  (the software accelerates premium, discount recognition by the par reduction percentage)
     •  Periodic reductions to Par for any reason  (the software accelerates premium, discount recognition by the par reduction percentage)



•  Purchased bonds
     -  Held to maturity or trade/sale/early call date



•  Fixed rate bonds
   and
•  Convertible bonds
     -  Including initial rate of zero
     -  Convertible rate amortization, accretion at Constant interest rate
     -  OID bonds
     -  For variable rate bonds when future dates, rates are unknown, view our Omnibus Variable, Floating Rates software page)



•  Discount accretion
     -  Individual bond level
     -  File, portfolio totals
     -  General ledger totals
     -  Lifetime accretion schedule for a bond



•  Premium amortization
     -  Individual bond level
     -  File, portfolio totals
     -  General ledger totals
     -  Lifetime amortization schedule for a bond



•  OID
     -  OID accretion totals (for more on this, view our Original Issue Discounts OID amortization page)
     -  Group and track OID with purchased bonds accretion totals
     -  Compare recognition amounts between OID and purchased
             Monthly
             Quarterly
             Annual (fiscal and calendar year totals)



•  Early call/redemption/sale date
     -  Recognize deferral balance in full as of any date for any reason



•  Interest at the coupon rate
     -  Calculate coupon rate interest and accruals for any period, too
     -  Supports 360/365/366 day basis



•  Generate:
     -  Premium recognition subtotals
     -  Discount recognition subtotals
     -  Accounting reports
     -  Journal voucher posting source document
     -  General ledger transaction posting file (supports any chart of accounts)



•  Existing bonds
     -  Preserve current deferral balances or
     -  System can calculate current balances



General Ledger Reporting ....
     •  General ledger reporting
          -  Subsidiary ledger balancing report
               Detail and totals by each general ledger account for
                    -  Premium and discount recognition
                    -  Accumulated
                    -  Remaining balance book values
          -  Journal voucher posting source document
          -  General ledger transaction posting file
                    -  Formatted for uploading to your general ledger system

     •  Interest accruals at bond coupon rate:
         -  Monthly amount (book to receivable) or
         -  Gross accrual from an accrual date (for book and reverse operations)
         -  Accrual report, journal voucher posting source document and general ledger transaction posting file


     •  NET report - what did you earn on your portfolio?
              Coupon interest for the period
          +  Discount accretion
          -  Premium amortization
          +  Gain on Sale
          =  NET result for each bond and entire portfolio



Your existing records
     •  Easy conversion ....
          -  Preserve current general ledger balances or
          - Have the software recalculate premium and discount amortization from Begin dates.







Maintain bond records in one or more worksheets.  At any time,
1)  Import a worksheet
2)  Select a calendar date and calculate
     -  Premium and discount recognition for an entire file
     -  Issue costs, fee recognition for an entire file
     -  Interest accruals
     -  All monthly accounting reports
     -  General ledger postings
          Direct post and
          Allocate to multiple cost and revenue centers
     -  Lifetime amortization schedule for any bond
     -  In a matter of seconds!


Getting started is easy.
     No adjusting journal entry required.
     Be up and running in no time.

Export calculation results and reports to Excel, other spreadsheet.
     For internal use.
     Email to outside auditors.

Records retention.
     Export reports to a worksheet.
     Or save bond worksheets with a unique monthly name.
          Import, calculate, report at any future date.


During import, the software:
     -  Determines premium or discount amount
     -  Provides:
          Monthly premium and discount amortization and accretion based on selected calendar date
          For each record:
               Monthly premium and discount recognition
               Accumulated recognition
               Deferred premium or discount balance
               Book value carrying balance
          Summary totals of the above by category:
               Premium totals
               Discount totals


You can also:
     Generate amortized income and expense totals for a
          Month
          Quarter
          Calendar or fiscal year
          As of a prior or future period
     View a lifetime month by month amortization and recognition schedule for any record
     Copy and paste results elsewhere


More about bond accounting and reporting ....

All monthly reports:
     View, print, export
     Subsidiary listing trial balance by general ledger account
     Detailed records plus accounting subtotals
     Journal voucher
     General ledger debit and credit posting summary recap

General ledger posting file preparation
     Supports any chart of accounts

Interest accruals
     Calculate an accrual for the current month only or
     Calculate a total accrued using an "accrue from" date
     Supports accrue and accrual reversal functions
     General ledger posting account numbers or system assigned defaults
     Projections: Calculate interest accrual through end of year, other period

Early maturity, call date column
     Take full premium and discount balances prior to scheduled maturity date
     System automatically finalizes a record if redeemed early, sold, called or otherwise disposed

Period calculations
     Fiscal and calendar years
     Determine all balances "as of" a future month, EOY period
     Determine income, expense spanning multiple months

Allocation capabilities
     Distribute income, expense to revenue and cost centers


Also available in a version where a file consists of
Bonds representing groups and packages (see our Omnibus software):
     -  Individual rates, composite, dollar weighted
     -  Mortgage backed securities
     -  LSBOs
          Purchased loans
          Participations
     -  Other packaged instruments
          Held to term
          Average life
     -  Amortizing
     -  Irregular principal receipts stream
          Variable amounts
          Curtailments, payoffs
          Partial sales
     -  Weighted rate changes





Calculations for desired period
     •  Any month
     •  Any year
     •  Current period, prior periods, future period projections
     •  Go back in time.  Go forward in time.
     •  Monthly totals, quarterly, other multiple month totals
     •  Yearly totals - Calendar year, Fiscal year, Tax year
     •  Income and expense for the period
     •  Earned Interest
     •  Premium and discount remaining balances
     •  Cost basis, book values



Reports
     •  Group totals to aggregate bonds for any user defined purpose
     •  Other user defined subtotal descriptions including general ledger accounts
     •  Premium amortization, discount accretion report
     •  Cash Due this month report includes
             Coupon interest due
             Uncollected purchased interest
             Par which may be due resulting from maturities, sales and calls
             Gain on sales (or reduction for Loss)
     •  Coupon interest status report showing next due dates with interest amount portion through the reporting month
     •  Finalized records report showing all bonds that matured, were sold, called or otherwise paid off
     •  Accrued interest report
     •  Accrued interest reversal report



Easy to operate - Nothing to learn
     •  Automatically import all bonds at the same time from a spreadsheet, such as Excel
               Maintain bond information in a spreadsheet you already know how to operate
               Copy an entire spreadsheet
               Paste all bonds to the software import screen - it's that easy
               Excel users can open, select one or multiple worksheets and import bonds directly (skip the copy/paste function)
     •  Calculate all bonds
               File totals
               Lifetime amortization and accretion schedule for any bond
     •  Run reports
     •  Export results to a spreadsheet
 



Designed for and in use by ....

Business, other organizations requiring general ledger reporting
     •  Accrual basis accounting
     •  Premium amortization, discount accretion
     •  General ledger posting files for premium and discount recognition
               With subsidiary ledger Balance Sheet account(s) listing
     •  Monthly accrued interest with general ledger posting file
               With subsidiary listing for Accrued Interest Receivable asset account(s)
     •  Accrued interest reversal file with general ledger posting file
               Accrued interest through prior months is reversed for bonds with cash due this month
     •  Coupon interest status report showing who owes you how much
               With subtotals by income account
     •  Cash Due report (a tickler file of who owes you money) listing all funds due each month including
               Coupon interest
               Purchased interest not yet received
               Par due to maturities, sales, calls, reductions for other reasons
               Adjusted for any gain or loss on sale
   •  A free standing calculator to calculate an effective rate and generate a schedule for other bonds


Individual bond owners, investors
     •  Premium amortization, discount accretion
     •  Coupon interest status report showing who owes you how much
               With subtotals by payer
     •  Cash Due report (a tickler file of who owes you money) listing all funds due each month including
               Coupon interest
               Purchased interest not yet received
               Par due to maturities, sales, calls, reductions for other reasons
               Adjusted for any gain or loss on sale
     •  A free standing calculator to calculate an effective rate and generate a schedule for other bonds


CPA, accounting firms
     •  Use the software to import, calculate, audit and report client files


Financial advisors.  Trust departments.
     •  Use the software to manage, import, calculate, export client files



Price
Accounting software price page
Free demo
Price page


Bond file calculation services
We can calculate a bond file on a one-time basis.
Premium and discount amortization for a month.
For an entire calendar/fiscal year.
Reports and supportive data are provided in Excel.
For more information, Email  Bond file calculation services


Questions?
Don't see what you need?
     Need some assistance with your situation?
1-800-245-8444
or email Support@fdssi.com

Other pages of interest ....
FASB 91 products page
Omnibus - Loan, bond packages FASB amortization
Loan origination fees FASB 91 amortization
Enter, calculate one record at a time calculator suite
CPA, auditor, financial advisor FASB 91 page
FASB 91 custom system
FASB 91 services offered

 











 
  Straight line discount and premium amortization
 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