US20110055064A1 - Methods and systems for assisting financial services firms and their representatives - Google Patents

Abstract

Methods and systems are provided for assisting financial services firms and their representatives in efficiently managing their businesses, and in developing and maintaining strong customer service and loyalty. An integrated, preferably web based browser operated system is provided that uses one or more central databases to store customer, account, accounting, compliance, and other relevant information. Interfaces and tools are also provided for accessing the one or more central databases in a manner that is consistent with and supports how a representative actually works.

Description

CROSS-REFERENCE TO CO-PENDING PATENT APPLICATIONS
• This Application a continuation of U.S. patent application Ser. No. 09/917,120, filed Jul. 27, 2001 entitled “Methods and systems for assisting financial services firms and their representatives” and is related to co-pending U.S. Pat. No. 7,653,564, filed Jul. 27, 2001, entitled “Methods And Systems For Providing A Measure Of Supervision Over The Activities Of Representatives Of A Business” and U.S. Pat. No. 7,349,865, filed Jul. 27, 2001, entitled “Methods and Systems for Monitoring the Efficacy of a Marketing Project”, all of which are incorporated herein by reference.
FIELD OF THE INVENTION
• The present invention generally relates to the financial services industry, and more particularly, to methods and systems for assisting financial services firms and their representatives in the operation of their businesses.
BACKGROUND OF THE INVENTION
• The distribution model used by the financial services industry to move investment products often begins with the DTCC (Depository Trust Clearing Corporation—formerly NSCC). The DTCC clears a majority of the investment market's equity, debt and mutual fund trades. Additionally, the DTCC clears some industry insurance transactions. Financial services firms such as Broker Dealers, who transact business through the DTCC, must either be a Clearing Broker Dealer or a correspondent to a Clearing Broker Dealer. Clearing Broker Dealers generally have systems that facilitate trading with the DTCC.
• There are various types of Broker Dealers, including for example, insurance based Broker Dealers, bank based Broker Dealers, independent Broker Dealers, specialty niche Broker Dealers, and others. Insurance-based Broker Dealers have evolved to support the distribution of variable life and annuity products. In some cases, the insurance based Broker Dealers have grown to be quite sophisticated in order to attract sales professionals to sell not only the insurer's products, but other investment products.
• Changes in legislation have allowed bank-based Broker Dealers to grow and acquire similar entities. As such, bank based Broker Dealers have become more sophisticated over time. They continue to attract representatives from wire house firms (i.e., Merrill Lync™, Paine Webber™, etc.), and train their representatives to focus on cross-selling bank and bank-related financial services. The cross-selling nature of their business requires the focus of referral tracking (identifying who in the bank or division referred the customer to the representative).
• Independent Broker Dealers have been formed over time to provide a vehicle for successful registered representatives who have built their businesses through the traditional wire house environment. These successful professionals are attracted to the independent Broker Dealers because of an enhanced payout schedule. They are, however, often disappointed by the technological solutions provided by the Independent Broker Dealers. Affiliate offices are typically tied to independent Broker Dealers.
• Specialty niche Broker Dealers have been formed to support vertically aligned specialty firms such as accountancy corporations and consumer and mortgage loan providers. These professionals attempt to cross sell their primary customers additional investment products.
• Over the past few decades, the development and use of computers and computer technology to help manage the business of the larger financial service firms has grown rapidly. Smaller Broker Dealers have been left behind, however, because the commercially available technology solutions are simply cost prohibitive. Also during this period, the number of products offered by the financial services firms have increased substantially. Many of the product offerings were added in an incremental fashion, over an extended period of time. Consistent therewith, the software products developed to support the various product offerings were also incrementally developed. The legacy of this environment is a group of rather expensive yet powerful software applications that operate and are accessible primarily independently of one other, resulting in multiple standards, redundant files, and often data errors and failed system cross-processing. In many cases, such systems have caused significant harm to customer relationships and firm reputations.
• What would be desirable, therefore, is a more affordable integrated system that assists financial services firms such as Broker Dealers in efficiently managing their businesses, and developing and maintaining strong customer service and loyalty.
SUMMARY OF THE INVENTION
• The present invention provides methods and systems for assisting financial services firms and their representatives in efficiently managing their businesses, and in developing and maintaining strong customer service and loyalty. In a preferred embodiment, this is accomplished by providing an integrated system that uses a central database to store customer, account, accounting and other relevant information. Interfaces and tools are then provided for accessing the central database in a manner that is consistent with and supports how a representative actually works.
• In one example, when a representative is analyzing or discussing a customer's portfolio, it is highly desirable to have ready access to all of the customer account information. It is also highly desirable to be able to combine certain accounts “on the fly”, such as several business accounts, or all family accounts including 401K accounts. To accomplish this, and in accordance with one illustrative embodiment of the present invention, the representative is allowed to create a data structure that has one or more associated links. The data structure can be thought of as a “household” account, although it does not have to be associated with a customer's “household”, nor does it preferably contain any actual account data. Instead, the “household” account can be arbitrarily defined, and preferably only includes a number of links that identify or point to other accounts within the system. The links are preferably defined by the representative. Once defined and selected, the present invention may display the account items that are within the accounts identified by the one or more links of the household account data structure. The household accounts may be saved for later reference and use.
• It is contemplated that the “household” accounts may link, point to, or pull in data from two or more databases. For example, a remote database may include account or other information for a remote brokerage house, bank or the like. In this example, the “household” account may link, point to, or pull in account information from the remote database, if desired. This illustrates that the “household” accounts may include references to both local and remote databases, if desired.
• To provide a degree of hierarchy, it is contemplated that a household account may include a link to other household accounts. Such a data structure may be called a household-of-households account. When a household-of-households account is selected, the present invention preferably displays the account items within the accounts identified by the one or more links of the household-of-households account, as well as the account items within the one or more accounts identified by the links in the identified sub-household account or accounts. Multiple levels of household-of-household accounts may be created, providing maximum flexibility to the representative. An advantage of using a data structure that only includes links rather than actual account data is that the displayed account items are collected from the actual accounts at the time of display, and are therefore up-to-date. For this reason, the household (and household-of-household) accounts can be thought of as dynamic links. Household-of-household accounts are often referred to herein simply as household accounts.
• To simplify the display of account items, related account items from the various accounts identified by a household account may be combined before the data items are displayed. Example account items that may be combined include, for example, stock positions in a particular company. To do this, the account items that are related must first be identified. Then, the account items may be combined by, for example, summing the stock positions for a particular company, and outputting a single account item for display. In this example, an average or effective purchase price for the stock may be computed and also displayed. By combining related account items, the number of account items that are displayed may be reduced, and a more clear picture of the particular emphasis of the customer's portfolio can be seen. It is contemplated that various reports may also be run on the individual accounts or the household accounts, as desired.
• To improve the efficiency of a representative in contacting or marketing to various customers, it is contemplated that a search function can be used to identifying database entries that have one or more fields that match a search query or expression. In one example, the account database may be part of a relational database that has one or more accounts for each customer. Each account may have a number of fields including, for example, the customer's name, the customer's address, the customer's birth date, the customer's past and current stock holdings, the number of shares of each stock owned, the purchase price of each stock, the current price of each stock, the customer's net worth, hobbies and interests of the customer, etc. The representative may identify those customers that have one or more fields that match a desired query or expression.
• For example, a representative may wish to identify all customers that have a birthday in March. Alternatively, the representative may wish to identify all customers that hold a particular stock, have a net worth greater than $500,000 and are interested in Golf By entering an appropriate query or expression, typically through a designated menu, the appropriate customers can be identified.
• Once identified, the present invention may provide a formatted output that includes, for example, the identified customers' names and addresses. The formatted output can be formatted as a merge file that can be read by another program that has a merge capability (such as Microsoft Word). The merge capability can be used to insert the outputted fields into designated locations within a letter or promotional item, which can then be sent to the identified customers. The formatted output can also be formatted for a spreadsheet program, or to print on printed labels, as desired. Other formats are also contemplated including, for example, formats that are compatible with e-mail systems or personal digital assistants (PDAs).
• To further improve the efficiency of the representative, a stock deposit function may be provided. In many small Broker Dealer firms, performing a stock deposit can be a time consuming, error prone, and tedious task. During a typical stock deposit, the representative receives the stock from the customer, retrieves a copy of a stock power from paper files, completes the stock power, provides the customer with a receipt, and manually enters the received stock in the blotter of the firm. The present invention may substantially simplify this process. In one illustrative embodiment, the representative merely selects or creates a customer account in the system, enters the number of shares to be deposited with the firm, a company identifier for the stock, and one or more stock certificate numbers. The system then automatically generates a stock power that can be readily printed. The system may also create an entry in the appropriate customer account, and enter a stock deposit entry in the firm blotter, if desired. This may significantly reduce the time required to process a stock deposit, and may reduce errors that might otherwise occur.
• For many representatives, customer referrals are a primary source of business. Therefore, the present invention contemplates tracking the productivity of customer referrals to help increase the representatives business. The productivity of customer referrals may be tracked in any number of ways. In one illustrative embodiment, the productivity of customer referrals is tracked by storing a customer referral source identifier for each referred customer. A total number of customer referrals for each customer referral source is then determined, along with an average number of customer referrals across all customer referral sources. A measure of relative productivity can then be determined for any particular customer referral source by comparing the total number of customer referrals for the particular customer referral source against the average number of customer referrals across all customer referral sources. The referral productivity of a particular customer is preferably displayed when the customer's account is accessed.
• Alternatively, or in addition, the present invention may identify those customer referral sources that are particularly productive, such as those that have a total number of customer referrals that exceed the average customer referrals, those that are in the top ten of customer referral sources, or those that are in the top “n” percent of productivity. If desired, the present invention may output a formatted output that includes the particularly productive customer referral sources. The representative may then use the formatted output to generate, for example, a thank your letter or an invitation to a special event.
• Because some customer referrals generate more commission than others, the present invention may track the productivity of customer referrals by commissions received, rather than by the total number of referrals. To do this, the present invention may determine a total dollar amount of commissions received from customers referred to the representative or firm by each customer referral source. Then, an average dollar amount may be computed for all customer referral sources. A measure of the relative productivity of any given customer referral source can then be determined by comparing the total dollar amount of commissions for a selected customer referral source against the average dollar amount received across all customer referral sources. Alternatively, or in addition, the present invention may identify those customer referral sources that are, for example, in the top “n” percent of productivity, as described above.
• When a representative receives a call from a customer or wants to review a customers account, it is desirable to have ready access to the customer's investment objectives, recent customer contacts, and other information such as the customer's current holdings. Accordingly, the present invention contemplates displaying on a single screen or window, or several screens or windows simultaneously, the investment objectives and selected previously documented customer contacts. The present invention also contemplates displaying on the same screen or window selected account holdings, and a number of personal information fields. A report generator option interface, a securities trade option interface, and/or a deposit option interface may also be displayed on the same screen or window. In aggregate, these represent the primary information sources that a representative needs to efficiently service a customer's needs and create significant customer satisfaction and loyalty.
BRIEF DESCRIPTION OF THE DRAWINGS
• FIG. 1 is a schematic diagram showing the product distribution model commonly used in the financial services industry;
• FIG. 2 is a schematic diagram showing the architecture of an illustrative system for assisting financial services firms and their representatives in efficiently managing their businesses;
• FIG. 3 is a schematic diagram showing an illustrative user hierarchy in accordance with the present invention;
• FIG. 4 is a schematic diagram showing an illustrative account hierarchy in accordance with the present invention;
• FIG. 5 is a screen shot of an illustrative initial window that may be displayed in accordance with the present invention;
• FIG. 6 is a screen shot of an illustrative window that may be displayed when the “Most active” button (for all Reps) inFIG. 5 is selected;
• FIG. 7 is a screen shot of an illustrative window that may be displayed when the “Most active” button (for Rep 3BR) inFIG. 5 is selected;
• FIG. 8 is a screen shot of an illustrative window that may be displayed when the “Deposits” button under the Compliance Ledgers section ofFIG. 5 is selected;
• FIG. 9 is a screen shot of an illustrative window that may be displayed when the “Trades” button under the Compliance Ledgers section ofFIG. 5 is selected;
• FIG. 10 is an illustrative screen shot that may be displayed when the “Daily Tickets” button under the Compliance Ledgers section ofFIG. 5 is selected;
• FIG. 11 is a screen shot of an illustrative window that may be displayed when the “Mail Merge” hyperlink under the Investigo Functions section ofFIG. 5 is selected;
• FIG. 12 is a screen shot showing an illustrative output when the “Create Mail Merge” button ofFIG. 11 is selected;
• FIG. 13 is a screen shot showing an illustrative window that may be displayed when the phrase “CSCO” is entered into the Symbol dialog box ofFIG. 5;
• FIG. 14 is a screen shot showing an illustrative window that may be displayed when the “Go” button ofFIG. 13 is selected;
• FIG. 15 is a screen shot showing an illustrative window that may be displayed when the “Investigo Today” hyperlink onFIG. 5 is selected;
• FIG. 16 is a screen shot showing an illustrative window that may be displayed when the phrase “customer” is entered into the account search dialog box ofFIG. 15;
• FIG. 17 is a screen shot showing an illustrative window that may be displayed when the hyperlink “JDEMO” is selected inFIG. 16;
• FIG. 18 is a screen shot showing the illustrative window ofFIG. 17 with the report menu expanded;
• FIG. 19 is a screen shot of an illustrative window that may be displayed when the “Realized G/L” report is selected inFIG. 18;
• FIG. 20 is a screen shot showing the illustrative window ofFIG. 17 with the trade menu expanded;
• FIG. 21 is a screen shot of an illustrative window that may be displayed when “Buy” is selected from the trade menu ofFIG. 20;
• FIG. 22 is a screen shot of an illustrative window that may be displayed when the “Confirm This Trade” button ofFIG. 21 is selected;
• FIG. 23 is a screen shot showing the illustrative window ofFIG. 17 with the “Make a” menu expanded;
• FIG. 24 is a screen shot of an illustrative window that may be displayed when the “Make a Stock Deposit” menu option ofFIG. 23 is selected;
• FIG. 25 is a screen shot of an illustrative window that may be displayed when the “Generate Stock Power” button ofFIG. 24 is selected;
• FIG. 26 is a screen shot of an illustrative window that may be displayed when the “ANEFX” hyperlink ofFIG. 17 is selected;
• FIG. 27 is a screen shot of an illustrative window that may be displayed when “View JDEMO's Contact History” hyperlink ofFIG. 17 is selected; and
• FIG. 28 is a screen shot of an illustrative window that may be displayed when the “Tell Me about” hyperlink ofFIG. 17 is selected.
DETAILED DESCRIPTION OF THE INVENTION
• The present invention is described below primarily with respect to Broker Dealer firms. The present invention is, however, equally applicable to other financial services firms including banks, insurance companies, consumer finance organizations, wire houses, etc. More generally, the present invention is applicable to any firm or business that has representatives, and may be useful in efficiently managing their businesses and in developing and maintaining strong customer service and loyalty.
• FIG. 1 is a schematic diagram showing the distribution model commonly used in the financial services industry to move investment products. The distribution model often begins with the DTCC (Depository Trust Clearing Corporation—formerly NSCC)10. The DTCC clears a majority of the investment market's equity, debt and mutual find trades, and also some industry insurance transactions. Financial services who transact business through theDTCC10, must either be aClearing Broker Dealer12 or acorrespondent14 to a Clearing Broker Dealer.Clearing Broker Dealers12 generally have systems that facilitate trading with theDTCC10.
• TheClearing Broker Dealers12 may have their own direct sales force, which often includes registered representatives andsales assistants16 that sell investment product directly to customers. TheClearing Broker Dealers12 may also have a number ofCorrespondent Broker Dealers14aand14b. EachCorrespondent Broker Dealer14aand14bmay have a number of registered representatives and sales assistants to sell investment product to their customers. Some of theCorrespondent Broker Dealers14 may have Affiliate Broker Dealers, such asAffiliate Broker Dealer20, which may also have registered representatives and sales assistants for selling investment product to their customers.
• FIG. 2 is a schematic diagram showing the architecture of an illustrative system for assisting financial services firms and their representatives in efficiently managing their businesses and developing and maintaining strong customer service and loyalty. The illustrative system may be used by financial services firms such asClearing Broker Dealers12,Correspondent Broker Dealers14aand14b, Affiliate Broker Dealers20 (seeFIG. 1), or other financial services firms such as banks, insurance companies, consumer finance organizations, wire houses, etc.
• The illustrative system uses adatabase30a, which is preferably a relational database such as a Microsoft Access™,Microsoft SQL Server 2000™, Oracle 9™, etc. In some embodiments, the system may also access other databases, such asdatabases30band30c.Database30bis shown as another local database, anddatabase30cis shown as a remote database. Multiple local and/or remote databases may be used by the system, if desired.
• The broker/dealer interface andcontrol block32 provides an interface between thedatabases30a-cand the users54A,54B, and54C of the system. The users54A,54B, and54C may be any type of users, but in the illustrative embodiment, are registered representatives and/or sales assistants. In a preferred embodiment, the broker/dealerinterfacing control block32 andrelational database30a(and30b-cif desired) operate on one or more servers connected to a number of client systems through the World Wide Web (WWW). The users54A,54B and54C preferably access the broker/dealer interface andcontrol block32 using the client systems. The server functions are generally shown below dashedline60, and the client functions are generally shown above dashedline60. While the preferred embodiment allows the users54A,54B and54C to access the broker/dealer interface andcontrol block32 via the WWW, other embodiments allow the users54A,54B and54C to access the broker/dealerinterface control block32 in any number of ways including, for example, through an intranet, a LAN, a direct connection, or any other connection mechanism or means.
• To receive pricing data and to clear trades, the broker/dealer interface andcontrol block32 may be connected to theDTCC10 and/or other services. It is contemplated that these connections may be via the WWW, an intranet, a LAN, a direct connection, or any other connection means.
• In the illustrative embodiment, therelational database30aincludes a number of data files (or entries) to support the activities of users54A,54B and54C. In some embodiments, some of these data files and/or additional data files are provided indatabases30band30c. Some illustrative data files includecustomer account data34,general ledger data36,securities ledger data38,trade blotter data40, user activity logs42, customer correspondence history logs44,customer contact information46, calendaringinformation48, andothers50. The account data file34 preferably identifies each customer account, and the contents of each account. A customer account may include, for example, a customer account number, current and past holdings of the account, investment objectives of the account, personal information about the customer including the customer's name, address, interests, etc.
• The general ledger data file36 preferably stores a general ledger for the broker dealer firm. Thesecurities ledger38 preferably records each buy and sell executed by the broker dealer firm. The trade blotter data file40 preferably stores each trade executed by the broker dealer firm. The user activity log data file42 preferably stores information relating to each user's activity on the system. The correspondence history data file44 preferably records the correspondence history between each representative and their customers. The contact information data file46 preferably stores contact information for each customer including, for example, customer name, address, phone number, fax number, e-mail address, etc. The calendaring information data file preferably records appointments as well as other items provided by the representatives.
• FIG. 3 is a schematic diagram showing an illustrative user hierarchy in accordance with the present invention. In the illustrative embodiment, theClearing Broker Dealer12 has a firstCorrespondent Broker Dealers14aand a secondCorrespondent Broker Dealers14b. Both theClearing Broker Dealers12 and theCorrespondent Broker Dealers14aand14bpreferably use the system, andshare database30aofFIG. 2. When so provided, the various users of the system can be placed in a hierarchical tree. Those placed higher in the hierarchical tree may be given access to the accounts and data of the users placed lower in the hierarchical tree structure. For example,user70 of the firstCorrespondent Broker Dealers14amay have access to the accounts and data ofusers72a,72band72c.User70 may be, for example, the representative that heads the firstCorrespondent Broker Dealers14a. Likewise, user74 of theClearing Broker Dealer12 may have access to the accounts and data ofusers70,72a,72band72cof firstCorrespondent Broker Dealers14a, and the users of the secondCorrespondent Broker Dealers14bincluding user76. User74 may be, for example, a compliance officer with theClearing Broker Dealers12. This user hierarchy is preferably achieved by providing an identifier for each user that identifies those users that are lower (or higher) in the hierarchical tree structure.
• As is known, the financial services industry as well as other industries are subject to a vast array of rules and regulations from a variety of regulatory agencies. Because of these rules and regulations, each broker dealer has an obligation to ensure that all of its representatives follow all applicable rules and regulations. To accommodate this, and to help limit any potential liability for non-compliance, the hierarchical tree structure discussed above may be used to monitor the activities of representatives in the firm. In one embodiment, those higher in the hierarchical tree structure are given the rights to monitor the activities of those lower in the hierarchical tree structure. Preferably, the hierarchical tree structure corresponds to the responsibility assumed by each broker dealer in complying with the rules and regulations required by the various regulatory agencies. Various methods and systems for providing a measure of supervision over the activities of the representatives of a firm are described in co-pending U.S. Pat. No. 7,653,564, entitled “Methods And Systems For Providing A Measure Of Supervision Over The Activities Of Representatives Of A Business”.
• FIG. 4 is a schematic diagram showing an illustrative account hierarchy in accordance with an illustrative embodiment of the present invention. When a representative is analyzing or discussing a customer's portfolio, it is highly desirable for the representative to have ready access to information regarding all of the customer's accounts. It is also highly desirable to be able to combine certain accounts “on the fly”, such as several business accounts or all family accounts including 401K accounts. This may allow the representative to provide an overall or macro view of the customer's portfolio. To accomplish this, and in accordance with one illustrative embodiment of the present invention, the representative is allowed to create a data structure that has one or more associated links. The data structure, when created, can be thought of as a “household” account, although it does not have to be associated with a customer's “household”, nor does it preferably contain any actual account data. Instead, the “household” account can be arbitrarily defined, and may only includes a number of links that identify or point to other accounts within the system.
• Several such household accounts are shown at90a,90b, and90c.Household account90aincludes links toaccounts92a,92band92c. Likewise,household account90bincludes links toaccounts92cand92e. As indicated above, the links are preferably defined by the representative. Once defined and selected, the present invention may display the account items that are within the accounts identified by the one or more links of the selected household account data structure. The household accounts may be saved for later reference and use.
• It is contemplated that the “household” accounts may link, point to, or pull in data from other databases, such asdatabases30band30c(seeFIG. 2). For example,database30cmay include account or other information from a remote brokerage house, bank or the like. In this example, the “household” account may link, point to, or pull in account information fromdatabase30c. This illustrates that the “household” accounts may include references to both local and remote databases, if desired.
• To provide a degree of hierarchy, a household account may include a link to one or more other household accounts. Such a data structure is shown at94, and may be referred to as a household-of-households account. When a household-of-households account is selected, the present invention preferably displays the account items within the accounts directly identified by the one or more links of the household-of-households account, as well as the account items within the one or more accounts identified by the links in the identified sub-household account or accounts. For example, when household-of-households account94 is selected, the present invention preferably displays the account items withinaccounts92a,92b,92cwhich are identified by the links ofhousehold account90a, account items withinaccounts92cand92ewhich are identified by the links ofhousehold account90b, as well asaccount92fwhich is directly identified by a link of household-of-household account94.
• Multiple levels of household-of-household accounts may be created, providing maximum flexibility to the representative. An advantage of using a data structure that only includes links rather than actual account data is that the displayed account items are collected from the actual accounts at the time of display, and are therefore up-to-date. For this reason, the household (and household-of-household) accounts may be referred to as dynamic link accounts.
• To simplify the display of account items, related account items from the various accounts identified by a household account may be combined before the data items are displayed. An example account item that may be combined is a stock position in a particular company. To do this, the account items that are related are first identified. Then, the related account items are combined by, for example, summing the stock positions for the particular company, and outputting a single collective account item for display. In this example, an average or effective purchase price for the stock may be computed and also displayed. By combining related account items, the number of account items that are displayed may be reduced. In addition, the representative may more clearly see the particular emphasis of the customer's portfolio. Various reports may also be run on the individual accounts or household (or household-of-household) accounts, as desired.
• FIG. 5 is a screen shot of an illustrative initial window that may be displayed in accordance with the present invention. The initial window includes anaccount administration section100, aportfolio administration section102, atrading report section104, asecurity administration section106, an Investigo functions section108, and acompliance ledger section112. Theaccount administration section100 allows a representative to create a new account, including a new household account, add an account type or edit an account type. Theaccount administration section100 is used by the representative to manage his or her customer accounts within the system.
• Theportfolio administration section102 allows a representative to add an industry group, edit an industry group, delete an industry group, enter daily performance data, or enter a speed ticket entry. The trading reportssection104 allows the representative to generate trade reports for selected representatives and for selected periods of time, as further described below. Thesecurity administration section106 allows a representative to add a new security, enter a stock-split, edit an existing security, manage mutual fund reinvestment, or delete an existing security. The Investigo functions section108 provides a number of functions for the representative user. These functions include a merge function, a download report viewer function, a download Adobe Acrobat Reader™ function, and a price security file function. The merge function is discussed further below.
• Theuser administration section110 allows a representative to add a new user, edit an existing user, or delete an existing user. Typically, only higher level users have the rights to perform these functions. Thecompliance ledger section112 allows a representative to generate a number of reports, each covering a specified period of time. In this illustrative embodiment, these reports include a deposits report, a new accounts report, a trade report, a stock powers report, and a daily tickets report. The deposits report displays all deposits made by customers to the broker dealer firm during a specified period of time. The new accounts report displays all new accounts that were created during the specified period of time. The trades report identifies all trades made by the broker dealer firm during the specified period of time. The stock powers report identifies all stock power that were created during the specified period of time. Finally, the daily tickets report identifies all daily tickets generated by the broker dealer firm during the specified period of time. Some or all of these reports can be limited to only display activities that are related to a particular representative or group of representatives. These reports are useful in monitoring the activities of the firm, and can provide valuable documentation in the event of a compliance audit.
• The illustrative initial window ofFIG. 5 also includes asymbol dialog box114. When a representative enters a symbol for a particular equity or fund into thesymbol dialog box114, and hits return, information about that particular equity is displayed as shown inFIG. 13. The illustrative initial window also includes asearch dialog box116. Thesearch dialog box116 allows the representative to enter a string. In the illustrative embodiment, the system compares the string against the account data within thedatabase30a(seeFIG. 2). All accounts having a customer name that at least partially matches the string is displayed in another window, as shown and further described below with respect toFIG. 16. Finally, the illustrative initial window ofFIG. 5 has arepresentative selection window118 for selecting a particular representative or user of the system. By selecting a particular representative, the data displayed by the various functions described above only includes data associated with the selected representative and his or her customers.
• FIG. 6 is a screen shot of an illustrative window that may be displayed when the “Most active” button (for all Reps) is selected in theTrading Reports Section104 ofFIG. 5. This window shows the ten most active accounts for all representatives using the system for the month ending Jan. 31, 2000. In the illustrative embodiment, “Most active” means the greatest number of trades. However, it is contemplated that “Most active” could mean the greatest number of shares or greatest value of shares traded or any other definition as desired. This window allows a broker dealer to identify the most active customers of the firm, which often translates into the most derived commissions. A savvy firm may provide preferential treatment to these customers.
• FIG. 7 is a screen shot of an illustrative window that may be displayed when the “Most active” button (for Rep 3BR) is selected in theTrading Reports Section104 ofFIG. 5. This window shows the ten most active accounts for representative “3BR” for the month ending Jan. 31, 2000. This window allows a representative to identify his or her most active customers, which as indicated above, often translates into the most derived commissions.
• FIG. 8 is a screen shot of an illustrative window that may be displayed when the “Deposits” button under the Compliance Ledgers section ofFIG. 5 is selected. This window shows the check deposit ledger for all representatives for the month ending Oct. 31, 2000. The illustrative check deposit ledger shows a date that each check was received, the account number where each check was deposited, the account name where each check was deposited, the amount of each check, the date of deposit, the payee of each check, and the representative. Such a check ledger is a mandatory requirement by, for example the NASD, and may be useful in the event of a compliance audit.
• FIG. 9 is a screen shot of an illustrative window that may be displayed when the “Trades” button under the Compliance Ledgers section ofFIG. 5 is selected. This window shows an illustrative trade buy blotter for all representatives of the broker dealer firm for dates extending between Oct. 1, 2000 to Oct. 31, 2000. The illustrative trade buy blotter shows the trade date, the settle date, whether the trade was a buy or sell, the account number corresponding to each trade, the particular product or security that was traded, the number of shares traded, whether the trade was solicited or unsolicited by the representative, the buy price per share, the total buy cost, and the buy commission. Each buy entry shown inFIG. 9 is generated by the system when a representative executes a buy trade using the pull down menu shown inFIG. 20.
• FIG. 10 is an illustrative screen shot that is displayed when the “Daily Tickets” button under the Compliance Ledgers section ofFIG. 5 is selected. This window shows illustrative daily trade tickets for all representative for the period extending between Oct. 1, 2000 and Oct. 31, 2000. The illustrative daily trade tickets report shows the trade date, the settle date, whether the trade was a buy or sell, the account number corresponding to each trade, the particular product or investment traded, the number of shares traded, whether the trade was solicited or unsolicited by the representative, the type of trade, the desired price, the report price, and the representatives for each trade.
• FIG. 11 is a screen shot of an illustrative window that may be displayed when the “Mail Merge” hyperlink under the Investigo Functions section ofFIG. 5 is selected. The “Mail Merge” function can be used to improve the efficiency of a representative in identifying and contacting various customers. The illustrative “Mail Merge” function begins with a search or query function. The search or query function can be used to identifying customers that have desired characteristics.
• As indicated above, the account data file34 ofFIG. 2 may include one or more accounts for each customer. Each account may have a number of fields including, for example, the customer's name, the customer's address, the customer's birthday, the customer's current holdings, the number of shares owned, the purchase price of each stock, the current price of each stock, the customer's net worth, hobbies and interests of the customer, etc. The representative may use the search or query function to identify those customers that have one or more fields that match a desired query value or expression. For example, the representative may wish to identify all customers that have a birthday in March. Alternatively, the representative may wish to identify all customers that hold a particular stock, have a net worth greater than $500,000 and are interested in Golf. By entering an appropriate value or expression into the system, such as through the appropriate menu shown inFIG. 11, the desired customers can be identified.
• The illustrative window shown inFIG. 11 includes four basic sections. The first section, called theaccount registration section150, allows a representative to select a particular representative, the account type desired, the report frequency, and the state of residence of the customer. The second section, called theinvestment objective section152, allows a representative to select customers by various investment objectives. The next section, called apersonal interest section154, allows a representative to select customers that have a particular hobby or interest. Finally, the last section, called theholdings section156, allows the representative to select customers by the type of holdings that they currently own.
• Once the various menu options are selected, the createmail merge button158 may be selected. In the illustrative embodiment, the createmail merge button158 causes the system to assembly a query and search thedatabase30ato identify those customers that match the query. The system preferably provides an output that includes, for example, the identified customers' names and addresses. The output is preferably formatted as a merge document that can be read by an application program that has a merge capability (e.g. Microsoft Word™). The merge capability can be used to insert the outputted fields into another document such as a letter or a promotional item, which can then be easily sent to the identified customers. The formatted output can also be formatted for a spreadsheet program, or to print on printed labels or envelopes, as desired. Other formats are also contemplated including, for example, formats that are compatible with e-mail systems or personal digital assistants (PDAs). The mail merge function allows the representatives to provide increased customer service with little extra effort.
• FIG. 12 is a screen shot showing an illustrative output when the “Create Mail Merge”button158 ofFIG. 11 is selected. In the illustrative embodiment shown, the output is formatted to print on printed labels. The names and addresses of the customers identified by the query ofFIG. 11 are formatted so that each name/address prints on a separate label of a conventional label sheet. It is contemplated that the page shown can be printed directly from within the browser program shown, and/or a file can be provided to the representative's local computer system, which can then be printed on a local printer.
• FIG. 13 is a screen shot showing an illustrative window that is displayed when the term
• “CSCO” is entered into the Symbol dialog box ofFIG. 5. When the string “CSCO” is entered, the system preferably searches through thedatabase30aand identifies all equity symbols that match. Only one symbol matches the string “CSCO” in the illustrative embodiment, which corresponds to Cisco Systems Inc. The symbol, the description of the symbol, the system price, the market price and the representative are all shown in the illustrative window. The system price, shown at162, may be a real time price or an end of day price, as desired. If a real time price is desired, a real time stock price feed must be provided to the system. Rather than accepting the system price162, the representative may provide another price, such as a current market price, into thedialog box160. This price will override the system price162 when thego button164 is selected.
• FIG. 14 is a screen shot showing an illustrative window that may be displayed when the “Go”button164 ofFIG. 13 is selected. This window shows all accounts for the representative 3BR that have open positions for CSCO. The illustrative window shows an account number, the last name of the customer corresponding to each account, the symbol (in this case CSCO), the number of shares owned, the open date, the average price of the shares, a total cost for the shares, a profit/loss based on the system price162 of $16.17, and contact phone numbers.
• To go to a specific account, the representative merely clicks on the account number, which is a hyperlink to the corresponding account within thedatabase30a. To sell a specific position, the representative need only click on the number of shares, which is a hyperlink to that specific entry within the corresponding account. This window may be useful in identifying customers that may wish to sell their open position in Cisco Systems Inc. Amerge function180 may be used to generate printed labels or a merge file that can be used to easily contact the identified customers.
• FIG. 15 is a screen shot showing an illustrative window that may be displayed when the “Investigo Today” hyperlink onFIG. 5 is selected. This window provides each representative with a calendaring function that allows the representative to schedule appointments and generally keep track of current and future activities. The window also displays a listing of all of the customers of the representative that should be contacted in the current month. Some customers may wish to be contacted every month or every quarter, and the system may track when each customer should be contacted next. Also, the system preferably only show those customers yet to be contacted. That is, once a customer is contacted, the representative preferably records the contact using the contact history function shown and described below with respect toFIG. 17. The system may note the contact history entry, and remove the customer from the list of customers to be contacted. Amerge function200 may be coupled to this function so that the representative can easily contact each of the listed customers.
• The window shown inFIG. 15 may also display those customers that have a birthday in the current month. Both the name and birthday are displayed on the screen. Amerge function202 may be provided for easily contacting each of the customers that have a birthday in the current month.
• FIG. 16 is a screen shot showing an illustrative window that may be displayed when the string “client” is entered into the accountsearch dialog box204 ofFIG. 15. The system searches the primary name field of each account, and identifies those accounts that match at least in part the string “client”. In the illustrative embodiment, only those accounts that correspond to the representative 3BR are searched, and five accounts are identified. For each account, the account number, the representative, the primary name of the customer, the account type, and the telephone numbers are displayed. Household and household-of-household accounts are designated by thehouse icon210. The accountsearch dialog box204 ofFIG. 15 can thus be used by a representative to quickly find and access accounts within the system.
• To access a particular account, the representative simply clicks on the account.FIG. 17 is a screen shot showing an illustrative window that may be displayed when the account number “JDEMO”212 ofFIG. 16 is selected. This window provides an overview for the selected account. The window identifies the particular account at220, the customer's name and the type of account at222, the customer's address, phone number and email address at224, the holdings in the account at226, the customer's investment objectives at228, certain personal information regarding the customer at230, and recent contact history between the representative and the customer at232. The window shown inFIG. 17 also includes anadministrative section234 and anaction section236, which are further described below.
• The holdingsection226 identifies the quantity, symbol, date opened, unit price, net cost, market price, market value, and gain/loss for each holding in the account. Also displayed is the total equity for the selected account. Theinvestment objectives section228 is set by the representative, preferably after having discussions with the customer. The investment objectives of the customer are important to keep in mind. In fact, according to current NASD regulations, the investment objectives of each customers must be maintained, as decisions about future investments and investment strategies are evaluated in view of the customers investment objectives. As can be seen, the investment objectives of each customers are readily available and viewable by the representative when the customer's account information is displayed.
• The personal information shown at230 provides the representative with a high level snapshot of the customer and the customer's portfolio. Thecontact history section232 is used to record the various contacts or discussions between the representative and the customer. This can be important, particularly during a regulatory audit of the firm. The full contact history between the representative and the customer can be displayed by simply selecting the “View JDEMO's contact history” hyperlink. A new entry in the contact history can be created by simply clicking on theGo button250.
• Theadministrative section234 allows the representative to edit account information such as when the customer's address changes or when the customer's investment objectives change. Theadministrative section234 also allows the representative to edit an open transaction or to perform a number of tasks that are commonly encountered when dealing with customers, such as making a cash deposit, as further described below with respect toFIG. 23. Theaction section236 allows the representative to quickly generate various tables or graphs for the benefit of the customer, as further described below with respect toFIG. 18. Theaction section236 also allows the representative to perform trades for the displayed account.
• When a representative receives a call from a customer or wants to review a customer's account, the illustrative window ofFIG. 17 may provide ready access to the customer's investment objectives, recent customer contacts, and other information such as the customer's current holdings. The present invention contemplates displaying, on a single screen or window such as shown inFIG. 17, the investment objectives and previously recorded customer contacts. Alternatively, the investment objectives and previously recorded customer contacts may be displayed in multiple windows that are displayed simultaneously, such as through multiple browser windows. The present invention also contemplates displaying on the same screen or window, or multiple screens or windows simultaneously, selected account holdings, and a number of personal information fields. A report generator option interface, a securities trade option interface, and/or a deposit option interface may also be displayed on the same screen or window, as shown. In aggregate, these represent the primary information sources that a representative needs to efficiently service his or her customers and create significant customer satisfaction and loyalty.
• FIG. 18 is a screen shot showing the illustrative window ofFIG. 17 with thereport menu260 in theaction section236 expanded. Thereport menu260 displays a number of reports that can be generated for the selected account. In the example shown, an appraisal report, an appraisal graph, an asset allocation report, an asset allocation graph, a realized G/L report, and a performance report may all be generated using thereport menu260 in theaction section236.FIG. 19 is a screen shot of an illustrative window that may be displayed when the “Realized G/L” report is selected from thereport menu260 ofFIG. 18. The “Realized G/L” report shows the realized gains and losses during the period from Jan. 1, 2000 to Apr. 26, 2001 for the selected account. The only position that was sold during this period was “AWSHX”. The short-term and long-term profit and loss are calculated and displayed, as shown. This may be particularly useful when customers are preparing their tax returns.
• Referring back toFIG. 17, theaction section236 also includes atrade menu262 for performing trades in the selected account.FIG. 20 is a screen shot showing the window ofFIG. 17 with thetrade menu262 expanded. In the illustrative embodiment, the trade menu includes buy, cover, sell, sell short, and sell covered menu options.FIG. 21 is a screen shot of an illustrative window that may be displayed when “Buy” menu option is selected from thetrade menu262 ofFIG. 20.
• The window shown inFIG. 20 accepts a number of fields from the representative. In the example shown, the window accepts a trade type, a symbol or CUSIP, a solicitation status, the location of the shares, a trade date, an amount or number or of shares, a price, etc. Anotes section268 is also provided, which allows the representative to record any notes that are pertinent to the trade. Once the representative fills in the appropriate fields, the representative hits the confirm thistrade button270.
• FIG. 22 is a screen shot of an illustrative window that may be displayed when the “Confirm This Trade”button270 ofFIG. 21 is selected. This window summarizes the information provided by the representative inFIG. 21. The representative reviews the displayed information and executes the order by selecting the “Execute this Buy Order”button272. When the “Execute this Buy Order”button272 is selected, the trade is executed and an entry is made in the trade buy blotter ofFIG. 9.
• Referring back toFIG. 17, theadministration section234 allows the representative to perform a number of operations that are commonly encountered when dealing with a customer.FIG. 23 is a screen shot showing the window ofFIG. 17 with the “Make a”menu274 expanded. The “Make a”menu274 allows a representative to make, for example, a cash deposit, a withdrawal, a stock deposit, or a reinvestment of dividends.
• FIG. 24 is a screen shot of an illustrative window that may be displayed when the “Make a Stock Deposit” menu option ofFIG. 23 is selected. This window shows the account number, the date of entry, the number of shares, the symbol, the stock type and the certificate number of the stock to be deposited with the broker dealer. Once these fields are entered by the representative, the representative may select the “generate stock power”button280. The “generate stock power”button280 generates a stock power for the stock deposit, as shown inFIG. 25.
• In many small Broker Dealer firms, performing a stock deposit can be a time consuming and tedious task. During a typical stock deposit, the representative receives the stock from the customer, retrieves a copy of a stock power from paper files, completes the stock power, provides the customer with a receipt, and manually enters the received stock in the blotter of the firm. The present invention may substantially simplify this process. In the illustrative embodiment, the representative merely enters or creates a customer account in the system, enters a number of shares, a symbol, the stock type, and one or more stock certificate numbers as shown inFIG. 24. The system may then automatically generate a stock power that can be readily printed, as shown inFIG. 25. The system may also generate a receipt that can be readily printed, create an entry in the customers account, and enter the stock deposit in the firm blotter. This may significantly reduce the time required to process a stock deposit, and may reduce errors.
• Referring back toFIG. 17, all open trades for a particular equity symbol for the active account can be displayed by selecting the equity symbol inFIG. 17.FIG. 26 is a screen shot of an illustrative window that may be displayed when the “ANEFX” equity symbol ofFIG. 17 is selected.FIG. 26 shows three open trades in the account JDEMO for ANEFX (American-New Economy Fund). A trade ID number is assigned to each open trade, as shown. To edit a particular trade, the representative may click on the trade ID number. To sell a specific position, the representative may click on the share amount. To delete a trade, the representative may click on the trash can icon shown to the right. A link is also provided for editing the “ANEFX's” database entry, if desired.
• FIG. 27 is a screen shot of a window that is displayed when “View JDEMO's Contact History” hyperlink ofFIG. 17 is selected. As indicated above, it is often desirable for a representative to view the contact history between the representative and the customer.FIG. 27 shows an illustrative contact history for the account JDEMO. As can be seen, the representative sent the customer an appraisal on Feb. 2, 2001, met with the customer on Apr. 11, 2001, and called the customer on Apr. 26, 2001. Each of these records was entered by the representative usingGo button250 ofFIG. 17.
• FIG. 28 is a screen shot of an illustrative window that may be displayed when the “Tell Me about” hyperlink ofFIG. 17 is selected. The window ofFIG. 28 is used to provide the representative with more detailed information about the customer of the selected account. The illustrative window includes acontact history section300, a hobbies andinterest section302, apersonal information section304, a notes andrelevant information section306, and areferral productivity section308. The contact history section displays the contact history between the representative and the customer, much like that described above with respect toFIG. 27. The hobbies andinterest section302 allows the representative to record the hobbies and interests of the customer. Thepersonal information section304 allows the representative to record some personal information about the customer. The notes andrelevant information section306 allows the representative to record any notes or other relevant information regarding the customer or the customer's account. All of these may be useful in developing and maintaining strong customer service and loyalty.
• Thereferral productivity section308 is shown extending across the top of the illustrative window ofFIG. 28. For many representatives, customer referrals are a primary source of business. As such, tracking the productivity of customer referrals is a tool that can be used to increase a representative's business. In the illustrative embodiment, the productivity of customer referrals is computed by storing a customer referral source identifier for each referred customer. For example, Joseph Client was referred to the representative by Scott O. Fergusson, as shown at314A. A total number of customer referrals for each customer referral source is then computed, along with an average number of customer referrals across all customer referral sources. Referring specifically to thereferral productivity section308 ofFIG. 28, the total number of customer referrals referred to the representative by Joseph Customer is seven (7), and the average number of customer referrals across all customer referral sources is three (3), as generally shown at310. This information is shown both as a bar graph as well as printed data.
• Because some customer referrals generate more commission than others, the present invention also contemplates measuring the productivity of customer referrals by commissions received instead of just mere number of referrals. In this illustrative embodiment, a total dollar amount of commissions received by the representative from customers referred from each customer referral source is computed. Then, an average dollar amount is computed for all customer referral sources. Referring again to thereferral productivity section308 ofFIG. 28, the total dollar amount of commissions received by the representative from Joseph Customer is $2,439, and the average dollar amount of commissions received by the representative across all customer referral sources is $204, as generally shown at312. This information is again shown both as a bar graph as well as printed data. As can be seen, Joseph Customer has a much higher referral productivity than the average customer of the representative. This information may indicate to the representative that Joseph Customer is a particularly important customer.
• To help identify productive customers, a measure of the relative productivity of any given customer referral source can be determined by comparing the total dollar amount of commissions for a selected customer referral source against the average dollar amount received across all customer referral sources. Alternatively, or in addition, those customer referral sources that are, for example, in the top “n” percent of productivity may be identified and displayed. If desired, the system may output a merge output that includes the particularly productive customer referral sources. The representative may use the merge output to generate, for example, a thank your letter or an invitation to a special event for those customers.
• Having thus described the preferred embodiments of the present invention, those of skill in the art will readily appreciate that the teachings found herein may be applied to yet other embodiments within the scope of the claims hereto attached.

