Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
LIMITED TIME 90% OFF QuickBooks for 3 months*
Buy nowI 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! Go to Solution.
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:
To manually clear:
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!
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:
To manually clear:
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!
Thank you.
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:
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.
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:
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.
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?
@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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here