Thanks for sharing detailed information, MaxGLWC.
I'm here to show you a way to match the transactions in QuickBooks Online.
Since the total is negative, we'll have to create a journal entry (JE) to move the funds from Undeposited Funds, and then group the JE with the payments. After that, we can match them. I'll guide you how.
To begin, let's create a JE to move the funds from Undeposited Funds to the appropriate bank account.
- From the + New icon, select Journal Entry.
- Enter the date of the transaction.
- On the first distribution line, select Undeposited Funds from the drop-down list in the Account column.
- Enter the amount of the deposit in the Debits column.
- On the second distribution line, select the appropriate bank account from the Account column drop-down list.
- Enter the amount of the deposit in the Credits column.
- Once done, select Save and close.
Then, we'll group the JE with the payments to create a $0 deposit and remove the payments from Undeposited Funds. Here's how:
- Go to the + New icon.
- Under Other, select Bank Deposit.
- Select the payments and the Journal Entry you created. The total should be zero.
- Select Save and close.
Once done, we can now match the transactions.
- From the Banking menu, select the Banking tab.
- Choose the appropriate bank account then click the For Review tab.
- Locate the transactions.
- Click the Match radio button.
- Review the Records found and then select the link next to each record to get more details.
- Check the Deposit to field on the forms.
- When you’re done, click on Match.
I've also included an article that'll help you in categorizing and editing your downloaded banking transactions.
If you're about to reconcile your account, I recommend reading our reconciliation guide. Doing so ensures that your QuickBooks accounts are accurate.
I want to ensure that you're able to match these transactions, so please let me know how it goes by clicking the Reply button.
