System and method for revenue and expense realignment

• US 7,654,445 B2
• Filed: 12/14/2005
• Issued: 02/02/2010
• Est. Priority Date: 12/14/2005
• Status: Active Grant

• Current Assignee: Bonaire Software Solutions LLC (Broadridge Financial Solutions Incorporated)
• Original Assignee: Bonaire Software Solutions LLC (Broadridge Financial Solutions Incorporated)
• Inventors: John, Christopher Michael, Gallardo, Kleber Santiago
• Primary Examiner(s): RUDY, ANDREW J
• Application Number:
  US11/300,028
• Publication Number:
  US 20070150384A1
• Time in Patent Office: 1,511 Days
• Field of Search: 705/28, 705/30, 235/375, 707/10, 707/100, 707/102, 707/104.1, 709/217
• US Class Current: 235/375
• CPC Class Codes: G06Q 20/10 specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
• CPC Class Codes: G06Q 40/00 Finance; Insurance; Tax strategies; Processing of corporate or income taxes
• CPC Class Codes: G06Q 40/12 Accounting

Abstract

A system and method for revenue and expense realignment is provided. A revenue and expense realignment application (RECAST) comprising of a rules engine executing on a computer receives revenue and/or expense transactions. At predetermined time intervals, the RECAST executes a series of steps, each of which has one or more user defined rules associated therewith to transform inbound transactions. The transformed transactions are then posted to other applications including, for example, a general ledger.

Claims

1. A system for revenue and expense realignment comprising:

a computer operatively interconnected with one or more transaction servers; and

a revenue and expense tracking system (RECAST) comprising;

a web accessible graphical user interface to allow a user to enter one or more rows of data mappings, the one or more rows of data mappings selected from a group consisting of;

a mapping type field, a fee type field, a received document type field, a received ledger field, a clearance ledger field, a revenue ledger field, and an accrual ledger field wherein the entered one or more rows of data mappings creating dynamically a set of user defined rules, and

wherein the computer operatively interconnected to the one or more servers, executes a rules engine to;

(i) receive a set of inbound transactions, the inbound transaction utilizing a first transaction format,

(ii) convert the set of inbound transactions into a uniform transaction format to enable realignment of any type of vendor format, the conversion occurring using the set of previously entered rows of data mappings,

(iii) perform the set of user defined rules based operations on the converted set of inbound transactions to generate a set of outbound transactions in the uniform transaction format,

(iv) convert the set of outbound transactions from the uniform transaction format into a plurality of different outbound transaction formats, and

(v) post the converted outbound transactions to one or more services.

2. The system of claim 1 wherein the RECAST further comprises an inbound interface module configured to convert a set of inbound transactions into a uniform transaction format.

3. The system of claim 1 wherein the RECAST further comprises an outbound interface module configured to convert a set of outbound transactions from a uniform transaction format into one or more outbound transaction formats.

4. The system of claim 1 wherein the RECAST further comprises a user interface module configured to provide a user interface to a client.

5. The system of claim 4 wherein the user interface is a graphical user interface and wherein the client accesses the graphical user interface using a web browser.

6. The system of claim 1 wherein the RECAST further comprises a statement builder that enables a user to construct the set of rules.

7. A system for revenue and expense realignment executed by a computer;

the system comprising;

means for entering, by a user on a web accessible graphical user interface, one or more rows of data mappings, the one or more rows of data mappings selected from a group consisting of;

a mapping type field, a fee type field, a received document type field;

a received ledger field, a clearance ledger field, a revenue ledger field, and an accrual ledger field wherein the entered one or more rows of data mappings creating dynamically a set of user defined rules;

means for receiving a set of inbound transactions by a computer within a network operatively interconnected to one or more servers, the inbound transaction utilizing a first transaction format;

means for converting the set of inbound transactions into a uniform transaction format to enable realignment of any type of vendor format, the conversion occurring using the set of previously entered rows of data mappings;

means for performing the set of user defined rules based operations on the converted set of inbound transactions to generate a set of outbound transactions in the uniform transaction format;

means for converting the set of outbound transactions from the uniform transaction format into a plurality of different outbound transaction formats; and

means for posting the converted outbound transactions to one or more services.

8. The system of claim 7 wherein the set of inbound transactions comprise revenue transactions.

9. The system of claim 7 wherein the set of inbound transactions comprise expense transactions.

10. The system of claim 7 wherein the means for converting the set of inbound transactions into a uniform transaction format comprises means for completing one or more fields of the uniform transaction format using a set of reference data.

11. The system of claim 7 wherein the means for converting the set of inbound transactions into a uniform transaction format is performed using a set of user defined mappings.