New user having trouble figuring out how to handle Venmo fees

Thanks for choosing QuickBooks Online to cater to your business needs, ShannonPhoto. I know it can be challenging when you can't match your transactions. I'm here to help you with that.

When recording the payment, you'll have to enter the full amount and put it on the Undeposited Funds account. When depositing the money, add another line item to deduct the fee from the balance. 

Here's how:

1. Go to the + New button and then select Bank deposit.
2. Select the bank account in the Account field and enter the Date.
3. Under the Select the payments included in this deposit section, mark the invoice payment.
4. Go to the Add funds to this deposit section, and select the bank fee account in the Account column.
5. On the Amount column, enter -1.05.
6. Once done, click on Save and close.
   

For more details about the process, please see this article: Using Undeposited Funds in QuickBooks Online.

Additionally, I've included an article that'll help you review your bank and credit card transactions and put them in the correct accounts. This ensures your books are accurate: Categorize and Match Online Bank Transactions in QuickBooks Online.

Please let me know if you have other QuickBooks-related questions or concerns, ShannonPhoto. I'd be happy to assist you. Keep safe always!

Thank you. So what do I do with the transaction that was pulled into QuickBooks from my bank? Do I "exclude" it?

Hi, @ShannonPhoto.

Thanks for getting back to us here in the Community. Allow me to chime in and provide details about bank transactions in your QuickBooks Online (QBO).

Since you already deducted the fee when depositing the payment, all you need to do is to match them instead. The Match option means QBO matched the downloaded transaction with the one you already entered. This links them together to avoid duplicates.

Here's how:

1. Find a downloaded transaction with the Match option in the Action column.
2. Note the Date, Description, Payee, and amount spent or received.
3. Click the downloaded transaction to expand the view.
4. Review the Matching records found in QuickBooks. This is the possible matching transaction you already entered in QuickBooks.
5. Select the link next to each match to get more details.
6. Make sure this is the correct match.
7. If this is the correct match, close the open transaction.
8. Hit Match.

To learn more about managing and matching bank transactions in QBO, consider checking out this article: Categorize and Match Online Bank Transactions in QuickBooks Online.

Once done, you may now proceed with reconciling your account to ensure it's balanced and accurate. You may refer to this article for future reference: Reconcile an account in QuickBooks Online.

I'm only a post away if you have more questions about bank transactions or anything else. I'll be here to help. Take care always.

Ok, I'm trying to follow this step by step. On step 4 it says to select the "bank fees account" in the account column.  My account column only has cash and my business checking as an option. If I select the "see and add more categories", the only option is bank & credit cards? Do I need to make a Venmo Fees bank account?

Thanks for the prompt response, @ShannonPhoto. I'm here to help you proceed to the steps of recording the Venmo payment in QuickBooks Online (QBO).

Yes, you'll need to create an expense account so that you can track the payment made through Venmo.

Follow these steps to proceed:

1. Go to the Gear icon and select Chart of Accounts.
2. Click the New button and then choose Expenses from the Account Type drop-down list.
3. In the Detail Type drop-down arrow, select the detail type of the account.
4. Enter the account name and click Save and close.

Once done, you can now proceed to the steps provided by my peer above.

For future reference, here are some articles that you can read to help speed up the review process of your online bank transactions:

• Categorize and match online bank transactions in QuickBooks Online.
• Set up bank rules to categorize online banking transactions in QuickBooks Online.

You can always post your questions here if there's anything else that you need help with recording payments in QBO. I’ll be glad to help and make sure it's taken care of for you. Have a great day ahead!

Ok, I created the Venmo Fees expense account, but it won't let me choose it. It is only letting me choose a bank or credit card for the account here. When I typed in Venmo Fees I got this error that something isn't right.

Thank you for getting back to us for additional assistance, @ShannonPhoto. Let me add some information about the payment charges. 

When depositing the payment made that includes the payment charges, choose the real-life bank account. You can use the business checking account that you mentioned above.

For the payment that includes bank processing fees, follow these steps:

1. Scroll down to the box under "Add funds to this deposit."
2. Make a line item for the charge.
3. Choose who the payment was from (for example, the bank charging you).
4. From the Account dropdown ▼, choose Bank Charges.
5. Enter a negative value for the fee amount. If the cost was $50, for example, type –50.
6. Compare the deposit amount to the bank fee.
7. Choose Save and close or Save and new.

You can check this article to know more about making bank deposits in QuickBooks Online: Record and make bank deposits in QuickBooks Online.

Then you can categorize and match bank transactions in QuickBooks Online. Refer to this article for the detailed steps:  Categorize and Match Online Bank Transactions in QuickBooks Online.

Get back to me if you need further assistance recording payments in QuickBooks Online. I'm always here to help.

This is where I am stuck.  You said on step 4 to to choose "bank charges" from the account drop down. My account drop down ONLY has my checking account, cash, and "see and add more categories". There is no choice of "bank charges".  I tried clicking on "see and add more categories" to add "bank charges", but it will only allow me to add a bank or credit card. It will not let me add and expense account.  What am I doing wrong?

Thank you for following up with us, Shannon. I'm here to show you how to select the account mentioned by Ethel_A.

The Bank Charges on Step 4 is manually created in QuickBooks Online (QBO) to track bank fees or charges. If you don't have this account you can create it from the Chart of Accounts or through the Bank Deposit window.

Here's how:

1. Go to the Add funds to this deposit section.
2. Select Add new from the Account dropdown.
3. 
4. Fill in the account details from the Account window.
5. Hit on Save and Close.

Once done, you can now use the account when recording the deposit.

If you wish to add the account through the Chart of Accounts, follow the steps from this article: Add an account to your chart of accounts in QuickBooks Online.

For additional hints while working with your banking entries in the future, you can review the resources from this link: Find help with bank feeds and reconciling accounts.

If you have any other questions about tracking Venmo fees, let me know by adding a comment below. I'm always here to help. Keep safe!

I finally had to contact Intuit support.  I guess my account was in Business View and not Accountant View.  Once I switched to Accountant View it worked!  I had no idea there were even different "views". Just wanted to update in case someone else is having the same issue.