Import locations

The following is a list and explanation of each of the fields you can include when importing locations.

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.

Field Name Required? Maximum Length Description Accepted Values Additional Information
Location Name* Yes 100 characters The name of this Location - Key field
- Requires an exact match with the desired Location's name (for updating)
Active? No NA Denotes if this Location is active or inactive - Active
- Inactive
- Requires an exact match with one of the accepted values
- All records are set to Active when created; they cannot be created and set to inactive in the same import
Description No 4000 characters The description of this location
Location ID* Yes 20 characters The ID of this Location
Parent Location Name No 100 characters The name of this Location's parent Requires an exact match with the desired Location's name
Parent Location ID No 40 characters The ID of this Locations's parent - Requires an exact match with the desired Location's name
- The desired Location must be active in Bill.com, or created during the same import

Please note: If specifying the Parent Location, both Parent Location Name and Parent Location ID must be provided.