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

Extra deposits in reconciliation feed

Hey team!

 

I'm having difficulty with a reconciliation; it seems that manually recorded credit card deposits are being double counted. They show up as a "-SPLIT" line item (which does not appear in our bank statement) but the same transactions show up as a "QuickBooks Payments" line item (which does appear in our bank statement).

 

I tried to delete the "-SPLIT-" line but those transactions were left hanging as pending deposits, even though they have already cleared the bank and been resolved in QBO. Does anyone have any tips for how to reverse engineer this to clean up my reconciliation?

 

Thanks!

5 Comments
Highlighted
Moderator

Extra deposits in reconciliation feed

Thank you for checking in with us, thephiljohnson.

I'd be happy to help you with your reconciliation for split transactions.

 

Are these transactions downloaded from your online banking and added to it to your QuickBooks Online account? If so, you can Undo the downloaded transactions and Match them to your manually recorded credit card deposits instead of adding them to your QuickBooks. This way, your credit card deposits will not double the amount.

 

To match transactions:

  1. On the Banking page, select the For Review tab.
  2. Locate a transaction with one or more possible matches to review.
  3. If one match was found, the matching transaction appears in the Category or Match column.
  4. For a transaction matched to a single record, if the match is correct, from the Action column, select Match to accept it.
  5. For a transaction matched to multiple records, from the Action column, select View to open the transaction row, review the possible matches listed under Records found, select the correct one, and select Match to accept it.
  6. If the possible match is not correct, select the transaction to open it, and select Find other records to open the Match Transactions window and search for other possible matches.

You can check this article for detailed information: https://community.intuit.com/articles/1773491-how-to-add-and-match-downloaded-banking-transactions.

 

If you need further assistance, you reach out to our Customer Care Team. Agents have the necessary tools, like screen-sharing to get you back up and running.

 

Feel free to get back in touch with me if you have other concerns about QuickBooks. I'd love to help.

Highlighted
Level 1

Extra deposits in reconciliation feed

Thanks so much!

 

I am having some marginal success with this; I know it'll be difficult parsing out specific deposits to invoices (we were making some processing transitions at this time), but I'm hopeful that this is fixable. My trouble is that when I select a transaction/deposit, it has no corresponding match (see attached screenshot). Should I be attempting to find another Bank Deposit to unlink? I'm not sure how to fix this problem so that processed invoices are tied to the appropriate deposit.

Highlighted
QuickBooks Team

Extra deposits in reconciliation feed

Hi there, thephiljohnson.

 

I'm delighted to know about your progress when you tried my colleague, RoseMarjorieA's, wonderful answer. Allow me to step in and share some more clarification that'll help you match the transactions.

 

I appreciate the screenshot. It helps me make sure that I provide you with the best solution. Just to clarify, on the first post you mentioned that you tried to delete Split transactions. Were those the payments you manually applied to the invoices showing on the screenshot?

 

If they were, then yes, you can try to undo other downloaded transactions (bank deposits) which may have been matched to the wrong transactions. Once you're done, I'm confident that you'll find the proper matches when you try to follow the steps provided by RoseMarjorieA again.

 

I recommend the following article as it contains additional insight about this: Bank transactions are duplicates, missing or wrong or bank balance not updating

 

I know you've got this. Should you need further assistance, please let me know. Good luck.

Highlighted
Level 1

Extra deposits in reconciliation feed

I think I have it! Thanks so much for all your help. I've used the deposit registers from credit card transactions to isolate where my matching went awry, and have adjusted deposits to contain the correct matching transactions.

 

Thanks again, everybody!

Highlighted
Moderator

Extra deposits in reconciliation feed

Sending good vibes to you, thephiljohnson.

 

That's great to hear! You know where to find us if you have any other questions. Don't work too hard, have a good one.

Need to get in touch?

Contact us