Skip to navigation

Excise Tax badge

View as Markdown

Administration and utilities

NameTypeDescriptionComments
Sign-in pageRequiredUsers must be provided with a configuration page or file that allows them to type in their authentication credentials and the company ID.
Sandbox or Production modeRequiredYour integration must provide a method for users to specify whether they’re working in a Sandbox or Production environment.
Test connection buttonRequiredUsers must be able to test the connection to the AvaTax service and verify their AvaTax credentials.
Enable client side loggingSuggestedUsers should have access to detailed AvaTax for Excise transaction logging within the application.
User guideRequiredUsers must be provided with a guide that contains screenshots and steps describing how to configure and use ATE.

Business entities

NameTypeDescriptionComments
Import nameRequiredWhen importing business entities, users must be able to specify a name for each import.
Import matches modeRequiredWhen importing business entities, users must be able to specify the behavior for treating existing business entities. Options include: * None * Insert * Update * Copy
Terminate new recordsRequiredWhen importing business entities, users must be able to specify whether to terminate new records.
Create all account typesRequiredWhen importing business entities, users must be able to specify whether to create all account types.
Load IDRequiredWhen importing business entities, users must be able to specify a unique value indicating a group of imports.
Legal nameRequiredUsers must be provided with a method for specifying the name of the person or entity that owns a business.
Legal name priorityRequiredUsers must be able to specify a priority for a legal name. This determines the value that a legal name search will use first.
Trade nameSuggestedUsers should be provided with an option to specify the name of the business that is used for advertising and sales purposes. Sometimes, this is different than the legal name.
Name controlSuggestedUsers should be provided with an option to specify a business’s name control. This is the sequence of characters derived from a taxpayer’s name that is used by the IRS when processing the tax returns filed by the taxpayer.
Effective dateRequiredYour integration must provide a method for specifying the date when a business entity will be valid for use.
Obsolete dateSuggestedYour integration should provide a method for specifying the date when a business entity will no longer be valid for use.
Business addressSuggestedUsers should be able to specify the business address, including the country, jurisdiction (for example, state), county, city, postal code, and street address.
Business entity ID codesRequiredUsers must be able to define an array of business entity ID codes. The codes include the country code, ID type, and ID code for each business entity.
Custom IDRequiredUser must be able to specify a unique value to identify a business entity
Custom ID priorityRequiredUsers must be able to specify a priority for a custom ID. This determines the value that a custom ID search will use first.
ID code and ID type priorityRequiredUsers must be able to specify a priority for an ID code and ID type. This determines the value an ID code and ID type search will use first.
Business entity mapping IDRequiredUsers must be able to specify a business entity mapping ID.
Business account country codeSuggestedIf including business accounts, users should be able to specify a business account country code.
Business account jurisdictionSuggestedIf including business accounts, users should be able to specify the business account jurisdiction (for example, the state).
Business typeSuggestedIf including business accounts, users should be able to specify the business type.
Business sub typeSuggestedIf including business accounts, users should be provided with a field to further define the type of account being created
Business account custom IDSuggestedIf including business accounts, users should be provided with a way to uniquely identify a business entity.
Business account effective dateSuggestedIf including business accounts, users should be provided with a method for specifying the date when a business account will be valid for use.
Business account obsolete dateSuggestedIf including business accounts, users should be provided with a method for specifying the date when a business account will no longer be valid for use.
Business account license numberSuggestedIf including business accounts, then should must be able to enter a business account’s state-specific license. This is used for a tax exemption, a tax deferral, a tax activation or to provide a tax collection allowance.
Business account license percentageSuggestedIf including business accounts, then users should be able to specify a license percentage for this account. This percentage will be applied to a tax exemption, tax deferral, tax activate, or tax collection allowance.
Business account mapping IDSuggestedIf including business accounts, then your integration should assign a unique ID to map to each business account.

Adjustments

NameTypeDescriptionComments
Transaction codeRequiredYour integration must allow users to include a code that corresponds to the transaction that should be adjusted.
Adjustment reason codeRequiredYour integration must allow users to specify a reason code that relates to the adjustment.
Adjustment descriptionRequiredYour integration must allow users to include an optional description for the adjustment. This description is a string with a maximum length of 256.
New transactionRequiredYour integration must allow users to enter new transaction details for the adjustment.

Advanced feature: Tobacco, nicotine, and vape transactions - document level

