# US 2004/0024665 A1 · System and method for calculating taxes and multi-currency pricing

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

- Number: US 2004/0024665 A1
- Document ID: US20040024665A1
- Status: Published application
- Kind: A1
- Application number: 10/213,426
- Filed: 2002-08-05
- Published: 2004-02-05
- Earliest claimed: 2002-08-05
- Inventors: Robert A. Foster
- Web page: https://patentgrep.com/patent/US20040024665A1

## CPC

- G06Q 40/02: Banking, e.g. interest calculation or account maintenance (credit or loans G06Q40/03)
- G06Q 40/12: Accounting
- G06Q 40/123: {Tax preparation or submission}
- 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 method and a system for determining taxes attributable to a financial transaction create a tax rate table, link an entity of the financial transaction to the tax rate table through a product rule, and calculate taxes based on the tax rate table according to one component of the financial transaction. The tax rate tables can be linked by a default product rule, which is a defined by a global variable. Alternatively, specific product rules can be used to link specific entities, such as tax jurisdiction records, or legal entity records. In one application, the method and the system calculate revenue tax, cost tax, input tax, and profits for each transaction. The method and the system may further include multi-currency support analysis for a financial transaction so that a financial transaction can be analyzed under a common currency, even though the financial transaction is conducted using one or more currencies in one or more jurisdictions.

## Claims

### Claim 1

A method of determining taxes for a transaction, comprising:
creating a tax table;
creating an attribute that links the tax table to an entity of the transaction; and
determining a tax rate or tax amount by accessing the tax table through the attribute for at least a component of the transaction.

### Claim 2 (depends on 1)

The method of claim 1, wherein the attribute is provided as a part of a product rule.

### Claim 3 (depends on 1)

The method of claim 1, wherein the attribute relates to a service code.

### Claim 4 (depends on 1)

The method of claim 1, wherein the attribute is provided as part of a component of the transaction.

### Claim 5 (depends on 1)

The method of claim 1, wherein the attribute is a global variable.

### Claim 6 (depends on 1)

The method of claim 1, wherein the tax rate or tax amount is applied to a component of a transaction.

### Claim 7 (depends on 1)

The method of claim 1, wherein the tax rate or tax amount is applied after aggregating components of a transaction.

### Claim 8 (depends on 1)

The method of claim 1, wherein the tax rate or tax amount is applied after-aggregating transactions.

### Claim 9 (depends on 1)

The method of claim 1, wherein the tax table includes a tax rate represented by a multiplier.

### Claim 10 (depends on 1)

The method of claim 1, wherein the attribute denotes a tax jurisdiction relevant to the component of the transaction.

### Claim 11 (depends on 1)

The method of claim 1, wherein a default product rule associates the transaction with the tax table.

### Claim 12 (depends on 1)

The method of claim 1, wherein multiple product rules are created for linking the transaction to multiple tax tables, according to the component of the transaction.

### Claim 13 (depends on 1)

The method of claim 1, wherein the tax table contains taxation values that are used for revenue tax calculations.

### Claim 14 (depends on 1)

The method of claim 1, wherein the tax table contains taxation values that are used for cost tax calculations.

### Claim 15 (depends on 1)

The method of claim 1, wherein the tax table contains taxation values that are used for transfer tax calculations.

### Claim 16 (depends on 1)

The method of claim 1, wherein the entity contains an attribute that identifies a taxation jurisdiction.

### Claim 17 (depends on 1)

The method of claim 1, wherein the entity contains an attribute that identifies a legal entity.

### Claim 18 (depends on 1)

The method of claim 1, wherein the entity contains an attribute that identifies a service rendered in the transaction.

### Claim 19 (depends on 1)

The method of claim 1, wherein the entity contains an attribute that identifies an activity.

### Claim 20 (depends on 1)

The method of claim 1, wherein the entity contains an attribute that identifies the transaction.

### Claim 21 (depends on 1)

The method of claim 1, wherein the entity contains an attribute that identifies an account.

### Claim 23 (depends on 1)

