Question
Bulk Updating Account Numbers in Chart of Accounts (Not Adding New Accounts)
I’m hoping someone can confirm whether there’s a way to bulk update existing accounts in QuickBooks Online with new account numbers.
Here’s the situation:
- My entity has around 1,000 accounts in the Chart of Accounts.
- Almost none of them currently have account numbers.
- I’ve already built an Excel file that assigns account numbers to each existing account.
I know about the “Batch Edit” feature in the Chart of Accounts, which does make editing easier, but it still requires me to copy and paste each account number one by one into QuickBooks. That’s not what I’m looking for.
When I try to use the import/upload feature, it only seems to add new accounts, not update existing ones.
Right now, our fallback plan is to have someone spend the next week or so updating all 1,000 accounts manually, but before we go that route, I wanted to check if there’s a better, true bulk update method available.
Has anyone found a reliable way to do this?