Claims (7)

1-47. (canceled)

48. A method, comprising:

a) identifying, by a computer, in a database of at least one financial institution at least one first account owned or managed by a first member of a family;

b) identifying, by a computer, in a database of the at least one financial institution at least one second account owned or managed by a second member of the family;

c) creating, by a computer, a household account having a data structure, wherein the data structure has at least one first dynamic association and at least one second dynamic association;

d) wherein the at least one first dynamic association associates the data structure with at least one first data item from the at least one first account owned or managed by the first member of the family;

e) wherein the at least one second dynamic association associates the data structure with at least one second data item from at least one second account owned or managed by a second member of a family;

f) populating data fields of the household account with corresponding data extracted:

(i) from the at least one first data item from the at least one first account owned or managed by the first member of the family, and

(ii) from the at least one second data item from the at least one second account owned or managed by the second member of the family; and

g) presenting, by the computer, the household account to a user.

49. The method ofclaim 48, the method further comprises a step of combining, by the computer, data extracted from related data items of the at least one first account and the at least one second account.

50. The method ofclaim 49, wherein the combining step includes summing the extracted related data.

51. The method ofclaim 48, wherein the at least one first data item from the at least one first account owned or managed by the first member of the family is associated with at least one third dynamic association with at least one third data item from the at least one third account owned or managed by the first member of the family.

52. The method ofclaim 48, wherein the at least one second data item from the at least one second account owned or managed by the second member of the family is associated with at least one fourth dynamic association with at least one fourth data item from the at least one fourth account owned or managed by the second member of the family.

53. The method ofclaim 48, wherein the method further comprises a step of verifying that the user is authorized to view data associated with at least one member of the family.

Images