Reconciliation

Just to confirm....   You said "...which I have backup, that is now showing in QuickBooks..."  Am I  correct that "now" is really NOT showing up in QBs?

How do you normally enter the Deposits into the Bank Register in QBs? Let me run through the way I would make the deposits and see if it matches and possibly answers your question.  If I'm way off base, give us some more info and we'll get you an answer.

My typical process for Client checks would be:

Check comes in and you go to Customer drop-down menu, then Receive Payment and connect the payment to the appropriate invoice(s).  Those payments then go into the Undeposited Funds Acct.  

Next when we're going to physically make a Deposit in the Bank we would go to the Banking drop-down menu, then Make Deposit.  This will bring up the funds in the Undeposited Funds Acct. and we'd select which funds we are going to deposit and into which Bank Acct.  

Depending you you do it, this will show a single Deposit for multiple payments.  Or, you can show them as individual Deposits.  (Just be sure to put them in the Bank the way you enter them into QBs.)

If it's some other kind of Deposit and not a Client payment.  Give us the details on how you entered the Deposit and we'll see if we can figure out why you don't see it in the Reconcile process.

Yes, sorry.  I should have clarified by saying I have paper backup showing what the deposit should have been.  That is exactly how I process the payments.  I go to "Receive Payments" and select the invoices to apply the payments to under the customer.  If I'm batching payments, such as if I'm depositing multiple checks, I will wait until I have them all completed and then I'll go to "Make Deposits" and select all the payments to make one deposit.

The payments were applied correctly in Quickbooks, but they aren't showing in the reconciliation either, otherwise I would have just selected them individually.  Basically, neither the individual payments, nor the total invoice are showing in the reconciliation screen for me to select.

So basically, if I go to the customer screen, payments were applied to the correct open invoices, but there is no deposit showing in the reconciliation screen.

Let me share with you a few information why transactions are not showing on the reconcile page, JeffGuldenschuh.   

Let's make sure you choose the correct bank account when recording a deposit in QuickBooks. Also, the Incorrect Statement date is one of the reasons why the transactions won't reflect when reconciling it or when the transaction is marked as reconciled on the register. You can try to delete the payment and record the bank, then deposit it again. For the detailed steps, refer to this article: Record and make bank deposits in QuickBooks Desktop.  

If same thing happens, you can run the Verify and Rebuild Data utility. It's possible there's a damaged data in the company file preventing the deposits to reflect in the reconcile and register page. It identifies the most commonly known data concerns while resolving them right away. Here are the steps to do it:

1. First, choose Window and then select Close All.
2. Go to the File menu, and then click Utilities.
3. Select Rebuild Data.
4. Follow the onscreen instruction to back up your data.
5. When the tool finishes, select OK.
6. Navigate to the File menu, then hover over Utilities.
7. Click Verify Data and select Rebuild Now once QuickBooks finds an issue with your company file.

Please know that you'll need to log in to your Desktop account using the single-user mode when performing this process. You can check out this repair article for additional instructions if the issue remains the same. 

I’ve also added this article that you can use for future guidance in effectively reconciling your accounts in QBDT: Reconcile an account in QuickBooks Desktop.

I’ve added a reference that can help review your accounts. This fixing issues when reconciling guide provides instructions to check the missing ones and transactions that were changed. 

Please let me know if you have any other issues or concerns in the comment section, and I'll get back to you as soon as possible. Have a good one!

Thank you.  I didn't even think to check another account and the deposit was sitting in our cash clearing account and not our cash account.  Found it, changed it to the correct account and I was able to reconcile with no issues!

I am a user on my husbands business account. I use it for personal checking account, but I'm not connected to the back.

I am thousands of dollars in the negative this last statement. I started ok, then noticed that items that cleared from the last reconcile were no longer cleared. I cleared them with the recent statement and now I'm lost.

Should I undo reconcile and just leave the former uncleared from earlier alone?

Thanks for joining this thread, @Adie80. Let me chime in and help fix your reconciled transactions.

You can use the undo option and leave previously uncleared transactions. This way, the negative value will be cleared. Before doing this, you may also want to consult an accountant to make sure your book is accurate.

Here's how:

1. To begin,  back up your company file.
2. In your top menu bar, proceed to Banking, then select Reconcile.
3. From the Begin Reconciliation window, click Undo Last Reconciliation.
4. Choose Continue, then OK.

Once done, check the items that are if it's no longer cleared in the Reconciliation page.

Additionally, I'm sharing these articles about reconciling which may come in handy moving forward:

• Reconcile an account
• Fix issues when reconciling

You're always welcome to send a reply if there's any additional questions about your cleared and reconciled transactions in QuickBooks. I'm always ready to help. Keep safe!