Can a Vemo Account be linked? (2024)

‎February 27, 202108:17 AM

• QuickBooks Self-Employed

Hey there, @mthann.

Yes, you can link your Venmo account to QuickBooks Online (QBO). Let me show you how:

1. Go to theBankingmenu orTransactionsmenu.
2. Select theBankingtab and clickConnect Accounton the landing page. Or selectAdd accountif you've already connected a different banking account.
3. Search for your bank, then clickContinue.
4. Enter the username and password you use for your bank's website in the window.
5. Follow the onscreen steps to connect. Your bank may require additional security checks. It may take a few minutes to connect.
6. Select the bank or credit card accounts you want to connect.
7. Choose the matching account type from the drop-down list. These areaccounts on your chart of accountsin QuickBooks.
8. Choose how far back you want to download transactions and clickConnect.

Once done, QuickBooks automatically downloads and categorizes bank and credit card transactions for you. All you have to do is approve the work. Here's how toreview and categorizing downloaded transactions.

Keep me posted if you need anything else or if you have other banking concerns in QuickBooks. I'll be here to help. Have a great weekend.

Looking forward to your reply. Have a pleasant day ahead!

How do I link ONLY my Business Venmo?

Right now I have Venmo linked, but Quickbooks is also pulling transactions from my personal venmo account.

I’m here to help you, @Tinyforest.

When you connect your accounts, QuickBooks will automatically download recent transactions, whether personal or business transactions.

If your Venmo account consists of these types of transactions, you’ll want to exclude those personal entries so only business entries will show.

Here’s how:

1. Select the Banking menu, then Banking.
2. Under For review tab, select the personal entries.
3. Press the Exclude button.
   

The excluded transactions will not appear in any account registers or financial reports.

On the other hand, you can create a separate Venmo account intended for business. This way, QuickBooks will only pull out business transactions.

You can use this information to categorize and match online bank transactions in QuickBooks Online. This helps organize your income and expenses so monthly reconciliation will be accurate.

Don’t hesitate to leave a message if you have other banking questions or concerns. I’ll be here. Always take care!

Yes, there's a way to download your Venmo processing fee, @sigal4lasi.

Connecting your bank account to QuickBooks Self-Employed (QBSE) automatically downloads your recent transactions. The system looks for a similar transaction you've recorded and categorizes them.

If you don't see your Venmo fees from the downloaded transactions, we can perform some steps to fix this. You'll need to update your bank to refresh the connection and download the recent entries. I'll be glad to guide you how.

1. Go to the Gear icon.
2. Select Bank accounts.
3. Click Refresh allto refresh the connection.

If the issue remains, I propose tomanually upload your Venmo processing fees. Also, I'd recommend contacting the Venmo support team and verify if there are any issues on their end.

Once everything is settled, you'll want tocategorizeyour transactions to ensure it's in the correct line with your Schedule C.

Keep me in touch if you still need help downloading your Venmo fees or managing your transactions. I'll be here to assist you anytime. Have a great weekend ahead!

I've come to help you manage your Venmo processing fees when recording your transactions inQuickBooks Online (QBO)., @sigal4lasi.

QuickBooks is dependent on the information that was transferred from your bank. To appropriately deduct the fee to the downloaded gross amount, you can utilize theResolve differencefeature. You'll have to incorporate the process while matching transactions so you can get the total net amount. To do this, here's how:

1. On theBankingpage, choose the Venmo Bank's emblem, and select theFor Reviewtab.
2. Select the transaction to open its details.
3. Choose either theFind other matchesor theFind matchbutton to open theMatch transactionswindow. By default, the pagelistsAlltransactions within the date range, but you can narrow the results.
4. Use options on theShowdrop-down menu to specify the type of transaction you're looking for. Then, select theFromandTodate fields if necessary.
5. Locate the gross amount and selectResolve Differenceto open theAdd resolving transactionsfields.
6. Choose theCategoryand enter theAmountof the Venmo processing fee.
7. SelectSave.

I've attached screenshots below for your reference.

To learn more about reviewing and/or matching your bank transactions in QBO, you can check out this article:Categorizeonline bank transactions in QuickBooks Online.

Also, I encourage you to reconcile your Venmo account every month. This way, you can effectively monitor your transactionsand detect any possible errors accordingly. For the step-by-step guide, you can refer to this article:Reconcile an account in QuickBooks Online.

You're always welcome to comment below if you have any other questions or banking concerns. I'll make sure to get back to you as soon as I can. Take care always.

Thanks for chiming in on this thread,

