Skip to main content
January 9, 2023
Solved

How to mark unpaid invoices as paid

  • January 9, 2023
  • 1 reply
  • 0 views

As newbie consultants we initially did not record QuickBooks invoices for our customer.  We did record and appropriately apply payments.   At the end of the year we discovered the error of our ways and after the fact created a single invoice to make things balance.   How do I mark it as paid without creating a corresponding income amount in Undeposited Funds?

Best answer by BigRedConsulting

RE: I can update those deposits to change the Received From to apply them to the customer, but that doesn't seem to apply them to the open, unpaid invoice.

 

That's correct. It won't. Based on this description, you didn't receive and apply Payment transactions as previously asserted, but instead recorded deposits. Notably, if you recorded deposits and used income accounts, and then recorded an invoice and also used income accounts, then you've doubled your income.

 

If you want to record invoices for your sales, then the proper sequence is Invoice -> Payment -> Deposit where only the invoice uses income accounts, and both the payment and the deposit will only use balance sheet accounts. Trying to do it backwards is somewhat difficult, but in this case you can record payments and then add them do your deposits, replacing the detail that is there.

 

 

 

1 reply

BigRedConsulting
January 9, 2023

You could not have appropriately applied payments if you didn't have invoices to apply them to.  Do you mean you appropriately recorded payment transactions?

 

If so, then edit those transactions and apply them to the big invoice you created, which will pay down the invoice's open balance. You'll need one invoice per customer in order to do this.

January 9, 2023

I have some checking account deposits (DEP) and some other received payments.   I can update those deposits to change the Received From to apply them to the customer, but that doesn't seem to apply them to the open, unpaid invoice. In the first case I'm guessing I need to change the Type from DEP to PMT?  But I can't see how to do that.   But double clicking what was obviously a payment deposit doesn't give me any obvious method to retroactively apply it as a payment to a specific invoice.

BigRedConsulting
January 11, 2023

RE: I can update those deposits to change the Received From to apply them to the customer, but that doesn't seem to apply them to the open, unpaid invoice.

 

That's correct. It won't. Based on this description, you didn't receive and apply Payment transactions as previously asserted, but instead recorded deposits. Notably, if you recorded deposits and used income accounts, and then recorded an invoice and also used income accounts, then you've doubled your income.

 

If you want to record invoices for your sales, then the proper sequence is Invoice -> Payment -> Deposit where only the invoice uses income accounts, and both the payment and the deposit will only use balance sheet accounts. Trying to do it backwards is somewhat difficult, but in this case you can record payments and then add them do your deposits, replacing the detail that is there.