The method of claim 1, wherein the entity contains an attribute that identifies a service rendered on an account.

### Claim 24 (depends on 1)

The method of claim 1, wherein the entity contains an attribute that identifies a plurality of accounts.

### Claim 25 (depends on 1)

The method of claim 1, wherein the entity contains an attribute that identifies a customer.

### Claim 26 (depends on 1)

The method of claim 1, further comprising:
determining a revenue tax for the transaction, wherein the revenue tax is calculated from a revenue tax table linked to the entity; and
calculating the tax on supplies based on the revenue tax.

### Claim 27 (depends on 1)

The method of claim 1, further comprising:
determining a cost tax for the transaction, wherein the cost tax is calculated from a cost tax table linked to the entity; and
calculating the acquisition tax credits based on the cost tax.

### Claim 28 (depends on 26)

The method of claim 26, further comprising:
determining a cost tax for the transaction, wherein the cost tax is calculated from a cost tax table linked to the entity;
calculating the acquisition tax credits based on the cost tax; and
calculating the tax owed by computing the difference between the tax for supply and the acquisition tax credits.

### Claim 29 (depends on 28)

The method of claim 28, further comprising:
calculating a first and second “excluding tax” amounts for revenue and cost of the transaction, respectively; and
calculating a profit by determining the difference between the first and second excluding tax amounts.

### Claim 30 (depends on 28)

The method of claim 28, further comprising:
determining a pre-tax profit using the difference between a total revenue and a total cost of the transaction; and
determining an excluding tax profit by taking into account the tax on supplies and the acquisition tax credits.

### Claim 31 (depends on 1)

The method of claim 1, further comprising displaying on a user interface the determined tax rate or a tax amount.

### Claim 32 (depends on 1)

The method of claim 1, further comprising creating a statement listing the determined tax rate or a tax amount.

### Claim 33 (depends on 1)

The method of claim 1, further comprising:
creating a currency exchange rate table;
creating a product rule linking the entity to the currency exchange rate table; and
converting an amount related to the transaction expressed in a first currency into an amount expressed in a second currency based on the currency exchange rate table.

### Claim 34

A data processing system for determining taxes of a transaction, said data processing system comprising:
means for creating a tax table;
means for creating a link between an entity of the transaction and the tax table; and
means for determining a tax for at least a component of the transaction based on the tax table.

### Claim 35 (depends on 34)

The data processing system of claim 34, wherein the link is provided as a part of a product rule.

### Claim 36 (depends on 34)

The data processing system of claim 34, wherein the link relates to a service code.

### Claim 37 (depends on 34)

The data processing system of claim 34, wherein the link is provided as part of a component of the transaction.

### Claim 38 (depends on 34)

The data processing system of claim 34, wherein the link is a global variable.

### Claim 39 (depends on 34)

The data processing system of claim 34, wherein the tax rate or tax amount is applied to a component of a transaction.

### Claim 40 (depends on 34)

The data processing system of claim 34, wherein the tax rate or tax amount is applied after aggregating components of a transaction.

### Claim 41 (depends on 34)

The data processing system of claim 34, wherein the tax rate or tax amount is applied after aggregating transactions.

### Claim 42 (depends on 34)

The data processing system of claim 34, wherein the tax table includes a tax rate represented by a multiplier.

### Claim 43 (depends on 34)

The data processing system of claim 34, wherein the attribute denotes a tax jurisdiction relevant to the component of the transaction.

### Claim 44 (depends on 34)

The data processing system of claim 34, wherein the means for creating a link comprises at least a default product rule associated with the tax table.

### Claim 45 (depends on 34)

The data processing system of claim 34, wherein the means for creating a link comprises:
means for creating a product rule related to the transaction, the product rule including an attribute; and
means for linking the tax table to the transaction by the attribute of the product rule.

### Claim 46 (depends on 34)

The data processing system of claim 34, wherein the tax table contains taxation values that are used for calculating revenue taxes.

### Claim 47 (depends on 34)

The data processing system of claim 34, wherein the tax table contains taxation values that are used for calculating cost taxes.

