Thanks for keeping us updated with the results when performing the steps provided by my colleague above, @T_Arkenberg.
When matching downloaded transactions in QuickBooks Online (QBO) to manually created data, you'll need to have the exact date or details to match.
In your case, when receiving the invoice payment, it should deposit on the Undeposited Funds. Here's how:
- In the left menu, Sales.
- Go to the Invoices tab.
- Locate the invoice.
- From the Actions column, click the Receive Payments link.
- Make sure to choose Undeposited Funds in the Deposit To drop-down.
- Enter the full payment of the invoice.
- Click Save and Close.
Then, create a bank deposit and select the Bank account where the actual payment was deposited.
- In the left menu, click the New (+) button.
- Choose Bank Deposit.
- Select the Bank Account where the actual payment was deposited.
- Enter the date when the actual deposit was made.
- In the Select the payments included in this deposit section, mark invoice payment that's paid.
- Review the payment details. The information should exactly match the downloaded bank transactions.
- Click the Save and Close button.
Once done, you can now start matching the recorded invoice payments and downloaded transactions. By doing this, you'd avoid getting duplicates. Let me share this guide for the step by step process: Categorize and match online bank transactions in QuickBooks Online.
For future help, here are some links that cover all the details on how to perform the following tasks in QBO.
That's it! If there's anything else you need help with, please feel free to let me know. I'm always here to help. Have a great day!
