When QB and probably QBO export trial balance reports, they append the account title to the gl account number (if you use account numbers in that QB client)
A lot of trial balance apps require gl account numbers or at least prefer them.
Every so often I try to use either TR's WPCS or Go System TB to send trial balance numbers directly to business tax returns.
The TR WPCS when running in Virtual Office (aka VO cloud server based) has issues with directly importing any data from QB because the VO WPCS is not running on same machine as QB Desktop and has to open QB Desktop. Theres a standalone utility, but that seems to have issues too.
The QB clients I have don't use fixed length account numbers.
I'm thinking that the only way to parse easily would be to manually insert a separator character such as comma or hyphen after the gl account number, and then use the Excel function to split that column into two separate ones, one with just the account number.