I know a way to match your deposit to your invoice in QuickBooks Online (QBO), @PlumbingSecretary.
In QuickBooks, there’s no way we can match multiple deposits from your bank feeds to an existing transaction in the application. However, there’s a trick that we can do to link them without any complication.
In this, we can utilize the Resolve difference feature. This functionality assists in entering the adjustment when the bank item amount doesn’t match the amount entered. In other words, we can use this to enter an adjustment to resolve the difference.
To start, let’s locate and match the transaction amounting to $17,866.66 as per your verbatim to the invoice. Here’s how:
- In the For Review tab, locate the deposit and tap this to expand.
- Click the Find Match radio button to drill down all possible matches.
- From the Match transactions window, filter the dates that cover when you received or recorded the amount.
- Once you select the transaction, scroll to the bottom of the table and click Resolve difference on the right.
- In the Add Resolving Transactions section, select the Date, Payee, and Category associated with the transaction.
- Then, enter the amount difference.
- Lastly, click Save.
After that, we can exclude the other deposits reflecting from your bank feeds to keep your records accurate and make your reconciliation process easier. I’ll show you how:
- Go to the Transactions menu in the left panel and choose Bank Transactions.
- In the For Review tab, select the particular transaction you are referring to.
- Tap on the Exclude button.
Consider checking out these articles on how to classify transactions and carry out account reconciliation for accurate bookkeeping:
Please comment on this thread if you have more questions or concerns about managing bank transactions. I'll get back to you as soon as possible to help. Take care!
