Length limitation on QBO file ACCTID field?

nhelman64 · ‎August 17, 2020

I am unable to find a file specification for QBO files. I need to know if there is a length limitation on the ACCTID field in QBO files. The OFX specification limits ACCTID to 22 characters, but I have been unable to find a limitation specified on way or the other for QBO file format.

ShiellaGraceA · ‎August 18, 2020

Hi @nhelman64,

You'll want to consult your financial institution to know the limit. QuickBooks only have account name character limit. You can find the character field limits at the link below.

QuickBooks Online file size and feature limits.

I'll also share with you our page about fixing bank upload errors that I'm sure you'll find helpful. It contains temporary and easy to fix resolution to manual-upload related issues.

Please know that we're always here if you have other questions or concerns, so don't hesitate to swing by anytime. Thanks for posting and I wish you have a good one.

View solution in original post

john-pero · ‎August 17, 2020

If ACCTID is Account Name then the limit is 100

https://quickbooks.intuit.com/learn-support/en-us/order-products-from-intuit/quickbooks-online-file-...

nhelman64 · ‎August 18, 2020

No, in a QBO file (not QuickBooks Online; it's a WebConnect file), there is a field called ACCTID. I need to know if there's a max length for this field in the extract file. In the OFX spec, it's limited to 22 characters.

nhelman64 · ‎August 18, 2020

No, it's not Account Name. It's in the QBO format WebConnect file, not QuickBooks Online. The extract file has a field named ACCTID. That's what I need to know the length limitation for.

ShiellaGraceA · ‎August 18, 2020

Hi @nhelman64,

You'll want to consult your financial institution to know the limit. QuickBooks only have account name character limit. You can find the character field limits at the link below.

QuickBooks Online file size and feature limits.

I'll also share with you our page about fixing bank upload errors that I'm sure you'll find helpful. It contains temporary and easy to fix resolution to manual-upload related issues.

Please know that we're always here if you have other questions or concerns, so don't hesitate to swing by anytime. Thanks for posting and I wish you have a good one.

Topics

Training

Community

Resources

Length limitation on QBO file ACCTID field?