### Claim 48 (depends on 34)

The data processing system of claim 34, wherein the tax table contains taxation values that are used for calculating transfer taxes.

### Claim 49 (depends on 34)

The data processing system of claim 34, wherein the entity contains an attribute that identifies a taxation jurisdiction.

### Claim 50 (depends on 34)

The data processing system of claim 34, wherein the entity contains an attribute that identifies a legal entity.

### Claim 51 (depends on 34)

The data processing system of claim 34, wherein the entity contains an attribute that identifies a service rendered in the transaction.

### Claim 52 (depends on 34)

The data processing system of claim 34, wherein the entity contains an attribute that identifies an activity.

### Claim 53 (depends on 34)

The data processing system of claim 34, wherein the entity contains an attribute that identifies the transaction.

### Claim 54 (depends on 34)

The data processing system of claim 34, wherein the entity contains an attribute that identifies an account.

### Claim 55 (depends on 34)

The data processing system of claim 34, wherein the entity contains an attribute that identifies a service rendered on an account.

### Claim 56 (depends on 34)

The data processing system of claim 34, wherein the entity contains an attribute that identifies a plurality of accounts.

### Claim 57 (depends on 34)

The data processing system of claim 34, wherein the entity contains an attribute that identifies a customer.

### Claim 58 (depends on 34)

The data processing system of claim 34, further comprising means for determining a revenue tax for the transaction, wherein the revenue tax is calculated from a revenue tax table related to the entity and means for calculating the tax on supplies based on the revenue tax.

### Claim 59 (depends on 34)

The data processing system of claim 34, further comprising means for determining a cost tax for the transaction, wherein the cost tax is calculated from a cost tax table linked to the entity and means for calculating the acquisition credits based on the cost tax.

### Claim 60 (depends on 58)

The data processing system of claim 58, further comprising:
means for determining a cost tax for the transaction, wherein the cost tax is calculated from a cost tax table linked to the entity;
means for calculating the acquisition tax credits based on the cost tax; and
means for calculating the tax owed by computing the difference between the tax for supply and the acquisition tax credits.

### Claim 61 (depends on 60)

The data processing system of claim 60, further comprising:
means for calculating a first and second “excluding tax” amounts for revenue and cost of the transaction, respectively; and
means for calculating a profit by determining the difference between the first and second excluding tax amounts.

### Claim 62 (depends on 60)

The data processing system of claim 60, further comprising:
means for determining a pre-tax profit using the difference between a total revenue and a total cost of the transaction; and
means for determining an excluding tax profit by taking into account the tax on supplies and the acquisition tax credits.

### Claim 63 (depends on 34)

The data processing system of claim 34, further comprising means for displaying on a user interface the tax rate or a tax amount attributable to the entity.

### Claim 64 (depends on 34)

The data processing system of claim 34, further comprising means for creating a statement listing the tax rate or a tax amount attributable to the entity.

### Claim 65 (depends on 34)

The data processing system of claim 34, further comprising:
means for creating a currency exchange rate table;
means for creating a link between the transaction and the currency exchange rate table; and
means for converting an amount related to the transaction expressed in a first currency into an amount expressed in a second currency based on the currency exchange rate table.

### Claim 66

A method of multi-currency support analysis for a transaction, comprising:
creating a currency exchange rate table;
creating an attribute linking the currency exchange rate table to an entity of the transaction; and
converting an amount related to the transaction expressed in the first currency into an amount expressed in the second currency based on the currency exchange rate table.

### Claim 67 (depends on 66)

The method of claim 66, wherein the attribute is provided as a part of a product rule.

### Claim 68 (depends on 66)

The method of claim 66, wherein the attribute relates to a service code.

### Claim 69 (depends on 66)

The method of claim 66, wherein the attribute is provided as part of a component of the transaction.

### Claim 69 (depends on 66)

The method of claim 66, wherein the attribute is a global variable.

### Claim 70 (depends on 66)

The method of claim 66, wherein the converting is performed on a component of a transaction.

