Received payment does not show in reconciliation

Thanks for posting, @radar-9628.

I have some information about reconciliation accounts. You'll want to mark the box next to Hide transactions after the statement's end date box. This way, deposits will be posted in the reconciliation window.

Here's how:

1. Go to Banking.
2. Select Reconcile.
3. Enter the account details and then tap Continue.
4. Hover towards the top of the screen and put a checkmark on the Hide transactions after the statement's end date box. If it has a checkmark remove it to view the deposit.
5. Look for the deposit and then continue with the reconciliation process.

Feel free to also browse this link for your reference: Fix issues when you're reconciling in QuickBooks Desktop.

Reach out to me again if you have other questions or concerns with reconciliation. I'll be glad to answer them for you. Take care and have a good one.

Hello,

I do know about the hide transactions checkbox. The deposit does not appear when I check that box.

Paula

Are you seeing the transaction in the ledger for the bank account where you deposited the funds?  If so, then it must either be the date range you've chosen for the reconciliation or the account.  The screenshots show that you received the payment on Nov. 18 but did not deposit the funds until Dec. 6.  Those dates are correct?

I appreciate you for getting back to us, radar-9628.

Based on the screenshot provided, it seems that the $140 is recorded under Undeposited Funds account. That said, you'll have to deposit it the correct account.

Here's how:

1. On the Homepage, select Record Deposits / Make Deposits.
2. In the Payments to Deposit window, select the payments you want to combine
3. Click OK.
4. Select the account you want to put the deposit into from the Deposit to dropdown.
5. Enter the date you made the deposit at your bank.
6. Click Save & Close.

Afterward, try reconciling the account again. Here's an article as your guide: Reconcile an account.

I'll be around if there's anything that I can help with. Have a good one!

Right now, I have an entry in the ledger for $280 of undeposited funds for the PVE client dated 12/6/21.

This client had two invoices. The 10/19/21 invoice (2021-145) for $140 was overlooked initially by their accounting department.

Meanwhile, the second invoice dated 11/2/21 (2021-144, $140) was paid first - check date 11/15/21 #2237. It was deposited in the bank on 11/18/21. https://www.screencast.com/t/zGlnoxFq2qil

It does not show up in my bank account ledger. 

The first invoice (2021-145) for $140 was finally paid - check # 2259 dated 12/3/21. It was deposited in the bank on 12/7/21.

It is possible that I applied the payment for the 11/2 invoice (2021-144) on 2021-145 by mistake since I was expecting it first. I thought I deleted the payment and applied it to the correct invoice - but that was several weeks ago.

Clearly I don't follow the flow of money very well within Quickbooks. Your help is appreciated.

There are no payments to deposit when I open that window.

https://www.screencast.com/t/41QOOlHfFQ

Thank you for providing us with more details about the concern you're having with your invoices, @radar-9628.

Yes, you may have applied the payment to the wrong invoice. You can follow the steps below on how to re-apply payments to the correct invoices. 

Here are the steps:

1. Open the invoice and then go to the Reports tab and select Transaction History.
2. On the window that appears, select the payment and select Go To.
3. On the Customer Payment window, remove the checkmark(s) from the invoice(s) that the payment shouldn't have been applied to.
4. Put a checkmark on the invoice(s) that the payment should be applied to.
5. Click Save & New.

This will apply the payment to the invoice(s) you selected and remove it from the original invoice it was applied to.

Check out this article for more information re-apply payments to the correct invoices: Resolve common issues when applying a payment towards an invoice.

You can also check your Chart of Accounts to check your Undeposited Funds account if the payment is posted to that account:

Here's how:

1. Go to the Lists menu and Chart of Accounts.
2. Right-click Undeposited Funds and select QuickReport: Undeposited Funds.
3. From the Dates drop-down menu, click All.

For additional reference about depositing payments into the Undeposited Funds account in QuickBooks Desktop, check out this article.

If you need help with the process for creating invoices and receiving payments, refer to the Accounts Receivable overview.

Let me know if you have any other questions about your bank deposits. I'm a few clicks away to help. Have a good day!

Regarding the 'you may have applied the payment to the wrong invoice', here is what I see:

https://www.screencast.com/t/w2tNefroLMk

I have checked invoice #, amount, customer, bank deposit date - it all looks accurate - at least today.

Here is what I see in the Undeposited Funds QuickReport: https://www.screencast.com/t/hrgPNM3lKpZ

I don't know how to interpret what I am seeing as it relates to the missing $140 deposit when reconciling.

I deleted both payments for the same client and re-entered them. I was able to reconcile.

Thanks.