cancel
Showing results for 
Search instead for 
Did you mean: 
tombunchy
Level 1

Deposit shows in register but not reconcile

I have a deposit that shows in customer check register but does not appear in the reconcile screen, so I cannot reconcile.

16 Comments 16
SkinnyRaven
Level 8

Deposit shows in register but not reconcile

First confirm the deposit shows in your bank register and in the reconcile window confirm you are showing all dates.

AliciaW
Level 2

Deposit shows in register but not reconcile

I'm having the same issue (using Quickbooks for Mac 2019).  The check is entered in the register but doesn't show in the reconcile window.  The check was written in February, but not cashed until March.  How can I get it to show without effecting the beginning balance?

JonpriL
Moderator

Deposit shows in register but not reconcile

Hello there, @AliciaW!

 

Let me step in for a moment and display all your check in the reconciliation page.

 

You'll have to make sure that the Statement date is the same as the date of your bank statement. In addition, the check should also be one of the transactions in your bank statement.

 

Lastly, here's an article you can read to learn more about reconciliation: Reconcile Bank and Credit Card Accounts (Mac).

 

Feel free to leave a comment below if you have any other questions about reconciliation. It'll be always my pleasure to help.
 

AliciaW
Level 2

Deposit shows in register but not reconcile

Hello and thank you for jumping in.  My statement date matches.  I'm in the right time period, but though the check shows in my register and on my statement, it does not appear in the reconcile window.  This is the problem.



 

 

JonpriL
Moderator

Deposit shows in register but not reconcile

Thank you for the response, @AliciaW!

 

Allow me to share a little more information about reconciliation and help you reconcile your bank account.

 

To start, your transactions that have been already reconciled are excluded and will not show in your reconciliation page.

 

With this, may I ask if you can share a screenshot of your register? Any information will surely be able to help share accurate resolutions and will let us solve your reconciliation.

 

In the meantime, you can review your check in your register if it has been marked as R or Reconciled. If so, you can consider it as the reason why it's showing on your reconciliation.

 

Please let me know in the comment section below. I'll be waiting for your response and will be always happy to lend a helping hand.

AliciaW
Level 2

Deposit shows in register but not reconcile

Quickbooks for Mac doesn't show an R for reconciled transactions.  It shows a check mark that is lighter or darker.  It is would be a lot more straightforward if it was marked R after its reconciled.  Thank you for your help.  I've got it squared away now.

El Papa
Level 1

Deposit shows in register but not reconcile

Had the same issue. The only difference in my case is that the payment was received via Intuit quickbooks, so I did not do the manual input, QB created the input and deposit automatically via the Merchant Service Deposit feature. Since I had hundreds of these transactions done without any issue but for some reason this one transaction did not show up in the reconcile window. Wierd

 

Believe it or not, I just solved the issue by just simply undoing a month of reconciliation and found another transaction in the same amount that I had reconciled erroneously. So it was my mistake. I am writing this reply just in case you want to retract some of your steps which may help you find an obvious error that is in front of your eyes.  Good luck.

 

 

Frustrated53121
Level 1

Deposit shows in register but not reconcile

I noticed it when I went to track a check to see if it was cleared and realized when I went into the individual check, it was not marked as cleared.  The reconciliation dates match the bank statements and all months are reconciled properly.  One bank account DOES show it though.   It is VERY frustrating - to find out of it is cleared, I have to go back to the actual bank statement.  WHAT GIVES?

MaryLandT
Moderator

Deposit shows in register but not reconcile

Hi there, @Frustrated53121,

 

It's possible the check was modified, and that's why the cleared status was removed.

 

What you need to do is pull up the Transaction Detail Report to verify transactions that were changed or modified.

Here's how to get the report:

  1. Go to your Reports menu.
  2. Select Custom Reports, then Transaction Detail.
  3. Go to the Display tab, then choose the following:
      a. Date From = earliest QuickBooks date (or leave it blank)
      b. Date To = date of the last reconciliation statement
  4. On the Filters tab, choose:
      a. Account = the account being reconciled
      b. Entered/Last Modified
      c. Date From = Date of the last reconciled
      d. Date To = Today
  5. Click OK.

Once done, you can then do a mini-reconciliation to clear the check.

 

I've added this article for other reports available in QBDT that will help identify transactions that were modified: Fix Reconciliation Discrepancies.

 

Should you need assistance, please let me know. I'd  be glad to help.

Frustrated53121
Level 1

Deposit shows in register but not reconcile

This has been happening for at least 7 months or more - on ALL checks and deposits.  The accounts are reconciled and I even print the reconciliation for my records and they show everything that should be cleared properly.  I cannot go into each transaction and mark it as cleared - every month.  

