cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Pebbles135
Level 2

How do you handle when your bank statement and quickbooks show different dates for payroll taxes clearing? Bank shows 07/29/22 and quickbooks shows 08/01/22. Thanks

Bank balance at end of month shows more cash available than bank statement for my reconcillation.
Solved
Best answer August 13, 2022

Best Answers
MadelynC
Moderator

How do you handle when your bank statement and quickbooks show different dates for payroll taxes clearing? Bank shows 07/29/22 and quickbooks shows 08/01/22. Thanks

I’ll make sure you can reconcile your account accurately, @Pebbles135.


If your payroll taxes records manually in QuickBooks Online, you can change the date to match it to your bank statement.


Here’s how:

 

  1. Select Taxes, then Payroll Tax.
  2. Go to the Tax payment history.
  3. Choose the payment you want to update, then select Edit.
  4. Change the date period and save after.


On the other hand, if the tax payment is processed electronically, you’ll need to void it. Simply open the said payment and void. After, recreate the transaction through a check. Then, include it in your July reconciliation.


I’ve attached this article to learn more about generating a reconciliation report: How do I view, print, or export a reconciliation report? This makes sure everything is cleared.


Don’t hesitate to leave a message if you need further assistance with managing your bank transactions and payroll. I’ll be here to help. Take care!

View solution in original post

7 Comments 7
MadelynC
Moderator

How do you handle when your bank statement and quickbooks show different dates for payroll taxes clearing? Bank shows 07/29/22 and quickbooks shows 08/01/22. Thanks

I’ll make sure you can reconcile your account accurately, @Pebbles135.


If your payroll taxes records manually in QuickBooks Online, you can change the date to match it to your bank statement.


Here’s how:

 

  1. Select Taxes, then Payroll Tax.
  2. Go to the Tax payment history.
  3. Choose the payment you want to update, then select Edit.
  4. Change the date period and save after.


On the other hand, if the tax payment is processed electronically, you’ll need to void it. Simply open the said payment and void. After, recreate the transaction through a check. Then, include it in your July reconciliation.


I’ve attached this article to learn more about generating a reconciliation report: How do I view, print, or export a reconciliation report? This makes sure everything is cleared.


Don’t hesitate to leave a message if you need further assistance with managing your bank transactions and payroll. I’ll be here to help. Take care!

breezy50
Level 2

How do you handle when your bank statement and quickbooks show different dates for payroll taxes clearing? Bank shows 07/29/22 and quickbooks shows 08/01/22. Thanks

I us QB online for payroll  and I allow QB to file my taxes electronically. I encountered this same situation (QB dated the payroll tax payment as 5/1/24 but took the payment out of my bank on 4/30/24 - which means the bank reflects it on the April statement not on the May statement). There is no way that I can currently balance my bank statement with this dating problem. QB online currently does not allow the tax payment transaction to be voided (as the suggestion from 2022 above mentions). Since the tax payment was not manually done, the date can not be edited either. I assume the only way to fix it is a general journal entry? Help!

FishingForAnswers
Level 10

How do you handle when your bank statement and quickbooks show different dates for payroll taxes clearing? Bank shows 07/29/22 and quickbooks shows 08/01/22. Thanks

@breezy50  This is, unfortunately, an unavoidable effect of how QB handles things.

 

Much like Direct Deposit, they will take the money from your account on Day 1 (Say, 4/30/2024) and send it on Day 2 (5/1/2024).

 

You could fight the good fight and try to get QB to fix their system, but honestly, there's an easier way.

 

In this case, the simplest way to handle it would be to reconcile April 2024's bank statement without marking the payroll tax payment as cleared (as you really should, since this is exactly like when you write a check to somebody in April 2024 and they don't cash it until May 2024 or later).

 

If you don't want to, or can't, do that for whatever reason, just reconcile both April 2024 and May 2024 in one run.

FishingForAnswers
Level 10

How do you handle when your bank statement and quickbooks show different dates for payroll taxes clearing? Bank shows 07/29/22 and quickbooks shows 08/01/22. Thanks

@breezy50  Sorry, I'm still half asleep and can't edit my posts.

 

On re-reading your post, you should ignore my first suggestion and just go with the second.

LouiseG
QuickBooks Team

How do you handle when your bank statement and quickbooks show different dates for payroll taxes clearing? Bank shows 07/29/22 and quickbooks shows 08/01/22. Thanks

Thank you for sharing detailed information about the payroll tax payment, @breezy50. Let me point you in the right direction for assistance.

 

Since the payroll tax payment was paid electronically through QuickBooks and you're unable to edit the date or void the transaction. I suggest contacting our Payroll Support team for further assistance in correcting the payroll tax payment date. They're equipped to help you with this issue.

 

Here's how you can reach them:

 

  1. Go to Help (?), and select the Search option.
  2. Click on Contact Us, then pick Payroll.
  3. Choose a way to connect with us.

 

Additionally, feel free to check out their support hours to connect with them accordingly.

 

For future reference, here's a guide on accessing your payroll tax payments and forms in QuickBooks: View your previously filed tax forms and payments.

 

Don't hesitate to revisit this forum if you have follow-up questions about tax payments in QuickBooks Online Payroll. We're always here to help you.

Rainflurry
Level 14

How do you handle when your bank statement and quickbooks show different dates for payroll taxes clearing? Bank shows 07/29/22 and quickbooks shows 08/01/22. Thanks

@breezy50 

 

"There is no way that I can currently balance my bank statement with this dating problem."

 

When you reconcile, just remove the filter for 'Statement ending date'.  That allows you to clear May transactions on April's reconciliation.  

breezy50
Level 2

How do you handle when your bank statement and quickbooks show different dates for payroll taxes clearing? Bank shows 07/29/22 and quickbooks shows 08/01/22. Thanks

Perfect...thanks so much!

 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us