### Claim 71 (depends on 66)

The method of claim 66, wherein the converting is performed after aggregating components of a transaction.

### Claim 72 (depends on 66)

The method of claim 66, wherein the converting is performed after aggregating transactions.

### Claim 73 (depends on 66)

The method of claim 66, wherein the currency exchange rate table includes a currency exchange rate represented by a multiplier.

### Claim 74 (depends on 66)

The method of claim 66, wherein the linking uses at least one default product rule to link the currency exchange rate table.

### Claim 75 (depends on 66)

The method of claim 66, wherein the linking comprises:
creating a product rule related to the transaction, the product rule including an attribute; and
linking the currency exchange rate table to the entity through the attribute.

### Claim 76 (depends on 66)

The method of claim 66, wherein the currency exchange rate table is periodically updated.

### Claim 77 (depends on 66)

The method of claim 66, further comprising pricing accounts with transactions in multiple currencies using a predetermined currency.

### Claim 78 (depends on 77)

The method of claim 77, further comprising retrieving unit price records for a service rendered and applying prices on the unit price records to the service.

### Claim 79 (depends on 78)

The method of claim 78, further comprising displaying results of applying prices on the unit price records in a user interface.

### Claim 80 (depends on 78)

The method of claim 78, further comprising listing results of applying prices on the unit price records in a statement.

### Claim 81 (depends on 66)

The method of claim 66, further comprising:
creating a tax table;
linking the tax table to an entity of the transaction; and
calculating a tax based on the tax table.

### Claim 82

A data processing system for multi-currency support analysis for a transaction, comprising:
means for creating a currency exchange rate table;
means for creating an attribute linking the currency exchange rate table to an entity of the transaction; and
means for converting an amount related to the transaction expressed in the first currency into an amount expressed in the second currency based on the currency exchange rate table.

### Claim 83 (depends on 82)

The data processing system of claim 82, wherein the attribute is provided as a part of a product rule.

### Claim 84 (depends on 82)

The data processing system of claim 82, wherein the attribute relates to a service code.

### Claim 85 (depends on 82)

The data processing system of claim 82, wherein the attribute is provided as part of a component of the transaction.

### Claim 86 (depends on 82)

The data processing system of claim 82, wherein the attribute is a global variable.

### Claim 87 (depends on 82)

The data processing system of claim 82, wherein the means for converting applies a conversion on a component of a transaction.

### Claim 88 (depends on 82)

The data processing system of claim 82, wherein the means for converting applies a conversion after aggregating components of a transaction.

### Claim 89 (depends on 82)

The data processing system of claim 82, wherein the means for converting applies a conversion after aggregating transactions.

### Claim 90 (depends on 82)

The data processing system of claim 82, wherein the currency exchange rate table includes a currency exchange rate represented by a multiplier.

### Claim 91 (depends on 82)

The data processing system of claim 82, wherein means for creating uses a default product rule to link the currency exchange rate table.

### Claim 92 (depends on 82)

The data processing system of claim 82, wherein the means of creating comprises:
means for creating a product rule related to the transaction, the product rule including an attribute; and
means for linking the currency exchange rate table to the entity through the attribute.

### Claim 93 (depends on 82)

The data processing system of claim 82, wherein the currency exchange rate table is periodically updated.

### Claim 94 (depends on 82)

The data processing system of claim 82, further comprising means for pricing accounts with transactions in multiple currencies using a predetermined currency.

### Claim 95 (depends on 94)

The data processing system of claim 94, further comprising means for retrieving unit price records for a service rendered and means for applying prices on the unit price records to the service.

### Claim 96 (depends on 82)

The data processing system of claim 82, further comprising displaying results of applying prices on the unit price records in a user interface.

### Claim 97 (depends on 82)

The data processing system of claim 82, further comprising means for listing results of applying prices on the unit price records in a statement.

### Claim 98 (depends on 82)

The data processing system of claim 82, further comprising:
means for creating a tax table;
means for linking the tax table to an entity of the entity; and
means for calculating a tax based on the tax table.
