Bond Interest Reporting

Each month a file is available from the clearing firm that contains all bond transactions and end of month holdings. This automatic download populates a database utilized to calculate accrued interest paid/received on a trade by trade basis and the accumulated accrued interest for any outstanding holdings. Since the originating data source computes this figure on their own end of month determination, the calculations performed by this application presents a more accurate end of month figure. Reports break these out by trading account and an overall and detail versions were designed to easy identify any anomalies or investigate these issues. Different accrued interest calculations are performed for both Treasury and Muni Bonds. Lastly, utilizing the Bond Master file and Bloomberg API, each transaction can be more accurately computed, with non-defined bonds reported on following the download.