The following is a list and explanation of each of the fields you can include when importing items.
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 |
|---|---|---|---|---|---|
| Active? | No | N/A | Denotes if this Item 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 |
| Name* | Yes | 100 characters | The name of this Item | N/A | N/A |
| Type* | Yes | N/A | Denotes if this Item is a product, service or other categories typically set by the accounting system | - unknown - service - inventory - nonInventory - payment - discount - salesTax - subtotal - otherCharge - inventoryAssembly - group - salesTaxGroup - fixedAsset |
- Requires an exact match with one of the accepted values - Only items with type: Sales Tax can be used as a Sales Tax on invoice - Items with type: Discount always invert the sign of their price/rate or percentage - unknown = Unknown - service = Service - inventory = Inventory - nonInventory = Product (Non-inventory) - payment = Payment - discount = Discount - salesTax = Sales Tax - subtotal = Subtotal - otherCharge = Other Charge - inventoryAssembly = Inventory Assembly - group = Group - salesTaxGroup = Sales Tax Group - fixedAsset = Fixed Asset |
| Description | No | 4000 characters | The description of this Item | N/A | N/A |
| Price/Rate | No | N/A | The price of one unit of this Item | N/A | - Must be in the range of -9999999 to 9999999 - Does not support fractions of cents - If this is left blank, it will appear as blank; this is treated as $0.00 - Accepts values with or without a $ - Any value imported using this field is converted to static currency (no percentages) - If this field is used, it will override the percentage field, except for Items of type: Sales Tax |
| Percentage | Only if item type is Sales Tax | N/A | The percentage value of this item | N/A | - Accepts values with or without a % - Supports up to five decimal places - If the price/rate field is used, it will override this field - This field is required for Items of type: Sales Tax |
| Subitem of | No | 100 characters | The name of this Item's parent | N/A | - Requires an exact match with the desired Item's name - The desired Item must be active in Bill.com, or created during the same import |
| Expense Account Name | No | 250 characters | The name of the account that this Item is coded to when used on bills / purchases in your accounting system | N/A | - Requires an exact match with the desired Account's name - The desired Account must be active in Bill.com, or created during the same import - Both account name and account number (if used) must be provided |
| Expense Account Number | No | 40 characters | The account number of the account that this Item is coded to when used on bills / purchases in your accounting system | N/A | - Requires an exact match with the desired Account's account number - The desired Account must be active in Bill.com, or created during the same import - Both account number (if used) and account name must be provided |
| Purchase Description | No | 4000 characters | The description of this Item when used on bills / purchases in your accounting system | N/A | N/A |
| Purchase Cost | No | N/A | The cost of purchasing this Item; primarily used in accounting systems | N/A | - Must be in the range of -9999999 to 9999999 - Does not support fractions of cents - If this is left blank, it will appear as blank; this is treated as $0.00 - Accepts values with or without a $; negative values must omit the $ |
| Account Name | No | 250 characters | The name of the account that this Item is coded to when used on invoices / sales | N/A | - Requires an exact match with the desired Account's name\ - The desired Account must be active in Bill.com, or created during the same import - Both account name and account number (if used) must be provided |
| Account Number | No | 40 characters | The account number of the account that this Item is coded to when used on invoices / sales | N/A | - Requires an exact match with the desired Account's account number - The desired Account must be active in Bill.com, or created during the same import - Both account number (if used) and account name must be provided |
| Taxable? | No | N/A | Denotes if this Item defaults to taxable on your invoices / sales | No Yes | Requires an exact match with one of the accepted values |
| Item Id | Yes | 20 characters | An alternative identifier for this Item defined by you and/or a third-party system | N/A | - Key field - Requires an exact match with the desired Vendor's name (for updating) |
