cancel
Showing results for 
Search instead for 
Did you mean: 
TomE2022
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

I have to reconcile several past months of bank statements. My problem is that QB (Contractor 21.0/PC version) is including all future dated transactions past my reconciliation statement month.

 

For example: I want to reconcile May 1, 2022 - May 31, 2022. A cash deposit posted on 6/3/2022 (nothing to do with May 2022!) is showing up as "New Transactions" and therefore Ending Balance is as of 6/3/2022. This gets very long and messy as I have to go back prior months and rec.

 

Can I get a nice clean "Month-only as of that month-end" bank rec report? Without all that extra post reconciliation dated "New Transaction" noise on the report? Yes, I have used the check box in the reconciliation window of "Hide transactions after the statement's end date" and it just seems to affect the available entries to show for clearing. The "New" transactions will still show up on that month's rec report.

21 Comments 21
Pete_Mc
Community Champion

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Confirm when you're Reconciling that you've put in the Statement Closing Date, not just letting QBs default to the current date.  Then if the Closing Balance is also per the Statement and you've got all the correct transactions checked off, the Reconciliation Balance should be $0/Balanced. 

 

All of the transactions prior to the Statement Date that have not cleared the Bank should not be checked.  Also any transactions that happened after the Statement Date should also not be checked.  There should also be a little Check Box (it's at the top on QB Desktop) where you can "Hide transactions after the statement's end date."  That should hide all of the newer transactions you're seeing.

 

TomE2022
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

I am including a screenshot to best show exactly what I mean, with the items in YELLOW that I do not need or want to see. (a short version of one account, I have many others that are many months old)

 

I did mention that I used the checkbox for "Hide transactions after the statement's end date" and all this appears to do is just not have the transaction show up in the box while you are selecting entries to mark cleared. This report was created both ways and with same results.

TomE2022
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

EDIT: If you cant see screenshot everything in RED is what I don't want. I'm including as text below:

 

Cleared Balance

Register Balance as of 5/31/2022

     New Transactions

          Deposits and Credits - 1 Item

Deposit                   06/10/2022

          Total Deposits and Credits

      Total New Transactions

Ending Balance

Archie_B
QuickBooks Team

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Thank you for following up and sharing the details, TomE2022.

 

I agree with @Pete_Mc, the statement date is filled automatically in QuickBooks. Make sure to change the statement date to May 31st since it needs to match your bank statement. 

 

Just to make sure we're not missing anything, I'll show you the detailed steps on how to start reconciling an account in QuickBooks Desktop.

 

Here's how:
 

  1. Go to the Banking menu, then choose Reconcile.
  2. Pick the bank or credit card account you want to reconcile in the Account field.
  3. Select the Statement Date (May 31, 2022).
  4. QuickBooks also automatically enters the Beginning Balance. It uses the ending balance from your last reconciliation to get this number.
  5. Enter the Ending Balance based on your bank statement.
  6. Enter the Service Charge and Interest Earned based on your bank statement. Don't enter charges you've already entered in QuickBooks.
  7. Review the fields. If the info is correct, select Continue or OK.

 

Once you're done reviewing the details and checked the option Hide transactions after the statement's end date, it should now exclude the new transactions for your reconciliation. Here's an article for more information: Reconcile an account in QuickBooks Desktop.

 

I'm adding this link in case you'll need to fix issues when you're reconciling in QuickBooks Desktop.

 

I'm always here if you need further assistance with your bank reconciliation. Take care and have a great day!

TomE2022
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Yes, Statement Date is set to month-end, 5/31/2022. Hide transactions box was also checked. The only way it works is to delete the 6/10/2022 transaction and it will not show then. This is obviously not an option for anything else, and shouldn't really be either for just this one transaction. 

 

Guess QB is forcing you to make sure you reconcile each month and not have a back log. And also before you start posting the next month, which kind of stinks since most of my statements come on the 5th-8th.

Giovann_G
Moderator

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

It's odd this one transaction is showing, TomE2022.

 

As it's not part of your reconciliation date, this new transaction shouldn't appear in your month's reconciliation report. Let's run the Verify and Rebuild data to ensure your company is not at risk of potential data damage. Since data problems can occasionally cause unexpected behavior in the software,

 

Here's how:

 

  1. Go to the File menu, then click Utilities.
  2. Choose Verify Data, then hit OK to close all windows. If you see “Your data has failed the integrity check” you need to rebuild your file. If there are no problems with your data, you’re done.

 

Rebuild data:

 

  1. Go to the File menu, then select Utilities.
  2. Click Rebuild Data, then press OK to close all windows.
  3. Choose OK to backup your company file.
  4. Once the rebuild's finished, hit OK.

 

Also, please make sure your QuickBooks Desktop is up to date. This guarantees you have the most recent features and fixes.

 

If the issue persists, I recommend contacting our QuickBooks Desktop Support. They have the tools to conduct a screen-sharing session and submit a ticket for further investigation to determine the root cause of this issue.

 

I've also added this article to learn what to do if you need to add or modify transactions you already reconciled for future reference: Mini-reconciliation.

 

You're welcome to add details below if you need further assistance in QuickBooks. We're always here to help you.

BigRedConsulting
Community Champion

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

No, there's no way to remove the references to future transactions.

DanielB1
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Yes, of course there is. Even on QB Desktop (2022) and here's how. Ready?

 

After reconciling, clicking Reconcile Now comes the option to Display or Print.

 

Click Display not Print!

 

In the Reconciliation Summary Report and the Reconciliation Detail Report that subsequently display, click the top left option Customize Report.

 

Under the Display tab, enter only the ending date of the month that was reconciled, leaving the beginning date field empty and click OK.

 

Click the top middle option Print and save!

 

Additionally, you can even do this to previously reconciled reports.

 

Reports > Banking > Previous Reconciliation

 

On the right side by In this report, include choose the second option Transactions cleared plus any changes made to those transactions since the reconciliation and click Display.

 

Customize Report with again only the ending date of the reconciled month and Print!

 

You're welcome!

 

Daniel B.

JodiB1
Level 1

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Hi Daniel, is there a way to do this in QBO?

randyh8504
Level 1

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Do you know of a way to make it save this customization so I don't have to change it each month?

SirielJeaB
QuickBooks Team

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Randy, it gives me great joy to welcome you to the Community. I'd be pleased to provide information about saving your current customization in QuickBooks Online (QBO).

 

It would be excellent and convenient if you could save the customization process so you don't have to do it every month.

 

The option to save the customization on your reconciliation process is unavailable in QBO. You can, however, set the date range to your preferred period. Please follow the steps below:

 

  1. Click the Gear icon at the top, then select Reconcile under Tools.


     
  2. Fill out all of the fields after clicking the Funnel icon.
  3. Click Apply.

 

 

Every time you finish reconciling, QuickBooks Online automatically generates a reconciliation report. You can customize and memorize it to modify its information and save its current configuration settings.

 

Read the following article to learn how to analyze downloaded bank and credit card transactions and assign them to the correct accounts: Categorize and match online bank transactions in QuickBooks Online.

 

Please let me know if you have any other questions about reconciliation or issues relating to QuickBooks. I'm anticipating your excellent year. Be careful!

KharyssaRhodes-CPB
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Not all heroes wear capes!

 

Thanks for the fix! Totally worked and I have the exact same issue as the OP.

SashaMC
Moderator

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

I am so happy my colleague was able to assist you! If you have any other problems, let us know. My team and I are here to help. See you later.

DanielB1
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

@KharyssaRhodes-CPB 

My pleasure!

DanielB1
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

@JodiB1 QBO is the easier one. After Reconciling, Print the report and check the box that says "Hide additional information." See attached.

DanielB1
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

@SirielJeaB ,

 

Randyh8504 is asking, I believe, about QB Desktop, not Online, of which I have the same question and I don't know of a a way to save this customization, unfortunately.

JessT
Moderator

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Thank you for helping, DanielB.

 

We're unable to save the customization, but you can click on Memorize to saved a copy of the customized report. 

 

 

Feel free to go back to this thread if you have other questions in mind. Take care and have a good one!

DanielB1
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

@JessT ,

 

We are looking to memorize a customization with ONLY the End Date entered WITHOUT any Beginning Date entered. This is needed to be able to save a Reconciliation Report without including transactions that took place after the End Date. Memorizing the customization for a Reconciliation Report will save it only with the specific end date entered.  And any other Memorized date, i.e. "Last Month," will automatically include the Beginning Date, which will not work for a Reconciliation. Please read the chain from the beginning to understand what Randyh8504 and I are referring to.

Adrian_A
Moderator

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

I appreciate you for getting back to us, DanielB1.

 

The option to memorize a report that shows only the end date is unavailable in QuickBooks. I can see how great it would be to be able to have the said option.

 

With that, I'd suggest sharing Feedback with our developers. Here's how:

 

  1. From the Help menu, select Send Feedback Online.
  2. Choose Product Suggestion.
  3. Enter the details of your suggestion.
  4. Hit Send Feedback.

 

Your valuable feedback goes to our Product Development team to help improve your experience in QuickBooks.

 

Feel free to pin this link as your guide in customizing and memorizing reports: 

 

 

I'm just a post away if you have concerns about managing your QuickBooks file.

JandJroofing
Level 1

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Actually - I get rid of this every month simply by going to "customize report" on the report itself once it's created. I choose FILTER and go to CLEARED option on menu list of items.

 

Select YES.

 

Go back to report and hit refresh.

 

That's it

DanielB1
Level 2

How do I stop QB from including transactions posted AFTER a bank reconciliation date?!

Ooh nice! That works too!

 

So I go to "customize report" on the report itself and type the closing date into the "To" area.

 

Accomplishes the same as your idea but I find this quicker. All personal preference though.

 

Daniel

Need to get in touch?

Contact us