Automatic modification of financial record parameters

• US 8,468,069 B2
• Filed: 01/27/2010
• Issued: 06/18/2013
• Est. Priority Date: 10/30/2009
• Status: Active Grant

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Stinson, Joseph Michael
• Primary Examiner(s): Zeender, Ryan
• Assistant Examiner(s): Mahone, Kristie A
• Application Number:
  US12/694,618
• Publication Number:
  US 20110106672A1
• Time in Patent Office: 1,238 Days
• Field of Search: 705/30
• US Class Current: 705/30
• CPC Class Codes: G06Q 40/02 Banking, e.g. interest calculation or account maintenance credit or loans G06Q40/03
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

Formatting of data entered and/or stored in a financial transaction record may be automatically corrected or modified to an expected or compatible format. The format in which data is to be stored may be defined by a financial institution processing the transaction and/or a customer affected by the transaction. Format rules may be defined and used to judge whether a transaction record parameter meets the required format. If so, the record parameter may be validated and saved. If, however, the parameter is not formatted according to the rule, the system may automatically revise the value stored in the parameter to satisfy the requirements. According to another aspect, if a transaction record has been modified, manual confirmation of the change may be requested.

Claims

1. A method comprising:

receiving, by a financial record processing system having at least one processor, data corresponding to a financial transaction submitted for processing;

generating, by the financial record processing system, an initial transaction record for the financial transaction;

receiving a transaction advice separately and at a different time from the data corresponding to the financial transaction, wherein the transaction advice includes information for a customer affected by the financial transaction;

determining, by the financial record processing system, whether the transaction advice corresponds to the initial transaction record;

in response to determining that the transaction advice corresponds to the initial transaction record;

generating, by the financial record processing system, a transaction case to include the initial transaction record and the transaction advice;

determining, by the financial record processing system, a customer associated with the financial transaction based on information included in the transaction case;

determining a first format based on the determined customer associated with the transaction case, wherein the first format includes a predefined number of characters;

determining, by the financial record processing system, whether a first parameter of the transaction case is formatted according to the first format;

in response to determining that the first parameter of the transaction case is not formatted according to the first format;

automatically modifying, by the financial record processing system, the first parameter to match the first format including the predefined number of characters;

request manual confirmation of the automatic modification of the first parameter; and

in response to not receiving manual confirmation of the automatic modification within a specified amount of time, requesting manual correction of the first parameter;

determining whether a customer-specific parameter is required based on the customer information included in the transaction case; and

in response to determining that a customer-specific parameter is required;

determining whether the customer-specific parameter has been entered in the transaction case; and

in response to determining that the customer-specific parameter has not been entered in the transaction case, prompting for the customer-specific parameter.

2. The method of claim 1, wherein determining that the first parameter is not formatted according to the first format includes determining that the first parameter includes a number of characters greater than the predefined number of characters;

and

wherein automatically modifying the first parameter to match the first format includes truncating the first parameter.

3. The method of claim 1, wherein determining that the first parameter is not formatted according to the first format includes determining that the first parameter includes a number of characters less than the predefined number of characters;

and

wherein automatically modifying the first parameter to match the first format includes adding one or more characters to the first parameter.

4. The method of claim 3, wherein the one or more characters include zeroes.

5. The method of claim 1, further comprising prompting for manual confirmation that the modification is correct upon automatically modifying the first parameter.

6. The method of claim 1, further comprising determining the first format based on a type of financial parameter of the first parameter.

7. The method of claim 1, wherein the first format is specified by the customer affected by the financial transaction.

8. An apparatus comprising:

a processor; and

memory operatively connected to the processor and storing computer readable instructions, that when executed, cause the apparatus to;

receive, at a financial institution, data corresponding to a financial transaction submitted for processing;

generate an initial transaction record for the financial transaction;

receive a transaction advice separately and at a different time from the data corresponding to the financial transaction, wherein the transaction advice includes information for a customer affected by the financial transaction;

