# US 2009/0271301 A1 · Multiple rate currency consolidator

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2009/0271301 A1
- Document ID: US20090271301A1
- Status: Published application
- Kind: A1
- Application number: 12/428,297
- Filed: 2009-04-22
- Published: 2009-10-29
- Earliest claimed: 2008-04-25
- Assignees: NetSuite Inc.
- Inventors: STEPHEN CLODE; GAURAV BAWA; DARREN LINSCOTT; WILLIAM ELLERY BAILEY
- Web page: https://patentgrep.com/patent/US20090271301A1

## CPC

- G06Q 20/381: {Currency conversion}
- G06Q 40/00: Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q 40/02: Banking, e.g. interest calculation or account maintenance (credit or loans G06Q40/03)
- G06Q 40/04: Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
- G06Q 40/06: Asset management; Financial planning or analysis
- G06Q 40/12: Accounting
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR

## Abstract

A multiple currency rate consolidator addresses the needs of multi-national companies that do business in different currencies and tax localities. A consolidated view of financial data may be provided in real time. The multiple currency rate consolidator allows each subsidiary within a subsidiary hierarchy to enter and manage transactional data as well as budget/forecast data in a corresponding localized functional currency. The multiple currency rate consolidator allows different consolidation levels to view localized, consolidated values of subsidiary transactions. The multiple currency rate consolidator also accommodates statutory, ad hoc and management reporting consolidation using different subsidiary configurations for the same time periods, as well as the versioning of the subsidiary hierarchy to accommodate structural changes across different time periods.

## Claims

### Claim 1

A computer-implemented method for consolidating multiple rate currencies associated with different corporate subsidiaries, the method being executed by a processor, the method comprising:
receiving a request for consolidated financial data, wherein the request is received at a user interface from a requesting subsidiary, the request indicating a perspective point of the requesting subsidiary relative to the other different corporate subsidiaries;
traversing a data structure representing a subsidiary hierarchy indicating a relationship between the different corporate subsidiaries, wherein each subsidiary in the subsidiary hierarchy comprises financial data in a functional currency, the requesting subsidiary being positioned higher in the subsidiary hierarchy than at least one other subsidiary;
in response to the request, accessing, from a data store, an exchange rate between at least two related subsidiaries in the subsidiary hierarchy, wherein at least one of the related subsidiaries is the requesting subsidiary and the remainder of the related subsidiaries is positioned below the requesting subsidiary in the subsidiary hierarchy;
converting the financial data of each subsidiary in the subsidiary hierarchy to the functional currency of a related subsidiary positioned higher in the subsidiary hierarchy based on the corresponding exchange rate; and
calculating the requested consolidated financial data based on the converted financial data for each subsidiary in the subsidiary hierarchy related to and positioned lower than the requesting subsidiary, wherein the consolidated financial data is calculated in the functional currency associated with the requesting subsidiary.

### Claim 2 (depends on 1)

The method of claim 1, wherein the subsidiary hierarchy is a tree-based data structure, each corporate subsidiary in the subsidiary hierarchy corresponding to a node in the tree-based data structure.

### Claim 3 (depends on 1)

The method of claim 1, further comprising:
receiving exchange rate data for converting a functional currency of one subsidiary in the subsidiary hierarchy to a different functional currency of any other subsidiary in the subsidiary hierarchy.

### Claim 4 (depends on 3)

The method of claim 3, wherein the exchange rate data comprises different rate categories between the same subsidiaries.

### Claim 5 (depends on 4)

The method of claim 4, wherein the different rate categories are associated with different accounting periods.

### Claim 6 (depends on 4)

The method of claim 4, wherein the different rate categories are associated with different account types.

### Claim 7 (depends on 3)

The method of claim 3, wherein the exchange rate data comprises two different sets of exchange rates for converting the same financial data between the same subsidiaries, a first set of exchange rates being variable and a second set of rates being static.

### Claim 8 (depends on 7)

The method of claim 7, further comprising:
verifying budget predictions using the second set of rates.

### Claim 9 (depends on 1)

The method of claim 1, further comprising:
receiving transaction data from at least one subsidiary in the subsidiary hierarchy.

### Claim 10 (depends on 1)

The method of claim 1, further comprising:
displaying the consolidated financial data to a user interface of the requesting subsidiary.

### Claim 11 (depends on 1)

The method of claim 1, wherein the subsidiary hierarchy identifies the functional currency of each subsidiary in the subsidiary hierarchy.

### Claim 12 (depends on 1)

The method of claim 1, further comprising:
modifying the subsidiary hierarchy in response to user input.

### Claim 13 (depends on 12)