I'd like to verify some information. Are you using QuickBooks Online? Do you want to categorize the personal transactions downloaded from your bank? If so, It's best to add them, so itmatches withyour bank statement when you reconcile the account.

To avoid recording the transaction as a business expense, many business owners add the transaction to anequity account they’ve created, called an owner’s draw. Before doing so, I recommend consulting with your accountant if you’re not sure how to handle a personal expense.

If you're not affiliated with an accountant, you can visit ourIntuit Find-A-ProAdvisorsite to find certified professionals near you.

On the other hand, if you decidetoremove the personal transactions,you can follow the steps provided by my colleague MadelynC. Please note that excludingatransactiondoesn't appear in any account registers or financial reports.

For more information about the process, feel free to read these articles:

• Exclude a bank transaction you downloaded into QuickBooks Online
• Reconcile an account in QuickBooks Online

Should you have any additional questions or other concerns, please leave a reply below. I'll be right here to help you out some more. Take care and stay safe!

Hello there, @auntjaimeorganizes.

Thank you for participating in the discussion. Your question on integrating a Venmo online bank account to QuickBooks Self-Employed (QBSE)will be handled by me.

On the Connect an account screen, I looked for Venmo and only found one result. I believe you're referring to your personal Venmo account.

I recommend logging in to your business account's webpage to see whether the Business Venmo account is available to sync. Copy the web address or URL from there and paste it into the search box on the Connect an account page.

If you're still having trouble finding your bank account, go to the screenshot above and click the Still can't find your bank? link.

You'll be routed to this page:

It will allow you to request that the online bank be made available for QBSEto sync with. Fill in the required information, then click the Request button.

You can upload bank transactions by hand while you wait for the connection to become accessible. The steps are outlined in this article:Manually upload transactions into QuickBooks Online.

If you have any additional questions about integrating your online bank account to QBSE,please leave a comment. I'll get back to you as soon as possible.

Allow me to step in and share how you can link a Venmo, Square, or PayPalQuickBooks Desktop (QBDT),aliveel.

You need a connector asthe bridge to integrate your third-party accounts. In QBDT, you can use Synder to connect the app.

To use the connector, you can find this through our QBDT marketplace. Let me guide you through the steps.

1. Go to this link:desktop.apps.com.
2. Enter Synder in the Find Applications search box, then click Search.
3. Click Learn More.
   
4. Click again the Learn More green box anddownload the connector.
   

You can also use another third-party connector outside of QuickBooks to help sync your sales to QBDT. IF not, you can manually import lists and transactions usingIntuit Interchange Format (IIF) files.

I'm adding this link to learn more about the process:Export, import, and edit IIF files. It includes export limitations and steps to guide you through the process.

Stay in touch with me if you have an update about linking a third-party application with QuickBooks. I'm always glad to help you.

Thanks for joining in on this thread,Sewing RL.

I'll share some information about the error and steps to help you fix it.

We currently don't have any reported issues regarding the bank error 103. However, you'll encounter this due to the following:

• An incorrect user ID or password for the bank account you’re trying to connect.
• Your bank needspermission to connect your account to another service, including QuickBooks Online.

Since your credentials are correct, you'll want to visit your bank’s website. Then,check if your bank has this requirement. If so, follow your bank’s instructions to turn it on.

Once done,sign in to your bank account in QuickBooks by following these steps:

1. Go to Transactions orBanking on the left panel.
2. From the Banking tab, select the bank or credit card account you need to update.
3. SelectEditand clickEdit sign-in info. If your web browser auto-fills the user ID and password fields, clear them. This ensures your browser doesn’t put in old info by mistake.
4. Manually type in the user ID and password for your bank account. If your bank offers aShowoption, select it so you can confirm you entered the password correctly.
5. HitUpdate.

You can click on this article for reference:Fix bank error 103.

In case you have all the transactions updated in the For review tab, you can start categorizing and matching them. The steps are included in this link:Categorize and match online bank transactions in QuickBooks Online.

If you're still getting the same result, I recommend reaching out to our Customer Care Team. They can review your account and investigate what's causing this error.

Please take note that our support for QuickBooks Online PayrollCore andPremium is available from M-F 6 AM to 6 PM PT.For QuickBooks Full Service Payroll, QuickBooks Online Payroll Elite/Premium, we're available any time, any day.

Here are the steps:

1. Click theHelpicon located in the upper right-hand corner.
2. In the Search window, click theContact Usbutton located at the bottom.
3. Enter your question and clickLet's talk.
4. Choose eitherChat with usorHave us call you.

