Once you've verified your settings, import or synchronize your transaction data so TrustFile can generate returns.
It's critical to include only transaction data from the current filing period in your returns. Data from outside the current filing period is swept forward into the current return, which can cause reconciliation errors. TrustFile doesn't file late or delinquent returns.
- Use a connector to synchronize your data if you have one of these TrustFile-compatible accounting software: Amazon, Etsy, FreshBooks, PayPal, PrestaShop, QuickBooks Online, Shopify Plus, Weebly, and Xero.
- Import transaction data using a CSV file if you don't have an TrustFile-compatible connector.
- Manually add a transaction if you need to add individual transactions to TrustFile.
Use a connector to synchronize your data
The overall process of synchronizing with TrustFile is pretty much the same across different accounting software.
- From the Current Returns page, click Manage in the Transactions and Sources field on the right of the screen.
- Select the platform you use, and then follow the instructions in the pop-up window. For many platforms, click Connect and follow the instructions to synchronize data. For platforms without a connector to synchronize data, import your data using a CSV file.
- After you connect, click Authorize. You're taken to the log-in screen for the platform to which you're trying to connect. Log in and authorize TrustFile to establish a connection with your platform.
The initial synchronization may take up to several days depending on the platform and the number of transactions. Keep this in mind when planning out your return schedule.
Synchronize with Xero - Video
Import transaction data using a CSV file
Use a CSV file to transfer transactions from an accounting software that doesn't have a connector. First, export the data from your accounting software, and then import that data using a CSV file. The initial synchronization may take several days depending on the number of transactions. Keep this in mind when planning your return schedule.
- On the Current Returns page, click Manage in the Transactions and Sources field on the right of the screen.
- On the Sources tab, click Upload, and then follow the upload wizard. It's best to download the preformatted template to reduce the chance of error.
- If this is the first time you've imported data, scroll down the Current Returns page and use the drop-down to verify the forms to file. Click Set Form to save. If you've imported before, the transactions you've imported already appear in a queue to file on a state return.
Export data from your accounting software
The best practice for importing data is to use the import template provided by TrustFile on the upload screen. This ensures the data is imported in a recognized format and ensures the least number of import errors as a result of this process. If you use your own CSV file instead of using a template, the CSV file needs each of the fields shown below. If the upload fails, the TrustFile team must manually map the data, which can take several days.
Review this list to ensure your CSV file matches the way TrustFile processes data.
|Order date||Determines on which return the transaction appears. If you're using cash-based accounting, and your invoices have different order and paid dates, transactions can be split across filing periods.|
|Sale price||If tax is included in the sale price, TrustFile shows zero sales tax collected for that transaction.|
|Tax amount||TrustFile handles tax only on tangible personal property and assumes all tax collected is sales tax.
|Ship-to address (with separate fields for street address, city, state, and zip)||Determines the tax rate for a transaction and for the jurisdictions to which your tax will be remitted; in some states, your business address is also used.|
Manually add a transaction
Add an individual transaction to reconcile errors on a return.
- On the Current Returns page, click Manage in the Transactions and Sources field.
- On the Sources tab, click Enter in the Manual Entry field.
- In the Add transactions manually window, type the details of the transaction, and then click Add Transaction.
- A summary of your transaction appears at the bottom of the Add transactions manually window. Click anywhere on the row to expand or collapse the details for that row.
- Add as many transactions as you need in this window. Click Generate Return after you're done adding transactions to upload the transaction details to your TrustFile account.