The method of claim 12, further comprising:
storing the unmodified subsidiary hierarchy.

### Claim 14 (depends on 12)

The method of claim 12, wherein the modified subsidiary hierarchy and the unmodified subsidiary hierarchy correspond to different time periods.

### Claim 15

A system for consolidating multiple rate currencies associated with different corporate subsidiaries, the system comprising:
a manage consolidated rates module configured to:
traverse a data structure representing a subsidiary hierarchy indicating a relationship between the different corporate subsidiaries, wherein each subsidiary in the subsidiary hierarchy comprises financial data in a functional currency, a requesting subsidiary being positioned higher in the subsidiary hierarchy than at least one other subsidiary;
a consolidated rate lookup module configured to:
receive a request for consolidated financial data, wherein the request is received at a user interface from the requesting subsidiary, the request indicating a perspective point of the requesting subsidiary relative to the other different corporate subsidiaries, and
in response to the request, access an exchange rate between at least two related subsidiaries in the subsidiary hierarchy, wherein at least one of the related subsidiaries is the requesting subsidiary and the remainder of the related subsidiaries is positioned below the requesting subsidiary in the subsidiary hierarchy, the exchange rate being accessed from a consolidated rate store; and
a currency conversion module configured to:
convert the financial data of each subsidiary in the subsidiary hierarchy to the functional currency of a related subsidiary positioned higher in the subsidiary hierarchy based on the corresponding exchange rate, and
calculate the requested consolidated financial data based on the converted financial data for each subsidiary in the subsidiary hierarchy related to and positioned lower than the requesting subsidiary, wherein the consolidated financial data is calculated in the functional currency associated with the requesting subsidiary.

### Claim 16 (depends on 15)

The system of claim 15, wherein the subsidiary hierarchy is a tree-based data structure, each corporate subsidiary in the subsidiary hierarchy corresponding to a node in the tree-based data structure.

### Claim 17 (depends on 15)

The system of claim 15, further comprising:
a spot currency rate store configured to store exchange rate data for converting a functional currency of one subsidiary in the subsidiary hierarchy to a different functional currency of any other subsidiary in the subsidiary hierarchy.

### Claim 18 (depends on 17)

The system of claim 17, wherein the manage consolidated rates module is further configured to calculate a conversion rate between each pair of different subsidiaries in the subsidiary hierarchy using the exchange rate data and the functional currency associated with each subsidiary in the subsidiary hierarchy.

### Claim 19 (depends on 15)

The system of claim 15, further comprising:
a subsidiary metadata store configured to store the subsidiary hierarchy and to store information identifying the functional currency associated with each subsidiary in the subsidiary hierarchy.

### Claim 20 (depends on 15)

The system of claim 15, further comprising:
a subsidiary transaction detail store configured to store financial data received from each subsidiary in the subsidiary hierarchy.

### Claim 21 (depends on 15)

The system of claim 15, wherein the currency conversion module is further configured to display the consolidated financial data to the user interface of the requesting subsidiary.

### Claim 22 (depends on 15)

The system of claim 15, further comprising:
a manage subsidiaries module for modifying the subsidiary hierarchy in response to user input, wherein the manage subsidiaries module stores the unmodified version of the subsidiary hierarchy.

### Claim 23

A computer-implemented method comprising executable program code stored on a computer-readable medium that, when executed, is operable to consolidate multiple rate currencies associated with different corporate subsidiaries, the executable program code comprising:
code for receiving a request for consolidated financial data, wherein the request is received from a user of a requesting subsidiary, the request indicating a perspective point of the requesting subsidiary relative to the other different corporate subsidiaries;
code for traversing a data structure representing a subsidiary hierarchy indicating a relationship between the different corporate subsidiaries, wherein each subsidiary in the subsidiary hierarchy comprises financial data in a functional currency, the requesting subsidiary being positioned higher in the subsidiary hierarchy than at least one other subsidiary;
code for accessing an exchange rate between at least two related subsidiaries in the subsidiary hierarchy, wherein at least one of the related subsidiaries is the requesting subsidiary and the remainder of the related subsidiaries is positioned below the requesting subsidiary in the subsidiary hierarchy, the exchange rate being accessed from a data store;
code for converting the financial data of each subsidiary in the subsidiary hierarchy to the functional currency of a related subsidiary positioned higher in the subsidiary hierarchy based on the corresponding exchange rate;
code for calculating the requested consolidated financial data based on the converted financial data for each subsidiary in the subsidiary hierarchy related to and positioned lower than the requesting subsidiary, wherein the consolidated financial data is calculated in the functional currency associated with the requesting subsidiary; and
code for displaying the consolidated financial data to the requesting subsidiary.
