SYSTEM AND METHOD FOR PROCESSING A FINANCIAL ACCOUNT
According to some embodiments, an inventory report file may be received. The inventory report file may, for example, have records representing outstanding transactions associated with a wealth management record keeping system, and each record in the inventory report file may be associated with a transaction code. Information in a data dictionary may then be accessed, wherein the data dictionary maps transaction codes to accounting categories. A convertor tool may then automatically translate each transaction code in the inventory report file into an appropriate accounting category to facilitate reconciliation of a general ledger account balance.
1 . A system associated with wealth management record keeping, comprising:
a communication device to receive an inventory report file having records representing outstanding transactions associated with wealth management record keeping, wherein each record in the inventory report file is associated with a transaction code;
a computer processor for executing program instructions; and
a memory, coupled to the computer processor, for storing program instructions for execution by the computer processor to:
access information in a data dictionary, wherein the data dictionary maps transaction codes to accounting categories,
automatically translate, by a convertor tool, each transaction code in the inventory report file into an appropriate accounting category to facilitate reconciliation of a general ledger account balance, and
writing an indication of the appropriate account category to a storage device.
2 . The system of claim 1 , wherein the memory further stores program instructions executable by the computer processor to:
load bank files associated with cash transactions into the record keeping system,
load customer account adjustment transactions into the record keeping system,
match cash transactions with customer account adjustment transactions, and
store unmatched transactions as outstanding transactions in the inventory report file.
3 . The system of claim 1 , wherein said automatic translating is performed periodically, as a batch process, each business day.
4 . The system of claim 1 , wherein the converter tool is associated with a spreadsheet macro program that includes a vertical lookup command.
5 . The system of claim 1 , wherein the accounting categories include at least one of: (i) a premium transaction, (ii) a disbursement transaction, (iii) a fee transaction, (iv) an outstanding liability transaction, or (v) annuity information.
6 . The system of claim 1 , wherein the wealth management record keeping system is associated with at least one of: (i) wealth annuity management, (ii) a mutual fund, (iii) a 401k plan, (iv) a 403b plan, (v) a 529 plan, (vi) an individual retirement account, (vii) a profit sharing plan, or (viii) life insurance.
7 . The system of claim 1 , wherein the memory further stores program instructions executable by the computer processor to:
generate a detailed aging report of suspense related inventories.
8 . The system of claim 1 , further comprising
a reconciliation engine, coupled to the communication device, to output the inventory report file.
9 . The system of claim 1 , further comprising:
a bank file system coupled to the reconciliation engine; and
a wealth management system coupled to the reconciliation engine, wherein the reconciliation engine outputs the inventory report file based on information received from the bank file system and the weal management system.
10 . A computer-implemented method associated with a wealth management record keeping system, comprising:
receiving an inventory report file having records representing outstanding transactions associated with the wealth management record keeping system, wherein each record in the inventory report file is associated with a transaction code;
accessing information in a data dictionary, wherein the data dictionary maps transaction codes to accounting categories;
automatically translating, by a convertor tool, each transaction code in the inventory report file into an appropriate accounting category to facilitate reconciliation of a general ledger account balance; and
writing an indication of the appropriate account category to a storage device.
11 . The method of claim 10 , further comprising:
loading bank files associated with cash transactions into the record keeping system;
loading customer account adjustment transactions into the record keeping system;
matching cash transactions with customer account adjustment transactions; and
storing unmatched transactions as outstanding transactions in the inventory report file.
12 . The method of claim 10 , wherein said automatic translating is performed periodically, as a batch process, each business day.
13 . The method of claim 10 , wherein the converter tool is associated with a spreadsheet macro program that includes a vertical lookup command.
14 . The method of claim 10 , wherein the accounting categories include at least one of: (i) a premium transaction, (ii) a disbursement transaction, (iii) a fee transaction, (iv) an outstanding liability transaction, or (v) annuity information.
15 . The method of claim 10 , wherein the wealth management record keeping system is associated with at least one of: (i) wealth annuity management, (ii) a mutual fund, (iii) a 401k plan, (iv) a 403b plan, (v) a 529 plan, (vi) an individual retirement account, (vii) a profit sharing plan, or (viii) life insurance.
16 . The method of claim 10 , further comprising:
generating a detailed aging report of suspense related inventories.
17 . A non-transitory computer-readable medium storing instructions adapted to be executed by a computer processor to perform a method, said method comprising:
receiving an inventory report file having records representing outstanding transactions associated with the wealth management record keeping system, wherein each record in the inventory report file is associated with a transaction code;
accessing information in a data dictionary, wherein the data dictionary maps transaction codes to accounting categories;
automatically translating, by a convertor tool, each transaction code in the inventory report file into an appropriate accounting category to facilitate reconciliation of a general ledger account balance; and
writing an indication of the appropriate account category to a storage device.
18 . The medium of claim 17 , wherein the method further comprises:
loading bank files associated with cash transactions into the record keeping system;
loading customer account adjustment transactions into the record keeping system;
matching cash transactions with customer account adjustment transactions; and
storing unmatched transactions as outstanding transactions in the inventory report file.
19 . The medium of claim 17 , wherein said automatic translating is performed periodically, as a batch process, each business day.
20 . The medium of claim 17 , wherein the converter tool is associated with a spreadsheet macro program that includes a vertical lookup command.
21 . The medium of claim 17 , wherein the accounting categories include at least one of: (i) a premium transaction, (ii) a disbursement transaction, (iii) a fee transaction, (iv) an outstanding liability transaction, or (v) annuity information.
22 . The medium of claim 17 , wherein the wealth management record keeping system is associated with at least one of: (i) wealth annuity management, (ii) a mutual fund, (iii) a 401k plan, (iv) a 403b plan, (v) a 529 plan, (vi) an individual retirement account, (vii) a profit sharing plan, or (viii) life insurance.
23 . The medium of claim 17 , wherein the method further comprises:
generating a detailed aging report of suspense related inventories.