cancel
Showing results for 
Search instead for 
Did you mean: 
sun5614
Level 1

I am reconciling bank account. Bank account shows 1 payment on 2/29 and it was actually posted on 3/1. I can't change the post date (it's auto debit for IRS tax) Help?

 
4 Comments 4
AlexV
QuickBooks Team

I am reconciling bank account. Bank account shows 1 payment on 2/29 and it was actually posted on 3/1. I can't change the post date (it's auto debit for IRS tax) Help?

I'm here to assist you with your reconciliation, sun5614.

 

We can change the date even if you're on the reconciliation page. Simply click on the payment transaction to expand it. Then, you can modify the date on the Date column and click Save.

 

Another way to change it is through the Chart of Accounts. Go to the Accounting tab and select Chart of Accounts. Locate the bank account you're reconciling and click on View register. Locate the payment from the list of transactions and select it. Change the date and click on Save.

 

We can perform some troubleshooting steps if you still can't update it. First, open and access your account using an incognito window. From there, follow again the steps I provided on how to change it. You can also clear the browser's cache since it can cause errors in QuickBooks Online. Aside from that, make sure that the browser is updated to avoid any browser issues.

 

You'll want to check this article on how to reconcile an account in QuickBooks Online.

 

I'll be glad to help if you have additional concerns. Have a great day and take care!

sun5614
Level 1

I am reconciling bank account. Bank account shows 1 payment on 2/29 and it was actually posted on 3/1. I can't change the post date (it's auto debit for IRS tax) Help?

Thank you for detailed answer. 

 

I have not YET tried incognito browser, but it does not allow me to change the date. 

I think it is because it is automatic debit for payroll taxes. I checked other entries and I was able to change dates, but not this one. Even when I clicked "edit" and tried, it still did not let me change the date.

 

I only see this entry on Register, NOT on "reconcile" page because this entry is considered as March transaction while the same entry shows as February transaction on my bank statement. 

 

I will try incognito and let you know. 

 

Thank you

sun5614
Level 1

I am reconciling bank account. Bank account shows 1 payment on 2/29 and it was actually posted on 3/1. I can't change the post date (it's auto debit for IRS tax) Help?

Hello Alex, 

 

Thank you for the detailed explanation, but I still could not fix the problem. 

 

The entry is "Payroll Taxes" and it automatically debits from our Business Checking Account.

Our pay day falls on the 25th and sometimes these taxes do not come out until the 1st of next month.

The problem is, my bank statement shows that this transaction happened on 2/29 and the actual date Department of Revenue received the payment (e-Payment Post Date) on the 3/1. I cannot change this date even when I followed your steps. 

 

Would you have other ways for me? 

 

Thank you

RenjolynC
QuickBooks Team

I am reconciling bank account. Bank account shows 1 payment on 2/29 and it was actually posted on 3/1. I can't change the post date (it's auto debit for IRS tax) Help?

Hello there, sun5614.

 

When a tax payment was processed through the E-Services, modifying the date is unavailable. What you can do is exclude the transaction that shows up in the Banking page, and manually clear the one recorded in the register.

 

To exclude, here's how:

 

  1. Go to the Banking For Review tab.
  2. Select the transactions by putting a check mark on the boxes and click the Batch actions drop-down menu.
  3. Choose Exclude Selected.

Please see this sample screenshot:

 

 

Once done, the transactions will be added to the Excluded tab were you can undo or delete them. Here's an article for reference: Exclude expenses from downloaded bank transactions.

 

Then, proceed with clearing the tax payment for 2/29 by following these step:

 

  1. On the left panel, select Accounting Chart of Accounts.
  2. Click the View register link of the bank account where the check was added.
  3. Find and select the check to show the options. Under the Reconcile (indicated by a check mark) column, click the blank field until you see the letter C. This letter means Cleared and the letter is for Reconciled.
  4. Press the Save button after.

 

Here's a sample screenshot:

 

 

I'm also adding these articles to use as a guide in the future: 

 

Feel free to leave a comment here if you have any additional questions. Take care. 

Need to get in touch?

Contact us