cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
yvesriel
Level 1

How to remove bill payment from an invoice?

Hi,

I've searched for a while but everything I found either doesn't work or isn't applicable.

 

My problem is that I have a customer who's also a supplier. When he's paying, he subtracts from the payment whatever I owe him.

  • I have a customer account and a supplier account. Both representing the same company
  • I have created a bill with what I owe him
  • I have created an invoice with what he owes me.
  • The deposit in my bank account is the invoice minus the bill.

How do I reconcile this in QBO?


Solved
Best answer July 22, 2025

Best Answers
JamesDuanT
Moderator

How to remove bill payment from an invoice?

The quickest way to reconcile the amounts on your bill and invoice is by affecting Accounts Payable and Accounts Receivable through your bank deposit, yvesriel.

 

Here's how we can record your bank deposit:

 

  1. Click the + New button, then select Bank deposit.
  2. Scroll down to the Add funds to this deposit section.
  3. On the first line, enter:
    RECEIVED FROM: Select the customer profile.
    ACCOUNT: Choose Accounts Receivable (A/R).
    AMOUNT: Enter the invoice's full amount.
  4. On the second line, enter: 
    RECEIVED FROM: Select the supplier profile. 
    ACCOUNT: Choose Accounts Payable (A/P)
    AMOUNT: Enter the bill's full amount as a negative value.
  5. Verify the AMOUNT at the upper-right corner of the Bank deposit page matches the net amount you received.
  6. Click Save and close or Save and new to record the deposit.
    image.png

 

Then, we can link the deposit to the bill.

 

  1. Open the bill, then click the Make payment button.
  2. On the Bill Payment page, mark the bill under the Outstanding Transactions section.
  3. Mark the deposit under the Credits section.
  4. Confirm that the AMOUNT PAID at the upper-right corner is zero (0.00).
  5. Click Save and close.
    image 2.png

 

The same process will apply to the invoice. We will link the deposit as payment to the invoice.

 

  1. Open the invoice, then click Receive payment.
  2. On the Receive Payment page, make sure the invoice is marked under the Outstanding Transactions section.
  3. Go to the Credits section and mark the bank deposit to apply it as payment.
  4. Confirm that the AMOUNT RECEIVED at the upper-right corner is zero (0.00).
  5. Click Save and close.
    image 3.png

 

After completing these transactions, the account will be ready for reconciliation without any issues. I also recommend consulting your accountant to explore alternative methods that can simplify this process further.

 

Feel free to reach out if you need any further assistance. We're here to help.

View solution in original post

3 Comments 3
JamesDuanT
Moderator

How to remove bill payment from an invoice?

The quickest way to reconcile the amounts on your bill and invoice is by affecting Accounts Payable and Accounts Receivable through your bank deposit, yvesriel.

 

Here's how we can record your bank deposit:

 

  1. Click the + New button, then select Bank deposit.
  2. Scroll down to the Add funds to this deposit section.
  3. On the first line, enter:
    RECEIVED FROM: Select the customer profile.
    ACCOUNT: Choose Accounts Receivable (A/R).
    AMOUNT: Enter the invoice's full amount.
  4. On the second line, enter: 
    RECEIVED FROM: Select the supplier profile. 
    ACCOUNT: Choose Accounts Payable (A/P)
    AMOUNT: Enter the bill's full amount as a negative value.
  5. Verify the AMOUNT at the upper-right corner of the Bank deposit page matches the net amount you received.
  6. Click Save and close or Save and new to record the deposit.
    image.png

 

Then, we can link the deposit to the bill.

 

  1. Open the bill, then click the Make payment button.
  2. On the Bill Payment page, mark the bill under the Outstanding Transactions section.
  3. Mark the deposit under the Credits section.
  4. Confirm that the AMOUNT PAID at the upper-right corner is zero (0.00).
  5. Click Save and close.
    image 2.png

 

The same process will apply to the invoice. We will link the deposit as payment to the invoice.

 

  1. Open the invoice, then click Receive payment.
  2. On the Receive Payment page, make sure the invoice is marked under the Outstanding Transactions section.
  3. Go to the Credits section and mark the bank deposit to apply it as payment.
  4. Confirm that the AMOUNT RECEIVED at the upper-right corner is zero (0.00).
  5. Click Save and close.
    image 3.png

 

After completing these transactions, the account will be ready for reconciliation without any issues. I also recommend consulting your accountant to explore alternative methods that can simplify this process further.

 

Feel free to reach out if you need any further assistance. We're here to help.

yvesriel
Level 1

How to remove bill payment from an invoice?

Hi James,

 

Thanks a lot! It worked perfectly. I used to do it differently, with a single operation via the bank deposit, but then it calculated a negative amount for taxes (GST/QST). When it was time to do the tax report, the government portal wasn't accepting negative values. At least, now, the taxes are properly set in the report.

 

Many many tanks for such a detailed answer.

Lyn_D
QuickBooks Team

How to remove bill payment from an invoice?

Hello there, Yvesriel.
 
Thank you for taking the time to respond and share how our solutions have positively impacted your business. Your feedback motivates us to continue providing exceptional service.
 
If you have any additional questions or concerns , please feel free to reply below. We are always here to assist you further.

Need to get in touch?

Contact us