cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
IT_Fiona
Level 2

Entering 4 digits of account number in the format sheet can be accepted?

I'm now doing the format spreadsheet of COA, can I put 4 or 5 -digits rather than 6 digits in the column of Account Number,does this fail to meet formatting requirements and cause the sheet import to fail?

1 Comment 1
Kurt_M
QuickBooks Team

Entering 4 digits of account number in the format sheet can be accepted?

It's a pleasure to have you here today, Fiona. I'll answer your question about importing spreadsheet file format to your Chart of accounts inside QuickBooks Online (QBO).

 

In QBO, you can enter 4 to 5-digit numbers in the Account Number column inside the spreadsheet and import them successfully into your Chart of Accounts. Also, you'll want to map the spreadsheet fields accurately to avoid errors during the process and have the data available inside your company file. 

 

For further guidelines, you can check this article: Import your chart of accounts to QuickBooks Online.

 

Moreover, we recommend checking these articles in case you want to upload bank transactions inside QBO:

 

 

We look forward to helping you again if you have other questions about the program or need further assistance getting data into your account. Feel free to comment below so we can respond right away. Keep safe.