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?
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:
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.
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.
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.
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!