Manual upload of transactions is not a fix. We bookkeepers don't have access to our clients' online banking. The entire point of QBO connecting to the bank is so that we don't need to have the login, but can still get transactions.