FINANCIAL MANAGEMENT SYSTEM AND METHOD
A system and method of performing financial management tracking comprising entering, on a mobile control device, data associated with a financial transaction; storing said entered financial transaction data in a database within said mobile control device; periodically synchronizing said mobile control device database with a base station database via a communications link such that budgetary and financial transaction data is update. In one embodiment of the invention, each member of a household utilizes a separate mobile control device, each of the mobile control devices is synchronized with the base device such that all mobile control devices are synchronized with each other.
This application is a continuation of pending U.S. patent application Ser. No. 09/811,911, filed Mar. 19, 2001, and entitled FINANCIAL MANAGEMENT SYSTEM AND METHOD, which application is incorporated herein by reference.
BACKGROUND OF THE INVENTION1. Field of the Invention
The present invention generally relates to the field of database management and, more particularly, to a system and method for tracking and updating financial transaction data.
2. Description of the Related Art
Most consumers utilize negotiable instruments such as personal checks to pay for desired goods and/or services. A book of checks (i.e., a check book) typically provides a bound group of sequentially related checks and a register for recording check number, payee, date and amount information relating to utilized checks. While useful in tracking available funds, the check book register provides no information relating to budget goals, application of checks towards particular budget items and similar financial management goals. Similarly, credit cards, debit cards and cash outlays provide no feedback to the user regarding budgetary and other financial management constraint other than “over limit” messages at a retail point-of-sale (POS) terminal, if applicable.
Financial management is regarded as a necessary task to be performed by each household. Unfortunately, since there are many ways to expend financial resources (as noted above), and many necessary expenses coming due at different times of the year (e.g., insurance, property tax and the like) as well as periodically occurring expenses having variable billing amounts (e.g., water, natural gas, communications and the like), coherent financial management strategies are often not practicable. Therefore, it is seen to be desirable to provide a system and method simplifying at least the data manipulation aspects of implementing appropriate financial management tasks.
SUMMARY OF THE INVENTIONThese and other limitations associated with the prior art are overcome by the present invention of a financial management system and method providing integrated financial management and budgeting functions across one or more mobile control devices periodically synchronized with a base device.
A system and method of performing financial management tracking comprising entering, on a mobile control device, data associated with a financial transaction; storing said entered financial transaction data in a database within said mobile control device; periodically synchronizing said mobile control device database with a base station database via a communications link such that budgetary and financial transaction data is update. In one embodiment of the invention, each member of a household utilizes a separate mobile control device, each of the mobile control devices is synchronized with the base device such that all mobile control devices are synchronized with each other.
So that the manner in which the above recited features, advantages and objects of the present invention are attained and can be understood in detail, a more particular description of the invention, briefly summarized above, may be had by reference to the embodiments thereof which are illustrated in the appended drawings. It is to be noted, however, that the appended drawings illustrate only typical embodiments of this invention and are therefore not to be considered limiting of its scope, for the invention may admit to other equally effective embodiments.
To facilitate understanding, identical reference numerals have been used, where possible, to designate identical elements that are common to the figures.
DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTThe present invention will be described within the context of one or more handheld devices comprising at least a control program and a transactions database which are used contemporaneously with a financial transaction to enter parameters associated with that financial transaction to store parameters associated with that financial transaction in the transactions database. It will be appreciated by those skilled in the art that the mobile control device may be implemented using a personal digital system (PDA) or any other handheld computational device capable of being adapted to a data entry and data synchronization function.
A system according to the invention may be implemented using a base device and a plurality of mobile control devices. The system may also be implemented using a plurality of mobile control devices where one of the mobile control devices operates as a master while the other mobile control devices operate as slaves to the master mobile control device. In either case, since the account information is quite sensitive, it is desirable to keep that information in as few mobile control devices as possible such that in the event of a mobile control device being lost or stolen the risk to the account holders is reduced.
The CPU 210 is preferably linked to each of the listed elements, either directly or indirectly, by means of a shared data bus, or dedicated connections, as shown in
The display driver 217 cooperates with a display device 250, such as a liquid crystal display (LCD) display device, computer monitor, television or other display device.
The input device 219 comprises, illustratively, a keyboard, pointing device, voice recognition device, or on-screen data receiving device suitable for receiving input from a user. The input device 219 cooperates with the CPU 210. In a preferred embodiment of the invention, the input device 219 and display device 250 are integrated using a touch screen device operable via a stylus.
The data storage device 220 typically includes one or more machine readable media; such media includes, as is well known in the art, magnetic, semiconductor and/or optical media. Data storage device 220 is preferably capable of supporting the searching and storing of data. Preferably, data storage device 220 comprises a low cost, low energy consumption semiconductor device.
The data storage device 220 preferably includes a control program 112, a transactions database 114, an account database 116 and a budgetary database 118. The control program 112 stores a plurality of instructions which, when retrieved and executed by the CPU 210, cause the control device 110/120 to operate as a special purpose device implementing the system and method of the present invention. The transactions database 114 preferably includes transaction specific data pertaining to transactions input to the control device by a user (e.g., via the input device 219) or from another control device during a synchronization operation. The transactions database 114 will be discussed in more detail below with respect to
Referring to
The transactions database 300 stores data relating to individual transactions recorded using a control device such as the mobile control device 110 or base control device 120 depicted above in
Field 310 is a transaction number field, used to store an identification number corresponding to the transaction number within a sequence of transactions. Field 320 is a date field indicating the date of the transaction. Field 330 is an account number field, indicating the account against which the transaction is debited or credited. In the case of a cash transaction, a null or zero account number is entered. Field 340 is an amount field indicating the amount of the transaction. Field 350 is a budget item identifier field, indicating the budgetary item (which will be described later with respect to
Referring to
The transaction database 114 within a mobile control device 110, and the transactions database 124 within a base control device 120 are formed substantially in accordance with the transactions database 300 of
The accounts database 400 stores data relating to accounts that are maintained for the transacting entities within the system. Each record (or row) of the accounts database 400 is maintained for each account available to the transacting entities. By way of example, three account records (R1 through R3) are shown in
Field 410 is an account number field, used to store an account number. Field 420 is a type field, used to store data indicative of the type of account associated with the particular record. Account types may comprise, for example, checking accounts, savings accounts, credit card accounts, money market accounts, retirement accounts and other accounts known to those skilled in the art.
Field 430 is an institution identifier field, used for storing at least the name of the institution (e.g., banking or other financial services institution) responsible for serving the identified account. Field 440 is an available balance field, used to indicate a balance of a checking or savings account, an amount of credit available in a credit card account, and similar data related to other account types. Field 450 is a last updated field, used to store the date and, optionally, time of when the account information was last updated. Account information is updated by synchronizing the various control devices such that account usage is properly metered and available balances are adjusted in accordance with the recorded transactions. Field 460 is an access limit field used to store the identification of those to whom account access is granted.
Field 470 is a reported balance field, used to store the last actual balance associated with the account identified in field 410. This balance is reported by the institution identified in field 430. Field 480 is a report data field, used to store the date and, optionally, the time when the last reported balance was provided.
By way of example, the first record R1 identifies account number 01234 as a checking account with first bank having an available balance of $1. Data associated with this record was last updated on Jan. 1, 2001. The transacting entities entitled to access this account are MOTHER and FATHER. The last reported balance from the institution for this account was $1, and the reporting date was Dec. 21, 2000.
Field 510 is an identifier field, used to store an identifier associated with the budgetary item corresponding to the particular record. In
Field 520 is an annual budget field, used to store a dollar (or other currency) amount indicative of the expected or allocated annual budget associated with the budgetary item identified in field 510. Field 530 is a periodic budget field, used to store a dollar amount to be paid periodically in support of the budgeted item. Field 540 is a fixed/variable field, used to indicate whether the identified budgetary item is a fixed or variable cost item. It will be appreciated that some budgetary items, such as property taxes, are adjusted annually though fixed costs otherwise. Field 550 is a periodicity field, used to indicate the time period between payments associated with the identified budgetary item. For example, the first record R1 indicates a mortgage of $24,000 per year is paid on a monthly basis at a budgeted rate of $2,000.
The method is entered at step 605 where the control device waits for input. Upon receiving an input via, for example, an input device such as a keyboard or, preferably, a stylus contacting a touch screen, the method proceeds to step 610.
At step 610, a query is made as to the appropriate mode for the control device to enter. If the input is indicative of a data entry, then the method 600 proceeds to step 640. If the input is indicative of a synchronization operation, then the method 600 proceeds to step 615.
In the case of a synchronization operation, at step 615 a communication link is established between the control device within which the method is operating and another control device. It is noted that the other control device may also be operating according to the method 600 of
At step 620, new remote data is retrieved via the communications link. That is, at step 620, data within the other control device that was entered into the other control device after the last synchronization operation is retrieved. At step 625, new local data is transmitted to the other control device via the communications link. That is, at step 625, data within the local control device that was entered or generated after the last synchronization operation is uploaded to or transmitted to the other control device.
At step 630, the databases of the local control device are updated with the new remote data retrieved at step 620. While not shown, the other control device or devices synchronize with the local control device to update their databases in response to the new local data transmitted at step 625.
Optionally, at step 635, the local control program 112 within the control device executing the method 600 is updated or otherwise modified based upon control program data retrieved along with new remote data at step 620. The method 600 then proceeds to step 605 to wait for the next user input.
In the case of a data entry operation, at step 640, transaction data from the input device is accepted. At step 645, the new transaction data accepted at step 640 is stored in the transaction database 114 of the control device 110/120.
At step 650, the transaction data is evaluated with respect to the budget data stored within the budgetary database 116. For example, in the case of new transaction data indicative of spending beyond a budgetary limit, spending on non-approved items, spending against non-authorized accounts and the like, one or more user messages may be generated. At step 655, the messages based upon evaluation at step 650 are displayed on the display device. For example, in the case of an unauthorized expenditure, a message indicating that such expenditure is not authorized may be displayed. This message may be overridden by the user and the expense made anyway.
At step 660, a query is made as to the type of control device performing the method 600 of
At optional step 670, the budgetary database stored within the control device operating the method 600 is adjusted as needed. For example, in the case of an evaluation at step 650 indicating an overspending condition for a particular budgetary item, the budgetary data associated with that item may be adjusted at step 670 to better reflect the spending requirements associated with that budgetary item. Other budgetary adjustments may be made including the addition or deletion of categories or items, and, generally, modifications to any of the items discussed above with respect to the budgetary database 500 of
In one embodiment of the invention, each of the mobile devices 110 comprises a personal digital assistant (PDA) operating using, illustratively, the PALM, Windows CE or other operating system. It is noted that PALM is a trademark of Palm Incorporated of Santa Clara, Calif. and that Windows CE is a trademark of Microsoft Corporation of Redmond, Wash. Each of the mobile devices includes a transactions database 114 that is updated in response to respective data entry manipulations. In addition, each mobile device includes a budgetary database 116 that stores information useful in determining whether transaction information is within budgetary guidelines. The base device 120 comprises a computer system such as a personal computer having associated with it a docking station which mechanically and electrically receives mobile devices 110 and facilitates the data interchange and database updating operations described above. Optionally, one or more of the mobile devices 110 may comprise an accounts database.
In an alternate embodiment of the invention, a first PDA operates as a master control device, while at least one other PDA operates as a slave control device. The PDA operating as a master control device includes a control program 112, a transactions database 114, a budgetary database 116 and an accounts database 118. The slave device(s) do not include an accounts database.
In one embodiment, the slave devices also do not include a budgetary database. In this embodiment, the slave devices only serve to receive transaction data, which transaction data is then processed by the master control device to evaluate whether transactions entered on the slave device are appropriate to the budgetary constraints defined by the budgetary database 500.
In one embodiment, a computing device according to the invention includes a printing means capable of printing a negotiable instrument such as a personal check. Upon a user entering transaction data associated with a presently contemplated transaction, in the case of a comparison of the transaction data to the budgetary data where an over budget or other indication of exceeding a budgetary constraint is determined, the negotiable instrument printing function is inhibited. This inhibited function may optionally be overridden by the user.
While the foregoing is directed primarily to the preferred embodiment of the present invention, other and further embodiments of the invention may be devised without departing from the basic scope thereof, and the scope thereof is determined by the claims that follow.
Claims
1. A method for managing financial transactions of a transacting entity having a computing device associated therewith, comprising:
- receiving transaction information associated with a financial transaction for the transacting entity;
- evaluating the transaction information for determining whether the financial transaction is appropriate with respect to at least one constraint defined by at least one of budgetary information and account information associated with the transacting entity; and
- propagating transaction evaluation result information toward the computing device, the transaction evaluation result information adapted for providing an indication to the transacting entity as to whether the financial transaction is appropriate.
2. The method of claim 1, wherein the budgetary information is stored in a budgetary database.
3. The method of claim 2, wherein the budgetary database comprises a plurality of records, each record comprising at least a budgetary item identifier field, an annual budget field, and a periodic budget field.
4. The method of claim 3, wherein, when the transaction information is evaluated using the budgetary information, evaluating the transaction information comprises:
- correlating a transaction type associated with the financial transaction to a budgetary item identifier field of one of the records of the budgetary database; and
- determining, using the one of the records of the budgetary database, whether the financial transaction exceeds at least one of an annual budget and a periodic budget for the transaction type.
5. The method of claim 1, wherein the account information is stored in an accounts database.
6. The method of claim 5, wherein the accounts database comprises a plurality of records, each record comprising at least an account number field, an account type field, an institution field and an available balance field, the account number field identifying a credit or debit account, the account type field identifying the type of account, the institution field identifying the financial institution associated with the account, and the available balance field identifying an available balance or credit limit associated with the account.
7. The method of claim 6, wherein, when the transaction information is evaluated using the account information, evaluating the transaction information comprises:
- correlating a financial transaction type associated with the financial transaction to at least one of the fields of one of the records of the accounts database; and
- determining, using the one of the records of the accounts database, whether the financial transaction exceeds an available balance from the available balance field of the one of the records of the accounts database.
8. The method of claim 1, further comprising:
- updating at least one of the budgetary information and the account information in response to a determination that evaluation of the transaction information indicates that the financial transaction is appropriate.
9. The method of claim 1, wherein the transaction information is received from the computing device of the transacting entity via a communication network.
10. The method of claim 1, wherein the computing device comprises a processor, a memory, an input device, and a display device.
11. The method of claim 10, wherein the memory stores a transactions database including data relating to financial transactions initiated via the computing device.
12. The method of claim 11, wherein the transactions database comprises a plurality of records, each record comprising at least an account number field, a transaction amount field, and a budgetary item identifier field, the account number field identifying a credit or debit account funding a respective transaction, the transaction amount field identifying the value of the respective transaction, the budgetary item identifier field identifying the type of the respective transaction.
13. The method of claim 11, wherein the transactions database is updated in response to user interaction via the input device.
14. A method for managing financial transactions of a transacting entity at a portable computing device, comprising:
- receiving, via an input device of the portable computing device, transaction information associated with a financial transaction for the transacting entity;
- propagating the financial transaction information toward a serving device adapted for evaluating the transaction information for determining whether the financial transaction is appropriate with respect to at least one constraint defined by at least one of budgetary information and account information associated with the transacting entity;
- receiving transaction evaluation result information indicative as to whether the financial transaction is appropriate; and
- displaying, via a display device of the portable computing device, an indication as to whether the financial transaction is appropriate.
15. The method of claim 14, further comprising:
- storing the transaction information in a memory of the computing device.
16. The method of claim 14, further comprising:
- propagating, toward the serving device, an indication as to whether financial transaction is completed by the transacting entity, wherein the indication as to whether financial transaction is completed by the transacting entity is adapted for use by the serving device to update at least one of the budgetary information and the account information based on the financial transaction.
17. The method of claim 14, further comprising:
- authorizing the financial transaction in response to an indication that the financial transaction is appropriate.
18. A system for managing financial information, comprising:
- a serving device, the serving device adapted for receiving transaction information associated with a financial transaction initiated by a transacting entity, evaluating the transaction information for determining whether the financial transaction is appropriate with respect to at least one constraint defined by at least one of budgetary information and account information associated with the transacting entity, and propagating transaction evaluation result information providing an indication as to whether the financial transaction is appropriate; and
- at least one portable computing device, each of the at least one portable computing device comprising a processor, a memory, an input device, and a display device, each of the at least one portable computing device adapted for receiving transaction information via the input device and propagating the transaction information toward the serving device for evaluation of financial transactions, each of the at least one portable computing device adapted for receiving financial transaction evaluation results from the serving device and displaying the financial transaction evaluation results via the display device.
19. The system of claim 18, wherein the serving device comprises at least one of a budgetary database storing budgetary information and an accounts database storing account information, wherein each of the at least one portable computing device comprises a transactions database storing financial transaction information.
20. The system of claim 18, wherein the serving device is a portable computing device, wherein the serving device operates as a master device and each of the at least one portable computing device operates as a slave device.
Type: Application
Filed: Jan 13, 2009
Publication Date: May 14, 2009
Inventor: Rebecca Anne Ansley (Westerville, OH)
Application Number: 12/352,845
International Classification: G06Q 10/00 (20060101); G06F 17/30 (20060101); G06F 17/40 (20060101);