When using an accounting system that we don't have a direct integration with, utilize our Import feature using .CSV files.

Important Note: If you sync with an accounting software, we don't recommend importing records via CSV into Bill.com unless they don’t exist in your accounting software at all to avoid duplicates and sync errors.

1. Select Settings
2. Select Import / Export
3. Select Import next to the record type you're importing
4. Select Browse
5. Select the .CSV file to import
6. Select Upload
   • This will lead to the Import Preview page where the information to be imported will be displayed
     • Action column: Create vs Update
       • Create: There's no matching record, this line item will be created as a new record
       • Update: There's a matching record, this line item will update the existing record
   • If the file selected is unable to be uploaded due to errors in the formatting or missing information, there will be an error message
7. Review and correct any errors
8. Select Import
   • The Import History page will be displayed, which provides details about the import process, including the time of the import and whether the information was imported successfully
9. If the Import says Failed in the Status column, select View in the Action column to see more details about why the import failed
   • Download the error report, correct any errors in the import file, and try the import again, if needed

Things to know

• The user permission required for importing data is Sync with Accounting System plus the corresponding permissions for the object
• There's no limit to the size of the csv file to be imported