If you havethe new QuickBooks Assistant help update, you can follow these steps:

1. In your QuickBooks Online account, go to theHelp>Assistant.
2. TypeTalk to a humanand enter what do you need help with.
3. ClickNoif none of the articles shared are helpful and selectChat with usorHave us call you.

You can also get our direct phone number in this article: Contact Payroll Support.

You're always welcome to post a reply here if there's anything else you need. Have a good day ahead.

Same issue with my Venmo account. It stopped feeding and when reconnecting I keep getting

Looks like the connection to Venmo isn’t available right now.

Glad to have you here,TiffanyMM.

I received similar issues from other users, and our engineers are working on a fix.

I'll make sure you'll be notified once the issue is fixed. I suggest contacting our QBO support team to add your company to the affected users' list. This way, you’ll receive a notification when a fix is available. Here's a link to contact them at a time convenient to you:QuickBooks Online Support.

In the meantime, you'll want to download your Venmo transactions via a CSV file and upload them to the Banking page. You can refer to these articles for your guide in uploading them into QBO:

• Format CSV files in Excel to get bank transactions into QuickBooks.
• Manually upload transactions into QuickBooks Online.

I'll be right here to keep helping if you have additional concerns about banking.

I too have been trying for two weeks to get Venmo to automatically download transactions. Mostly it returns Error 102, try in a few hours. Once it downloaded a single transaction.

I know you can download a CSV of the transactions. When doing this I disconnected the Venmo account so I could process the CSV BUT, A BIG BUT...after processing the CSV transactions, QBO automtically without asking reconnected the Venmo account (the little lightning bold shows up in the COA).

I have reported this bug to QBO as it applies to other bank accounts as well.

When bank accounts are not connected their panel does not show up in the Banking Tab, but after downloading transactions from other bank accounts the bank is magically reconnected.

All this leads to duplicated transactions which are a mess to clean up.

This all needs to be cleaned up as it causes a lot of unnecessary work in QBO, and keeping track of duplicated transactions.

I can definitely help you out! For this, we can fix your negative balance by editing your opening balance in the Chart of Accounts.

You can follow these simple steps:

1. Go to Settings and select Chart of Accounts.
2. Locate the account and select View register.
3. Find the opening balance entry. Tip: Sort the date column to show the oldest entries first.
4. Select the opening balance entry.
5. Edit the date, then the amount. If needed, select Edit to make your changes.
6. Select Save.
   

• Learn the reconcile workflow in QuickBooks.
• Fix issues for accounts you've reconciled in the past in QuickBooks Online.
• Categorize and match online bank transactions in QuickBooks Online.

Please don't hesitate to reach us back or simply add a reply under this post if you need more assistance with your banking transactions. Have a great day!

Hi there, Pip and You.

It's good to know that you've already checked and reviewed the register. I appreciate you for doing that.

If you didn't see an opening balance entry, you'll have to useyour bank statements tomake sure the opening balance is correct. Then, take note of the date and amount of the oldest transaction in the account. Once done, you'll need to create a journal entry for this.

1. Go to the +New button.
2. SelectJournal entry under Other.
3. Enter a date that comes before the oldest transaction in the account. This will be the opening balance date.
4. On the first line from theAccountdrop-down menu,select the account you want to enter the opening balance for.
5. We recommend adding a note in theDescriptionfield so you know what the journal entry is for.
6. On the second line from theAccountdrop-down menu,selectOpening Balance Equity.
7. Use your bank statements to enter the opening balance. Note: Enter the balance of your real-life account for the date you picked as the opening balance.
8. Enter the debits and credits based on the type of account you entered on the first line.
   

Once done, make sure tomanually reconcile the transaction in the bank register. This way, the beginning balance shows up on the reconciliation page.

Here's how:

1. On the left panel, selectAccounting and select Chart of Accounts.
2. Click theAccount historylink of the bank account you want to reconcile. Search for the opening balance journal entry, and select it to expand the view.
3. Under theReconciliation statuscolumn (Indicated by a check mark), click the blank field until you see anR. This reconciles the transaction. SelectSave.

Please see sample screenshots below:

Also, I'd recommend reaching out to your accountant for further advice on fixing the beginning balance issue in QBO, especially when creating a journal entry.

I'm also adding these articles about managing opening balances in QBO:

• Enter and manage opening balances in QuickBooks Online.
• What to do if you didn't enter an opening balance in QuickBooks Online.

Please post or comment in this thread if you have additional questions about opening balances or anything else. I'm always ready to lend a hand. Keep safe.