Announcement:Materials and articles for ProductCart 5 can be found at our brand new support center.

Create an account to edit articles | See Formatting Syntax for Wiki syntax | We look forward to your contribution!

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

productcart:tax_data_file [2008/04/29 06:47]
paula
productcart:tax_data_file [2013/07/12 14:44] (current)
Line 1: Line 1:
-====== Tax Options ​======+====== ​Using a Tax Data File ======
  
-In the United States, taxation of online sales is typically handled as follows: ​ 
- 
-  * orders submitted by customers that reside in the **same state** where the company managing the online store is located are taxed 
-  * orders submitted by **out-of-state** customers are not taxed (this includes international customers). ​ 
- 
-ProductCart also supports country-based taxation for international stores. Canadian stores can now display federal and local taxes separately (other stores in other countries that require this, can do so as well, of course). Independently of the tax settings configured using the //Tax Option// module, you can set a product or service as tax-exempt when adding or modifying a product. 
- 
-The tax calculation features provided by ProductCart are designed to help you calculate sale taxes. However, the calculation performed by the software may or may not exactly match the tax laws that you need to comply with. __You should consult your local tax authority to determine the tax laws that you need to adhere to.__ 
- 
-ProductCart gives you the ability to either use a **database file containing tax rates**, or enter rates **manually by location, product, and/or zone**. ​ All methods are described in more detail in this section of the User Guide. 
- 
- 
-===== Using a Tax Data File ===== 
  
 This section applies mostly to US merchants, although you can use this feature of ProductCart outside of the US too if you can apply tax rates based on the customer’s postal code. This section applies mostly to US merchants, although you can use this feature of ProductCart outside of the US too if you can apply tax rates based on the customer’s postal code.
Line 21: Line 8:
 It is important to understand when you are required to collect sales tax in your Internet store, and for which states. Most online sellers collect tax only in the state(s) where they have a "​nexus",​ or physical presence. The definition of nexus varies from state to state, but can include employees, agents, telecommuters,​ premises, personal property, or even web servers. ​ __Check with your CPA or the state directly to determine if your company has a nexus in that state.__ It is important to understand when you are required to collect sales tax in your Internet store, and for which states. Most online sellers collect tax only in the state(s) where they have a "​nexus",​ or physical presence. The definition of nexus varies from state to state, but can include employees, agents, telecommuters,​ premises, personal property, or even web servers. ​ __Check with your CPA or the state directly to determine if your company has a nexus in that state.__
  
-==== Accounting for multiple local sales tax levels ====+===== Accounting for multiple local sales tax levels ​=====
  
 Sales tax can be at local levels beyond just the state rate.  These local rates can include the county, city, special purpose district (SPD), and metropolitan transit area (MTA). ​ Keeping track of these rates and rate changes is essential to ensure that you are charging the correct sales tax rate for your online transactions. Sales tax can be at local levels beyond just the state rate.  These local rates can include the county, city, special purpose district (SPD), and metropolitan transit area (MTA). ​ Keeping track of these rates and rate changes is essential to ensure that you are charging the correct sales tax rate for your online transactions.
  
