Populating the Transaction Import Template
Please follow the below instructions on how to populate the Default Transaction Import Template for Telecommunications:
- Grouping:invoiceNumber (Recommended Field)
- Invoice Date (Required Field)
- Date of the invoice, can be populated as either YYYY-MM-DD OR MM/DD/YYYY, which will be converted to the preceding format upon upload
- Invoice Total Amount (Recommended Field)
- Total amount of the Invoice
- If each of your Invoices are just 1 line, then this will be the same value as the Revenue amount.
- If a unique Invoice has multiple Line ID's, this field should be the sum of the Revenue amounts for each Line ID on the Invoice.
- Customer Account (Recommended Field)
- A unique identifier for your customer. Can be an ID or a Name.
- Business Type (Required Field)
- The type of Business your company identifies as. This should be the same value for every line in the Import File. Available options are:
- 10 - CLEC
- 11 - IXC
- 12 - CMRS/Wireless
- 13 - ILEC
- 14 - Prepaid Wireless
- 15 - VoIP
- 16 - TV Provider
- Customer Type (Required Field)
- The type of Customer you are selling to. This value can be different for each Customer. Available options are:
- 01 - Residential
- 02 - Business/Commercial (Default)
- 04 - Senior Citizen
- 05 - Tribal Government
- 06 - Federal Government
- 07 - State Government
- 08 - Local Government
- Note: Because these values contain leading zeros (0), you will want to ensure the format of these cells in the import file are Text.
- 10 - Lifeline
- 12 - Retail
- 13 - Tribal Member
- Seller Type (Required Field)
- The type of Seller for this Invoice. Available options are:
- 01 - Physical Nexus in State (Default)
- Note: Because this value contains a leading zero (0), you will want to ensure the format of this cell in the import file is Text.
- Revenue Includes Tax (Required Field)
- Indicates whether the revenue amount for this Line Item already includes tax. Available options are:
- 0 – No tax in revenue (Default). CereTax will calculate tax on the provided revenue amount.
- 1 - Revenue includes tax. An Adjusted Revenue amount will be displayed in the Transactions screen after importing the file & in any CereTax reporting, indicating the tax exclusive portion of the revenue.
- Line ID (Required Field)
- Unique ID for each line on the invoice.
- If a unique Invoice only has 1 line item, this value will typically be 1.
- If a unique Invoice has multiple line items, this value will typically start at 1 and increase sequentially.
- Item Number (Required OR Recommended Field)
- Unique ID for your Product/Service. Utilization of this field requires that the Item Number be mapped to a psCode within CereTax. This field does not need to be populated if you will be using the psCode field, but can still be optionally provided.
- Item Description (Optional Field)
- Description of your Product/Service.
- psCode (Required Field)
- The CereTax taxability category. Utilization of this field does not require Product Mapping configuration within CereTax. The Item Number & Item Description fields can still be optionally populated.
- Revenue (Required Field)
- The total revenue amount for the associated Line ID. CereTax is not performing any calculation based on Revenue X Quantity.
- Note: If the file being uploaded is inclusive of tax amounts that were already calculated, the Revenue Amount should also include the already calculated tax amount for the associated line.
- units.quantity (Required Field)
- Quantity of Units. Default value is 1 unit.
- CereTax is not performing any calculation based on Revenue x Quantity.
- units.type (Required Field)
- Type of Units. Available options are:
- 03 - Access Line (Default)
- Note: Because this value contains a leading zero (0), you will want to ensure the format of this cell in the import file is Text.
- situs.taxSitusRule (Required Field)
- Defines the address type that will be used to calculate tax on the line. Available options are:
- C - Toll Calling
- Uses Toll Calling Block (Origination Address, Termination Address) and Billing Address
- L - Private Line
- Uses Private Line Block (Address Point A, Address Point Z)
- S - Customer Address
- Uses the Customer's Service Address or Billing Address
- f both are provided, Service Address will take priority
Customer Address Fields
The following section provides instruction on the available Address fields within the Default Import File, using Customer Address as the Tax Situs Rule. If you are only using Billing Address, the Service Address columns can be deleted from your file. If you are only using Service Address, the Billing Address columns can be deleted from your file. Any unused Address fields can be deleted from your file, as long as they are not required.
- billingAddress.addressLine1 (Recommended Field)
- Address line 1.
- Ex. 3440 Preston Ridge Rd
- billingAddress.addressLine2 (Optional Field)
- billingAddress.city (Recommended Field)
- billingAddress.state (Required Field)
- billingAddress.postalCode (Required Field)
- Address postal code. Can be US or Canadian postal code values.
- For US, if the full 9-digit postal code is provided, it must be entered in one of the following formats:
- ######### (ex. 300053817)
- #####-#### (ex. 30005-3817)
- ##### #### (ex. 30005 3817)
- For any postal codes that begin with zero (0), those cells should be formatted as text.
- For Canada, the postal code must be entered in one of the following formats:
- A#A A#A (ex. H1A 0A2)
- A#AA#A (ex. H1A0A2)
- billingAddress.latitude (Optional Field)
- Latitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Longitude field.
- billingAddress.longitude (Optional Field)
- Longitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Latitude field.
- billingAddress.validateAddress (Optional Field)
- Determines if the address should be validated before the tax calculation. Available options are:
- FALSE - When set to false, the address will not be validated before the tax calculation.
- TRUE - When set to true, the address will be validated before the tax calculation. If set to true, one of the following field combinations must be included in the address object:
- addressLine1 + City + State
- addressLine1 + postalCode
- billingAddress.phoneNumber (Optional Field)
- Phone number for this address, if known. Number should be formatted as NPANXXNNNN. Place a zero (0) in first position if outside of North America.
- serviceAddress.addressLine1 (Recommended Field)
- Address line 1.
- Ex. 3440 Preston Ridge Rd
- serviceAddress.addressLine2 (Optional Field)
- serviceAddress.city (Recommended Field)
- serviceAddress.state (Required Field)
- serviceAddress.postalCode (Required Field)
- Address postal code. Can be US or Canadian postal code values.
- For US, if the full 9-digit postal code is provided, it must be entered in one of the following formats:
- ######### (ex. 300053817)
- #####-#### (ex. 30005-3817)
- ##### #### (ex. 30005 3817)
- For any postal codes that begin with zero (0), those cells should be formatted as text.
- For Canada, the postal code must be entered in one of the following formats:
- A#A A#A (ex. H1A 0A2)
- A#AA#A (ex. H1A0A2)
- serviceAddress.latitude (Optional Field)
- Latitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Longitude field.
- serviceAddress.longitude (Optional Field)
- Longitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Latitude field.
- serviceAddress.validateAddress (Optional Field)
- Determines if the address should be validated before the tax calculation. Available options are:
- FALSE - When set to false, the address will not be validated before the tax calculation.
- TRUE - When set to true, the address will be validated before the tax calculation. If set to true, one of the following field combinations must be included in the address object:
- addressLine1 + City + State
- addressLine1 + postalCode
- serviceAddress.phoneNumber (Optional Field)
- Phone number for this address, if known. Number should be formatted as NPANXXNNNN. Place a zero (0) in first position if outside of North America.
Toll Calling Address Fields
The following section provides instruction on the available Address fields within the Default Import File, using Toll Calling as the Tax Situs Rule. Any unused Address fields can be deleted from your file, as long as they are not required.
- originationAddress.addressLine1 (Recommended Field)
- Address line 1.
- Ex. 3440 Preston Ridge Rd
- originationAddress.addressLine2 (Optional Field)
- originationAddress.city (Recommended Field)
- originationAddress.state (Required Field)
- originationAddress.postalCode (Required Field)
- Address postal code. Can be US or Canadian postal code values.
- For US, if the full 9-digit postal code is provided, it must be entered in one of the following formats:
- ######### (ex. 300053817)
- #####-#### (ex. 30005-3817)
- ##### #### (ex. 30005 3817)
- For any postal codes that begin with zero (0), those cells should be formatted as text.
- For Canada, the postal code must be entered in one of the following formats:
- A#A A#A (ex. H1A 0A2)
- A#AA#A (ex. H1A0A2)
- originationAddress.latitude (Optional Field)
- Latitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Longitude field.
- originationAddress.longitude (Optional Field)
- Longitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Latitude field.
- originationAddress.validateAddress (Optional Field)
- Determines if the address should be validated before the tax calculation. Available options are:
- FALSE - When set to false, the address will not be validated before the tax calculation.
- TRUE - When set to true, the address will be validated before the tax calculation. If set to true, one of the following field combinations must be included in the address object:
- addressLine1 + City + State
- addressLine1 + postalCode
- originationAddress.phoneNumber (Optional Field)
- Phone number for this address, if known. Number should be formatted as NPANXXNNNN. Place a zero (0) in first position if outside of North America.
- terminationAddress.addressLine1 (Recommended Field)
- Address line 1.
- Ex. 3440 Preston Ridge Rd
- terminationAddress.addressLine2 (Optional Field)
- terminationAddress.city (Recommended Field)
- terminationAddress.state (Required Field)
- terminationAddress.postalCode (Required Field)
- Address postal code. Can be US or Canadian postal code values.
- For US, if the full 9-digit postal code is provided, it must be entered in one of the following formats:
- ######### (ex. 300053817)
- #####-#### (ex. 30005-3817)
- ##### #### (ex. 30005 3817)
- For any postal codes that begin with zero (0), those cells should be formatted as text.
- For Canada, the postal code must be entered in one of the following formats:
- A#A A#A (ex. H1A 0A2)
- A#AA#A (ex. H1A0A2)
- terminationAddress.latitude (Optional Field)
- Latitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Longitude field.
- terminationAddress.longitude (Optional Field)
- Longitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Latitude field.
- terminationAddress.validateAddress (Optional Field)
- Determines if the address should be validated before the tax calculation. Available options are:
- FALSE - When set to false, the address will not be validated before the tax calculation.
- TRUE - When set to true, the address will be validated before the tax calculation. If set to true, one of the following field combinations must be included in the address object:
- addressLine1 + City + State
- addressLine1 + postalCode
- terminationAddress.phoneNumber (Optional Field)
- Phone number for this address, if known. Number should be formatted as NPANXXNNNN. Place a zero (0) in first position if outside of North America.
- billingAddress.addressLine1 (Recommended Field)
- Address line 1.
- Ex. 3440 Preston Ridge Rd
- billingAddress.addressLine2 (Optional Field)
- billingAddress.city (Recommended Field)
- billingAddress.state (Required Field)
- billingAddress.postalCode (Required Field)
- Address postal code. Can be US or Canadian postal code values.
- For US, if the full 9-digit postal code is provided, it must be entered in one of the following formats:
- ######### (ex. 300053817)
- #####-#### (ex. 30005-3817)
- ##### #### (ex. 30005 3817)
- For any postal codes that begin with zero (0), those cells should be formatted as text.
- For Canada, the postal code must be entered in one of the following formats:
- A#A A#A (ex. H1A 0A2)
- A#AA#A (ex. H1A0A2)
- billingAddress.latitude (Optional Field)
- Latitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Longitude field.
- billingAddress.longitude (Optional Field)
- Longitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Latitude field.
- billingAddress.validateAddress (Optional Field)
- Determines if the address should be validated before the tax calculation. Available options are:
- FALSE - When set to false, the address will not be validated before the tax calculation.
- TRUE - When set to true, the address will be validated before the tax calculation. If set to true, one of the following field combinations must be included in the address object:
- addressLine1 + City + State
- addressLine1 + postalCode
- billingAddress.phoneNumber (Optional Field)
- Phone number for this address, if known. Number should be formatted as NPANXXNNNN. Place a zero (0) in first position if outside of North America.
Private Line Address Fields
The following section provides instruction on the available Address fields within the Default Import File, using Private Line as the Tax Situs Rule. Any unused Address fields can be deleted from your file, as long as they are not required.
- addressPointA.addressLine1 (Recommended Field)
- Address line 1.
- Ex. 3440 Preston Ridge Rd
- addressPointA.addressLine2 (Optional Field)
- addressPointA.city (Recommended Field)
- addressPointA.state (Required Field)
- addressPointA.postalCode (Required Field)
- Address postal code. Can be US or Canadian postal code values.
- For US, if the full 9-digit postal code is provided, it must be entered in one of the following formats:
- ######### (ex. 300053817)
- #####-#### (ex. 30005-3817)
- ##### #### (ex. 30005 3817)
- For any postal codes that begin with zero (0), those cells should be formatted as text.
- For Canada, the postal code must be entered in one of the following formats:
- A#A A#A (ex. H1A 0A2)
- A#AA#A (ex. H1A0A2)
- addressPointA.latitude (Optional Field)
- Latitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Longitude field.
- addressPointA.longitude (Optional Field)
- Longitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Latitude field.
- addressPointA.validateAddress (Optional Field)
- Determines if the address should be validated before the tax calculation. Available options are:
- FALSE - When set to false, the address will not be validated before the tax calculation.
- TRUE - When set to true, the address will be validated before the tax calculation. If set to true, one of the following field combinations must be included in the address object:
- addressLine1 + City + State
- addressLine1 + postalCode
- addressPointA.phoneNumber (Optional Field)
- Phone number for this address, if known. Number should be formatted as NPANXXNNNN. Place a zero (0) in first position if outside of North America.
- addressPointZ.addressLine1 (Recommended Field)
- Address line 1.
- Ex. 3440 Preston Ridge Rd
- addressPointZ.addressLine2 (Optional Field)
- addressPointZ.city (Recommended Field)
- addressPointZ.state (Required Field)
- addressPointZ.postalCode (Required Field)
- Address postal code. Can be US or Canadian postal code values.
- For US, if the full 9-digit postal code is provided, it must be entered in one of the following formats:
- ######### (ex. 300053817)
- #####-#### (ex. 30005-3817)
- ##### #### (ex. 30005 3817)
- For any postal codes that begin with zero (0), those cells should be formatted as text.
- For Canada, the postal code must be entered in one of the following formats:
- A#A A#A (ex. H1A 0A2)
- A#AA#A (ex. H1A0A2)
- addressPointZ.latitude (Optional Field)
- Latitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Longitude field.
- addressPointZ.longitude (Optional Field)
- Longitude of address location, if known. Can be used in place of the Postal Code field in conjunction with the Latitude field.
- addressPointZ.validateAddress (Optional Field)
- Determines if the address should be validated before the tax calculation. Available options are:
- FALSE - When set to false, the address will not be validated before the tax calculation.
- TRUE - When set to true, the address will be validated before the tax calculation. If set to true, one of the following field combinations must be included in the address object:
- addressLine1 + City + State
- addressLine1 + postalCode
- addressPointZ.phoneNumber (Optional Field)
- Phone number for this address, if known. Number should be formatted as NPANXXNNNN. Place a zero (0) in first position if outside of North America.
Once the Transaction Import Template is populated, it can be saved in either .CSV or .XLSX format.
Transaction Import Templates
The following tables are pre-populated sample templates for each available Tax Situs Rule that can be exported into Excel:
Transaction Import Template for Telecommunications - Customer Address
Transaction Import Template for Telecommunications - Toll Calling
Transaction Import Template for Telecommunications - Private Line