Delete a Past Invoice and Payment

[DouglasROA]

I’m using Quickbooks 2012 for Mac (version V13.0.8 R9).

I discovered that, several months ago, I had assigned both an invoice and its payment to the wrong project. In an attempt to correct that I first went to the Transaction Center, Received Payments window, opened the payment and unchecked it. Then I opened the invoice and voided that. I created a new invoice and its corresponding payment, both back dated to their appropriate dates. However the payment appears in my current Bank Reconciliation and if I check it there, the account doesn’t balance. It appears that an extra payment is still in the system.

How can I fix this?

Thank you.

[cojhl2]

Originally Posted by DouglasROA

I’m using Quickbooks 2012 for Mac (version V13.0.8 R9).

I discovered that, several months ago, I had assigned both an invoice and its payment to the wrong project. In an attempt to correct that I first went to the Transaction Center, Received Payments window, opened the payment and unchecked it. Then I opened the invoice and voided that. I created a new invoice and its corresponding payment, both back dated to their appropriate dates. However the payment appears in my current Bank Reconciliation and if I check it there, the account doesn’t balance. It appears that an extra payment is still in the system.

How can I fix this?

Thank you.

Correct, it is in there twice. Deleting the invoice did not delete the payment.

What should have been done I think, is to change the project on the original invoice because that would not change the overall financials.

Now, (I hate to suggest this) but I guess you must go in and delete the original payment, and then mark as cleared the new payment.

[DouglasROA]

Are you kidding? It's really that easy? That never occurred to me. If that works I am tempted to recover an old backup and redo the whole month. Thank you!

[cojhl2]

I am tempted to recover an old backup and redo the whole month. Thank you!

Be careful, don't jump to making changes that may cause irreparable damage to your system.

Just fix the current issue and move on. If you entered the data correctly regardless of how clumsy it was it is still correct!!

[DouglasROA]

I already went back a month. But that's OK. I'd like to do this correctly if possible, however I'm not sure your method worked completely so I didn't save it. What I did was go back to the original invoice and I changed the project. I got a message saying that the change was connected to other transactions that wouldn't be changed. Then I went to the payment and changed the project there. The invoice then showed as unpaid so I checked the payment with the appropriate date. The result was an unapplied credit to the original project. I am going to go ahead and redo the current month and hold off on correcting the error until I know more. Thanks...

[cojhl2]

Oh shoot! i hope my solution did not cause more issues for you.

I apologize for giving out bad info..

[DouglasROA]

Originally Posted by cojhl2

Oh shoot! i hope my solution did not cause more issues for you.

I apologize for giving out bad info..

It's OK. I didn't want that error and didn't know how to correct it otherwise.