Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
mlr94549
Level 2

Managing Venmo transactions

In the past one could not import Venmo transactions easily, but now on can set up Venmo as a pseudo-bank and import the transactions, either automatically (which I DO NOT recommend) or manually from a downloaded CSV file.

The issue arises with how QBO handles payments you make out of Venmo that are really transfers to your bank account. QBO views payments out of Venmo as an expense item and catetorizes them as such, assigning them automatically to Uncategorized Expense and there is no way to turn this into the transfer that it really is. This is a good reason no to use Venmo as a connected account but to import the transactions from a downloaded CSV file. 

And when you code the Venmo payment as a transfer to  your bank account, don't do it directly but put the transfer dollars into a holding account - an Other Current Asset account which you use to hold the money. 

Why? Well when you do the actual bank transfer in the real world, you end up with a deposit transaction in your real-world bank account and if you now record this is as a transfer directly from Venmo it debits  your bank account and credits the Venmo account, causing a negative balance in Venmo. The solution for the transfer on the bank account side of things is to encode the transfer transactions as a debit for the bank account and a credit from the holding account. 

Using this technique you get a record in QBO of the transfer transaction for both accounts - Venmo and the transfer target bank account.

1 Comment 1
Archie_B
QuickBooks Team

Managing Venmo transactions

Thank you for sharing those information with us, mlr94549.

 

Let me share some insights about handling Venmo transactions in QuickBooks Online.

 

QuickBooks is dependent on the data that was transferred from Venmo or from your bank.

 

That said, if QuickBooks recognize it on the category or account. You can utilize the banking window to categorize or manually match the transactions to your QuickBooks.

 

Like this:

 

  1. Go to the Banking menu.
  2. Click the Banking tab.
  3. On the For Review column, choose the correct transaction. 
  4. Select a customer or vendor name from the Select Payee drop-down.
  5. Check that the selection in the Category field is accurate, or choose a more specific Category.

 

To manually match the transactions:

 

  1. Click the transaction to expand the view.
  2. Review the Records found. These transactions are ones you already entered in QuickBooks.
  3. Review the Deposit to field on the forms.
  4. Once done, select Match.

 

For more details check out this link: Categorize and match online bank transactions in QuickBooks Online.

 

I've added this article for your future reference: Reconcile an account in QuickBooks Online.

 

In case you have other banking questions, post them below. I'll be here to check. Have a great day!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us