determine, whether the transaction advice corresponds to the initial transaction record;

in response to determining that the transaction advice corresponds to the initial transaction record;

generate, a transaction case to include the initial transaction record and the transaction advice;

determine, a customer associated with the financial transaction based on information included in the transaction case;

determine a first format based on the determined customer associated with the transaction case, wherein the first format includes a predefined number of characters;

determine, whether a first parameter of the transaction cases is formatted according to the first format;

in response to determining that the first parameter of the transaction case is not formatted according to the first format;

automatically modify the first parameter to match the first format including the predefined number of characters;

request manual confirmation of the automatic modification of the first parameter; and

in response to no receipt of confirmation manual confirmation of the automatic modification within a specified amount of time, request manual correction of the first parameter;

determine whether a customer-specific parameter is required based on the customer information included in the transaction case; and

in response to determining that the customer-specific parameter is required;

determine whether the customer-specific parameter has been entered in the transaction case; and

in response to determining that the customer-specific parameter has not been entered in the transaction case, prompt for the customer-specific parameter.

9. The apparatus of claim 8, wherein determine that the first parameter is not formatted according to the first format includes determine that the first parameter includes a number of characters greater than the predefined number of characters;

and

automatically modify the first parameter to match the first format includes a truncation of the first parameter.

10. The apparatus of claim 8, wherein determine that the first parameter is not formatted according to the first format includes determine that the first parameter includes a number of characters less than the predefined number of characters;

and automatically modifying the first parameter to match the first format includes adding one or more characters to the first parameter.

11. The apparatus of claim 10, wherein the one or more characters include zeroes.

12. The apparatus of claim 8, wherein the computer readable instructions, when executed, further cause the apparatus to determine the first format based on a type of financial parameter of the first parameter.

13. One or more non-transitory computer readable media storing computer readable instructions that, when executed, cause an apparatus to:

receive, at a financial institution, data corresponding to a financial transaction submitted for processing;

generate an initial transaction record for the financial transaction;

receive a transaction advice separately and at a different time from the data corresponding to the financial transaction, wherein the transaction advice includes information for a customer affected by the financial transaction;

determine, whether the transaction advice corresponds to the initial transaction record;

in response to determining that the transaction advice corresponds to the initial transaction record;

generate, a transaction case to include the initial transaction record and the transaction advice;

determine, a customer associated with the financial transaction based on information included in the transaction case;

determine a first format based on the determined customer associated with the transaction case, wherein the first format includes a predefined number of characters;

determine, whether a first parameter of the transaction cases is formatted according to the first format;

in response to determining that the first parameter of the transaction case is not formatted according to the first format;

automatically modify the first parameter to match the first format including the predefined number of characters;

request manual confirmation of the automatic modification of the first parameter; and

in response to no receipt of confirmation manual confirmation of the automatic modification within a specified amount of time, request manual correction of the first parameter;

determine whether a customer-specific parameter is required based on the customer information included in the transaction case; and

in response to determining that the customer-specific parameter is required;

determine whether the customer-specific parameter has been entered in the transaction case; and

in response to determining that the customer-specific parameter has not been entered in the transaction case, prompt for the customer-specific parameter.

14. The one or more computer readable media of claim 13, wherein determine that the first parameter is not formatted according to the first format includes determine that the first parameter includes a number of characters greater than the predefined number of characters;

and

automatically modify the first parameter to match the first format includes a truncation of the first parameter.

15. The one or more computer readable media of claim 13, wherein determine that the first parameter is not formatted according to the first format includes determine that the first parameter includes a number of characters less than the predefined number of characters;

and

automatically modify the first parameter to match the first format includes adding one or more characters to the first parameter.

16. The one or more computer readable media of claim 15, wherein the one or more characters include zeroes.

17. The one or more computer readable media of claim 13, wherein the computer readable instructions, when executed, further cause the apparatus to determine the first format based on a type of financial parameter of the first parameter.