Information
-
Patent Application
-
20040267620
-
Publication Number
20040267620
-
Date Filed
June 30, 200321 years ago
-
Date Published
December 30, 200420 years ago
-
CPC
-
US Classifications
-
International Classifications
Abstract
A method and system for assessing VAT on marketing services provided via a network-based marketplace are disclosed. VAT is automatically assesses for users of the services having residences in different countries, at least a portion of which require VAT charges for the services. Corresponding data is stored at individual sites operated by the marketplace service. Periodically, VAT-related data are aggregated for each of the plurality of countries to generate respective tax return reports. VAT is accessed for different users based on the country of residence of the user and whether the user has a VAT-exempt status.
Description
FIELD OF THE INVENTION
[0001] The field of invention relates generally to on-line services and, more specifically but not exclusively relates to a method and system for assessing value-added tax (VAT) for services provided to users of both VAT and non-VAT countries by a network-based marketplace.
BACKGROUND INFORMATION
[0002] More and more Internet users are realizing the ease and convenience of buying and selling online by way of person-to-person online trading pioneered by eBay® Inc., San Jose, Calif., the assignee of the present invention. As a result, collectors, hobbyists, small dealers, unique item seekers, bargain hunters, and other consumers are able to buy and sell millions of items at various online trading sites.
[0003] Unlike many types of commerce, the Internet has no physical boundaries. This lets anyone around the world trade with others, regardless of the country in which the traders reside (absent restrictions on certain types of trade of for certain countries). While this is advantageous to many, it creates a tax-collection nightmare for many governments.
[0004] In particular, taxing authorities (i.e., government entities) in the European Union (EU) rely heavily on a form of tax known as a value-added tax. The VAT is applied to nearly every product purchased by residents of EU countries. In contrast, the VAT is (effectively) not levied on non-EU residence; generally, VAT will be paid by a non-EU resident on an item at the point of purchase, and then refunded when appropriate paperwork is submitted to the taxing authority imposing the VAT.
[0005] In addition to products, VAT is also charged on services provided by EU businesses. At the same time, online marketplace sites, such as those hosted by eBay®, derive revenues by offering marketing services to its users. As a result, as of Jul. 1, 2003, the EU has imposed a tax directive requiring online marketplace hosts to collect a VAT for services provided to non-exempt users who reside in EU countries and distribute the collected VAT to the appropriate taxing authorities.
SUMMARY OF THE INVENTION
[0006] In accordance with aspects of the present invention a method and system for assessing VAT on marketing services provided via a network-based marketplace are disclosed. VAT is automatically assesses for users of the services having residences in different countries, at least a portion of which require VAT charges for the services. Corresponding data is stored at individual sites operated by the marketplace service. Periodically, VAT-related data are aggregated for each of the plurality of countries to generate respective tax return reports.
[0007] generating VAT tax return reports for each of the plurality of countries.
[0008] In another aspect of the present invention,
BRIEF DESCRIPTION OF THE DRAWINGS
[0009] The foregoing aspects and many of the attendant advantages of this invention will become more readily appreciated as the same becomes better understood by reference to the following detailed description, when taken in conjunction with the accompanying drawings, wherein like reference numerals refer to like parts throughout the various views unless otherwise specified:
[0010]
FIG. 1 is a schematic block diagram of a system architecture illustrating software and hardware components of a network-based marketplace machine and exemplary client machines;
[0011]
FIG. 2 is a schematic block diagram of a portion of an exemplary database schema employed by the network-based marketplace machine of FIG. 1;
[0012]
FIG. 3 is a schematic block diagram illustrating further details of the database schema of FIG. 2 relating to value added tax (VAT) operations performed by the network-based marketplace machine of FIG. 1;
[0013]
FIG. 4 is a schematic diagram of a VAT assessment model, according to one embodiment of the present invention;
[0014]
FIG. 5 is a representation of a portion of a web-page form displayed to a user illustrating a note relating to a VAT assessment for fees charged in connection with use of marketing services offered by the network-based marketplace machine;
[0015]
FIG. 6 is a representation of a portion of a web-page form displayed to a user corresponding to setting up a future listing;
[0016]
FIG. 7 is a flowchart illustrating operations performed to perform a credit of fees, wherein the debit/credit sequence spans a change in VAT rate for a user;
[0017]
FIG. 8 is a representation of a portion of a web-page form displayed to a user illustrating final value fees that include a built-in VAT charge and a note identifying an applicable VAT rate;
[0018]
FIG. 9 is a representation of a portion an exemplary account status page corresponding to a non-exempt EU-registered user;
[0019]
FIG. 10 is a representation of a portion of an exemplary account status page corresponding to an VAT-exempt EU-registered user;
[0020]
FIG. 11 is a representation of a portion of an exemplary invoice page corresponding to a non-exempt EU-registered user
[0021]
FIG. 12 is a representation of a portion of an exemplary invoice page corresponding to an VAT-exempt EU-registered user;
[0022]
FIG. 13 is a representation of a portion of an exemplary web page form via what a user can enter a VAT identification number;
[0023]
FIG. 14 is a schematic diagram illustrating a timeline and corresponding operations related to a user's VAT charges across two billing cycles when a user changes his country of residence;
[0024]
FIG. 15 is a flowchart illustrating operations performed to generate VAT tax returns and distributed collected VAT to appropriate taxing authorities;
[0025]
FIG. 16 is a schematic diagram illustrating VAT-related data generated on various on-line marketplace sites in Europe, the United States, and Canada that are sent to a data warehouse and processed to generate VAT reports;
[0026]
FIG. 17 is a schematic diagram illustrating aspect of the VAT report-generation process, including details of an EOM interim balance table containing VAT-related data that is processed to generate the VAT reports; and
[0027]
FIG. 18 is a schematic diagram illustrating components of an exemplary computer server that may be employed to execute various software components to implement the method operations disclosed herein.
DETAILED DESCRIPTION OF PREFERRED EMBODIMENTS
[0028] Embodiments of method and apparatus for calculating, collecting, reporting and distributing collected value-added taxes in connection with services provided by online marketplace sites are described herein. In the following description, numerous specific details are set forth to provide a thorough understanding of embodiments of the invention. One skilled in the relevant art will recognize, however, that the invention can be practiced without one or more of the specific details, or with other methods, components, materials, etc. In other instances, well-known structures, materials, or operations are not shown or described in detail to avoid obscuring aspects of the invention.
[0029] Reference throughout this specification to “one embodiment” or “an embodiment” means that a particular feature, structure, or characteristic described in connection with the embodiment is included in at least one embodiment of the present invention. Thus, the appearances of the phrases “in one embodiment” or “in an embodiment” in various places throughout this specification are not necessarily all referring to the same embodiment. Furthermore, the particular features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
[0030] Terminology/Definitions
[0031] The present invention concerns facilities for the determination, collection, and distribution of value-added taxes imposed for services rendered by online marketplace sites. In order to better understand the principles disclosed herein, the following definitions are provided, wherein:
[0032] Value Added Tax (VAT):
[0033] A tax charged on a good or service delivered. VAT referred to herein concerns value added taxes incurred for services rendered ((i.e. the online marketplace service fees to the seller), not the goods traded between seller and buyer.
[0034] VAT-registered Sellers (=VAT-exempt):
[0035] The EU directive requires the online marketplace host to handle sellers differently when charging VAT, depending on whether the sellers are VAT-registered businesses in any EU member state or not. VAT-registered sellers whose VAT-ID has been verified and approved by the online marketplace host are termed “VAT-exempt” and are not to be charged VAT.
[0036] Non-VAT-registered Sellers (a.k.a. Private Sellers):
[0037] Related to the above, this specification refers to sellers who are not VAT registered as non-VAT registered sellers or also as private sellers.
[0038] Local EU Users:
[0039] Country of residence of a seller equals country of the site that is being referred to.
[0040] Foreign EU Users:
[0041] Country of residence of a seller in EU but not in the country of the site that is being referred to.
[0042] Non-EU Users:
[0043] Country of residence of a seller outside EU (e.g. US, Switzerland, Australia)
[0044] Actual Gross:
[0045] Net+VAT of country where seller resides.
[0046] Local Gross:
[0047] Net+VAT of country of the site that is being referred to.
[0048] Net:
[0049] Amount excluding VAT—this amount is identical for all sellers on a certain site.
[0050] Fees:
[0051] All amounts charged to the user directly related to selling activity on the online merchant sites, i.e. insertion fees, final value fees, featured fees, subscription fees (e.g. for selling manager, etc.)
[0052] Finance Charges
[0053] Charges to users not related to direct selling activity, but rather to banking processes (e.g. Direct Debit charge-backs, Check return fees, etc).
[0054] Network-Based Marketplace Facility
[0055]
FIG. 1 shows and exemplary architecture 100 implemented by a network-based (i.e., on-line) facility that provides on-line marketplace services to various EU and non-EU users in accordance with one embodiment of the invention. On-line marketplace services are hosted by a network-based marketplace machine 102 that is operated via execution of various software components on corresponding hardware components. The network-based marketplace machine 102 includes one or more of a number of types of front-end servers, namely communications servers in the exemplary form of an application program interface (API) servers 104, page servers 106 that deliver web pages (e.g., markup language documents), picture servers 108 that dynamically deliver images to be displayed within Web pages, listing servers 110, processing servers in the exemplary form of CGI (or ISAPI) servers 112 that provide an intelligent interface to back-end servers, and search servers 114 that handle search requests to the network-based marketplace machine 102. The architecture also includes e-mail servers 116 that provide, inter alia, automated e-mail communications to users of network-based marketplace machine 102.
[0056] Data corresponding to service transactions and the like are stored in databases hosted by various back-end servers, including a database engine server 118, a search index server 120 and a credit card database server 122, each of which maintains and facilitates access to a respective database 124, 126, and 128. In addition, various administrative applications and functions performed by network-based marketplace machine 102 are depicted by a block
[0057] The network-based marketplace machine 102 facilitates on-line trading activities between buyers and sellers via services embodied as an on-line marketplace, such as the on-line marketplace hosted by eBay®. The services are provided via markup language-based pages (e.g., HTML-based Web pages) that are hosted by network-based marketplace machine 102 and served to client machines operated by the various seller and buyer users of the service via a network 132; these client machines are collectively represented by a buyer client machine 134 and a seller client machine 136. The network 132 may be embodied as an Internet, a LAN, a WAN, PSTN, Frame Relay, ATM, satellite communications, wireless communications, combinations thereof, or any other network equipment or protocol that enables electronic communication between the above described network entities.
[0058] In addition to other software components that are not illustrated, each of buyer and seller client machines 134 and 136 includes a client communication program 138. The client communication program 138 enables a user to display web pages or e-mail that are loaded from server computers. In one embodiment, client communication program 138 is embodied as a browser (e.g., the Microsoft Internet Explorer browser developed by Microsoft™ Corporation of Redmond, Wash. or the Navigator™ browser developed by Netscape of Mountain View, Calif.). The client communication program 138 executes under an operating system (e.g., Microsoft™ Windows developed by Microsoft™ Corporation or Mac OS X developed by Apple Computers of Cupertino, Calif.) running on a processing core (both not shown). The client communication program 138 may also be embodied as a mail client (e.g., the Microsoft Outlook personal information manager or Lotus Notes™ developed by the Lotus Notes Development Corporation.
[0059] A portion 200 of a database schema implemented by database 124 is shown in FIG. 2. In one embodiment, database 124 may be implemented as a relational database, and includes a number of tables having entries, or records, that are linked by indices and keys. In an alternative embodiment, database 124 may be implemented as a collection of objects in an object oriented database.
[0060] Central to database 124 is a user table 202, which contains a record for each user of services provided by network-based marketplace machine 102. The user may operate as a seller, buyer, or both, within the context of the network-based marketplace. Database 124 also includes listings table 204 that may be linked to user table 202 and a listing association table 206. In general, a user record in the user table 202 may be linked to multiple items that are being, or have been, transacted via network-based marketplace machine 14. Recorded transactions are stored in a transaction record table 208. Detailed user information is stored in a user information table 210. A number of other tables are also shown to be linked to the user table 202, namely a user past aliases table 212, a bids table 214, an account table 216, a fee table 218 and a purchase history table 111.
[0061] Database 124 may also include a note table 220 populated with note records that may be linked to one or more listing records within listings table 204 and/or to one or more user records within the user table 202. Each note record within the note table 210 may include, inter alia, a comment, description, history or other information pertaining to an item being auctioned via the network-based marketplace machine 102, or to a user of the network-based marketplace machine.
[0062] A masters categories table 222 stores records for listing categories presented across multiple views (or presentations) of list categories via regional or community sites presented by the network-based marketplace machine 102. A site categories table 224 stores records indicating which item categories are to be presented for respective regional or community sites (e.g., a country, region or city specific site) presented by the network-based marketplace machine 102.
[0063] In addition to the foregoing tables, database schema 200 also shows a plurality of VAT tables 226. The plurality of tables are employed to generally depict corresponding tables used for VAT-related purposed, including a portion of the tables comprising a portion 300 of the database schema shown in FIG. 3.
[0064] In addition to the aforementioned table, database schema portion 300 includes a VAT rate table 302, an EOM (end of month) interim balance table 304. As discussed in further detail below, instances of various tables are copied to a data warehouse 308 and stored in a database 310, whereby VAT reports (i.e., tax returns) 312 may be generated.
[0065] VAT rate table stores the VAT rate for services, by EU country, for a given time period. (It is noted that the columns relating to the time period are not shown in FIG. 3 for clarity). For example, the VAT rate varies for different EU countries. Furthermore, the VAT rate for a given country may change over time. Storing the historical VAT rates enables auditing to be performed of transactions that occurred prior to new VAT rates going into effect, and for appropriate VAT rates to be applied for each billing cycle. EOM Interim balance table is used to store VAT-related data corresponding to user activities with the on-line marketplace service.
[0066] Rules for VAT Calculation
[0067] On-line marketplace services are required to charge VAT to all non-VAT registered sellers residing in an EU member state for their activity on all EU sites. EU resident sellers who are VAT-registered will in fact not be charged VAT, but rather are required to assess the VAT themselves (and pay to their local tax authorities) after having received an invoice from the non-EU supplier (such as eBay®), which invoices a net amount, excluding VAT. All non-EU residents will not be charged VAT for any activity on any marketplace site (including EU sites), no matter whether they are VAT-registered in their country of residence or not. These users are generally not affected by VAT considerations, except for special messaging on Help and Sell your item (SYI) pages of EU sites. These rules are graphically depicted in Table 1 below:
1TABLE 1
|
|
Seller Country of
ResidencePrivate SellerVAT Registered
|
EUCharge VATDo not charge VAT
Non-EUDo not charge VAT
|
[0068] VAT will be charged on all fees paid for on-line marketplace services (e.g. insertion fees, final value fees, subscription fees). Finance charges are not subject to VAT. All goods and services traded between sellers and buyers on on-line marketplace's sites are not considered herein for VAT purposes.
[0069] The VAT rate applicable for each user is determined by the country of residence of the user. For example, a German resident who registers on eBay® with a German address will always be charged German VAT rate even if he is trading on another EU-Website, e.g. http://www.ebay.fr (eBay's France site). The VAT for each user will be assessed at the time of invoice, per the then-current VAT rate for the full invoice cycle (e.g., once a month). Therefore, changes to VAT rates always lead to the activity of the full cycle to be charged per the new VAT rate.
[0070] VAT Calculation Data Model
[0071] A VAT calculation data model 400 employed for calculating and displaying VAT charges in accordance with a typical listing process is shown in FIG. 4. In accordance with a predetermined fee schedule, a fee for a listing is calculated and stored in Fee table 218. The following operations contained in an SYI block 400 are then performed.
[0072] In a first step, the applicable local gross amount of the fee is fetched from Fee table 218. In a second step, the applicable VAT rate based on the site is determined. For example, if the user is using a German site hosted by the on-line marketplaces service, the German VAT rate would apply, and the VAT rate would be retrieved from VAT rate table 302 by querying for the VAT rate applicable for Germany (via, e.g., a corresponding 2-character EU country code). Next, in a step 3 the net is calculated using a formula of:
round(gross/(1+VAT rate), 6) Eq. 1
[0073] which produce a 6-decimal net value.
[0074] In a step 4, the applicable VAT rate based on a combination of the site, country of residence, and VAT status is determined. This involves determining a VAT status of the user; determining a registration country of the user if the VAT status indicates VAT is applicable to the user; and querying VAT rate table 302 with the user's country code to retrieve the applicable VAT rate.
[0075] In a step 5 the gross is recalculated using the rounded 6 decimal net calculated above in step 3 using a formula of
round(net*1+VAT rate), 2) Eq. 2
[0076] The recalculated gross amount is then displayed to the user.
[0077] The next operations discussed in the model of FIG. 4 concern the steps listed in an account status box 402. First, the total amount owed by the user from the most-recent previous invoice fetched. In a second step, the net amounts from account table 216 are fetched and a running total is calculated. The applicable VAT rate based on a combination of the site, user country of residence, and VAT status is then determined in a step 3. Finally, the total VAT is calculated using the following equation in a step 4:
round(total net*VAT rate), 6) Eq. 3
[0078] The final set of operations corresponding to the model are shown in a block 404, which concerns invoicing. In a first step, the total amount from the most-recent previous invoice is fetched. In a step 2, the net amounts from account table 216 is fetched and the total net is calculated, rounded to 2 decimals. In a step 3, the applicable VAT rate based on the user's country of residence at the time of invoicing is determined.
[0079] Next, in a step 4, the total VAT is calculated using the equation:
round(total net*VAT rate), 2) Eq. 4
[0080] Subsequently, in a step 5 the total gross is calculated using the equation:
round(total net*(1+VAT rate), 2) Eq. 5
[0081] In a sixth step the payment and credits for the user are fetched from account table 216. The total amount is then calculated in a step 7 using the equation:
round(total amount previous invoice+total gross payments−credits, 2) Eq. 6
[0082] In a step 8 the total net, VAT, and total amount are then written to the user's invoice.
[0083] In addition to listing fees, service fees are also assessed based on the selling price of an item. These fees are known as final value fees (FVF) and are calculated as follows. In general, when calculating the FVF, the FVF percentage is applied to the final price (winning bid or By it now™-price) of the item, then the deduct VAT of the site of the listing is deducted; this result is rounded to 6 decimal digits and store as the net amount. At invoice time, the VAT is assessed based on the rules for the user. The net FVF for a single item is calculated by:
NET FVF
=ROUND[Final Price*FVF-Rate/(1+VAT-Rate of Site); 6] Eq. 7
[0084] For example:
[0085] NET FVF=Final Price EUR 10,00; FVF Rate 5,00% (inc. VAT-Rate 20%)
[0086] NET FVF=10,00*0,05/(1+0,2)=0,416666666 . . . round to =0,416667
[0087] For multiple item listings having the same price, the foregoing (Eq. 7) calculation is applied to each item. For Dutch auctions, the NET single item FVF (Eq. 7) is first calculated and then multiplied with the number of items sold (again rounding to 6 decimal digits). The result will be stored in account table 216 as a multi-item net FVF. The calculation is shown below:
NET
Dutch FVF=ROUND [ROUND (Final Price*FVF-Rate; 6)*Qty Sold/(1+VAT-Rate of Site); 6] Eq. 8
[0088] For example:
[0089] NET Dutch FVF=Final Price EUR 10,50; 12 Items Sold, FVF Rate 5,00% (inc. VAT-Rate 19,6%)
[0090] NET Dutch FVF=11,20*0,05=0,560000 (rounded to 6 decimal digits, if required)
[0091] 0,560000*12/(1+0,196)=5,618729096989 . . . round to =5,618729
[0092] The general rule for display fees on SYI pages, is to display the actual gross amount for each user on EU-sites. Two decimal digits shall be displayed. For Non-EU sites there are no changes. The display rules are shown below in Table 2, wherein examples correspond to a user of eBay's German site.
2TABLE 2
|
|
EU-Sites
Type of UserNon-VAT Registered (Private)VAT Registered
|
Local EU ResidentActual Gross (= Local Gross),Actual Gross (= Local Gross),
[e.g. German Resident]incl. local VATincl. local VAT
[e.g. ebay.de Gross fee][e.g. ebay.de Gross fee]
Foreign EU ResidentActual Gross, incl. actual VATActual Gross, incl. actual VAT
[e.g. French Resident][e.g. Local ebay.de Gross fee,[e.g. Local ebay.de Gross fee,
adjusted by French VAT rate]adjusted by French VAT rate]
Non-EU ResidentNet (= Actual Gross), incl. 0%n/a
[e.g. USA Resident]VAT
[e.g. Local ebay.de Gross fee,
deducted by DE VAT rate]
|
[0093] As discussed above EU residents are use to paying prices for goods and services that have the VAT already build into the price. Thus, individual listing, invoicing, and account balance information is displayed to EU users in a manner that doesn't explicitly indicate individual VAT assessments—rather the VAT assessments are rolled into the listed fees. However, a statement is provided indicating to the user that the fees include a VAT charge, identifying the rate and the EU country. For example, a portion of a typical SYI fee review page 500 showing listing fees for an exemplary item listing is shown in FIG. 5. A statement 502 indicates a VAT rate 504 (20%) is being assessed for residents of a country 506 (Germany). The displayed rate is and country correspond to the user, rather than the site, and are thus generated dynamically based on the user's Country ID.
[0094] In addition to listing items for immediate (after confirmation) bid availability, users of network-based marketplace 102 may also set up listings for auctions or fixed priced sales that will occur at a future date. Accordingly, since the actual service (i.e., the listing of the item) will not be performed until the future point in time, the actual VAT assessment will likewise not take place until that time. Therefore, a note is provided to the user at the time of preparing the listing identifying that the actual listing fee charges will be determined at the time the listing goes into effect, as depicted by a note 602 on a portion of an SYI fee review page 600 in FIG. 6.
[0095] Another consideration relates to revising a listing. A common parameter that is revised is the price of an item. This creates an interesting situation with regard to VAT assessment. Since listing fees may depend on a listing price, a change in price may result in an increased or reduced listing fee. Additional charges (due to raising the start price) or partial credits (in case of lowering the start price, are handled by the network-based marketplace machine 102 through fully crediting the original charge and debiting the full new charge.
[0096] Regarding the VAT calculation, these credits will be handled in a manner similar to other item-related credits. Therefore, for revise credits, the “net” portion (i.e. excluding tax) of the fee based on the original fee charged at listing time of the item will be credited. The additional “tax” portion of the credit will be based on the current VAT-rate instead.
[0097] This process is illustrated in the flowchart of FIG. 7. The process begins in a block 700, wherein the item listing fees (i.e., insertion fees) are determined when an item is originally listed based on the net insertion fee and the VAT rate for the cycle corresponding to the original date. For example:
[0098] Original item listed on July 14:
[0099] net insertion fee=$10
[0100] tax rate based on cycle (July 15) covering July 14=2%
[0101] VAT=$0.20
[0102] total fee=$10.20
[0103] Next, in a block 702, a credit for the full net insertion fee based on the original listing date is provided. In addition, a VAT credit relating to the original net insertion fee amount is made. However, the VAT credit is based on the VAT rate for the cycle corresponding to the revision date rather than the original date. Continuing with the example;
[0104] Revise the item on July 18:
[0105] net insertion fee credit (based on July 14)=$10
[0106] tax rate based on cycle (August 15) covering July 18=3%
[0107] VAT credit=$0.30
[0108] total credit=$10.30
[0109] The process is completed in a block 704, wherein a new debit charge is incurred corresponding to the new net insertion fee plus the VAT. In this case, the VAT rate is based on the cycle corresponding to the revision date. Continuing with the example:
[0110] new net insertion fee (based on July 18)=$20
[0111] tax rate based on cycle (August 15) coving July 18=3%
[0112] VAT=$0.60
[0113] total fee=$20.60
[0114] Relists, including bulk relists, are handled in a similar manner to revised items—that is, the credits and new debits reflect the VAT rate for the cycle corresponding to the date on which the relists occur.
[0115] In addition to including VAT rates in displayed listing fees, final value fees including built-in VAT charges are also shown to users. For example, an SYI listing fee page 800 shown in FIG. 8 contains an FVF fee section 802 delineating final value fees based on the final sale price. SYI listing fee page 800 also includes a note 804 indicating that the fees include a VAT rate for a corresponding country, as depicted by a VAT rate field 806 and a Country field 808. It is noted that when SYI listing fee page 800 is rendered, VAT rate field 806 and a Country field 808 will contain appropriate values for a current user.
[0116] The account status pages available to users vary dependent on whether the user is registered EU user. In short, non-EU users will be presented with account information that does not include any VAT-related data, while EU users will be provided with account information that includes VAT-related data.
[0117] A portion of an exemplary account status page 900 corresponding to an EU-registered user (non-exempt) is shown in FIG. 9. The account status page includes three VAT-related columns: a VAT rate column 902, a net amount column 904, and a gross amount column 906. The VAT rate column 902 lists the VAT rate charged for a given fee entry. Values in net amount column 902 correspond to the actual fee amount to which the VAT rate is applied for a given fee, while the values in gross amount column 906 reflect the total fee charged for the given fee entry.
[0118] By comparison, a portion of an exemplary account status page 1000 corresponding to a VAT-exempt EU-registered user is shown in FIG. 10. Notably, there are no debit charges shown in gross amount column 906, since the net and gross amounts are the same when no VAT is assessed. Also illustrated in the page is a credit entry 1002 for a VAT credit for the month of July. As described in further detail below, in response to a request to change a user's VAT status (entered by the user), there is a time period between the time of the request and the time of confirmation during which VAT is still assessed. Any assessed VAT accrued prior to confirmation of the user's VAT status is remitted to the user as a credit.
[0119] Both the Account Status and the Invoice requirements are specific to the user's country of registration (i.e., COUNTRY ID). Both sections do not follow the SITE ID logic. For example, the logic on the US site will be dependent on the country of residence of the user, resulting in different site behaviour between DE (German) and US users: US users will be treated as non-EU residents, with no changes vs. the current status quo; DE users will be treated as EU-residents with the behaviour for EU-residents defined herein.
[0120] A portion of an exemplary invoice page 1100 is shown in FIG. 11. Each invoice includes three sections: a header 1102, an invoice summary table 1104, and a detailed invoice section (not shown). The detailed invoice section contains information similar to that shown above with reference to the account balance pages of FIGS. 9 and 10, and, as before, the specific format of this section will reflect the VAT status of the user.
[0121] The header 1102 contains information specifically required by the EU authority for the site, such as a particular AG VAT identification number 1106, and a registration number 1106 issued to the on-line marketplace service. The header also includes user-specific information, such as name, address, account number, etc.
[0122] The invoice summary table 1104 shows summary information for fees, payments, and credits. In the illustrated example, the fees include both vatable fees 1106 (i.e., those fees for which VAT assessments are made), and non-vatable fees 1108.
[0123] Header and summary portions of an invoice page 1200 corresponding to an VAT-exempt EU user are shown in FIG. 12. In this instance, header 1102 will further contain a VAT identification number 1202 and a VAT status 1204. Further note that the invoice summary table 1104 for this type of invoice will not include any VAT entries since VAT is not assessed for VAT-exempt users.
[0124] The invoice summary table 1104 will include information calculated by an invoicing program based on the rules shown in the following table:
3TABLE 3
|
|
TYPEDISPLAY AND CALCULATION RULES
|
Total NetSum of all net debits for the billing period, rounded to 2
Feesdecimal digits
VAT-RateVAT-rate (in %) depending on country of residence at
invoicing time, applicable for full cycle*), displayed in memo
line.
Do not show for VAT-exempt users.
VATTotal net multiplied with VAT-rate, rounded to 2 decimal
Amountdigits, displayed in memo line.
Do not show for VAT-exempt users.
TotalTotal net for cycle plus VAT amount for cycle, rounded to 2
Grossdecimal digits
FeesDo not show for VAT-exempt users.
PreviousPulled from EOM table
Amount
Due
PaymentsSum of all Payments received during the billing cycle, plus
andsum of all credits received (incl. VAT where applicable),
Creditspulled from accounts table.
CurrentFor private sellers:
TotalTotal Gross for Cycle plus Previous Balance
Balanceminus Payments & Credits
For VAT-registered sellers
Total Net for Cycle plus Previous Balance
minus Payments & Credits
Round to 2 decimal digits in either case.
TotalSum of Total Gross Fees, Previous Amount Due, Payments
Amountand Credits.
Due
|
[0125] VAT-Exemption Process
[0126] The following section defines the process and the functionality by which VAT-registered users can obtain a VAT-exemption status, in order not to be charged VAT on services rendered by the on-line marketplace site. Generally, users are required to submit their European VAT-ID to the on-line marketplace. The on-line marketplace will the perform a validation check (e.g., via confirmation with an appropriate taxing authority) on the ID once received and then approve or deny the VAT-exempt status based on the outcome of the verification. In one embodiment, a VAT-exemption status request can be entered by logging into the on-line marketplace site and navigating to a VAT-exempt status request form 1300 and entering the VAT ID, as shown in FIG. 13. A pull-down control 1302 is provided to enable the user to select an appropriate country code for the VAT ID, which is entered in a text box 1306. Based on pre-defined identification number patterns for each EU country, a mask is employed to verify the entered VAT ID is of proper form for the country selected via pull-down control 1302. In one embodiment an initial verification check is performed by observing whether or not the country code selected for the request matches the registered country for the user. In a similar manner, users are enabled to update and delete VAT ID's via corresponding forms (not shown).
[0127] Information (i.e., status codes) corresponding to the VAT status for each user is stored in database 124. An exemplary set of status codes is shown below in Table 4. In one embodiment, the VAT-exempt status data is stored in user information table 210.
4TABLE 4
|
|
VAT-Exempt StatusCode
|
|
VAT-exemption not applied for0
VAT-exemption pending approval (i.e. VAT-ID submitted)1
VAT-exemption granted2
VAT-exemption status denied3
Active VAT-ID deleted by on-line marketplace site−1
Active VAT-ID deleted by user−2
|
[0128] The moment the user receives the VAT-exempt status, the VAT amount charged applies for all full billing cycles for the period between initial VAT-ID submission and the VAT-exempt status approval (for that same VAT-ID, in case of submission of multiple IDs) is automatically credited in the user's account as a VAT-only credit. For this process, an aggregation of the VAT charged for the full billing cycles in question is performed, and a one-time VAT credit is issued, as illustrated above as VAT credit 1002 in FIG. 10.
[0129] Handling User Moves Between EU Countries
[0130] Due, in part, to the proximity between EU countries in combination with the large number of EU users, there are likely to be many instances in which users move from one EU country to another. Users may change their country of residence on any sites managed by the on-line marketplace service by updating the address of their user profile. Whenever a user changes his/her country of residence, a new VAT-rate is applicable for the user, unless the user is already VAT-exempt or changes his country of residence from Non-EU country to another Non-EU country. This creates additional tax considerations due to a likely change in the VAT rate, especially with respect to refunds for changes made to a particular listing before an after a move. However, for simplicity, whenever a change in the VAT-rates occurs due to a user's moving to a new country, the billing system will apply the VAT-rate at time of the invoicing run. If the user changes his country of residence to a higher VAT-rate he will be charged the higher VAT rate for all transactions in that billing cycle (including transactions before the date of change).
[0131] An exemplary use case illustrating a scenario where a user changes residence from Germany to France is shown in FIG. 14. In a first step on January 3, the user (i.e. Seller) lists an item for auction, and is charged an insertion fee of 0.50 (Net), which is recorded in account table 216. In a second step on January 10, the end of auction (EOA) occurs, with an unsuccessful result (no winning bid). On January 12, the Seller than revises the listing in accordance with a third step, incurring another insertion Fee of 0.50 (Net). On January 15, during a fourth step an invoice is created using the VAT rate for the Seller's residence (Germany) on that date. The resulting invoice includes:
[0132] Total Net=−1.00
[0133] VAT (16%)=−0.16 [German Tax liability]
[0134] Total Due=−1.16
[0135] At step 5 on January 20, the second auction ends successfully. The insertion fee recorded in step 3, 0.50, is credited. At a final step 6, a new invoice is generated on February 15, this time using the VAT rate for the Seller's new residence (France). This yields the following result.
[0136] Total Net=0.50
[0137] VAT (19.6%)=0.10 [French Tax Liability]
[0138] Total Due =0.60
[0139] It is noted that VAT is still calculated on negative totals for consistency.
[0140] To enable detection of potential tax fraud resulting from a user changing his country of residence and changing it back afterwards (e.g. with respect to a large fee transaction or set of transactions, following data are tracked (via storage in user audit table 306 and pass on to data warehouse 310.
[0141] Date of change (of country of residence)
[0142] Initial Country ID (before change)
[0143] New country ID (after change)
[0144] Given these data, the user's changes between different countries can be tracked for tax fraud purposes.
[0145] Reporting to Tax Authorities and Collected VAT Distribution
[0146] Collected VAT and VAT activities are reported to an appropriate tax authority on a periodic basis, which in one instance is quarterly. The reporting should provide sufficient information for internal accounting purposes as well as for tax return submissions to each EU member state. In one embodiment, a single report for all countries is submitted to one local EU tax authority, with country-specific information provided for each EU member state.
[0147] The quarterly return shall be made in Euro. If fees have been charged in other currencies, a currency conversion is performed, wherein the valid exchange rate is for the last date of the reporting period. The exchange is done following the exchange rates published by the European Central Bank for the day in question (or, if there is no publication on that day, on the next day of publication).
[0148] From a tax perspective, the following information is to be filed for each return:
[0149] Total Net amount by jurisdiction
[0150] VATable Net amount by jurisdiction
[0151] Non-VATable Net amount by jurisdiction with a break out for Business exempt revenue
[0152] VAT charged for the period
[0153] VAT credits given in the period
[0154] With reference to the flowchart of FIG. 15, and FIGS. 16 and 17, a tax reporting processes in accordance with one embodiment is performed in the following manner. In a block 1500, all VAT-related data 1602 is forwarded from each site operated by the on-line marketplace service, such as depicted in FIG. 16, wherein respective network-based marketplace machines 102 operating in the United States (USA), Canada, Germany, France, Italy, Spain, and the United Kingdom (UK) forward respective instances of VAT-related data 1602 to data warehouse 308 to be stored in database 310.
[0155] In one embodiment, the pertinent VAT-related data is stored in EOM interim balance table 304. An exemplary set of VAT-related columns corresponding to interim balance table 304 is shown in FIG. 17. These columns include a USER ID column 1700 which is used to link to other tables in database 124 for corresponding primary key-foreign key relationships. A CURRENCY ID column 1702 contains a code that identifies the currency employed by the user (e.g., Pounds, Francs, Euros, etc.). The user's country of residence is identified by a COUNTRY ID column 1704.
[0156] Information indicating whether or not a user is (VAT) tax-exempt is contained in a TAX EXEMPT STATUS column 1708. Total and local net VATable amounts are respectively stored in VATABLE NET AMOUNT and VATABLE NET AMOUNT LOCAL columns 1710 and 1712. Total and local net non-VATable amounts are respectively stored in NON-VATABLE NET AMOUNT and NON-VATABLE NET AMOUNT LOCAL columns 1714 and 1716. Applicable VAT rates for a given billing cycle are stored in a VAT RATE column 1718.
[0157] The total VAT due is stored in a VAT DUE column 1720, while a local VAT due is stored in a VAT DUE LOCAL column 1722. Total and local VAT credits are respectively stored in VAT CREDIT column 1724 and 1726. Finally, a code identifying each site corresponding to a respective user is stored in a SITE_ID column 1728.
[0158] As indicated by start and end blocks 1502 and 1504, operations contained in blocks 1506, and 1508 are performed for each EU member state (i.e., country). First, in block 1506, data contained in EOM interim balance table 304 are aggregated based on COUNTRY ID. At the same time (or prior thereto), any necessary currency conversions are performed. In a block 1508, a tax return 1700 is generated for the currently-processed EU member country. Details of how various VAT data are obtained for tax return 1700 are shown in a table 1702.
[0159] In general, individual tax returns and collected VAT may be returned to an appropriate taxing authority for each EU member. Optionally, as depicted in a block 1510, all of the reports and collect VAT may be sent to a single taxing authority. As discussed above, in this instance the currency will be Euros.
[0160] Exemplary Computer Server System
[0161] With reference to FIG. 18, a generally conventional computer server 1800 is illustrated, which is suitable for use in connection with practicing embodiments of the present invention. For example, computer server 1800 may be used for running the various software applications, modules, and components discussed above, such as those employed by network-based marketplace machine 102. Typically, a plurality of computer servers 1800 may be employed in a well-known N-tier configuration, including front-end web servers, back-end database servers, and middle-tier application servers. Examples of computer systems that may be suitable for these purposes include stand-alone and enterprise-class servers operating UNIX-based and LINUX-based operating systems, as well as servers running the Windows NT or Windows 2000 Server operating systems.
[0162] Computer server 1800 includes a chassis 1802 in which is mounted a motherboard 1804 populated with appropriate integrated circuits, including one or more processors 1806 and memory (e.g., DIMMs or SIMMs) 1808, as is generally well known to those of ordinary skill in the art. The circuitry and components contained in chassis 1802 are powered one or more power supplied (not shown). A monitor 1810 may be provided for displaying graphics and text generated by software programs and program modules that are run by the computer server. A mouse 1812 (or other pointing device) may be connected to a serial port (or to a bus port or USB port) on the rear of chassis 1802, and signals from mouse 1812 are conveyed to the motherboard to control a cursor on the display and to select text, menu options, and graphic components displayed on monitor 1810 by software programs and modules executing on the computer. In addition, a keyboard 1814 is coupled to the motherboard for user entry of text and commands that affect the running of software programs executing on the computer. Computer server 1800 also includes a network interface card (NIC) 1816, or equivalent circuitry built into the motherboard to enable the server to send and receive data via a network 1818.
[0163] File system storage may be implemented via a plurality of hard disks 1820 that are stored internally within chassis 1802, and/or via a plurality of hard disks that are stored in an external disk array 1822 that may be accessed via a SCSI card 1824 or equivalent SCSI circuitry built into the motherboard. Optionally, disk array 1822 may be accessed using a Fibre Channel link using an appropriate Fibre Channel interface card (not shown) or built-in circuitry, or a NAS storage array may be employed.
[0164] Computer server 1800 generally may include a compact disk-read only memory (CD-ROM) drive 1826 into which a CD-ROM disk may be inserted so that executable files and data on the disk can be read for transfer into memory 1808 and/or into storage on hard disk 1820. Similarly, a floppy drive 1828 may be provided for such purposes. Other mass memory storage devices such as an optical recorded medium or DVD drive may also be included. The machine instructions comprising the software components that cause processor(s) 1806 to implement the operations of the present invention that have been discussed above will typically be distributed on floppy disks 1830 or CD-ROMs 1832 (or other memory media) and stored in one or more hard disks 1820 until loaded into memory 1808 for execution by processor(s) 1806. Optionally, the machine instructions may be loaded via network 1818 as a carrier wave file.
[0165] Thus, embodiments of this invention may be used as or to support a software program executed upon some form of processing core (such as the CPU of a computer) or otherwise implemented or realized upon or within a machine-readable medium. A machine-readable medium includes any mechanism for storing or transmitting information in a form readable by a machine (e.g., a computer). For example, a machine-readable medium can include such as a read only memory (ROM); a random access memory (RAM); a magnetic disk storage media; an optical storage media; and a flash memory device, etc. In addition, a machine-readable medium can include propagated signals such as electrical, optical, acoustical or other form of propagated signals (e.g., carrier waves, infrared signals, digital signals, etc.).
[0166] The above description of illustrated embodiments of the invention, including what is described in the Abstract, is not intended to be exhaustive or to limit the invention to the precise forms disclosed. While specific embodiments of, and examples for, the invention are described herein for illustrative purposes, various equivalent modifications are possible within the scope of the invention, as those skilled in the relevant art will recognize.
[0167] These modifications can be made to the invention in light of the above detailed description. The terms used in the following claims should not be construed to limit the invention to the specific embodiments disclosed in the specification and the claims. Rather, the scope of the invention is to be determined entirely by the following claims, which are to be construed in accordance with established doctrines of claim interpretation.
Claims
- 1. A method comprising:
automatically assessing value-added tax (VAT) for services rendered by a network-based marketplace service for respective users having residences in a plurality of countries requiring VAT charges for the services; storing data related to the VAT assessed for the services; aggregating the data to generate VAT assessment totals for each of the plurality of countries; and generating VAT tax return reports for each of the plurality of countries.
- 2. The method of claim 1, wherein the VAT is accessed, in part, by performing operations including:
determining if a user is a resident of a country for which VAT is not applicable; and not accessing VAT for services provided to the user if the user is a resident of a country for which VAT is not applicable.
- 3. The method of claim 2, further comprising:
determining if a user who is a resident of a country for which VAT is applicable has a VAT-exempt status; and not accessing VAT for services provided to the user if the user has a VAT-exempt status, otherwise accessing VAT for the services.
- 4. The method of claim 1, wherein the VAT is assessed by performing the operations of:
determining a country of residence of a user; determining a current VAT rate for the country of residence for the user; determining service fees for the user; determining a VAT assessment for the service fees based on the current VAT rate for the country of residence of the user.
- 5. The method of claim 4, further comprising providing service fee information to a user for a given transaction, said service fee information containing service fees with built-in VAT assessments.
- 6. The method of claim 4, wherein the service fees include a debit fee occurring during a first billing cycle and a related credit fee occurring during a second billing cycle; and wherein the VAT assessment includes:
assessing VAT on the debit fee using a VAT assessment rate applicable for the first billing cycle; and accessing VAT as a credit on the credit fee using a VAT assessment rate applicable for the second billing cycle.
- 7. The method of claim 1, further comprising:
enabling a user having residence in a country for which VAT is assessed on the service to provide a VAT identifier to request a VAT-exempt status; confirming the VAT-exempt status; and not assessing VAT charges for future services provided to the user.
- 8. The method of claim 9, further comprising:
identifying a first point in time at which the user requests a VAT-exempt status; recording VAT assessments on services rendered for the user between the first point in time and a second point in time at which the VAT-exempt status is confirmed; and crediting the user for any VAT assessments that accrued between the first and second points in time.
- 9. The method of claim 1, further comprising providing on-line account information to both non-exempt and VAT-exempt users of the network-based marketplace service, said on-line account information for non-exempt users breaking out any VAT assessments for corresponding account entries.
- 10. The method of claim 1, further comprising providing account invoices to both non-exempt and VAT-exempt users of the network-based marketplace service, said account invoices for non-exempt users breaking out any VAT assessments for corresponding invoice entries.
- 11 The method of claim 1, further comprising tracking a user's registered country of residence over time to identify potential fraudulent user activities.
- 12. The method of claim 1, wherein the network-based marketplace services are hosted on a plurality of Internet sites, each corresponding to a respective country or region.
- 13. The method of claim 12, wherein the tax return reports are generated by performing operations including:
storing service transaction data for users of a given Internet site on a database hosted by that site; forwarding service transaction data from the databases hosted by each of the plurality of Internet sites to a central data repository; and aggregating the service transaction data forwarded to the central data repository to generate the VAT return reports.
- 14. The method of claim 1, further comprising dynamically generating web pages via which the users can interact with the network-based marketplace, wherein the web pages generated for a given user my differ based on a VAT status of that user.
- 15. A system, comprising:
a plurality of software components configured to interact with one another, including:
front-end software components to generate markup language pages via which users may be provided with network-based marketplace services, said users having residences in respective countries, at least a portion of which charge value-added tax (VAT) for services, a VAT assessment software component to access value-added tax (VAT) on the network-based marketplace services; a database interface software component to interface with a database to store and retrieve data related to VAT assessments made by the VAT assessment software component; and a reporting software component to generate respective VAT tax returns for each country for which VAT is assessed via aggregation of data stored in the database.
- 16. The system of claim 15, wherein the VAT assessment software component assesses the VAT by performing operations including:
determining a country of residence of a user; determining a current VAT rate for the country of residence for the user; determining service fees for the user; determining a VAT assessment for the service fees based on the current VAT rate for the country of residence of the user.
- 17. The system of claim 15, wherein the plurality of the software components are configured to perform the further operation of generating a markup language page to provide service fee information to a user for a given transaction, said service fee information containing service fees with built-in VAT assessments.
- 18 The system of claim 15, wherein the plurality of the software components are configured to perform the further operation of generating a markup language page to provide account status information to a user, said account status information including data identifying VAT assessments for services provided via the network-based marketplace service.
- 19. The system of claim 15, wherein the plurality of the software components are configured to perform the further operation of generating a markup language page to provide account status information to a user, said account status information including data identifying VAT assessments for services provided via the network-based marketplace service.
- 20. The system of claim 15, wherein the plurality of the software components are configured to perform the further operations of:
determining a VAT status of a user; and dynamically generating markup language pages via which a user can access the network-based marketplace server based on the VAT status of the user, wherein different markup language pages are generated for users having different VAT statuses.
- 21. A machine readable medium on which instructions are stored comprising the plurality of software components recited in claim 15
- 22. A system comprising:
means for generating markup language pages via which users may be provided with network-based marketplace services, said users having residences in respective countries, at least a portion of which charge value-added tax (VAT) for services, VAT assessment means for assessing value-added tax (VAT) on the network-based marketplace services for a plurality of countries having different VAT rates; database interface means for interfacing with a database to store and retrieve data related to VAT assessments made by the VAT assessment means; and reporting means for generating respective VAT tax returns for each country for which VAT is assessed via aggregation of data stored in the database.
- 23. The system of claim 22, wherein the means for generating markup language pages generates user-specific markup language pages that differ dependent on a VAT status of a user of the network-based marketplace services.
- 24. The system of claim 22, further comprising a means for generating on-line account status data corresponding to a user's account with the network-based marketplace service, the account status data identifying VAT assessments for the user.
- 25. The system of claim 22, further comprising a means for generating an on-line invoice corresponding to a user's account with the network-based marketplace service, the invoice including data identifying VAT assessments for the user.
- 26. The system of claim 22, further comprising a means for warehousing VAT assessment data collected from a plurality of on-line sites hosted by the network-based marketplace service.
- 27. The system of claim 22, further comprising a means for detecting fraudulent user activity involving avoidance of being assessed VAT on services provided by the network-based marketplace service.