cancel
Showing results for 
Search instead for 
Did you mean: 
Sonny209
Level 3

Customer overpayment and want to retain as credit

Hi,

I have a customer who made an overpayment 2 months ago and we have no invoice and might not be receiving invoice until couple months from now , so I want to retain this credit for the customer.  We did receive payment and the credit shows up in A/R report and unapplied payment in the customer page . 

 

is there anyway for the credit not to show up on a/r report, like if i can move the credit from accounts receivable to some other liability account ?   

Solved
Best answer January 19, 2024

Best Answers
Rainflurry
Level 13

Customer overpayment and want to retain as credit

@Sonny209 

 

"what if in future i don't get invoice and have to refund them , would i be writing a check and choosing other current liability account to pay out of it ?"

 

You got it.  Assign the liability account to the check and you're all set.

 

"or if i do get invoice how would i apply"

 

You can move it back to A/R with a journal entry - debit the liability account, credit A/R.  Then apply it to the invoice using New > Receive payment.  Or, you can create a 'Customer Deposit' service product (select the liability account under the 'Income account' drop down in the product set-up screen) and add that to the invoice as a negative amount.  That will reduce the amount due by the amount of the deposit and reduce the liability account by the same amount.  Either way works.  It's up to you which one to use.  

 

View solution in original post

7 Comments 7
LeizylM
QuickBooks Team

Customer overpayment and want to retain as credit

I'm here to assist you in finding a way to keep this credit for your customer without affecting your A/R report, Sonny. 

 

We can create a journal entry to move the credit from the accounts receivable to this new liability account. This will remove the credit from the A/R report. 

 

Here's how:

 

  1. Click +New and select Journal entry.
  2. On the first line, debit the Accounts receivable.
  3. Put the amount on the debit column on the first line.
  4. On the next line, credit the liability account.
  5. In journal entries, the total of the Debit and Credit columns must be equal.
  6. Once done, click Save and Close.

 

Let me also share these articles that you can utilize for future use. These can walk you through the steps on how to modify your reports based on your preference: Customize reports in QuickBooks Online.

 

If you have any follow-up queries about your report, make sure to tag me in your response. I'm always here ready to help you anytime. Keep safe and always stay healthy!

Sonny209
Level 3

Customer overpayment and want to retain as credit

i created the journal entry as you stated , now i get  payment and journal entry showing up on A/R Report .   I have attached the picture of itScreenshot 2024-01-18 201755.jpg

Sonny209
Level 3

Customer overpayment and want to retain as credit

I did the journal entry as you stated but i still get payment and JR showing up in A/R report and  on my customer tab it's also showing overdue.  

 

A/R Report  

Screenshot 2024-01-18 201755.jpg

 

customer screen :

customer.jpg

Maybelle_S
QuickBooks Team

Customer overpayment and want to retain as credit

I can help you remove the payment from the report, Sonny.

 

The journal entry will show in the Accounts Receivable (A/R) Aging report if it's not linked to the transaction. We can go to the Receive payment window and apply it from there.

 

Here's how:

 

  1. Go to the +New button.
  2. Click Receive payment.
  3. Select the journal entry you've created.
  4. Hit Save and close.

 

Additionally, here's an article that you can read to help track all invoices that are due on a particular day or date range: Due invoices report.

 

Lastly, refer to this link to help view the status of all sales transactions, such as open and paid invoices: View sales transactions.

 

If I can be of any additional assistance, let me know by leaving a comment below. I'll be more than happy to help you again. Take care.

Rainflurry
Level 13

Customer overpayment and want to retain as credit

@Sonny209 

 

You can move that amount to a liability account using a journal entry (JE) as you did but then QB can no longer automatically apply that credit to a future invoice.  You will have to manually track it and apply it to a future invoice.  As mentioned, you will need to go to New > Receive payment to apply the A/R credit from the payment to the A/R debit from the JE to remove them from your A/R aging reports.   

Sonny209
Level 3

Customer overpayment and want to retain as credit

thank you that worked to get it out of the a/r.   what if in future i don't get invoice and have to refund them , would i be writing a check and choosing other current liability account to pay out of it ? or if i do get invoice how would i apply 

Rainflurry
Level 13

Customer overpayment and want to retain as credit

@Sonny209 

 

"what if in future i don't get invoice and have to refund them , would i be writing a check and choosing other current liability account to pay out of it ?"

 

You got it.  Assign the liability account to the check and you're all set.

 

"or if i do get invoice how would i apply"

 

You can move it back to A/R with a journal entry - debit the liability account, credit A/R.  Then apply it to the invoice using New > Receive payment.  Or, you can create a 'Customer Deposit' service product (select the liability account under the 'Income account' drop down in the product set-up screen) and add that to the invoice as a negative amount.  That will reduce the amount due by the amount of the deposit and reduce the liability account by the same amount.  Either way works.  It's up to you which one to use.  

 

Need to get in touch?

Contact us