Avalara Consumer Use transaction import template guidelines

The vendor’s unique identifier in your source system.

This translates to customerCode in an AvaTax call.

Total line item amount before discount and tax.

This isn't the unit price, which is not specified on the import.

System either needs a valid DestLocationCode that is known to AvaTax OR a complete DestAddress with DestPostalCode.

If LocationCode and address are provided for a new location, Avalara Consumer Use will remember the association.

Note: A ShipTO error may occur for a location code that starts with zero because Microsoft Excel removes this zero during the import process. To prevent this error, we recommend adding an apostrophe (') to the location code that starts with zero. For example, if the location code is 01234, we recommend you change it to '01234 to prevent Microsoft Excel from removing zero during the import process.

A postal code (11)

Sub company to which this invoice was originally billed. 

If empty Avalara Consumer Use will default this to the current company during file upload.

Defaults to PurchaseInvoice. 

Expects one of the AvaTax document type enums.

Note that this is the original doc type from the host system. When sent to AvaTax, type will always be PurchaseInvoice or InventoryTransferInvoice so that results are recorded correctly.

Optional, but must be populated for all lines for an invoice or all blank. 

All blank line numbers will be populated with sequential numbers from 1, in order of appearance within the file.

Original accounting system cost center to which this invoice or specific line item was charged. 

Can be used within Avalara Consumer use to identify cost centers that are tax exempt per list provided by customer.

 Defaults to DocDate. 

This is for exception cases where the invoice date is not the effective date for determination of Consumer Use Tax liability.

It is uncommon to get this directly in the feed, unless the source system is one already AvaTax-aware. 

Will most often be "G" for Resale, or "I" for production/manufacturing.  Must be one of the AvaTax enum values for EntityUseCode.

Defaults to "P0000000", which is generic, taxable. 

One would either specify a TaxCode directly or specify an ItemCode and let AvaTax pull the TaxCode from the Item. 

When the system sees a new ItemCode, it will collect any available TaxCode for default values in the future. View valid tax codes.

Specific use of material or service represented by this line item. 

Very useful for specific tax handling, especially for invoices expected to be tax exempt.

Recommended for item taxability rules and rates, as well as readability within Avalara Consumer Use.

Must be an item code for an item created for this company.  These then map to TaxCodes. View related APIs.

A number

Boolean. If True the Amount less than the discount is that final line item amount.  If False, the Amount + Tax.

Note that this defaults to FALSE unless TotalTax is null.  The system treats a line with an empty TotalTax amount as tax included.

Tax collected by the vendor and paid on this line item directly to tax authority.  Use zero if no tax was collected. 

Note that when this value is null, the system will treat the line as tax included and back the tax out of the line’s TaxableAmount

Recommended for reliable addresses. 

Defaults to US.

Host system identifier for the Purchasing Agent for this transaction. 

Passed into the SalesPersonCode in AvaTax

Custom1-10

Avalara Consumer Use allows 10 custom fields.

They aren't sent to AvaTax. They're useful for classifying transactions for better filtering, allocation, and export.