Can Quickbooks connect to a Venmo Business account without having to manually upload the transactions?

I've got your back, Kylin.

Can you tell us what specific error you received? 

For now, you can manually update your banking transaction information. Doing so downloads any new transactions listed within the previous 90 days. Here's how: 

1. Go to Transactions,  then choose Bank transactions.
2. Select Update.
3. If prompted, type in your Multi-Factor Authentication (MFA) credentials and click Continue update. You'll need to enter these credentials within 2 minutes. MFA is any security precaution requiring more than a username and password.

If the issue persists, I suggest contacting our support team to investigate further.

Moreover, here's an article that provides more info about QuickBooks and Venmo connection: Use PayPal and Venmo with QuickBooks Online.

I'll be waiting to hear from you about the error you encountered. Your response will help me offer the best solution to the problem.

@kylin.mettler 

You can use MT Online or one of the converter tools (e.g csv2qbo @ $60 one time license) as a workaround.

https://www.moneythumb.com/?ref=110