-Early Impact ​recently partnered with Tax Data Systems to allow US-based users of ProductCart to quickly, easily and accurately calculate sales tax on orders placed on their store. +ProductCart ​recently partnered with Tax Data Systems to allow US-based users of ProductCart to quickly, easily and accurately calculate sales tax on orders placed on their store. 
-If would like to use a tax data file to calculate taxes in ProductCart,​ but elect not to use Tax Data Systems’ services, you can manually create a tax data file. Please refer to Appendix O FIXME [check this reference--should add linkof this User Guide for details on the file format that you will need to adhere to.+ 
 +If would like to use a tax data file to calculate taxes in ProductCart,​ but elect not to use Tax Data Systems’ services, you can manually create a tax data file. Please refer to this [[:​developers:​taxdatafiles|technical article]] for details on the file format that you will need to adhere to. 
 Tax Data Systems provides inexpensive subscription services to complete and updated data files that contain all the information that is needed to properly calculate sales taxes. The company sends regular updates to its customers to keep them up-to-date with the latest tax changes. Tax Data Systems provides inexpensive subscription services to complete and updated data files that contain all the information that is needed to properly calculate sales taxes. The company sends regular updates to its customers to keep them up-to-date with the latest tax changes.
  
-==== The benefits of using Tax Data Systems'​ data files with ProductCart ====+===== The benefits of using Tax Data Systems'​ data files with ProductCart ​=====
  
 ProductCart v2.7 and above contain a sophisticated tax module that takes advantage of Tax Data Systems’ data files to allow your store to effectively perform the following tax-related tasks: ProductCart v2.7 and above contain a sophisticated tax module that takes advantage of Tax Data Systems’ data files to allow your store to effectively perform the following tax-related tasks:
  
   * Properly calculate sales tax, based on the tax rate associated with the customer’s shipping address.   * Properly calculate sales tax, based on the tax rate associated with the customer’s shipping address.
- 
   * Correctly handle scenarios in which a ZIP code includes multiple city/county combinations and therefore multiple tax rates are associated with it. The customer will automatically be prompted to select the county/city combination that they reside in.   * Correctly handle scenarios in which a ZIP code includes multiple city/county combinations and therefore multiple tax rates are associated with it. The customer will automatically be prompted to select the county/city combination that they reside in.
- 
   * Automatically determine whether shipping charges should be added to the taxable total.   * Automatically determine whether shipping charges should be added to the taxable total.
- 
   * Automatically determine whether handling fees should be added to the taxable total.   * Automatically determine whether handling fees should be added to the taxable total.
  
 +For more information,​ please see: http://​www.earlyimpact.com/​productcart/​support/​updates/​taxlink.asp
  
-==== Do you need a tax data file? ====+===== Do you need a tax data file? =====
  
 If your company has a physical presence in one or more US states, and if any of those states are listed in the table shown below, then local tax rates are used, and the answer to the question of whether you should use a tax data file is **“yes”**. If your state is not listed, then it means that either there is no sales tax in your state, or a uniform tax rate is applied across the state. If your company has a physical presence in one or more US states, and if any of those states are listed in the table shown below, then local tax rates are used, and the answer to the question of whether you should use a tax data file is **“yes”**. If your state is not listed, then it means that either there is no sales tax in your state, or a uniform tax rate is applied across the state.
 __Contact your local tax authority for more information on how sales taxes should be calculated in your state (and in all other states in which your company has a physical presence).__ Below is a list of the states that collect local taxes. __Contact your local tax authority for more information on how sales taxes should be calculated in your state (and in all other states in which your company has a physical presence).__ Below is a list of the states that collect local taxes.
- 
    
   *   ​Alabama   *   ​Alabama
Line 88: Line 74:
  
  
-==== Obtaining a tax data file from Tax Data Systems ====+===== Obtaining a tax data file from Tax Data Systems ​=====
  
 Once you have determined in which states your company has a physical presence and which of those states require the company to pay sales taxes, contact [[http://​www.earlyimpact.com/​productcart/​support/​updates/​taxlink.asp|Tax Data Systems]] to purchase a subscription service to tax data files for those states. In most cases, you will probably need just one tax data file for the state in which your company resides. Once you have determined in which states your company has a physical presence and which of those states require the company to pay sales taxes, contact [[http://​www.earlyimpact.com/​productcart/​support/​updates/​taxlink.asp|Tax Data Systems]] to purchase a subscription service to tax data files for those states. In most cases, you will probably need just one tax data file for the state in which your company resides.
Line 96: Line 82:
 Once you have obtained the data file from [[http://​www.earlyimpact.com/​productcart/​support/​updates/​taxlink.asp|Tax Data Systems]], you can return to ProductCart and finish setting up the tax settings. If you purchased more than one file, carefully review the next section. Once you have obtained the data file from [[http://​www.earlyimpact.com/​productcart/​support/​updates/​taxlink.asp|Tax Data Systems]], you can return to ProductCart and finish setting up the tax settings. If you purchased more than one file, carefully review the next section.
  
-==== Combining multiple data files ====+===== Combining multiple data files =====
  
 You can only use one data file at a time in ProductCart. This means that if you purchase two or more data files (two or more states) from [[http://​www.earlyimpact.com/​productcart/​support/​updates/​taxlink.asp|Tax Data Systems]] (e.g. your company has an office in California and one in New York), you will need to combine them into one and upload the combined file to ProductCart. You can only use one data file at a time in ProductCart. This means that if you purchase two or more data files (two or more states) from [[http://​www.earlyimpact.com/​productcart/​support/​updates/​taxlink.asp|Tax Data Systems]] (e.g. your company has an office in California and one in New York), you will need to combine them into one and upload the combined file to ProductCart.
Line 111: Line 97:
   * Proceed to the next section, which contains information on how to upload your tax data file to ProductCart.   * Proceed to the next section, which contains information on how to upload your tax data file to ProductCart.
    
-==== Configuring ProductCarts Tax Module ====+===== Configuring ProductCart's Tax Module ​=====
  
   - Log into your ProductCart //Control Panel// and select //Store Management Tools > Tax Options > View/Edit Tax Options//. From the screen that is shown to you, select the option to use a tax file.   - Log into your ProductCart //Control Panel// and select //Store Management Tools > Tax Options > View/Edit Tax Options//. From the screen that is shown to you, select the option to use a tax file.
Line 119: Line 105:
   - Enter the name of the file that you just uploaded to the store in the corresponding input field. For example, the naming convention of the tax files is the state abbreviation underscore complete.csv (e.g. “CA_complete.csv”). Make sure to include the “.csv” extension when you enter the file name in the corresponding field. If you enter a name that does not match that of the file that you uploaded to the store, you will receive an error message during checkout.   - Enter the name of the file that you just uploaded to the store in the corresponding input field. For example, the naming convention of the tax files is the state abbreviation underscore complete.csv (e.g. “CA_complete.csv”). Make sure to include the “.csv” extension when you enter the file name in the corresponding field. If you enter a name that does not match that of the file that you uploaded to the store, you will receive an error message during checkout.
   - Select whether wholesale customers should be taxed or not on your store.   - Select whether wholesale customers should be taxed or not on your store.
-  - Enter one or more default states and specify a tax rate for all of them.  +  ​-- Enter one or more "​fallback" ​tax rates for the states in which you pay taxes.  
-  .. The default ​sales tax rate is the sales tax rate that will be used if a match for the customers shipping address is not found in your tax rate file (for example, ​the customer types an incorrect zip code or a new zip code is added by the State and your file has not been updated to reflect this). +  .. The fallback ​sales tax rate is the rate that will be used if a match for the customer's shipping address is not found in your tax rate file (e.g. the customer types an incorrect zip code or a new zip code is added by the State and your file has not been updated to reflect this). 
-  .. If your company resides in California and you only have a physical presence in California, then the tax data file that you uploaded to your store will likely only contain tax rates for California, and your default ​state is only California. If you collect sales taxes for more than one state, enter them as default ​states. +  .. For example, if your company resides in California and you only have a physical presence in California, then the tax data file that you uploaded to your store will likely only contain tax rates for California, and your fallback tax rate state will be only California. If you collect sales taxes for more than one state, enter them as fallback ​states. 
-  - Place an order in your storefront to ensure that taxes are properly calculated. ProductCart will look at the ZIP code of the customer’s shipping address match it to a tax rate in the data file that you have uploaded. If there is no match, and if the state entered for the shipping address is not one of the default ​states listed in the tax settings, ProductCart will assume that the order does not need to be taxed. If there is more than one match, ProductCart will prompt the user to select the city/county in which they live in.+  - Place an order in your storefront to ensure that taxes are properly calculated. ProductCart will look at the ZIP code of the customer’s shipping address match it to a tax rate in the data file that you have uploaded. If there is no match, and if the state entered for the shipping address is not one of the fallback ​states listed in the tax settings, ProductCart will assume that the order does not need to be taxed. If there is more than one match, ProductCart will prompt the user to select the city/county in which they live in.
  
 <​note>​ <​note>​
-As long as the file is properly formatted, ProductCart will automatically determine whether shipping charges and/or handling fees should be part of the taxable total.+As long as the file is properly formatted, ProductCart will automatically determine whether shipping charges and/or handling fees should be part of the taxable total. The file contains two columns which control this: TAX_SHIPPING_ALONE and TAX_SHIPPING_AND_HANDLING_TOGETHER. Enter either N or Y into these columns to control these options.
 </​note>​ </​note>​
  
Line 136: Line 122:
    
  
-Once you have setup the tax calculation to use a database, ProductCart shows you a summary of such settings every time you click on //View/Edit Tax Options// from the //Tax Options// menu, as demonstrated in the screenshot above. From that screen you can either keep the tax settings 'as is', edit them (e.g. change the default ​tax rate), or switch to alternative ways to compute taxes, which are described in the next sections.+Once you have setup the tax calculation to use a database, ProductCart shows you a summary of such settings every time you click on //View/Edit Tax Options// from the //Tax Options// menu, as demonstrated in the screenshot above. From that screen you can either keep the tax settings 'as is', edit them (e.g. change the fallback ​tax rate), or switch to alternative ways to compute taxes, which are described in the next sections.
  
-==== Troubleshooting problems related to using a tax file ====+ 
 +===== Troubleshooting problems related to using a tax file =====
  
 If you are receiving an error when placing a test order, and the error occurs during the checkout process, after the shipping selection page and before the order verification page are shown, and/or the error details shown by your browser include the file name tax.asp, please check on the following before contacting us for technical support: ​ If you are receiving an error when placing a test order, and the error occurs during the checkout process, after the shipping selection page and before the order verification page are shown, and/or the error details shown by your browser include the file name tax.asp, please check on the following before contacting us for technical support: ​
Line 148: Line 135:
   * If you combined two or more files together, review the instructions listed earlier in this section. Specifically,​ make sure that you did NOT include the header of the first file when you copied it into the second file.   * If you combined two or more files together, review the instructions listed earlier in this section. Specifically,​ make sure that you did NOT include the header of the first file when you copied it into the second file.
  
-If your problem is not solved by one of the items listed above, please note: +If are having an issue with the tax data file itself, please contact Tax Data Systems.
- +
-  * If are having an issue with the tax data file itself, please contact Tax Data Systems. +
-  * If you are having problems configuring your tax settings within ProductCart,​ please first review the corresponding chapter in the ProductCart User Guide FIXME [add link]. If you don’t find an answer there, visit the ProductCart //Support Center// for more information,​ to search an updated **knowledge base**, and to submit a support request. +
-  * If you purchased ProductCart from an Early Impact reseller, please contact the reseller for technical support as they may have made modifications to ProductCart for you.  +
- +
-==== Manually Adding a Tax Rate ==== +
- +
-=== Overview === +
- +
-When you cannot or do not want to use a tax database to calculate taxes on your orders, ProductCart allows you to manually enter tax rates and charge taxes based on the customer’s **location** (but not necessarily his or her postal code), **products**,​ or a specified geographic **zone**. +
- +
-<note tip> +
-Manually adding tax by **zone** is the newest and most flexible way to apply taxes to your store. Originally designed with Canadian taxes in mind because of the different levels of federal and local taxes that need to be applied in this country, this method has been used in many different creative ways such as adding on //​surcharges//​ to certain products and/or categories. ​ For stores doing business in countries with similarly complex tax rules as Canada, we strongly recommend using the **zone** method described below. +
-</​note>​ +
- +
-The first configuration steps are the same for all three manual tax methods (location, product and zone). ​ Click on //Enter// tax rates manually on the //Tax Options// window. If you are using a Tax Database, click on //Switch to Manual Tax Calculation//​. Next, configure the following settings: +
- +
-  * __Include shipping charges__. You can include shipping charges and/or handling fees in the calculation. As mentioned above, typically shipping charges are excluded, but handling fees are taxable. +
-  * __Include handling fees__. See above. +
-  * __Base the calculation on the billing vs. shipping address__. Typically, the shipping address is the one that should determine which tax rate should be applied, if any. +
-  * __Display taxes separately__. Since you have the ability to enter more then one tax rule, now ProductCart gives the option to display those taxes separately to the customer. For example, Canadian customers can use this feature to separately display federal and province tax. +
-  +
-When you are done, click on the //Update & Continue// button. +
- +
-The next screen asks you to choose whether you would like to add a tax rule based on **product**,​ **location**,​ and/or **zone**, and it also provides a link to view existing **tax rules**. Let’s review the different options. +
- +
-==== Add tax by location ==== +
-  +
-To add a tax rule that applies taxes to an order based on the location where the customer resides: +
- +
-  - Click on //Add tax by location//​ +
-  - Set the tax rate (to add a 6.5% tax rate, simply enter 6.5) +
-  - Define the geographic limitation by selecting a postal code, a US state or a country.  +
- +
-**You can have multiple tax rates working at the same time.** Use the //​description field// to enter a label for this tax (useful when taxes are displayed separately).  +
- +
- +
- +
-==== Add tax by product ==== +
- +
-To add a tax rule that applies taxes to an order based on the shopping cart content: +
- +
-  - Click on //Add tax by product// +
-  - Select a product from the drop-down menu +
-  - Set the tax rate (to add a 6.5% tax rate, simply enter 6.5 ) +
-  - Define a geographic limitation by selecting a postal code, a US state or a country.  +
- +
-**You can have multiple tax rates working at the same time, so that you may cover all products that fall into a certain product category, for example**. +
- +
-<​note>​ +
-ProductCart does not apply the **tax by location** on a product for which a **tax by product** has been entered, thus avoiding double taxation. In other words, when the shopping cart contains a combination of products for which a tax has been specified, and products for which it has not, ProductCart first applies the **tax by product**, then applies the **tax by location** (if any) on the rest of the products, unless they are tax-exempt. The tax added to the order is the sum of all taxes calculated on the shopping cart content. +
-</​note>​ +
-  +
-==== Add Tax by Zone Overview==== +
- +
-Adding tax by **zone** is a two-step process. ​ The first step is defining one or more tax **zones** and the second step is adding/​editing a tax rule which will be applied to one or more zones. ​  +
- +
-=== Defining a Zone === +
- +
-A **zone** is made up of the following elements: +
- +
-  - A geographic area that consists of a country and a state or province contained in that country. The states and countries are pulled from your //State// and //Country lists// that are setup in your store. +
-  - A name which is easily identifiable to you.  This name will not be shown to the customer; it is for the store owner’s reference only. +
- +
-After you have completed defining your zones, click on the //Complete Tax Zone Configuration//​ button to close the window and refresh the existing //Control Page// with the new information. If the page does not refresh automatically,​ you can click on the “refresh” page button in your browser or click on the F5 key on your keyboard. +
- +
-=== Add/Edit Tax Rule by Zone === +
- +
-Once you have defined one or more “zones” you will be able to apply a new //tax rule// definition. ​ The definition has the following components:​ +
- +
-  * The //tax rule **description**//​ will be shown in the storefront to your customers and will display on the order summary page and on any invoices or order detail pages. It should be a description of the tax or fee that you are applying to the order. **This is a required field.** +
- +
-  * The //tax rule **type**// is solely for your own reference so that you can quickly see what type of tax this is that you set up. An example would be “BC GST”. **This is a required field.** +
- +
-  * The //tax rule **rate**// is the actual percentage rate for this zone. **This field is required** and must contain a whole number and not include the percentage symbol (%). +
- +
-  * Use //tax rule order// if you are creating multiple zones that will contain same state/​province to apply an order number to each one. This will tell the system which tax rule to apply to the order first. __This is very important if some of the taxes are taxable.__ **This is an optional field.** +
- +
-__Optional Check Boxes:__ +
- +
-  * Enable //apply tax to shipping & handling// if you want your zone tax to apply to the shipping & handling fees of an order. +
- +
-  * Enable //apply this tax only to customers in the same state/​province as your store// only if you wish to apply your zone tax to customers that are located in the same state/​province as your store address is located. **For example, this feature can be used to apply a local tax only to local sales.** +
- +
-  * //This tax is taxable.// In some countries there are taxes that need to be tax by an additional tax. **For example: In Quebec the local tax is applied to the order total plus the federal tax, whereas in Ontario both taxes are calculated only on the order total.**  +
- +
-<​note>​ +
-When applying the //this tax is taxable// option to a zone, make sure that the //Order// of the zone is before any other taxes for the same zone. This will ensure that the tax is properly taxed by the other tax rates by zones you have setup. +
-</​note>​ +
- +
- +
-=== Tax Rules by Zone and Customer Exemptions === +
- +
-This feature allows you to exempt select customers from paying tax. To access this feature, click on the link to modify your **tax rule by zone** from the tax summary page and click the button located at the bottom of the //modify// page that reads //view/edit customer exemptions for this tax//​. ​ You can then add new customers or remove existing customers for the tax rule that you are modifying. +
- +
-=== Tax Rules by Zone and Category or Product Exemptions === +
- +
-You can create an exemption list for each **tax rule by zone** that includes specific products or categories. To access this feature, click on the link //​zone-specific product/​category tax exemptions for tax by zone// rules from the tax summary page. +
- +
-The first time you view this page click on the //Add New Rules// button to get started. The following two items are included in this page: +
- +
-  * __Rule/​Zone__ ​ A drop-down will list all of your current **tax rules by zone**. Choose which tax rule by zone you wish to apply the exemption to.   +
- +
-  * __Exemptions by Products & Categories__ This option allows you to select individual products, entire categories of products, or a combination of both, from which to apply an exemption from a tax rule by zone.   +
- +
-=== Additional Tax by Zone Exemption Settings Not Available through the Control Panel === +
- +
-To avoid discrepancies that have occurred when a cart contains both exempt and non-exempt products as defined by a particular **tax rule by zone** ​ we have created a hard-code flag in the file called “orderVerify.asp” located in the “ProductCart/​pc/​” folder. Towards the top of this page, locate the following code: +
- +
-<​code>​ +
-intTaxExemptZoneFlag="​1"​  +
-</​code>​ +
- +
-Change the "​1"​ to “0” if you want to tax any tax zone exempt products when they are added to the cart with taxable products. Use the "​1"​ to ensure that tax zone exempt products are never taxed for that zone.  +
- +
-==== Other General Tips for Tax Rules ==== +
- +
-To display a list of all tax rules currently active in your store, select //List all tax rules//. To modify any of them, click on the //Modify// button. To delete a tax rule, click on the //Delete// button. To add a new tax rule, click on //Add New//. +
- +
-The bottom part of the window allows you to reset the general rules described at the beginning of this section. To update these options, click on the //Update// button. +
- +
-To switch to calculating taxes using a tax file, click on //Switch to Tax file//. To switch to using VAT, click on //Switch to VAT//. +
- +
-  +
- +
-  +
- +
-===== Calculating the Value Added Tax (VAT) ===== +
- +
-ProductCart v2.7 and above allow you to show your customers the VAT (Value Added Tax) on the products that they are purchasing (product details page) and on the order total (order details page). The system behaves based on the following assumptions:​  +
-• When you enter prices in ProductCart,​ they are always entered VAT included. When you add a product to your store, the product'​s price includes VAT. The system gives you the option to show the price without VAT on the product details page.  +
-• The same VAT is applied to all products sold on the store.  +
-You can configure the following settings: +
-• VAT Rate (e.g. 20%)  +
-• Whether VAT should be shown on the product details page. If set to "​Yes",​ ProductCart calculates the price without VAT and displays it below the online price. Here is an example of how the price would be shown for a hypothetical product: +
-Price: £26.00 Price inc. VAT +
-Price without VAT: £21.76 +
-List Price: £29.96 - You Save: £3.96 +
-• Whether to include shipping charges in the calculation. If set to "​Yes",​ ProductCart assumes that shipping charges include VAT. So when it calculates the total VAT applied to the order, it includes these charges in the equation. +
-• Whether to include handling fees. If set to "​Yes",​ ProductCart assumes that handling fees include VAT. So when it calculates the total VAT applied to the order, it includes these fees in the equation. +
-• Whether wholesale customers should be taxed. You can choose whether or not VAT should be shown when wholesale customers are checking out.  +
-  +
-Setting a Product as Tax-Exempt +
-In many countries there are products and services on which taxes are not applied. In the United States, for example, you are not required to charge taxes if you are selling services (e.g. a legal consultation,​ graphic design services, etc.). You are also typically not required to pay sales taxes on products that are delivered electronically to your customers, as long as no physical product (e.g. a CD, a manual, etc.) is shipped to the customer. +
-ProductCart allows you to set individual products as tax-exempt. This way you can configure general tax settings for your store, and then exclude from them products and services on which taxes should not be calculated. +
-You can set a product as non-taxable both when adding a new product and when modifying a product. In both cases, notice the Non-Taxable check box locate in the Other Settings section of the page. Check this option to make a product non-taxable,​ then save the product information to the database. +
-If an order contains both taxable and non-taxable items, taxes will be calculated on the subtotal for the taxable products. +
- +
- +

QR Code
QR Code Using a Tax Data File (generated for current page)