NameTypeDescriptionComments
Transaction effective dateRequiredUsers must be able to specify the date when the tax rate should be applied to this transaction. This would typically be the bill of lading date.
Invoice numberRequiredUsers must be able to specify the invoice number of a transaction.
Invoice dateRequiredUsers must be able to specify the date of the invoice on a transaction.
Title transfer codeRequiredUsers must be able to specify whether the title transfer takes place at the ORIG or DEST.
Transaction typeRequiredUsers must be able to specify where the entire order is in the supply chain. For tobacco, nicotine, and vape tax, the available transaction types are: WHOLESALE, RETAIL, and DIRECT.
SellerRequiredUsers must be able to specify the unique seller ID.
BuyerRequiredUsers must be able to specify the unique buyer ID.
User transaction IDRequiredUsers must be able to specify the corresponding AvaTax transaction code that is used to commit a transaction in both environments. Every new transaction must have a new UserTranId.
Entity use codeRequiredUsers must be able to specify an entity use code for a sales/use tax exemption at the document and line levels.
Custom strings and numericsRequiredUsers must have a way to enter up to ten custom strings and up to ten custom numeric values as a way to customize calculations based on their business rules.
Source systemRequiredUsers must be able to specify a string that identifies the system that’s calling the application with this transaction.
User dataSuggestedUsers should be provided with a field for entering data about the user at the document and line levels.
AvaTax transaction typeSuggestedUsers should be able to specify the corresponding AvaTax transaction type.
Discount amountSuggestedUsers should be able to specify a discount amount at the header level. This discount will then be applied to all lines with "Discounted": true.

Advanced feature: Tobacco, nicotine, and vape transactions - line level

NameTypeDescriptionComments
Invoice lineRequiredUsers must be able to specify multiple lines on a transaction.
Product codeRequiredUsers must be able to specify a product code when creating an ATE transaction.
Origin addressRequiredUsers must be able to specify the origination country code, jurisdiction (for example, the state), county, city, and postal code. In addition, including a street-level address will provide more accurate tax determination.
Origin codeSuggestedUsers should be able to specify a custom ID for a defined origination location rather than specifying the full origin address.
Destination addressRequiredUsers must be able to specify the destination country code, jurisdiction (for example, the state), county, city, and postal code. In addition, including a street-level address will provide more accurate tax determination.
Destination codeSuggestedUsers should be able to specify a custom ID for a defined destination location rather than specifying the full destination address.
Sale addressRequiredUsers must be able to specify the sales country code, jurisdiction (for example, the state), county, city, and postal code. In addition, including a street-level address will provide more accurate tax determination.
Line amountSuggestedTransactions must know the cost or amount of an item to perform a tax calculation. This is done by specifying either a unit price and/or a line amount.
Alternate line amountSuggestedTransactions may include an alternate line amount. This is the total amount of value of product on the line item calculated by BilledUnits * AlternateUnitPrice. If left blank, ATE will calculate this value.
Unit priceRequiredTransactions must know the cost or amount of an item to perform a tax calculation. This is done by specifying either a unit price and/or a line amount.
Alternate unit priceRequiredTransactions must include an alternate cost per unit. This is used in calculating taxes from manufacturing.
Tax includedSuggestedYour integration should allow users to specify whether tax is already included in a transaction line’s unit price and/or amount.
Billed unitsRequiredUsers must be able to specify the unit amount that is used for billing. This value must match either the net units or gross units.
Net unitsRequiredUsers must be able to specify the net unit volume of a product on a line item.
Gross unitsRequiredUsers must be able to specify the gross unit volume at the time of delivery for an item.
CurrencyRequiredUsers must be able to specify the currency that the unit price and/or line amount use.
DiscountedConditionalIf users can specify a discount amount at the document level, then they must be able to specify whether that value applies to a transaction line.
Unit of measureRequiredUsers must be able to specify the unit of measure that the net, gross, and billed units are defined in.
Unit quantitySuggestedUsers should be able to specify a unit quantity, or the number of subunits within a unit (for example, the number of cigars in a box). This attribute can be assigned directly to the product code within ATE.
Unit quantity unit of measureSuggestedUsers should be able to specify the unit of measure for subunits. This attribute can be assigned directly to the product code within ATE.
Unit volumeSuggestedUsers should be able to specify a volume for a line item. This attribute can be assigned directly to the product code within ATE.
Unit volume unit of measureSuggestedUsers should be able to specify the unit of measure for the volume. This attribute can be assigned directly to the product code within ATE.
Unit weightSuggestedUsers should be able to specify a weight value for a line item. This attribute can be assigned directly to the product code within ATE.
Unit weight unit of measureSuggestedUsers should be able to specify the unit of measure for a weight. This attribute can be assigned directly to the product code within ATE.

Advanced feature: Fuel transactions - document level

