When using an accounting system that we do not have a direct integration with, utilize our Import feature using .CSV files.
Important Note: If you sync with an accounting software, we highly suggest not manually importing records & transactions via CSV into Bill.com, unless they do not exist in your accounting software at all, to avoid duplicates and sync errors
- Click Settings
- Click Import / Export
- Click Import next to the type of record being imported
- Click Browse
- Select the .CSV file to import
- Click 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 is no matching record, this line item will be created as a new record
- Update: There is 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
- This will lead to the Import Preview page where the information to be imported will be displayed
- Review and correct any errors
- Click Import
- The Import History page will be displayed
- This page provides details about the import process, including the time of the import and whether the information was imported successfully
- The Import History page will be displayed
- If the Import says Failed in the Status column, click 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 permissions required for importing data is Sync with Accounting System plus the corresponding permission for the object