Skip to main content
V
VFAKathy
April 29, 2019
Solved

How to change the payment received date on a reconciled transaction

  • April 29, 2019
  • 2 replies
  • 0 views

We need to change the payment received date for an invoice. The transaction has already been reconciled. What is the best way to do this without creating an opening balance problem on the next rec? 

 

Thanks!

Best answer by MaryGraceS

Hello there, @VFAKathy.

 

Thank you for choosing the Community to help you with your concern about editing a reconciled payment in QuickBooks Online. Allow me to help share some insight to get this taken care of today. 

 

When you change the reconciled payment received date, the effect depends on the date you're going to enter. It may not impact the opening balance of your next reconciliation if the date is within the month you currently reconciled. If not, it'll affect the opening balance. 

 

Let me show you how:

  1. On the left pane, select Accounting.
  2. In the Chart of Accounts section, find the bank.
  3. In the ACTION column, click View Register. 
  4. Select the payment, then click Edit.
  5. On the Receive Payment window, change the Payment date. 
  6. Click Save and close. 
  7. Click Yes to confirm. 

Additionally, you may wish to consider reaching out to your accountant to ensure your books are recorded correctly. You may also visit the QuickBooks Blog for additional reference and to check the latest features added to the product. 

 

That should get you back in track. Drop me a comment below if you have any other questions about editing the reconciled transaction or while working with QuickBooks. I'll be happy to help you out. Wishing you and your business success. 

2 replies

lynda11_2
lynda11_2
April 29, 2019

Hello @VFAKathy :

 

You can open and edit the transaction. Changing the date will not unreconcile it.  You will get a warning though.  Just disregard it and click ok.

 

Lynda

M
MaryGraceSAnswer
April 29, 2019

Hello there, @VFAKathy.

 

Thank you for choosing the Community to help you with your concern about editing a reconciled payment in QuickBooks Online. Allow me to help share some insight to get this taken care of today. 

 

When you change the reconciled payment received date, the effect depends on the date you're going to enter. It may not impact the opening balance of your next reconciliation if the date is within the month you currently reconciled. If not, it'll affect the opening balance. 

 

Let me show you how:

  1. On the left pane, select Accounting.
  2. In the Chart of Accounts section, find the bank.
  3. In the ACTION column, click View Register. 
  4. Select the payment, then click Edit.
  5. On the Receive Payment window, change the Payment date. 
  6. Click Save and close. 
  7. Click Yes to confirm. 

Additionally, you may wish to consider reaching out to your accountant to ensure your books are recorded correctly. You may also visit the QuickBooks Blog for additional reference and to check the latest features added to the product. 

 

That should get you back in track. Drop me a comment below if you have any other questions about editing the reconciled transaction or while working with QuickBooks. I'll be happy to help you out. Wishing you and your business success. 

J
JJCDC
June 2, 2020

I need to change the payment received date on two unreconciled transactions that are dated in November and December 2019 registers.  They should have been dated January 2020.  The books are reconciled through 2019, but no months reconciled for 2020 yet.

 

I reached out to our CPA and they confirmed the deposits need to be recorded in 2020, but no additional guidance was provided on the best way to do this.

Angelyn_T
Angelyn_T
June 2, 2020

I appreciate you for joining the thread, @JJCDC.

 

Since those two transactions aren't reconciled yet, they won't affect your 2019 reconciliation. To make changes for those payments, you can directly update the date to the correct one.

 

  1. Open the payment, then update the date under the Payment date section.
  2. Tap on Save and close to record the changes.
  3. Hit Yes to confirm the action.

 

I found these articles that may help you about reconciliation in QuickBooks Online:

 

Comment down below if you have any other questions. I'm more than happy to help. Have a good day!

Terms & ConditionsAccessibility statement