Skip to main content
A
a1densmom
November 22, 2022
Solved

Reconciliation Question- cleared before date of transaction

  • November 22, 2022
  • 1 reply
  • 0 views

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...

Best answer by Mich_S

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!



 

1 reply

M
Mich_SAnswer
November 22, 2022

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!



 

A
a1densmomAuthor
November 22, 2022

Thank you.

R
RCV
November 22, 2022

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. 

Terms & ConditionsAccessibility statement