LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
a1densmom
Level 1

Reconciliation Question- cleared before date of transaction

I am catching up on the reconciliation. I am trying to reconcile my checking account for April. I am unable to clear it because there was a payroll tax payment that cleared in April, but the date of the actual transaction is 05/02/22. I am unable to change the date and if I extend the statement ending date, it will ruin my current work...

Solved
Best answer November 22, 2022

Best Answers
Mich_S
QuickBooks Team

Reconciliation Question- cleared before date of transaction

I see you wish to reconcile a transaction that cleared prior to its transaction date in QuickBooks Online, @a1densmom.

 

I want to provide some ideas so you can have this done in no time.

 

Your bank statement must always be the basis for reconciling transactions. Before starting the reconciliation, make sure to check the opening balance. This maintains the accuracy and consistency of the numbers. For more information and detailed steps, see this guide: Reconcile an account in QuickBooks Online.

 

Additionally, I recommend excluding the transaction that cleared on May 02, 2022. Once done, you can manually clear it from your Chart of Accounts. I'll show you how.

 

To exclude:

 

  1. Open the Banking menu and select Banking.
  2. Navigate to the For review section.
  3. Click on the checkbox for each transaction you want to exclude.
  4. Hit Exclude.

 

To manually clear:

 

  1. Open the Accounting menu.
  2. Select Chart of Accounts.
  3. Locate the payment transactions you're working on.
  4. Go to the Reconciled Status column or the box icon. (In between the Deposit and Balance column.)
  5. Click on the blank space until it shows C.
  6. Click on Save to confirm.

 

I'm also adding these helpful articles about managing online banking transactions and fixing any reconciliation errors that you might encounter.

 

 

Keep in touch for more help about this topic or QuickBooks as a whole. We're here to back you up 24/7. Take the best care always!



 

View solution in original post

7 Comments 7
Mich_S
QuickBooks Team

Reconciliation Question- cleared before date of transaction

I see you wish to reconcile a transaction that cleared prior to its transaction date in QuickBooks Online, @a1densmom.

 

I want to provide some ideas so you can have this done in no time.

 

Your bank statement must always be the basis for reconciling transactions. Before starting the reconciliation, make sure to check the opening balance. This maintains the accuracy and consistency of the numbers. For more information and detailed steps, see this guide: Reconcile an account in QuickBooks Online.

 

Additionally, I recommend excluding the transaction that cleared on May 02, 2022. Once done, you can manually clear it from your Chart of Accounts. I'll show you how.

 

To exclude:

 

  1. Open the Banking menu and select Banking.
  2. Navigate to the For review section.
  3. Click on the checkbox for each transaction you want to exclude.
  4. Hit Exclude.

 

To manually clear:

 

  1. Open the Accounting menu.
  2. Select Chart of Accounts.
  3. Locate the payment transactions you're working on.
  4. Go to the Reconciled Status column or the box icon. (In between the Deposit and Balance column.)
  5. Click on the blank space until it shows C.
  6. Click on Save to confirm.

 

I'm also adding these helpful articles about managing online banking transactions and fixing any reconciliation errors that you might encounter.

 

 

Keep in touch for more help about this topic or QuickBooks as a whole. We're here to back you up 24/7. Take the best care always!



 

a1densmom
Level 1

Reconciliation Question- cleared before date of transaction

Thank you.

RCV
QuickBooks Team
QuickBooks Team

Reconciliation Question- cleared before date of transaction

Thanks for coming back, a1densmom.

 

It's great to know the recommended works on your end. If you need to run a Reconciliation report, just follow the steps below:

 

  1. Go to Business overview and select Reports.
  2. Type Reconciliation Report in the Find report by name search bar.
  3. Tap Reconciliation Reports.
  4. Choose the Account for the reconciliation report you want to view.
  5. From the Report period dropdown arrow, choose the reconcile period.
  6. Press View Report.

 

Let me share some resources that you can browse and use as a reference in managing and navigating your QuickBooks account:

 

 

Should you need any additional assistance managing your bank transactions, you can leave a comment below. I'll be sure to get back to you. Have a great day ahead. 

homegrownben
Level 1

Reconciliation Question- cleared before date of transaction

Hello, 

 

This is the exact issue I am experiencing.  I've followed the instructions below; however, there is no "exclude" option in the review of this transaction.  Can you please advise?

 

To exclude:

 

  1. Open the Banking menu and select Banking.
  2. Navigate to the For review section.
  3. Click on the checkbox for each transaction you want to exclude.
  4. Hit Exclude.

 

MariaSoledadG
QuickBooks Team

Reconciliation Question- cleared before date of transaction

I'll guide you so you'll be able to locate the exclude option, homegrownben.

 

Excluding transactions lets, you move transactions to the Excluded tab of the Banking page. You'll usually find the option after you've selected the transaction that you want t to exclude. I've added this screenshot for your reference:

 

 

Once you've selected the Exclude button, the transaction can already be found under the Excluded tab. 

 

 

However, if you're still having issues accessing the button, you'll have to make sure that you are set as an admin so you'll have the access to every part of the QuickBooks account and that includes the Banking page. To learn more about how you manage roles and limit to access specific tasks, consider reading this article for more details: User Roles And Access Rights In QuickBooks Online.

 

Additionally, QuickBooks downloads the latest transaction once you've already connected your bank and credit card accounts. You can check out this article if you want to know how it adds or tries to look for a match with those you've already entered in QuickBooks: Categorize And Match Online Bank Transactions In QuickBooks Online.

 

You can always touch base with us here in the Community if you need further assistance. I'll always be right here to help.

JamaicaTB
Level 1

Reconciliation Question- cleared before date of transaction

Is there an option for this in quickbooks desktop?

I have a 1099 who cashed his check early. Check date is 1/1/25. It was cashed on 12/31/24. How do I reconcile the discrepancy without changing the check date?

FishingForAnswers
Level 10

Reconciliation Question- cleared before date of transaction

@JamaicaTB  Desktop allows you to see transactions past the reconciliation period unless you mark the relevant box.

 

While this may be the sleep deprivation talking, you should be able to simply mark the transaction as cleared and move on, no different than if a check dated in December didn't clear until January and you needed to unmark it.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us