Skip to main content
Avalara Help Center

Import or Synchronize Transactions

This article applies to:Avalara TrustFile

Once you've verified your settings, provide the transaction data TrustFile uses to generate sales tax returns.

Use one of the following methods to add your transaction data to TrustFile:

  • Synchronize transaction data if you have accounting software that connects to TrustFile
  • Import transaction data using a CSV file if your accounting software doesn't connect to TrustFile
  • Manually add a transaction if you need to add individual transactions to TrustFile

If transactions that shouldn't be included in your filing sync to TrustFile, delete the transactions from TrustFile.

Keep in mind that:

  • TrustFile doesn't calculate taxes.
  • TrustFile doesn't file late or delinquent returns. It's critical you include only transaction data from the current filing period in returns. TrustFile sweeps data from outside the current filing period forward into the current return, which can cause reconciliation errors.

Synchronize your accounting software data with TrustFile

To synchronize accounting software transaction data with TrustFile:

  1. In TrustFile, click Data Sources. The Data Sources screen opens.
  2. Click the name of your accounting software, fill in the fields, and then click Connect.
  3. Follow any additional on-screen instructions to connect, and then click Authorize. The login screen for the accounting software with which you're synchronizing data opens.
  4. Log in and authorize TrustFile to establish a connection with the platform.

The initial synchronization may take up to several days, depending on the accounting software and the number of transactions. Keep this in mind when planning out your return schedule.

Import transaction data in a CSV file

Use a CSV file to transfer transactions from accounting software that doesn't connect with TrustFile. First, export the data from your accounting software, and then import that file into TrustFile.

Export data from your accounting software

To minimize import mistakes and ensure the data is imported in a recognized format, put the data you export from your accounting software into the import template provided by TrustFile on the upload screen (Data Sources > Upload). Delete the example transaction in the template, but retain the column headings.

If you use your own CSV file instead of using the template, the CSV file needs each of the columns below. If the upload fails, the TrustFile team must manually map the data, which can take several days, in addition to upload time. We strongly recommend using the provided template.

Use this information to make sure your CSV file and the information in it are formatted correctly for TrustFile:

Column heading Description
order_id The unique identifier number for the invoice, credit memo, or return.

The number must be unique at the company level.

date

Date of the transaction. Format the date as MM/DD/YY or MM/DD/YYYY.

Determines which return the transaction appears on. If you're using cash-based accounting, and invoices have different order and paid dates, you can split transactions across filing periods.

sales The sales price of the transaction. To make sure your tax is filed correctly, enter the sales price before shipping and taxes. If you include tax in the sales price, TrustFile shows zero sales tax collected for that transaction.
tax

Sales tax collected on the transaction. TrustFile handles tax only on tangible personal property and assumes all tax collected is sales tax.

  • TrustFile can't retroactively calculate how much tax to collect for a transaction. For that service, use AvaTax.
  • TrustFile assumes you collected the correct amount of tax for a transaction; if the tax amount and the sales price don't match for a particular transaction, TrustFile adjusts the sales amount to match the collected tax.
description A description of the transaction.
shipping Shipping fee charged on the transaction, if any.
shipping_tax Tax collected on the shipping fee.

origin_line1, origin_line2, origin_city, origin_state, origin_zip

The origin address of the transaction. In some states, your business address is used to determine the tax rate for a transaction and the jurisdictions to which tax will be remitted.
shipping_line1, shipping_line2, shipping_city, shipping_state, shipping_zip The ship-to address for the transaction. Determines the tax rate for a transaction and the jurisdictions to which tax will be remitted.

Import a CSV file into TrustFile

To import a CSV file with transaction data into TrustFile:

  1. Click Data Sources. The Data Sources screen opens.
  2. Next to Files, click Upload, follow instructions in the upload wizard, and then:
    • If this is the first time you've imported data, scroll down the Current Returns page, verify the forms to file, and then click Set Form.
    • If you've imported data before, the transactions you've imported appear in a queue to file on a return.

The initial synchronization may take several days, depending on the number of transactions. Keep this in mind when planning your return schedule.

Manually add a transaction

Add an individual transaction to reconcile errors on a return.

To manually add a transaction:

  1. Click Data Sources. The Data Sources screen opens.
  2. Next to Manual Entry, click Enter. The Add Transactions Manually window opens.
  3. Fill in the details of the transaction, and then click Add Transaction. A summary of your transaction appears at the bottom of the window.
  4. Click anywhere on a summary row to expand or collapse the details for that row.
  5. Add as many transactions as you need in this window, and then click Generate Return to finalize the transaction details.

Next steps

Once you've synchronized or imported your data, reconcile your transaction data. If everything adds up, you're ready to file your returns.