NameTypeDescriptionComments
Transaction effective dateRequiredUsers must be able to specify the date when the tax rate should be applied to this transaction. This would typically be the bill of lading date.
Invoice numberRequiredUsers must be able to specify the invoice number of a transaction.
Invoice dateRequiredUsers must be able to specify the date of the invoice on a transaction.
Title transfer codeRequiredUsers must be able to specify whether the title transfer takes place at the ORIG or DEST.
Transaction typeRequiredUsers must be able to specify where the entire order is in the supply chain. For fuel tax, the available transaction types are: * ABOVE: Above the rack * BELOW: Below the rack * RACK: At the rack
SellerRequiredUsers must be able to specify the unique seller ID.
BuyerRequiredUsers must be able to specify the unique buyer ID.
User transaction IDRequiredUsers must be able to specify the corresponding AvaTax transaction code that’s used to commit a transaction in both environments. Every new transaction must have a new UserTranId.
Entity use codeRequiredFor each transaction, users must be able to specify an entity use code for a sales/use tax exemption.
Custom strings and numericsRequiredUsers must have a way to enter up to ten custom strings and up to ten custom numeric values as a way to customize calculations based on their business rules.
Source systemRequiredUsers must be able to specify a string that identifies the system that’s calling the application with this transaction.
Fuel use codeSuggestedUsers should be able to specify a code that describes how the fuel is used.
Transportation mode codeSuggestedUsers should be able to specify a code that describes the transportation mode. This code comes from the transportation mode code master data table.
User dataSuggestedUsers should be provided with a field for entering data about the user.
AvaTax transaction typeSuggestedUsers should be able to specify the corresponding AvaTax transaction type.
Discount amountSuggestedUsers should be able to specify a discount amount at the header level. This discount will then be applied to all lines with "Discounted": true.

Advanced feature: Fuel transactions - line level

NameTypeDescriptionComments
Invoice lineRequiredUsers must be able to specify multiple lines on a transaction.
Product codeRequiredUsers must be able to specify a product code when creating an ATE transaction.
Unit priceConditionalTransactions must know the cost or amount of an item to perform a tax calculation. This is done by specifying either a unit price and/or a line amount.
Line amountConditionalTransactions must know the cost or amount of an item to perform a tax calculation. This is done by specifying either a unit price and/or a line amount.
CurrencyRequiredUsers must be able to specify the currency that the unit price and/or line amount use.
Net unitsRequiredUsers must be able to specify the net unit volume when the item is at 60 degrees Fahrenheit.
Gross unitRequiredUsers must be able to specify the gross unit volume at the time of delivery for an item.
Billed unitsRequiredUsers must be able to specify the unit volume that is used for billing. This value must match either the net units or gross units.
Unit of measureRequiredUsers must be able to specify the unit of measure that the net, gross, and billed units are defined in.
Origin addressRequiredUsers must be able to specify the origination country code, jurisdiction (for example, the state), county, city, and postal code. In addition, including a street-level address will provide more accurate tax determination.
Origin codeRequiredUsers must be able to specify a custom ID for a defined origination location rather than specifying the full origin address.
Origin typeSuggestedUsers should have an option to specify the type of facility where the product originated from (for example, pipeline, refinery, terminal, truck, and so on).
Destination addressRequiredUsers must be able to specify the destination country code, jurisdiction (for example, the state), county, city, and postal code. In addition, including a street-level address will provide more accurate tax determination.
Destination codeRequiredUsers must be able to specify a custom ID for a defined destination location rather than specifying the full destination address.
Destination typeSuggestedUsers should have an option to specify the type of facility receiving the product (for example, pipeline, refinery, terminal, truck, and so on).
Sale addressRequiredUsers must be able to specify the sales country code, jurisdiction (for example, the state), county, city, and postal code. In addition, including a street-level address will provide more accurate tax determination.
Sale typeSuggestedUsers should have an option to specify the type of facility where the sale of the product took place (for example, pipeline, refinery, terminal, truck, and so on).
Movement start and end datesSuggestedFor specialty tax configurations, users should be able to specify the start and end dates for when items are transported.
Bill of lading numberSuggestedUsers should have an option to specify a bill of lading number. This is useful for integrations that allow searching for transactions via the ATE UI.
Bill of lading dateSuggestedUsers should have an option to specify a bill of lading date. This is useful for integrations that allow searching for transactions via the ATE UI.
Tax includedSuggestedYour integration should allow users to specify whether tax is already included in a transaction line’s unit price and/or amount.
DiscountedSuggestedYour integration should allow users to specify whether a transaction line’s unit price and/or amount is a discounted value.

Certification badge requirements. View on Avalara.