US20040024665A1 - System and method for calculating taxes and multi-currency pricing - Google Patents
System and method for calculating taxes and multi-currency pricing Download PDFInfo
- Publication number
- US20040024665A1 US20040024665A1 US10/213,426 US21342602A US2004024665A1 US 20040024665 A1 US20040024665 A1 US 20040024665A1 US 21342602 A US21342602 A US 21342602A US 2004024665 A1 US2004024665 A1 US 2004024665A1
- Authority
- US
- United States
- Prior art keywords
- tax
- transaction
- data processing
- processing system
- attribute
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/123—Tax preparation or submission
Definitions
- Appendix A submitted herewith on a compact disk contains computer program listings in 646 files in 15 directories, which form a part of the present disclosure.
- the computer listings, which are hereby incorporated by reference herein in its entirety, contain material that is subject to copyright protection.
- the copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure, as it appears in the patent and trademark office patent file or records, but otherwise reserves all copyright rights whatsoever.
- the present invention relates generally to pricing, costing, and tax systems, and more particularly to a system and method for calculating taxes and multi-currency pricing.
- Tax systems calculate taxes for a financial or commercial transaction based on its components of goods and services.
- Goods and services may originate or travel through multiple tax jurisdictions that impose different tax treatments and tax obligations on the services or goods. Further, some goods and services may receive different tax treatments based on industry or the nature of the service. For example, foreign goods or services may be treated differently for tax purposes, and other services, such as health care services, may be tax-exempt in a particular jurisdiction.
- a value-added tax (“VAT”) is an example of a tax that is imposed on goods and services that may receive different treatments based on the origin or the nature of the good or service.
- an exemplary VAT system illustrates a multi-jurisdictional tax system impacting goods and services that are part of a financial transaction.
- Other examples of a similarly complex tax system include a tax system on telecommunication activities crossing boundaries of multiple tax jurisdictions, a tax system involving multiple states or counties, and a tax system on foreign commerce.
- a VAT is applied to most commercial activities involving goods and services (e.g., production, wholesaling and retailing), and is generally assessed on the value added to goods and services at each stage in their production, distribution and sale.
- goods and services e.g., production, wholesaling and retailing
- acquisition credits For example, a company within a chain of production and distribution is given input VAT credits for the goods it purchases from a supplier (“acquisition credits”).
- acquisition credits When the company later sells its goods to the next link in the chain, it is charged a VAT on the goods (“tax on supply”).
- the amount of VAT owed by the company to the government on each item sold is the difference between the tax on supply and the total acquisition credits of all the inputs that can be claimed by the company that are attributable to the item sold.
- Some VAT jurisdictions exempt particular kinds of services and goods. For example, some tax jurisdictions exempt from their VAT foreign service inputs in a financial service transaction.
- the complexity in a VAT system gives rise to many approaches for tracking input tax credits.
- the “cost allocation approach” tracks all the individual goods and services involved in each transaction. Such an approach, however, imposes a very expensive administrative burden on many companies. Consequently, most VAT jurisdictions allow companies to claim input tax credits using an alternative, simplified method, generally referred to as a “formula approach.” Under the formula approach, cost allocation for the purpose of calculating the VAT owed is approximated by a metric, such as a percentage of revenue or a percentage of net income. Government regulations, however, often limit the use of the formula approach to reduced credit acquisitions. As a result, the formula approach is financially unfavorable to the companies engaged in financial transactions because of the potential loss of otherwise available tax credits.
- the cost allocation approach provides full and specific attribution of direct and indirect costs to transactions or activities, thus enabling the costs and the VAT paid to more accurately relate back to applicable specific transactions.
- the cost allocation method provides a more accurate basis for treating VAT input tax credits than the formula approach, the cost allocation method's complexity incurs high administrative costs. The higher administrative costs are especially burdensome to smaller organizations engaged in transactions with mixed taxed and non-taxed inputs.
- a further complication in some VAT calculations is that the transactions may occur in more than one currency, or in a foreign currency. Transactions in different currencies complicate VAT calculations and pricing and billing decisions.
- a method and a system for determining taxes attributable to the components of a financial transaction include: (a) creating a tax rate table, (b) linking an entity to the tax rate table, and (c) determining the tax rate from the tax rate table for at least a component of the financial transaction.
- the entity may be a service, an activity, a financial transaction, an account, a service of an account, a group of accounts, a customer, a legal entity, or any other entity that relates to the transaction, account, or customer holding the account.
- the entity is linked to a tax rate table by global variables or default product rules.
- a revenue tax, a cost tax, or a transfer tax can all be calculated from tax tables.
- specific product rules may be created with attributes to link specific entities to specific tax tables, depending on the applicable tax treatments governing the transactions.
- the method can further calculate the tax owed to a government agency by applying an input tax credit amount against the tax to be collected. “Excluding tax” amounts and profits can also be determined from that calculation.
- a data processing system includes means for creating a tax table, means for creating a link between a financial transaction and the tax table, and means for determining a tax rate or a tax amount for a component of the financial transaction based on the tax table.
- a method for multi-currency support analysis for a financial transaction includes: (a) creating a currency exchange rate tables, (b) linking the currency exchange rate table to the financial transaction through a link, an attribute or a product rule, and (c) converting the monetary amounts of the financial transaction from a first currency to a second currency.
- a company may use, for example, a second currency to be a common currency for managing and pricing its business and services.
- the second currency may be a currency desired by a customer for a particular account.
- Such a method may further price a multi-currency Customer Account Analysis (“CAA”) group of accounts or a similar group of related accounts by (a) converting the monetary amounts involved in the transactions of the accounts to be expressed in a common or single currency, (b) retrieving the unit price records for the services rendered, and (c) applying the relevant prices to the services.
- CAA Customer Account Analysis
- FIG. 1 shows a flow chart of an exemplary method for assigning taxes to transaction services, according to one embodiment of the present invention.
- FIG. 2 shows a flow chart of an exemplary method for multi-currency support analysis for a transaction, according to one embodiment of the present invention.
- FIG. 3 shows a flow chart of an exemplary method for multi-currency support pricing for a Customer Account Analysis (CAA) grouping of accounts, according to one embodiment of the present invention.
- CAA Customer Account Analysis
- the present invention is illustrated below by examples of data processing systems and methods for determining taxes for financial transactions, such as financial transactions involving multiple currencies.
- financial transactions under a VAT system illustrate a tax system involving multiple tax jurisdictions.
- each tax jurisdiction imposes its own particular tax treatment on goods and services related to the financial transactions that are rendered within its boundaries.
- financial transaction refers generally to any commercial transaction for goods and services, including services and activities related to telecommunication activities, companies, banks, foreign commerce and e-commerce.
- the present invention is not limited in its application to the specific examples described below.
- a data processing system and an associate method calculate taxes on financial services and perform multi-currency pricing.
- the data processing system uses tax tables and currency exchange rate tables to provide a comprehensive itemized list of all services, listing taxes to be paid to government agencies, taxes to be refunded (or tax credits to be applied), and the net value of these taxes.
- the data processing system provides a comprehensive and sophisticated system of transaction analysis in which each individual transaction is broken down into component services for costing, pricing, and billing purposes.
- the component services allow the cost allocation approach to be used for calculating input or acquisition tax credits.
- the component services can be further broken down, such as taxable activities, input taxed activities and tax-exempt activities, thereby providing an accurate treatment of input tax credits on the cost side, and of VAT charges on the fee, supply or revenue side.
- a financial service tax is determined by a revenue tax amount and a cost tax amount.
- a comprehensive set of service codes and mapping rules track price and cost VAT amounts for supplies and acquisitions. Different service codes can also be assigned to denote the different tax jurisdictions the goods or the services rendered may fall under. Alternatively, an attribute, a table or a record related to the transaction or an entity related to the transaction can be created to indicate the appropriate tax jurisdiction.
- the data processing system analyzes the transaction to determine the various components of the transaction. The components are defined at the service or activity level.
- the revenue or cost tax value for a service or activity is computed by locating an applicable tax table and using the tax table to calculate the appropriate tax rate or tax amount for the service or activity.
- a suitable database system for implementing a data processing system of the present invention is described in commonly owned U.S. Pat. No. 6,052,672 entitled “DATA PROCESSING SYSTEM FOR COMPLEX PRICING AND TRANSACTIONAL ANALYSIS,” which is hereby incorporated by reference in its entirety.
- other suitable database systems can also be used to implement a data processing system according to the methods of the present invention described herein. (Like terms in this detailed description and the '672 Patent are intended to be accorded like meanings.)
- each transaction is created as entities, which are data objects in the database.
- entities are data objects in the database.
- One way to implement an entity is to implement it as a record, or an attribute of a record.
- the nature of each entity i.e., the type of service or activity each entity represents) is indicated by its product or service code.
- the product or service codes attach to track-able, price-able, cost-able, collect-able, or statement-able events or actions.
- Each service code can represent a single atomic event or service within a larger transaction, or a combination of related events or services.
- Product rules then link the entities to billing categories, billing plans, price or cost tables, tax tables and other data.
- the applicable tax tables for revenue tax calculations, normal cost tax calculations, and transfer (internal) tax calculations can be specified by attributes in default product rules, in global variables or parameters, in entities related to the transaction, in components of the transaction, or in the transaction itself. Particularized product rules are often created to allow special or custom (“exception”) pricing. In fact, different product rules may be applied in the financial transactions of different clients, even though the services rendered may be the same.
- product rules can be created for all products, for all billable service codes (BSC1/2/3/4) of each product, for all billable service codes of each product for each market segment, for all billable service codes of each product for each balance allocation code (BAC), for all billable service codes of each product for each customer account analysis (CAA) group of accounts, and for all billable service codes of each product for an individual.
- BSC1/2/3/4 billable service codes
- BAC balance allocation code
- CAA customer account analysis
- FIG. 1 is a flow chart of an exemplary method 100 for assigning VAT to transaction services, according to one embodiment of the present invention.
- the user e.g., a financial service company or a bank
- the user also creates and defines various entities in the data processing system, such as billing entities, accounts, pricing relationships.
- the user initiates the process to compute the VAT associated with revenue from the transaction.
- the company retrieves the account, service, and billing-plan information from the data processing system.
- To properly determine the VAT associated with the revenue unit prices, unit costs, total revenue, and total costs are all relevant component inputs to the tax computation.
- the data processing system determines from the billing-plan information whether the particular transaction relates to “services rendered” (“SERV”), or another revenue type “Other”. “SERV” cost is the total of all costs associated with billing plan “SERV”.
- SESV indicates that the transaction is billed according to “services rendered.” Such a transaction is generally treated from the VAT standpoint as having no applicable input tax credit, and the costs are internal costs or allocations of “service rendered costs”.
- “Process for Cost Tax” step 116 is carried out next. However, if the billing plan is of the “Other” category, the VAT associated with the revenue is first determined from the applicable tax table TAXR (step 110 ).
- Exemplary billing plans under the “Other” category are fee-based plan “FEE”, and a compensation balance plan “COMP” (i.e., based on the value of the balance in the account, for example).
- a product rule refers to a tax table in a “Tax Table name” field. For example, if the “TAX Table name” field contains.“TX01”, the product rule applies the rates or amounts specified in the tax table labeled “TX01”.
- the term “tax table” refers to any data object, such as a record, a table of values, a formula, or an application program through which the applicable tax amounts can be determined.
- the tax rates may be stored as multipliers with a method “R” and a schema “RATE” in the data processing system of the present invention. Further, rates can be stored as prices.
- Entity Name TAXR Product: PBB Schema: RATE Valid From Date: Jan. 1, 2000 Minimum: 1 1100030 Brnch Dep Merch Card Draft 0.1000 R 1100040 Brnch Coin and/or Curr OrdMan 0.1000 R 1100041 Brnch Coin and/or Curr OrdStnd 0.6947 R 1100042 Brnch Coin and/or Curr OrdSpec 0.1000 R 1100043 Brnch Furn CoinLoose 0.1000 R 1100044 Brnch Furn CoinRolled 0.0700 R 1100045 Brnch Furn CoinHalf Box 0.1000 R
- the data processing system finds the tax rate corresponding to a particular service code of the financial transaction.
- An “excluding tax” amount can then be computed as the difference between the revenue and the VAT.
- the service codes and the mapping rules allow the company to breakdown individual supplies and acquisitions for their respective applicable individual VAT treatments.
- the data processing system of one embodiment uses the rate table named by the parameter-variable AP-REVENUE-TAX-RATES-TABLE to calculate the “excluding tax” amount.
- the data processing system stores the date-effective tax rate in the data processing system alongside the revenue. Of course, the data processing system could store either the date-effective tax rate percentage, or the calculation of the date-effective tax amount.
- the data processing system then proceeds to “Process for Cost Tax” step 116 .
- step 118 to compute the applicable cost tax credits, if the billing plan is in the “Other” category (step 118 ), cost tax table “TAXC” is associated at step 122 .
- cost Tax Table “TAXS” is associated at step 120 (i.e., a formula approach can be used with service revenue).
- the applicable tax credits for the financial transaction are computed from the applicable tax table using the service codes.
- the date-effective tax rate is stored in the billing record alongside the cost.
- a second “excluding tax” amount may be calculated, equaling the total cost less the applicable cost tax credits.
- the data processing system may calculate the second “excluding tax” amount using the tax tables found in the parameter-variables AP-SERV-COST-TAX-RATES-TABLE, when the billing plan is of the “SERV” category, and AP-OTHER-COST-TAX-RATES-TABLE, when the billing plan is in the “Other” category.
- the data processing system in step 128 , can then manipulate the stored data in the billing record relating to the revenue, the revenue tax, the costs, and the cost taxes, so that input credits, taxes owed, taxes to be credited are determined. Further, a profit amount can be calculated for each transaction as the difference between the “excluding tax” amounts. Alternatively, the “excluding tax” profit can be computed by applying the revenue tax and the acquisition tax credits to a pre-tax profit.
- the data processing system can itemize in a statement or a report a list of all services, taxes assessed on the products, and acquisition tax credits to be applied, and the net tax owed to the government, and any other presentation of the data. This data may then be displayed by a user interface (e.g., a computer screen) or reported on an itemized statement generated internally, or generated for a customer or a reporting authority (e.g., an electronic account statement).
- a company can accurately calculate the taxes associated with each service being rendered in the appropriate tax jurisdiction, and the input tax credits and reduced input tax credits that can be applied to each service in each instance.
- Each component of the customer transaction is thus properly accorded the applicable tax treatment, i.e., whether the components of the transaction is taxable, or tax-exempt in each applicable tax jurisdiction.
- Costs also are properly treated for tax credits according to whether the costs are internal, out-sourced or imported, and whether that service is eligible for reduced input tax credit.
- Acquisition activities can likewise be mapped to all supply activities, so that standard unit costs are allocated to the acquisition activities.
- the input tax credits and reduced input tax credits are calculated based on the tax status of each acquisition activity's related supply activity.
- the components of a transaction can be aggregated, and the applicable taxes computed on the aggregated total.
- the tax tables are applied to aggregated transactions of an account, transactions of a group of accounts of the same customer, transactions of a legal entity or transactions occurring within a given tax jurisdiction.
- the data processing method and system convert currencies from different transactions into a common currency for each account or customer.
- the financial institution or its customers can therefore analyze transactions and accounts in one or more common currencies, while at the same time conduct the transactions in the different currencies that are required.
- a company can manage its business as if it uses a single or a small number of “global” currencies, while actually conducting business in a large number of currencies.
- a company can further price multi-currency financial transactions and CAA accounts in a common currency regardless of the currencies used in the transactions or handled in the accounts.
- the multi-currency support analysis can operate in conjunction with the financial service tax support analysis described above to provide a system for global pricing and tax-determination for transactions occurring in various places of the world.
- the multi-currency support analysis is applied individually to each financial transaction, which is stored in the data processing system in the currency the transaction was carried out.
- the data processing system links a transaction or entity to a currency exchange rate table using product rules, mapping rules and service codes.
- a currency exchange rate table contains rate information for converting one or more currencies to a second or common currency.
- FIG. 2 is a flow chart of an exemplary method 200 for a multi-currency support analysis according to one embodiment of the present invention.
- the data processing system identifies and validates (step 204 ) each financial transaction that has occurred during a billing cycle to perform a multi-currency analysis.
- the transaction amount is stored in its native currency (i.e., the currency in which the transaction is carried out).
- the data processing system converts (if necessary) the applicable amount of the transaction in the currency in which the account is kept, and stores, at step 210 , the transaction under “category M” (i.e., the account's currency).
- exchange rate tables which are associated using product rules in the manner similar to that discussed above with respect to associating a transaction with applicable tax tables.
- the conversion calculations of the currency exchange rate tables adhere to a standard specified for the Euro currency. Under that standard, for example, exchange rates are specified to six significant figures.
- a conversion between currencies A and B via a common currency C involves dividing the amount in currency A by a first exchange rate to arrive at an equivalent amount under common currency C, and then multiplying the amount in currency C by a second exchange rate to arrive at the equivalent amount under currency B.
- the transaction is converted from its native currency into a common currency (e.g., U.S. dollars or Euros), and stored at step 214 under “category N” (i.e., in the common currency).
- a common currency e.g., U.S. dollars or Euros
- categories N i.e., in the common currency.
- the customer i.e., the account holder
- the data processing system of the present invention uses an exchange rate table specified in the parameter-variable AP-COMMON-CURRENCY-CODE.
- the data processing system updates the exchange rate tables on an ongoing basis. Update can be achieved by accesses over the Internet, from an update service, or from other data sources. Because exchange rates are constantly varying, transaction amounts, account balances, and pre-priced revenues are time-sensitive. In one example, the exchange rate tables may be updated every 15 to 60 minutes, depending on the accuracy desired. The new exchange rates are stored with a Min-Tran threshold tag that keeps track of the elapsed time since the last update on any particular day.
- the exchange rates can be stored as multipliers with a method “R” and schema “RATE”.
- a Rate Table to convert the Euro to various currency equivalents can be provided as follows: Entity Name: EUR Product: CURX Schema: RATE Valid From Date: Jan. 13, 2000 Minimum: 1315 ATS AustriaSchilling 12.0919 R AUD AustraliaDollar 1.5753 R BEF BelgiumFrancs 42.0168 R BRL BrazilReal 1.66611 R CAD CanadaDollar 1.39938 R GBP UKPound .689275 R USD USDollar .951475 R
- a two-step process can be used.
- the transaction amount in the first currency is converted into the common currency
- the second step the amount in the common currency is converted into the second currency.
- the data processing system uses the procedure described above to convert the 2,500 Canadian dollars into 1,786.505452 Euros.
- FIG. 3 shows a flow chart of an exemplary method 300 for multi-currency support pricing of a transaction, according to one embodiment of the present invention.
- method 300 is applied from a CAA main account.
- a CAA is a group of related accounts consisting of a main account linked to one or more subordinate accounts.
- the data processing system determines the CAA's “billing category”, which is either category N (common currency) or M (the selected currency for the account).
- billing category N common currency
- the data processing system obtains category N activity (or services) for the CAA in step 320 .
- the related unit price records for the services rendered are obtained, and in step 314 , prices are applied to the activity.
- a CAA with a common currency is priced using the common currency.
- the data processing system obtains each account's currency code within the CAA in step 306 .
- the account currency code is stored as an attribute on the account record. The data processing system then determines if the CAA is a mixed currency CAA in step 308 .
- the data processing system obtains category N activity for the CAA in step 310 .
- category N e.g., account balances, transaction amounts, pre-priced revenue amounts
- the data processing system obtains category N activity for the CAA.
- the data processing system obtains default unit price and cost tables for the common currency, and then applies the appropriate prices to the activity at step 314 .
- the data processing system obtains category M activity for the CAA.
- the data processing system obtains related unit price records for the services rendered and then applies, at step 314 , the related unit prices thus obtained to the activity.
- total revenue and cost for each service used can be apportioned back to an individual account or transaction, if desired. For example, one may determine the profitability of a transaction by executing the pricing and costing against the CAA(s) of the debit and credit accounts, and then apportion the pricing and costing thus obtained back to the individual accounts according to an appropriate rule.
- the present invention provides a method and a system for conducting a financial transaction in any currency while, using the multi-jurisdictional tax support and multi-currency pricing analysis described above, allowing both pricing and taxes related to the transaction to be computed for any desired currency.
- a company located in the United States, operating on US Dollars basis can determine the pricing and the applicable taxes for a subsidiary Canadian corporation, operating on the basis of Canadian dollars, for a financial transaction that took place in Belgium Francs.
- the subsidiary Canadian corporation can view the entire transaction, prices, and tax calculations in Canadian Dollars, while the US parent can view the same transaction in U.S. Dollars.
Abstract
Description
- Appendix A submitted herewith on a compact disk contains computer program listings in 646 files in 15 directories, which form a part of the present disclosure. The computer listings, which are hereby incorporated by reference herein in its entirety, contain material that is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure, as it appears in the patent and trademark office patent file or records, but otherwise reserves all copyright rights whatsoever.
- 1. Field of the Invention
- The present invention relates generally to pricing, costing, and tax systems, and more particularly to a system and method for calculating taxes and multi-currency pricing.
- 2. Description of the Related Art
- Many tax systems calculate taxes for a financial or commercial transaction based on its components of goods and services. Goods and services may originate or travel through multiple tax jurisdictions that impose different tax treatments and tax obligations on the services or goods. Further, some goods and services may receive different tax treatments based on industry or the nature of the service. For example, foreign goods or services may be treated differently for tax purposes, and other services, such as health care services, may be tax-exempt in a particular jurisdiction.
- A value-added tax (“VAT”) is an example of a tax that is imposed on goods and services that may receive different treatments based on the origin or the nature of the good or service. In the following detailed description, an exemplary VAT system illustrates a multi-jurisdictional tax system impacting goods and services that are part of a financial transaction. Other examples of a similarly complex tax system include a tax system on telecommunication activities crossing boundaries of multiple tax jurisdictions, a tax system involving multiple states or counties, and a tax system on foreign commerce.
- The United Kingdom, Canada, New Zealand, and Australia are among those countries having a VAT system. In those countries, a VAT is applied to most commercial activities involving goods and services (e.g., production, wholesaling and retailing), and is generally assessed on the value added to goods and services at each stage in their production, distribution and sale. For example, a company within a chain of production and distribution is given input VAT credits for the goods it purchases from a supplier (“acquisition credits”). When the company later sells its goods to the next link in the chain, it is charged a VAT on the goods (“tax on supply”). The amount of VAT owed by the company to the government on each item sold is the difference between the tax on supply and the total acquisition credits of all the inputs that can be claimed by the company that are attributable to the item sold.
- Some VAT jurisdictions exempt particular kinds of services and goods. For example, some tax jurisdictions exempt from their VAT foreign service inputs in a financial service transaction. The complexity in a VAT system gives rise to many approaches for tracking input tax credits. For example, the “cost allocation approach” tracks all the individual goods and services involved in each transaction. Such an approach, however, imposes a very expensive administrative burden on many companies. Consequently, most VAT jurisdictions allow companies to claim input tax credits using an alternative, simplified method, generally referred to as a “formula approach.” Under the formula approach, cost allocation for the purpose of calculating the VAT owed is approximated by a metric, such as a percentage of revenue or a percentage of net income. Government regulations, however, often limit the use of the formula approach to reduced credit acquisitions. As a result, the formula approach is financially unfavorable to the companies engaged in financial transactions because of the potential loss of otherwise available tax credits.
- The cost allocation approach provides full and specific attribution of direct and indirect costs to transactions or activities, thus enabling the costs and the VAT paid to more accurately relate back to applicable specific transactions. As discussed above, while the cost allocation method provides a more accurate basis for treating VAT input tax credits than the formula approach, the cost allocation method's complexity incurs high administrative costs. The higher administrative costs are especially burdensome to smaller organizations engaged in transactions with mixed taxed and non-taxed inputs.
- A further complication in some VAT calculations (also true of other multi-jurisdictional tax calculations, pricing or billing functions) is that the transactions may occur in more than one currency, or in a foreign currency. Transactions in different currencies complicate VAT calculations and pricing and billing decisions.
- According to one embodiment of the present invention, a method and a system for determining taxes attributable to the components of a financial transaction include: (a) creating a tax rate table, (b) linking an entity to the tax rate table, and (c) determining the tax rate from the tax rate table for at least a component of the financial transaction. As used herein, the entity may be a service, an activity, a financial transaction, an account, a service of an account, a group of accounts, a customer, a legal entity, or any other entity that relates to the transaction, account, or customer holding the account.
- In one embodiment, the entity is linked to a tax rate table by global variables or default product rules. A revenue tax, a cost tax, or a transfer tax can all be calculated from tax tables. Further, specific product rules may be created with attributes to link specific entities to specific tax tables, depending on the applicable tax treatments governing the transactions. The method can further calculate the tax owed to a government agency by applying an input tax credit amount against the tax to be collected. “Excluding tax” amounts and profits can also be determined from that calculation.
- According to another embodiment of the present invention, a data processing system includes means for creating a tax table, means for creating a link between a financial transaction and the tax table, and means for determining a tax rate or a tax amount for a component of the financial transaction based on the tax table. According to another embodiment of the present invention, a method for multi-currency support analysis for a financial transaction includes: (a) creating a currency exchange rate tables, (b) linking the currency exchange rate table to the financial transaction through a link, an attribute or a product rule, and (c) converting the monetary amounts of the financial transaction from a first currency to a second currency. A company may use, for example, a second currency to be a common currency for managing and pricing its business and services. Alternatively, the second currency may be a currency desired by a customer for a particular account. Such a method may further price a multi-currency Customer Account Analysis (“CAA”) group of accounts or a similar group of related accounts by (a) converting the monetary amounts involved in the transactions of the accounts to be expressed in a common or single currency, (b) retrieving the unit price records for the services rendered, and (c) applying the relevant prices to the services.
- The present invention is better understood upon consideration of the detailed description below and the accompanying drawings.
- FIG. 1 shows a flow chart of an exemplary method for assigning taxes to transaction services, according to one embodiment of the present invention.
- FIG. 2 shows a flow chart of an exemplary method for multi-currency support analysis for a transaction, according to one embodiment of the present invention.
- FIG. 3 shows a flow chart of an exemplary method for multi-currency support pricing for a Customer Account Analysis (CAA) grouping of accounts, according to one embodiment of the present invention.
- The present invention is illustrated below by examples of data processing systems and methods for determining taxes for financial transactions, such as financial transactions involving multiple currencies. In this detailed description, financial transactions under a VAT system illustrate a tax system involving multiple tax jurisdictions. Typically, each tax jurisdiction imposes its own particular tax treatment on goods and services related to the financial transactions that are rendered within its boundaries. As used in this detailed description, the term “financial transaction” refers generally to any commercial transaction for goods and services, including services and activities related to telecommunication activities, companies, banks, foreign commerce and e-commerce. Of course, the present invention is not limited in its application to the specific examples described below.
- In one application of the present invention, described in further detail below, a data processing system and an associate method calculate taxes on financial services and perform multi-currency pricing. In that application, the data processing system uses tax tables and currency exchange rate tables to provide a comprehensive itemized list of all services, listing taxes to be paid to government agencies, taxes to be refunded (or tax credits to be applied), and the net value of these taxes. The data processing system provides a comprehensive and sophisticated system of transaction analysis in which each individual transaction is broken down into component services for costing, pricing, and billing purposes. The component services allow the cost allocation approach to be used for calculating input or acquisition tax credits. The component services can be further broken down, such as taxable activities, input taxed activities and tax-exempt activities, thereby providing an accurate treatment of input tax credits on the cost side, and of VAT charges on the fee, supply or revenue side.
- In one VAT system, a financial service tax is determined by a revenue tax amount and a cost tax amount. To determine the respective tax amounts, a comprehensive set of service codes and mapping rules track price and cost VAT amounts for supplies and acquisitions. Different service codes can also be assigned to denote the different tax jurisdictions the goods or the services rendered may fall under. Alternatively, an attribute, a table or a record related to the transaction or an entity related to the transaction can be created to indicate the appropriate tax jurisdiction. To identify the applicable service codes and to apply the mapping rules, the data processing system analyzes the transaction to determine the various components of the transaction. The components are defined at the service or activity level. The revenue or cost tax value for a service or activity is computed by locating an applicable tax table and using the tax table to calculate the appropriate tax rate or tax amount for the service or activity.
- A suitable database system for implementing a data processing system of the present invention is described in commonly owned U.S. Pat. No. 6,052,672 entitled “DATA PROCESSING SYSTEM FOR COMPLEX PRICING AND TRANSACTIONAL ANALYSIS,” which is hereby incorporated by reference in its entirety. Of course, other suitable database systems can also be used to implement a data processing system according to the methods of the present invention described herein. (Like terms in this detailed description and the '672 Patent are intended to be accorded like meanings.)
- Using a suitable database system, the services or activities of each transaction are created as entities, which are data objects in the database. One way to implement an entity is to implement it as a record, or an attribute of a record. The nature of each entity (i.e., the type of service or activity each entity represents) is indicated by its product or service code. The product or service codes attach to track-able, price-able, cost-able, collect-able, or statement-able events or actions. Each service code can represent a single atomic event or service within a larger transaction, or a combination of related events or services. Product rules then link the entities to billing categories, billing plans, price or cost tables, tax tables and other data. Alternatively, rather than using product rules, the applicable tax tables for revenue tax calculations, normal cost tax calculations, and transfer (internal) tax calculations can be specified by attributes in default product rules, in global variables or parameters, in entities related to the transaction, in components of the transaction, or in the transaction itself. Particularized product rules are often created to allow special or custom (“exception”) pricing. In fact, different product rules may be applied in the financial transactions of different clients, even though the services rendered may be the same. For example, using terms familiar to those skilled in the banking industry, product rules can be created for all products, for all billable service codes (BSC1/2/3/4) of each product, for all billable service codes of each product for each market segment, for all billable service codes of each product for each balance allocation code (BAC), for all billable service codes of each product for each customer account analysis (CAA) group of accounts, and for all billable service codes of each product for an individual.
- FIG. 1 is a flow chart of an
exemplary method 100 for assigning VAT to transaction services, according to one embodiment of the present invention. Beginning atstep 102, the user (e.g., a financial service company or a bank) creates and defines in the data processing system the financial transactions and the mapping rules for the transactions, including production services and billing services. The user also creates and defines various entities in the data processing system, such as billing entities, accounts, pricing relationships. - At
step 104, the user initiates the process to compute the VAT associated with revenue from the transaction. Atstep 106, the company retrieves the account, service, and billing-plan information from the data processing system. To properly determine the VAT associated with the revenue, unit prices, unit costs, total revenue, and total costs are all relevant component inputs to the tax computation. Atstep 108, the data processing system determines from the billing-plan information whether the particular transaction relates to “services rendered” (“SERV”), or another revenue type “Other”. “SERV” cost is the total of all costs associated with billing plan “SERV”. “SERV” indicates that the transaction is billed according to “services rendered.” Such a transaction is generally treated from the VAT standpoint as having no applicable input tax credit, and the costs are internal costs or allocations of “service rendered costs”. For “SERV” type billing plans, “Process for Cost Tax”step 116 is carried out next. However, if the billing plan is of the “Other” category, the VAT associated with the revenue is first determined from the applicable tax table TAXR (step 110). (Tax table TAXR, just as any other tax table, can include either tax rates or a table of tax amounts.) Exemplary billing plans under the “Other” category are fee-based plan “FEE”, and a compensation balance plan “COMP” (i.e., based on the value of the balance in the account, for example). - In one embodiment, a product rule refers to a tax table in a “Tax Table name” field. For example, if the “TAX Table name” field contains.“TX01”, the product rule applies the rates or amounts specified in the tax table labeled “TX01”. As used herein, the term “tax table” refers to any data object, such as a record, a table of values, a formula, or an application program through which the applicable tax amounts can be determined. In one embodiment, the tax rates may be stored as multipliers with a method “R” and a schema “RATE” in the data processing system of the present invention. Further, rates can be stored as prices. For example using multipliers:
Entity Name: TAXR Product: PBB Schema: RATE Valid From Date: Jan. 1, 2000 Minimum: 1 1100030 Brnch Dep Merch Card Draft 0.1000 R 1100040 Brnch Coin and/or Curr OrdMan 0.1000 R 1100041 Brnch Coin and/or Curr OrdStnd 0.6947 R 1100042 Brnch Coin and/or Curr OrdSpec 0.1000 R 1100043 Brnch Furn CoinLoose 0.1000 R 1100044 Brnch Furn CoinRolled 0.0700 R 1100045 Brnch Furn CoinHalf Box 0.1000 R - At
step 112, the data processing system finds the tax rate corresponding to a particular service code of the financial transaction. An “excluding tax” amount can then be computed as the difference between the revenue and the VAT. The service codes and the mapping rules allow the company to breakdown individual supplies and acquisitions for their respective applicable individual VAT treatments. For example, the data processing system of one embodiment uses the rate table named by the parameter-variable AP-REVENUE-TAX-RATES-TABLE to calculate the “excluding tax” amount. Atstep 114, the data processing system stores the date-effective tax rate in the data processing system alongside the revenue. Of course, the data processing system could store either the date-effective tax rate percentage, or the calculation of the date-effective tax amount. The data processing system then proceeds to “Process for Cost Tax”step 116. - At
step 118, to compute the applicable cost tax credits, if the billing plan is in the “Other” category (step 118), cost tax table “TAXC” is associated atstep 122. Alternatively, if the billing plan is in the “SERV” category, cost Tax Table “TAXS” is associated at step 120 (i.e., a formula approach can be used with service revenue). In either case, atstep 124, the applicable tax credits for the financial transaction are computed from the applicable tax table using the service codes. The date-effective tax rate is stored in the billing record alongside the cost. A second “excluding tax” amount may be calculated, equaling the total cost less the applicable cost tax credits. For example, the data processing system may calculate the second “excluding tax” amount using the tax tables found in the parameter-variables AP-SERV-COST-TAX-RATES-TABLE, when the billing plan is of the “SERV” category, and AP-OTHER-COST-TAX-RATES-TABLE, when the billing plan is in the “Other” category. - The data processing system, in
step 128, can then manipulate the stored data in the billing record relating to the revenue, the revenue tax, the costs, and the cost taxes, so that input credits, taxes owed, taxes to be credited are determined. Further, a profit amount can be calculated for each transaction as the difference between the “excluding tax” amounts. Alternatively, the “excluding tax” profit can be computed by applying the revenue tax and the acquisition tax credits to a pre-tax profit. The data processing system can itemize in a statement or a report a list of all services, taxes assessed on the products, and acquisition tax credits to be applied, and the net tax owed to the government, and any other presentation of the data. This data may then be displayed by a user interface (e.g., a computer screen) or reported on an itemized statement generated internally, or generated for a customer or a reporting authority (e.g., an electronic account statement). - In this manner a company can accurately calculate the taxes associated with each service being rendered in the appropriate tax jurisdiction, and the input tax credits and reduced input tax credits that can be applied to each service in each instance. Each component of the customer transaction is thus properly accorded the applicable tax treatment, i.e., whether the components of the transaction is taxable, or tax-exempt in each applicable tax jurisdiction. Costs also are properly treated for tax credits according to whether the costs are internal, out-sourced or imported, and whether that service is eligible for reduced input tax credit. Acquisition activities can likewise be mapped to all supply activities, so that standard unit costs are allocated to the acquisition activities. The input tax credits and reduced input tax credits are calculated based on the tax status of each acquisition activity's related supply activity.
- Using service codes and product rules in this manner enables an accurate and comprehensive analysis of each financial transaction, providing maximum flexibility in treating transactions that are taxed in different manners, classes, and rates individually. For instance, a company may classify every financial transaction service by service, and evaluate the cost separately from the revenue.
- Alternatively, rather than computing taxes on the component basis, the components of a transaction can be aggregated, and the applicable taxes computed on the aggregated total. In fact, in one embodiment, the tax tables are applied to aggregated transactions of an account, transactions of a group of accounts of the same customer, transactions of a legal entity or transactions occurring within a given tax jurisdiction.
- According to another aspect of the present invention, the data processing method and system convert currencies from different transactions into a common currency for each account or customer. The financial institution or its customers can therefore analyze transactions and accounts in one or more common currencies, while at the same time conduct the transactions in the different currencies that are required. Viewed another way, according to the present invention, a company can manage its business as if it uses a single or a small number of “global” currencies, while actually conducting business in a large number of currencies. A company can further price multi-currency financial transactions and CAA accounts in a common currency regardless of the currencies used in the transactions or handled in the accounts.
- The multi-currency support analysis can operate in conjunction with the financial service tax support analysis described above to provide a system for global pricing and tax-determination for transactions occurring in various places of the world.
- The multi-currency support analysis is applied individually to each financial transaction, which is stored in the data processing system in the currency the transaction was carried out. Like the tax support analysis described above, the data processing system links a transaction or entity to a currency exchange rate table using product rules, mapping rules and service codes. A currency exchange rate table contains rate information for converting one or more currencies to a second or common currency.
- FIG. 2 is a flow chart of an
exemplary method 200 for a multi-currency support analysis according to one embodiment of the present invention. Beginning atstep 202, the data processing system identifies and validates (step 204) each financial transaction that has occurred during a billing cycle to perform a multi-currency analysis. Atstep 206, the transaction amount is stored in its native currency (i.e., the currency in which the transaction is carried out). For each account involved in the financial transaction, atstep 208, the data processing system converts (if necessary) the applicable amount of the transaction in the currency in which the account is kept, and stores, atstep 210, the transaction under “category M” (i.e., the account's currency). The conversions are made using exchange rate tables, which are associated using product rules in the manner similar to that discussed above with respect to associating a transaction with applicable tax tables. In one application, the conversion calculations of the currency exchange rate tables adhere to a standard specified for the Euro currency. Under that standard, for example, exchange rates are specified to six significant figures. A conversion between currencies A and B via a common currency C involves dividing the amount in currency A by a first exchange rate to arrive at an equivalent amount under common currency C, and then multiplying the amount in currency C by a second exchange rate to arrive at the equivalent amount under currency B. - Next, at
step 212, the transaction is converted from its native currency into a common currency (e.g., U.S. dollars or Euros), and stored atstep 214 under “category N” (i.e., in the common currency). Using this common currency, the customer (i.e., the account holder) can view all the accounts in a single “global” currency and at the same time keep each account in its native currency. In one embodiment, the data processing system of the present invention uses an exchange rate table specified in the parameter-variable AP-COMMON-CURRENCY-CODE. - Of course, the data processing system updates the exchange rate tables on an ongoing basis. Update can be achieved by accesses over the Internet, from an update service, or from other data sources. Because exchange rates are constantly varying, transaction amounts, account balances, and pre-priced revenues are time-sensitive. In one example, the exchange rate tables may be updated every 15 to 60 minutes, depending on the accuracy desired. The new exchange rates are stored with a Min-Tran threshold tag that keeps track of the elapsed time since the last update on any particular day.
- In some embodiments the exchange rates can be stored as multipliers with a method “R” and schema “RATE”. For example, a Rate Table to convert the Euro to various currency equivalents can be provided as follows:
Entity Name: EUR Product: CURX Schema: RATE Valid From Date: Jan. 13, 2000 Minimum: 1315 ATS AustriaSchilling 12.0919 R AUD AustraliaDollar 1.5753 R BEF BelgiumFrancs 42.0168 R BRL BrazilReal 1.66611 R CAD CanadaDollar 1.39938 R GBP UKPound .689275 R USD USDollar .951475 R - Using the exchange rate table above, for example, 43.15 British Pounds is converted to its Euro equivalent by the data processing system first locating the currency exchange rate table EURO above for product CURX, which is tagged with a valid-from-date and time (min-tran-count) tag that is the closest and hence, most appropriate, to the date and time required (e.g., the timestamp that equals or immediately precedes the effective accounting timestamp of the transaction). From this exchange rate table, the data processing system looks up the British Pound “GBP” (i.e., the Euro-to-GBP-rate). 43.15 GBP is then simply divided by the Euro-to-GBP-rate, giving 43.15/.689275=62.60 Euros to two decimal places.
- To convert between two currencies that are not one of the selected common currencies, a two-step process can be used. In the first step, the transaction amount in the first currency is converted into the common currency, and then, in the second step, the amount in the common currency is converted into the second currency. For example, if it is desired to convert 2,500.00 Canadian Dollars to Brazilian Reals, the data processing system uses the procedure described above to convert the 2,500 Canadian dollars into 1,786.505452 Euros. (Here, the Euro equivalent is rounded to six decimal places for added precision even though, under the Euro standard, only four decimal places are required for interim results.) The system then looks up the BRL service within this set of EUR exchange rates (i.e., the Euro-to-BRL-rate), to obtain 1,786.505452×1.666110=2,976.51 BRL (rounded to two decimal places).
- FIG. 3 shows a flow chart of an
exemplary method 300 for multi-currency support pricing of a transaction, according to one embodiment of the present invention. As shown in FIG. 3,method 300 is applied from a CAA main account. A CAA is a group of related accounts consisting of a main account linked to one or more subordinate accounts. Atstep 304, the data processing system determines the CAA's “billing category”, which is either category N (common currency) or M (the selected currency for the account). In one application, where a CAA contains mixed currencies (e.g., account 1 is GBP, account 2 is USD, account 3 is USD, and account 4 is EUR), billing category N (common currency) is used to ensure a consistent currency is applied to the entire CAA. - When the CAA's billing category is category N, the data processing system obtains category N activity (or services) for the CAA in
step 320. Atstep 322, the related unit price records for the services rendered are obtained, and instep 314, prices are applied to the activity. Thus, a CAA with a common currency is priced using the common currency. Alternatively, when the CAA's billing category is category M, the data processing system obtains each account's currency code within the CAA instep 306. In one embodiment the account currency code is stored as an attribute on the account record. The data processing system then determines if the CAA is a mixed currency CAA instep 308. - When the CAA is a mixed currency CAA, the data processing system obtains category N activity for the CAA in
step 310. To price a mixed currency CAA, pricing is established using the common currency. Thus, the monetary amounts of the CAA (e.g., account balances, transaction amounts, pre-priced revenue amounts) are converted to the common currency (i.e., category N).Step 310, likestep 320, obtains category N activity for the CAA. Atstep 312, the data processing system obtains default unit price and cost tables for the common currency, and then applies the appropriate prices to the activity atstep 314. - When the CAA is not a mixed currency CAA, at
step 316, the data processing system obtains category M activity for the CAA. Atstep 318, the data processing system obtains related unit price records for the services rendered and then applies, atstep 314, the related unit prices thus obtained to the activity. - In some embodiments, although the pricing and costing functions are performed at the CAA level, total revenue and cost for each service used can be apportioned back to an individual account or transaction, if desired. For example, one may determine the profitability of a transaction by executing the pricing and costing against the CAA(s) of the debit and credit accounts, and then apportion the pricing and costing thus obtained back to the individual accounts according to an appropriate rule.
- Therefore, the present invention provides a method and a system for conducting a financial transaction in any currency while, using the multi-jurisdictional tax support and multi-currency pricing analysis described above, allowing both pricing and taxes related to the transaction to be computed for any desired currency. For example, a company located in the United States, operating on US Dollars basis, can determine the pricing and the applicable taxes for a subsidiary Canadian corporation, operating on the basis of Canadian dollars, for a financial transaction that took place in Belgium Francs. The subsidiary Canadian corporation can view the entire transaction, prices, and tax calculations in Canadian Dollars, while the US parent can view the same transaction in U.S. Dollars.
- The above detailed description illustrates specific embodiments of the present invention and is not intended to be limiting. Numerous modifications and variations within the scope of the present invention are possible. For example, numerous combinations of the tax rate support method and system can be combined in various ways with the multi-currency support analysis and pricing method and system. Accordingly, the present invention is defined by the appended claims.
Claims (98)
Priority Applications (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/213,426 US20040024665A1 (en) | 2002-08-05 | 2002-08-05 | System and method for calculating taxes and multi-currency pricing |
US11/519,380 US7966231B2 (en) | 2002-08-05 | 2006-09-11 | System and method for calculating taxes and multi-currency pricing |
US13/086,715 US20110191216A1 (en) | 2002-08-05 | 2011-04-14 | System and method for calculating taxes and multi-currency pricing |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/213,426 US20040024665A1 (en) | 2002-08-05 | 2002-08-05 | System and method for calculating taxes and multi-currency pricing |
Related Child Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US11/519,380 Division US7966231B2 (en) | 2002-08-05 | 2006-09-11 | System and method for calculating taxes and multi-currency pricing |
Publications (1)
Publication Number | Publication Date |
---|---|
US20040024665A1 true US20040024665A1 (en) | 2004-02-05 |
Family
ID=31187877
Family Applications (3)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/213,426 Abandoned US20040024665A1 (en) | 2002-08-05 | 2002-08-05 | System and method for calculating taxes and multi-currency pricing |
US11/519,380 Expired - Fee Related US7966231B2 (en) | 2002-08-05 | 2006-09-11 | System and method for calculating taxes and multi-currency pricing |
US13/086,715 Abandoned US20110191216A1 (en) | 2002-08-05 | 2011-04-14 | System and method for calculating taxes and multi-currency pricing |
Family Applications After (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US11/519,380 Expired - Fee Related US7966231B2 (en) | 2002-08-05 | 2006-09-11 | System and method for calculating taxes and multi-currency pricing |
US13/086,715 Abandoned US20110191216A1 (en) | 2002-08-05 | 2011-04-14 | System and method for calculating taxes and multi-currency pricing |
Country Status (1)
Country | Link |
---|---|
US (3) | US20040024665A1 (en) |
Cited By (27)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020178098A1 (en) * | 2001-03-01 | 2002-11-28 | Beard Mark L. | System and method for measuring and utilizing pooling analytics |
US20030101114A1 (en) * | 2001-11-29 | 2003-05-29 | Delapass Janine L. | System and method for collecting and analyzing tax reporting surveys |
US20040117305A1 (en) * | 2002-08-30 | 2004-06-17 | Beat Meier | Methods and systems for automated generation of bills |
US20040216057A1 (en) * | 2003-04-24 | 2004-10-28 | Sureprep, Llc | System and method for grouping and organizing pages of an electronic document into pre-defined catagories |
US20040243626A1 (en) * | 2003-05-30 | 2004-12-02 | Sureprep, Llc | System and method for managing login resources for the submission and performance of engagements |
WO2006020315A2 (en) * | 2004-07-30 | 2006-02-23 | Sureprep, Llc | Creating cross-reference links, tables and lead sheets for tax documents |
US20070026906A1 (en) * | 2005-07-29 | 2007-02-01 | Research In Motion Limited (A Corp. Organized Under The Laws Of The Province Of Ontario, Canada) | Portable wireless communications device including pickpocket notification and related methods |
US20080319882A1 (en) * | 2007-06-20 | 2008-12-25 | Wyle David A | Efficient work flow system and method for processing taxpayer source documents |
US20090287591A1 (en) * | 2003-05-07 | 2009-11-19 | Sureprep, Llc | Multi-stage, multi-user engagement submission and tracking process |
US7739160B1 (en) * | 2004-12-22 | 2010-06-15 | Ryan, Inc. | Dynamic, rule-based, tax-decision system |
US7756896B1 (en) | 2002-03-11 | 2010-07-13 | Jp Morgan Chase Bank | System and method for multi-dimensional risk analysis |
US7853494B2 (en) | 2005-01-07 | 2010-12-14 | Sureprep, Llc | Efficient work flow system and method for preparing tax returns |
US7962391B2 (en) | 2000-12-20 | 2011-06-14 | Jpmorgan Chase Bank, N.A. | System and method for determining elegibility and enrolling members in various programs |
US20120191719A1 (en) * | 2000-05-09 | 2012-07-26 | Cbs Interactive Inc. | Content aggregation method and apparatus for on-line purchasing system |
CN103578200A (en) * | 2012-07-27 | 2014-02-12 | 精工爱普生株式会社 | Information processing device and control method thereof, server device and control method thereof |
US8775408B2 (en) | 2011-09-23 | 2014-07-08 | Sureprep, Llc | Document element indexing system |
US20150095204A1 (en) * | 2013-09-30 | 2015-04-02 | Mastercard International Incorporated | Processes and Systems for Recovering Refundable Taxes |
US20150271538A1 (en) * | 2012-10-22 | 2015-09-24 | Zte Corporation | System and Method for IPTV Value-added Service Management |
US9177059B2 (en) | 2000-05-09 | 2015-11-03 | Cbs Interactive Inc. | Method and system for determining allied products |
US20170161652A1 (en) * | 2015-12-08 | 2017-06-08 | Formula Technologies, Inc. | Financial Monitoring and Forecasting Systems and Methods |
US20180114195A1 (en) * | 2016-10-26 | 2018-04-26 | American Express Travel Related Services Company, Inc. | Provisioning Available Appointments |
US10685370B2 (en) | 2012-09-16 | 2020-06-16 | American Express Travel Related Services Company, Inc. | Purchasing a reserved item |
US11232521B2 (en) * | 2014-04-14 | 2022-01-25 | Lukka, Inc. | Methods, systems, and tools for providing tax related services for virtual currency holdings |
US11238540B2 (en) | 2017-12-05 | 2022-02-01 | Sureprep, Llc | Automatic document analysis filtering, and matching system |
US11314887B2 (en) | 2017-12-05 | 2022-04-26 | Sureprep, Llc | Automated document access regulation system |
US11544799B2 (en) | 2017-12-05 | 2023-01-03 | Sureprep, Llc | Comprehensive tax return preparation system |
US11860950B2 (en) | 2021-03-30 | 2024-01-02 | Sureprep, Llc | Document matching and data extraction |
Families Citing this family (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7548615B2 (en) * | 2004-04-28 | 2009-06-16 | American Express Travel Related Services Company, Inc. | Rate validation system and method |
US7865399B2 (en) * | 2005-04-22 | 2011-01-04 | Google Inc. | Distributed electronic commerce system with centralized point of purchase |
US7640193B2 (en) * | 2005-12-09 | 2009-12-29 | Google Inc. | Distributed electronic commerce system with centralized virtual shopping carts |
US7860751B2 (en) * | 2006-06-27 | 2010-12-28 | Google Inc. | Cross domain customer interface updates |
US8818878B2 (en) * | 2006-06-27 | 2014-08-26 | Google Inc. | Determining taxes in an electronic commerce system |
US7949572B2 (en) * | 2006-06-27 | 2011-05-24 | Google Inc. | Distributed electronic commerce system with independent third party virtual shopping carts |
US9105059B2 (en) * | 2006-06-27 | 2015-08-11 | Google Inc. | Electronic commerce system utilizing custom merchant calculations |
US20080255971A1 (en) * | 2007-04-10 | 2008-10-16 | Epiphany Star Ltd. | Method and system of self-auditing for recovering sales tax |
US20110246318A1 (en) * | 2010-04-05 | 2011-10-06 | Ebay Inc. | Systems and methods for facitiating tax status categorization over a network |
US20120089404A1 (en) * | 2010-10-06 | 2012-04-12 | Microsoft Corporation | Global pricing for content distribution |
US9525548B2 (en) | 2010-10-21 | 2016-12-20 | Microsoft Technology Licensing, Llc | Provisioning techniques |
US8805434B2 (en) | 2010-11-23 | 2014-08-12 | Microsoft Corporation | Access techniques using a mobile communication device |
US9509686B2 (en) | 2010-12-03 | 2016-11-29 | Microsoft Technology Licensing, Llc | Secure element authentication |
US10789653B1 (en) | 2013-06-21 | 2020-09-29 | Citibank, N.A. | Methods and systems for providing a global statement |
US9911160B2 (en) | 2015-06-10 | 2018-03-06 | Rigel Technology Corporation | Tax payment system and method for accurate payments |
AU2016275568A1 (en) * | 2015-06-12 | 2018-01-04 | Billtrader Pty Ltd | Computer implemented multi-currency invoice capture, trading, access and payment system |
US11010731B1 (en) | 2017-02-17 | 2021-05-18 | Wells Fargo Bank, N.A. | Systems and methods for processing global financial transactions |
WO2019217323A1 (en) | 2018-05-06 | 2019-11-14 | Strong Force TX Portfolio 2018, LLC | Methods and systems for improving machines and systems that automate execution of distributed ledger and other transactions in spot and forward markets for energy, compute, storage and other resources |
US11669914B2 (en) | 2018-05-06 | 2023-06-06 | Strong Force TX Portfolio 2018, LLC | Adaptive intelligence and shared infrastructure lending transaction enablement platform responsive to crowd sourced information |
CN109711732A (en) * | 2018-12-27 | 2019-05-03 | 税友软件集团股份有限公司 | A kind of storage method, device, equipment and the storage medium of index integral |
US20210158456A1 (en) * | 2019-11-26 | 2021-05-27 | Avalara, Inc. | Assembling parameters to compute taxes for cross-border sales |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5943657A (en) * | 1994-03-30 | 1999-08-24 | British Telecommunications Public Limited Company | Communications pricing and charging maintenance sub-system and process |
US6330545B1 (en) * | 1993-07-27 | 2001-12-11 | Eastern Consulting Company, Ltd. | Activity information accounting method and system |
US20020052792A1 (en) * | 2000-06-14 | 2002-05-02 | Johnson Kevin C. | Sales tax assessment, remittance and collection system |
US6424706B1 (en) * | 1999-03-31 | 2002-07-23 | Imagine Networks, Llc | Method and system for transferring telecommunication-time units among accounts and exchanging same for goods or services |
US20020156688A1 (en) * | 2001-02-21 | 2002-10-24 | Michel Horn | Global electronic commerce system |
US20020188527A1 (en) * | 2001-05-23 | 2002-12-12 | Aktinet, Inc. | Management and control of online merchandising |
US20030115072A1 (en) * | 2001-12-18 | 2003-06-19 | Rajiv Manucha | Integrated import/export system |
Family Cites Families (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5999913A (en) * | 1997-12-19 | 1999-12-07 | Ncr Corporation | Electronic price label system which displays prices in multiple currencies |
US6477510B1 (en) * | 1999-03-15 | 2002-11-05 | Andrew Johnson, Inc. | Euro booking currency conversion method |
EP1314103A2 (en) * | 2000-04-05 | 2003-05-28 | Ruesch International, Inc. | System, method and apparatus for international financial transactions |
US7412418B2 (en) * | 2002-12-06 | 2008-08-12 | Ocwen Financial Corporation | Expense tracking, electronic ordering, invoice presentment, and payment system and method |
US20040243508A1 (en) * | 2003-05-30 | 2004-12-02 | Samson James A. | Systems and methods for automating credit counseling and debt management programs |
US20050049966A1 (en) * | 2003-06-09 | 2005-03-03 | Legal Systems Holding Company | Ensuring the accurateness and currentness of information provided by the submitter of an electronic invoice throughout the life of a matter using tentative electronic invoice submission |
US7853463B2 (en) * | 2004-04-16 | 2010-12-14 | Capital Projects Software, Llc | Method and system to assess, track and implement capital projects by municipalities |
-
2002
- 2002-08-05 US US10/213,426 patent/US20040024665A1/en not_active Abandoned
-
2006
- 2006-09-11 US US11/519,380 patent/US7966231B2/en not_active Expired - Fee Related
-
2011
- 2011-04-14 US US13/086,715 patent/US20110191216A1/en not_active Abandoned
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6330545B1 (en) * | 1993-07-27 | 2001-12-11 | Eastern Consulting Company, Ltd. | Activity information accounting method and system |
US5943657A (en) * | 1994-03-30 | 1999-08-24 | British Telecommunications Public Limited Company | Communications pricing and charging maintenance sub-system and process |
US6424706B1 (en) * | 1999-03-31 | 2002-07-23 | Imagine Networks, Llc | Method and system for transferring telecommunication-time units among accounts and exchanging same for goods or services |
US20020052792A1 (en) * | 2000-06-14 | 2002-05-02 | Johnson Kevin C. | Sales tax assessment, remittance and collection system |
US20020156688A1 (en) * | 2001-02-21 | 2002-10-24 | Michel Horn | Global electronic commerce system |
US20020188527A1 (en) * | 2001-05-23 | 2002-12-12 | Aktinet, Inc. | Management and control of online merchandising |
US20030115072A1 (en) * | 2001-12-18 | 2003-06-19 | Rajiv Manucha | Integrated import/export system |
Non-Patent Citations (1)
Title |
---|
"Determinants fo Value-Added Tax Revenue: a cross section analysis", Bogetic, Zeljko, Hassan, Farred, World Bank Policy Research Working Paper No. 1203, October 1, 1993 * |
Cited By (54)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20120191719A1 (en) * | 2000-05-09 | 2012-07-26 | Cbs Interactive Inc. | Content aggregation method and apparatus for on-line purchasing system |
US9177059B2 (en) | 2000-05-09 | 2015-11-03 | Cbs Interactive Inc. | Method and system for determining allied products |
US8930370B2 (en) * | 2000-05-09 | 2015-01-06 | Cbs Interactive Inc. | Content aggregation method and apparatus for on-line purchasing system |
US7962391B2 (en) | 2000-12-20 | 2011-06-14 | Jpmorgan Chase Bank, N.A. | System and method for determining elegibility and enrolling members in various programs |
US8255307B1 (en) | 2001-03-01 | 2012-08-28 | Jpmorgan Chase Bank, N.A. | System and method for measuring and utilizing pooling analytics |
US7895098B2 (en) | 2001-03-01 | 2011-02-22 | Jpmorgan Chase Bank, N.A. | System and method for measuring and utilizing pooling analytics |
US20020178098A1 (en) * | 2001-03-01 | 2002-11-28 | Beard Mark L. | System and method for measuring and utilizing pooling analytics |
US8577770B2 (en) | 2001-03-01 | 2013-11-05 | Jpmorgan Chase, N.A. | System and method for measuring and utilizing pooling analytics |
US20030101114A1 (en) * | 2001-11-29 | 2003-05-29 | Delapass Janine L. | System and method for collecting and analyzing tax reporting surveys |
US7756896B1 (en) | 2002-03-11 | 2010-07-13 | Jp Morgan Chase Bank | System and method for multi-dimensional risk analysis |
US7761377B2 (en) * | 2002-08-30 | 2010-07-20 | Sap Ag | Methods and systems for automated generation of bills |
US8538878B2 (en) * | 2002-08-30 | 2013-09-17 | Sap Ag | Methods and systems for automated generation of bills |
US8620807B2 (en) | 2002-08-30 | 2013-12-31 | Sap Ag | Methods and systems for electronic bill presentment and payment |
US20040143548A1 (en) * | 2002-08-30 | 2004-07-22 | Beat Meier | Methods and systems for electronic bill presentment and payment |
US20120265658A1 (en) * | 2002-08-30 | 2012-10-18 | Beat Meier and Peter Goedtler | Methods and systems for automated generation of bills |
US8224749B2 (en) | 2002-08-30 | 2012-07-17 | Sap Ag | Methods and systems for automated generation of bills |
US20100241538A1 (en) * | 2002-08-30 | 2010-09-23 | Sap Ag | Methods and systems for automated generation of bills |
US8032458B2 (en) | 2002-08-30 | 2011-10-04 | Sap Ag | Methods and systems for automated generation of bills |
US7870070B2 (en) | 2002-08-30 | 2011-01-11 | Sap Ag | Methods and systems for electronic bill presentment and payment |
US20040117305A1 (en) * | 2002-08-30 | 2004-06-17 | Beat Meier | Methods and systems for automated generation of bills |
US20110078078A1 (en) * | 2002-08-30 | 2011-03-31 | Sap Ag | Methods and systems for electronic bill presentment and payment |
US7636886B2 (en) | 2003-04-24 | 2009-12-22 | Sureprep Llc | System and method for grouping and organizing pages of an electronic document into pre-defined categories |
US20040216057A1 (en) * | 2003-04-24 | 2004-10-28 | Sureprep, Llc | System and method for grouping and organizing pages of an electronic document into pre-defined catagories |
US7720616B2 (en) | 2003-05-07 | 2010-05-18 | Sureprep, Llc | Multi-stage, multi-user engagement submission and tracking process |
US20090287591A1 (en) * | 2003-05-07 | 2009-11-19 | Sureprep, Llc | Multi-stage, multi-user engagement submission and tracking process |
US8321311B2 (en) | 2003-05-07 | 2012-11-27 | Sureprep, Llc | Multi-stage, multi-user engagement submission and tracking process |
US20040243626A1 (en) * | 2003-05-30 | 2004-12-02 | Sureprep, Llc | System and method for managing login resources for the submission and performance of engagements |
US7454371B2 (en) | 2003-05-30 | 2008-11-18 | Sureprep, Llc | System and method for managing login resources for the submission and performance of engagements |
WO2006020315A2 (en) * | 2004-07-30 | 2006-02-23 | Sureprep, Llc | Creating cross-reference links, tables and lead sheets for tax documents |
WO2006020315A3 (en) * | 2004-07-30 | 2007-04-05 | Sureprep Llc | Creating cross-reference links, tables and lead sheets for tax documents |
US7739160B1 (en) * | 2004-12-22 | 2010-06-15 | Ryan, Inc. | Dynamic, rule-based, tax-decision system |
US7853494B2 (en) | 2005-01-07 | 2010-12-14 | Sureprep, Llc | Efficient work flow system and method for preparing tax returns |
US20070026906A1 (en) * | 2005-07-29 | 2007-02-01 | Research In Motion Limited (A Corp. Organized Under The Laws Of The Province Of Ontario, Canada) | Portable wireless communications device including pickpocket notification and related methods |
USRE45007E1 (en) | 2007-06-20 | 2014-07-08 | Sureprep, Llc | Efficient work flow system and method for processing taxpayer source documents |
USRE47037E1 (en) | 2007-06-20 | 2018-09-11 | Sureprep, Llc | Efficient work flow system and method for processing taxpayer source documents |
US20080319882A1 (en) * | 2007-06-20 | 2008-12-25 | Wyle David A | Efficient work flow system and method for processing taxpayer source documents |
US7769646B2 (en) | 2007-06-20 | 2010-08-03 | Sureprep, Llc | Efficient work flow system and method for processing taxpayer source documents |
US8775408B2 (en) | 2011-09-23 | 2014-07-08 | Sureprep, Llc | Document element indexing system |
CN103578200A (en) * | 2012-07-27 | 2014-02-12 | 精工爱普生株式会社 | Information processing device and control method thereof, server device and control method thereof |
US10685370B2 (en) | 2012-09-16 | 2020-06-16 | American Express Travel Related Services Company, Inc. | Purchasing a reserved item |
US20150271538A1 (en) * | 2012-10-22 | 2015-09-24 | Zte Corporation | System and Method for IPTV Value-added Service Management |
US20150095204A1 (en) * | 2013-09-30 | 2015-04-02 | Mastercard International Incorporated | Processes and Systems for Recovering Refundable Taxes |
US11557001B2 (en) | 2014-04-14 | 2023-01-17 | Lukka, Inc. | Methods, systems, and tools for providing tax related services for virtual currency holdings |
US11823091B2 (en) | 2014-04-14 | 2023-11-21 | Lukka, Inc. | Methods, systems, and tools for providing tax related services for virtual currency holdings |
US11232521B2 (en) * | 2014-04-14 | 2022-01-25 | Lukka, Inc. | Methods, systems, and tools for providing tax related services for virtual currency holdings |
US20170161652A1 (en) * | 2015-12-08 | 2017-06-08 | Formula Technologies, Inc. | Financial Monitoring and Forecasting Systems and Methods |
US20210312346A1 (en) * | 2015-12-08 | 2021-10-07 | Formula Technologies, Inc. | Financial Monitoring and Forecasting Systems and Methods |
US11087380B2 (en) * | 2016-10-26 | 2021-08-10 | American Express Travel Related Services Company, Inc. | Method, article of manufacture, and system for provisioning available appointments |
US20180114195A1 (en) * | 2016-10-26 | 2018-04-26 | American Express Travel Related Services Company, Inc. | Provisioning Available Appointments |
US11314887B2 (en) | 2017-12-05 | 2022-04-26 | Sureprep, Llc | Automated document access regulation system |
US11544799B2 (en) | 2017-12-05 | 2023-01-03 | Sureprep, Llc | Comprehensive tax return preparation system |
US11238540B2 (en) | 2017-12-05 | 2022-02-01 | Sureprep, Llc | Automatic document analysis filtering, and matching system |
US11710192B2 (en) | 2017-12-05 | 2023-07-25 | Sureprep, Llc | Taxpayers switching tax preparers |
US11860950B2 (en) | 2021-03-30 | 2024-01-02 | Sureprep, Llc | Document matching and data extraction |
Also Published As
Publication number | Publication date |
---|---|
US20110191216A1 (en) | 2011-08-04 |
US20070043636A1 (en) | 2007-02-22 |
US7966231B2 (en) | 2011-06-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US7966231B2 (en) | System and method for calculating taxes and multi-currency pricing | |
US7668768B2 (en) | Computer-implemented method for evaluating an investment | |
US20050154662A1 (en) | Asset allocation, rebalancing, and investment management system | |
US7620595B1 (en) | System, method, and computer program product for distributing cash flow or asset interests of a financial product | |
JP2007528066A (en) | Method and system for financing a fund | |
US20130339134A1 (en) | Method and System for Auditing Advertising Agency Performance | |
WO2015121933A1 (en) | Fund raising system | |
US8229822B2 (en) | Computer-implemented method for financial analysis | |
US20120116904A1 (en) | Method and system for paying taxes | |
CN108242022A (en) | A kind of petty load and entrusted loan system and method based on ERP | |
US20040044599A1 (en) | Payment auditing | |
WO2000068861A2 (en) | Benchmark analysis system | |
KR20070022245A (en) | Method and system for advancing funds | |
JPH113376A (en) | Enterprise fund plan simulation system | |
WALAKANDOU et al. | E-Receipt Based Value Added Tax Accounting Treatment at CV Mega Lestari Manado | |
Spahn et al. | Tax modelling for economies in transition | |
KR102152936B1 (en) | Buyer and credit card company tax proxy payment unified managing apparatus and method thereof | |
Yetter et al. | No excuses: Automation advances make sales tax collection easier for everyone | |
WO2005048049A2 (en) | Asset allocation, rebalancing, and investment management system | |
Kalmykova | Application of Accounting Principles in a Collection of Case Studies | |
Cejková et al. | HOW TO ESTIMATE THE SIZE OF CAROUSEL FRAUD? | |
Ueda et al. | Revenue administrafion gap analysis program–The value-added tax gap | |
Patel | Discover SAP ERP Financials | |
Mengstu | Tax Reform and Tax Revenue Collection Performance in Ethiopia (From 2005 to 2013 EFY) | |
Shannon | A Compilation of Analyses of Financial Reporting |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AS | Assignment |
Owner name: FINANCIAL SYSTEMS TECHNOLOGY PTY. LTD., AUSTRALIA Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:FOSTER, ROBERT A.;REEL/FRAME:013906/0364 Effective date: 20030313 |
|
AS | Assignment |
Owner name: FINANCIAL SYSTEMS TECHNOLOGY, AUSTRALIA Free format text: ASSET SALE AGREEMENT;ASSIGNOR:FINANCIAL SYSTEMS TECHNOLOGY;REEL/FRAME:014830/0547 Effective date: 20030701 Owner name: FINANCIAL SYSTEMS TECHNOLOGY,AUSTRALIA Free format text: ASSET SALE AGREEMENT;ASSIGNOR:FINANCIAL SYSTEMS TECHNOLOGY;REEL/FRAME:014830/0547 Effective date: 20030701 |
|
AS | Assignment |
Owner name: FINANCIAL SYSTEMS TECHNOLOGY (INTELLECTUAL PROPERT Free format text: CORRECTIVE ASSIGNMENT TO CORRECT THE ASSIGNEE PREVIOUSLY RECORDED ON REEL 014830 FRAME 0547. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT.;ASSIGNOR:FINANCIAL SYSTEMS TECHNOLOGY PTY LTD;REEL/FRAME:020540/0307 Effective date: 20030701 Owner name: FINANCIAL SYSTEMS TECHNOLOGY (INTELLECTUAL PROPERT Free format text: CORRECTIVE ASSIGNMENT TO CORRECT THE ASSIGNEE PREVIOUSLY RECORDED ON REEL 014830 FRAME 0547. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT;ASSIGNOR:FINANCIAL SYSTEMS TECHNOLOGY PTY LTD;REEL/FRAME:020540/0307 Effective date: 20030701 |
|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |