SYSTEM AND METHOD OF RECONCILIATION OF TRADE, PAYMENT AND DELIVERY DATE WITH EXPECTED TRANSACTIONS

摘要

A system, method and graphical presentation method of reconciling trade, delivery and payment records of financial transactions by grouping records on the basis of the offerings or transactions to which such records relate, matching buy and sell records for securities in the offering, pairing delivery and receipt records of such securities into various accounts, and pairing wire funds transfers. Grouped, matched and paired records are loaded into a ledger where calculations are executed and presented to show open and closed positions, delivered and received securities and wire transfers.

主权项

1. A method for reconciling trade, payment and delivery data in a plurality of financial accounts, comprising
receiving into a memory device, data from a plurality of securities transaction records of said plurality of financial accounts, said plurality of transaction records including transaction records from a plurality of securities offerings; associating a first of said plurality of records stored in said memory device with a first of said securities offerings and a second of said plurality of records with a second of said securities offerings
by
associating an issuer identifier of said first of said plurality of records with an issuer identifier of said first offering and by associating a proximity of a date of said first of said plurality of records with a date of said first offering, andassociating an issuer identifier of said second of said plurality of records with an issuer identifier of said second offering and by associating a proximity of a date of said second of said plurality of records with a date of said second offering; comparing
a quantity of securities in buy transaction records from among said plurality of securities transaction records of said first offeringtoa quantity of securities in sell transactions records from among said plurality of securities transaction records of said first offering in said plurality of financial accounts, and indicating an open position if said comparison indicates a difference in said quantity of securities in said buy transaction records and said sell transaction records; comparing an account identity of a first of said buy transaction records to an account identity of a first of said sell transaction records, and if said account identities are not the same,
pairing a delivery record of a quantity of securities of a first of said buy transaction records, said delivery from a first of said plurality of financial accountsto a receive record of said quantity of securities of a first of said sell transaction records, said receive record from a second of said plurality of financial accounts; and issuing a first signal if there is at least one of a delivery and receive record from said plurality of records associated with said first securities offering that are not paired; and
pairing a funds delivery record from among said plurality of securities transaction records stored in said memory device, said funds delivered record from a first of said plurality of financial accountsto a funds receive record from among said plurality of securities transactions records, said funds received records from a second of said plurality of financial accounts; and issuing a second signal if there is at least one of said funds delivery and said funds receive record from said plurality of records associated with said first securities offering that is not paired.