KhimG
QuickBooks Team

Deposit shows in register but not reconcile

Thanks for getting back to us and providing additional information regarding your concern, @Frustrated53121.

 

I understand how inconvenient it is for you to go through each transaction and mark it as cleared. Since they're not showing as reconciled, let's perform a few troubleshooting solutions to isolate the problem.

 

Running the Verify and Rebuild Utility Tool can help fix any data damage on the company file. Always create a backup to avoid any accidental data loss before performing the following steps.

  1. Go to the File menu.
  2. Select Utilities, then Rebuild Data.
  3. Click OK on the QuickBooks Information window. 
  4. Follow the prompt to save a backup.
  5. Hit OK when you see Rebuild has completed.

Utilities 1.PNGUtilities 2.PNG

You can follow the steps above except choose verify instead of rebuild.

 

Take a look at this article for reference: Resolve data damage. In the same link, you’ll find other data damage troubleshooting steps for Windows.

 

Now try checking the reconciled account. If you continue to get the same result, I recommend reaching out to our Customer Care Team for further assistance.

 

They can initiate a screen-sharing session in a secure environment and create a ticket to open an investigation if necessary. 

 

Here’s how to get in touch with support:

  1. Press F1 or go to the Help menu and select QuickBooks Desktop Help.
  2. Type in your concern on the Search box and hit Enter.
  3. Click the Contact us link at the bottom.
  4. Tell us more about your question on the box provided.
  5. Hit Start a Message.

Please let me know how this goes and if you need any assistance. I’m always here to help. Have a good one!

Karirunt
Level 1

Deposit shows in register but not reconcile

My Direct Deposit went through the bank just fine and looks EXACTLY the same as all of my others however it is listed in my register but does not subtract it so it does not show up when I reconcile. HELP PLEASE!

Adrian_A
Moderator

Deposit shows in register but not reconcile

You have me to help you resolve this issue, Karirunt.

 

We can run some steps and check to see why the transactions are not showing when reconciling.

 

Let's make sure that the Statement date is the same as the date of your bank statement. In addition, the check should also be one of the transactions in your bank statement.

 

If the dates are correct, the transactions may have been reconciled thus, they will not show in your reconciliation page. You can review them on the register page if it has been marked as or Reconciled.

 

Once done, you can then do a mini-reconciliation to clear the check.

 

I've added this article for other reports available in QBDT that will help identify transactions that were modified: Fix Reconciliation Discrepancies.

 

I'll be around if there's anything that I can help with reconciliation. Keep safe!

WB9RRO
Level 1

Deposit shows in register but not reconcile

I had a similar problem today. I'm on QB Enterprise. I was trying to reconcile my payroll account. My payments to QuickBooks Payroll Service showed in my register but not when I went to reconcile. I had to get Right Networks to run the QB Tool kit on my file. Once this was done the payments to QuickBooks Payroll Service no longer appeared in my check register. After having uninstall and reinstall QB (per Intuit support) I found the payments were in an in-active bank account (our old payroll account from 2 years ago). I was able to manually select the correct accounts and this resolved the issue. 

RVMUSEUM
Level 1

Deposit shows in register but not reconcile

I have the same issue and it's not that the deposit was entered incorrectly, it's something about the format for the window showing the reconcile. If I check "Deposits" or "All" at the top, it shows a date for the deposit, but not the amount. Infuriating. It must be a formatting problem 

on QB, but I don't see anywhere to modify it.

JaeAnnC
QuickBooks Team

Deposit shows in register but not reconcile

Thanks for visiting the support forum for QuickBooks, RV. I can suggest some methods for displaying the deposit amount on the Reconcile screen in your QuickBooks account.

 

Based on your description, it appears that you have a QuickBooks Online (QBO) subscription. It's more likely that you dragged the column headers too far, causing the Deposit column to disappear. 

 

To show the amount, you can scroll to the right side of the screen. Here's a screenshot for your reference:

image (1).pngimage (2).png

 

If you want the columns to fit on one screen without scrolling, you can also adjust the width of the headers. To do that, hover your mouse over the border of the column heading until the cursor changes. Then, drag it to widen the column. For your visual reference, please refer to the attached image below.

image (3).png

You can also share a screenshot with us showing your Reconcile window in order for us to have a better picture of your concern. 

 

Additionally, I'll share this article if you need a guide to performing or fixing a reconciliation: Learn the reconcile workflow in QuickBooks.

 

Please don't hesitate to get back to us if you have any follow-up concerns about deposits. I'll be around to help anytime. Keep safe!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us