cancel
Showing results for 
Search instead for 
Did you mean: 
Bertoniandsons1
Level 1

So I added 200+ transactions manually not realizing that I could connect my venmo account. So I am wondering if there is a way I can match them up?

 
3 Comments 3
ReymondO
QuickBooks Team

So I added 200+ transactions manually not realizing that I could connect my venmo account. So I am wondering if there is a way I can match them up?

Hi there, @Bertoniandsons1.

 

We can only match manually uploaded transactions to the transactions that you've entered in QuickBooks Online (QBO). Since you've already connected to your bank, QuickBooks will automatically download the last 90 days worth bank transactions in the system. Because of this, you will see duplicate transactions in the For Review tab.

 

However, we can exclude those transactions so that it won't be reported as part of your business finances. Here's how:
 

  1. Select Banking.
  2. On the Banking page, click the For Review tab.
  3. Select the checkboxes of the transactions you want to exclude.
  4. From the Batch actions drop-down arrow, choose Exclude Selected.

 

Excluded transactions are listed on the Excluded tab for reference or review, but are not tracked or reported in any associated account registers or reports.

 

Once done, you can now categorize your bank transactions in QBO.

 

Don't hesitate to tag my name in the comment section below if you have other concerns or questions. I'm always ready to help.

 

Bertoniandsons1
Level 1

So I added 200+ transactions manually not realizing that I could connect my venmo account. So I am wondering if there is a way I can match them up?

So the thing is I already added them to a cash account so they're not coming up in the review tab.

Nick_M
QuickBooks Team

So I added 200+ transactions manually not realizing that I could connect my venmo account. So I am wondering if there is a way I can match them up?

Hi Bertoniandsons1. 

 

I'm happy to point you in the right direction to get this figured out. If you already added the transactions to the cash account, you'll need to do a reconciliation to make sure they're all accounted for. If not you'll have to add the missing transactions and delete the duplicates. Below are the steps to do a reconciliation. 

  1. In QuickBooks Online, select Settings ⚙ and then select Reconcile. If you're reconciling for the first time, select Get Started first and then Let's do it.
  2. From the Account ▼ drop-down menu, select the account you want to reconcile. Make sure it's the same one on your statement.
  3. Check the Last statement ending date. Make sure your bank statement starts the day after your last reconciliation.
  4. Review the Beginning balance. Make sure the beginning balance in QuickBooks matches the one on your bank statement. Here’s what to do if they don't match.
  5. Enter the Ending balance and Ending date as they're written on your bank statement. Some banks call the ending balance a "new balance."
  6. When you're ready to start, select Start reconciling.

You can find these steps and much more on the reconciliation process here at the reconcile an account in QuickBooks Online article. 

I'm also including a video tutorial below:

 

If you still need further assistance or have any other questions, feel free to post them here. 

 

Thanks for your time and have a lovely afternoon. 

Need to get in touch?

Contact us