Can I apply part of a bank deposit to an open invoice and exclude the rest?

Thank you for providing details of your concern, @jkope26!

Let me help you match your invoices in QuickBooks Online.

When recording a payment via bank deposit, it will not be applied directly to the open invoice. You'll have to enter the customers' payment via the Receive Payment screen and match it with the deposit.

You can exclude it and create the deposits manually.

Here's how: 

1. Select + New.
2. Click Bank Deposit.
3. From the Account ▼ dropdown, choose the account you want to put the money into.
4. Select the checkbox for each transaction you want to combine.
5. Make sure the total of the selected transactions matches your deposit slip. Use your deposit slip as a reference.
6. Click Save and new.

Make sure everything matches between invoice and payment, like dates, etc.

You can check this article: Matching transactions. You'll avoid getting duplicate records of your transaction in the bank register.

If there's anything else that I can help you with, let me know in the comments. I'll be here to lend a hand.

thank you, but I'm not sure this answers my question.  

we have our bank account linked to quickbooks.  I pulled in a deposit that was made to our bank account, lets say it was for 100K.  Usually, in the case of deposits, I can just "match" them to open invoices.  However, in this case, I want to match part of it and exclude part of it.

60K is for an open invoice

40K is the amount I want to exclude (this amount was reversed from our bank account a few days later, as a stop payment was put on the check by our client.)

how can I apply the 60K to an invoice and exclude the 40K from being mapped anywhere (it is going to be offset by a -40K and I just want them to cancel each other out.)

thanks.

I got you cover, @jkope26.

I have some information about matching and excluding deposits. Since using the exclude function will exclude your entire deposit, you'll want to record your reversed payment into an account. This way, you can match the other part of the downloaded deposit.

Here's how to do it:

1. Go to Banking, then tap the Banking tab.
2. Select the deposit  to open, then tick the Find match radio-button.
3. Mark the invoices that are included in the deposit amount. Then, switch the Resolve| Differrence button.
4. In the Add resolving transactions section, choose an account under Category.
5. Memo is optional, and then add the Amount.
6. Click Save.

Here's how it looks like:

You can check out this article for more information about matching transactions: Categorise and match online bank transactions.

Additionally, here's a link that covers all the tasks you can do when using the banking feature in QBO. Just look for responses that suit your concern.

Let me know in the reply section below if you still have questions or concerns with bank transactions. I'll be around for you. Take care and happy weekend.

thank you, this seems to work for the most part.  however, one thing I can't figure out....the check deposit obviously got tagged with a "deposit" transaction type.  the stop payment (reversal in bank account) is tagged with an "expense" transaction type.  I have a cash receipts report I created and the issue is that its pulling in the deposit, but not pulling in the subsequent reversal b/c its tagged as an "expense" (and not payment or deposit). is there anyway to change the transaction type on a transaction that comes in from my bank account?  thank you!

Yes, you can change the transaction type, jkope26.

QuickBooks Online depends on what your bank shared with us. This could be the reason the transactions has different transaction type.

I'd suggest following these steps if the transactions are still in the For Review tab.

1. Go to Banking from the left menu.
2. Select the For Review tab. 
3. Locate and open the transaction. 
4. Choose the appropriate income account from the Category drop-down. 
5. Click Add. 

If they're already in the Reviewed tab, you'll have to undo them. They'll be moved back to the For Review tab so you can categorize them to the correct type.

After that, I encourage reconciling your account monthly. This ensures your QuickBooks accounts match the bank statement.

Don't hesitate to let me know if you need more help in handling your bank transactions. I'm always here to back you up.

thanks, but I don't see where to change the transaction type, only where I want to map (categorize) the transaction.  how do I change the transaction type?