Gallery
Share
Explore

icon picker
Data Import Requirements Manual

Thank you for choosing Complyt for your tax compliance needs. This guide is designed to help you seamlessly navigate through our tax assessment process, ensuring a smooth and efficient process for your tax compliance requirements.

Outputs

Economic Nexus Mapping - Identification of tax obligations based on transaction locations and items.
Exposures - Calculation of the taxable amount for each transaction, as if processed by Complyt's engine from the start.

Prerequisites

Products Classification: To ensure the most accurate assessment, it's crucial to consider the varying taxability of different items. Therefore, we need to determine the specific Complyt tax code for each of the client's products before initiating the automated assessment.

Important to Know

Each row in the file represents a line item - Taxability can vary depending on the items sold. Thus, an invoice with multiple line items may have different tax rates applicable to each. To accurately process and calculate the tax for each item, it's necessary for each to be in a separate row.
Exempt Customers & Customer Type Update - Both exempt customers and customer types can affect tax calculation. For example - Some states include the taxable amount in the nexus threshold, and some states exclude the marketplace. We might need to update these before running the Automated Assessment again with the updated values.

Template File to Download

Table Fields Details


⁠
Automated Assessment Template.xlsx
19.7 kB
⁠
⁠
Fields
Field Name
Importance
Description
Examples 2
1
Customer ID
Mandatory
The customer ID in the accounting system. If there isn’t an ID (because the customers are not managed in a system), a unique value such as an email address is also applicable.
15714 CS323241 Complyt@Complyt.io
2
Customer Name
Recommended
Customer's name. If not applicable, the ID can be used as the name as well.
Complyt’s Home Made Cookies 15714 CS323241
3
Customer Type
Recommended
Category of the customer.
This can influence nexus threshold calculations. If not applicable, the default value of 'RETAIL' will be assigned.
RETAIL
MARKETPLACE
RESELLER
4
Transaction ID
Mandatory
Unique identifier for each transaction.
388828
5
Transaction Name
Recommended
Descriptive or reference name of the transaction. If missing, the transaction ID will be used instead
INVUS22331 388828
6
Transaction Type
Mandatory
The type of the transaction.
INVOICE
REFUND
7
Transaction Country
Mandatory
The shipping country of the transaction. The system will ignore non-USA countries, including blank values.
USA United States
8
Transaction State
Mandatory
The shipping State of the transaction
NY New York
9
Transaction City
Highly Recommended
City to which the transaction's items are shipped.
Orlando Baltimore
10
Transaction Address
Highly Recommended
Street address to which the transaction's items are shipped.
20 E Market St 101 S West St
11
Transaction ZIP
Highly Recommended
The shipping zip of the transaction. If missing, a default ZIP will be used
19801 89169
12
Transaction Created Date
Mandatory
The date of which the transactions was issued
Allowed format - yyyy-MM-dd
2023-05-17
13
Item Name
Mandatory
Item’s unique name or ID
Subscription module per year
14
Item Unit Price
Mandatory
Price per unit of the item.
5
15
Item Quantity
Mandatory
Number of units of the item included in the transaction.
4
16
Item Amount
Recommended
Total price for the item, calculated as Item Unit Price multiplied by Item Quantity.
20
17
Subsidiary
Highly Recommended
The ID or the name of the Subsidiary that is associated with the transactions
Complyt INC
There are no rows in this table
⁠


Outputs
Prerequisites
Important to Know
Template File to Download
Table Fields Details
Fields
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.