Undeposited Funds - Paid via Quickbooks

Hello, milleremedia.

I'll help you proceed to the next step on handling your bank transaction. 

I take it that the payment was downloaded as a lump sum amount (for the two invoice). Instead of adding or splitting it, you'll want to match the single payment transaction with multiple records (supposedly the other invoice and the payment transaction). 

Here's how: 

1. In the Bank feeds, find and select the lump sum payment.
2. Click the Find match radio button.
3. Check the invoice and the payment transactions.
4. Click Save. 

You can find more details about handling bank transactions here: Categorize and match online bank transactions in QuickBooks Online.

If you're ready to reconcile your bank account, please check this article for a guide on the workflow: Reconcile an account in QuickBooks Online.

Let me know if you have more questions regarding your income transactions. Need help with other processes? Include them to your reply and I'll help you out. 

Thanks for the response.

My problem is that the invoices are automatically matched and marked "Paid" through the Quickbooks Online Payment process.

When I attempt to "Match" the downloaded Bank Transaction to an Invoice, they are already closed.

Is this a glitch? Should I exclude it?

I've got additional steps so you can match the downloaded payment to the paid invoice, milleremedia.

You can still match the payment downloaded on your Banking page with the paid invoice. The system will automatically find a match and you'll see a 1 record found banner. 

Just make sure to categorize the transaction based on the item you've used for the invoice. Simply click Match and the system will automatically add it to your register.

I've attached screenshots of the sample match.

If the system isn't finding the match, you can exclude the payment on your Banking page. Just make sure to post the payment you've processed from the QuickBooks Payment service is deposited to the right bank account on your register.

Here's how to exclude an entry:

1. Go to the Banking menu or Transactions menu, then select the Banking tab.
2. Select the For Review tab.
3. Select the checkbox of the transactions to exclude.
4. Click Exclude.
   
   

The transaction moves to the Excluded tab of the Banking page. When you exclude a transaction, it doesn’t appear in any account registers or financial reports.

You can then start reconciling your bank after recording your transactions to keep your book balance.

Please comment below if you have follow-up question about matching transactions. I'll be right here to provide the information.