Skip to main content
August 13, 2022
Solved

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

  • August 13, 2022
  • 1 reply
  • 0 views
Bank balance at end of month shows more cash available than bank statement for my reconcillation.
Best answer by MadelynC

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!

1 reply

MadelynCAnswer
August 13, 2022

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!

August 14, 2024

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
August 14, 2024

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