cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
mrp2
Level 2

Customer deducts an invoice from a payment

Hi,

 

Attached is a very detailed description of my problem.  Every week I receive a remittance into my bank account.  There are normal additions and deductions but a lot of the times there are deductions for an invoice, etc that I do not know how to post.  There are some solutions from 2018 but not sure if they will work now.

Thanks in advance for any help you can provide.

Al

2 Comments 2
Erika_K
QuickBooks Team

Customer deducts an invoice from a payment

Greetings, mrp2. It's good to have you back.

 

It seems you've posted twice in the Community forum about how to post the deductions for an invoice, which my colleague Ivan_G already answered. 

 

To view the response, check out this link: https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-create-a-bank-account-ca....

 

I've compiled a set of guides to help you master the art of managing customer remittances, invoicing, and financial reporting:

 

 

Have more questions about adding deductions to invoices or managing sales activities? Visit our Community Forum for expert help. Our team is ready and waiting to provide all the support you need.

Rainflurry
Level 14

Customer deducts an invoice from a payment

@mrp2 

 

Just to confirm, your "Invoice Offset" ($3,059.70) is showing as a positive amount on your attachment when presumably it is being used to reduce the invoice amount.  

 

If you don't need your sales receipt itemized, here are a few things to consider:

 

1) Use an invoice instead of a sales receipt.  A sales receipt doesn't allow you to offset A/P and A/R directly without an item and you can't assign A/R or A/P to an item.  Your idea of setting up a bank Clearing Account (you called it "Transfer A/R & A/P") is great.  

 

2) Invoice Offset - Enter Nayax's bill for the fixed assets and pay it using the bank Clearing Account.  Then, receive payment on the invoice for the same amount.  This reduces the amount due on the invoice by the amount of Nayax's bill.  This serves as the Invoice Offset on your attachment.

 

3) Prior period - Use the same process as Invoice Offset.  Pay the Nayax bill for parts using the Clearing Account.  Then, receive payment on the invoice for the same amount.  This also reduces the amount due on the invoice by the amount of Nayax's bill.  This serves as the Prior Period Adjust on your attachment.

 

At this point, your invoice total should match the remittance from Nayax.  Receive payment on the invoice and you should be all set. 

 

The description on page 3 of your attachment is on the right track.  No need to use Undeposited Funds though - just receive payment directly to the Transfer (Clearing Account).

 

If you need to use a sales receipt and items, you can assign the bank Clearing Account to the items used for the prior period adjust and invoice offset.  Entering those as a negative amount will put those amounts back into the Clearing Account that was driven negative when used to pay the Nayax bills, thereby zeroing it out.  Either way works, it just depends on which method works best for you.    

 

    

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us