Skip to main content
November 29, 2023
Solved

Can I change an AP Expense entry to a vendor payment and apply it to an existing invoice? When matching bank transactions and ADD is clicked, it creates an expense entry.

  • November 29, 2023
  • 2 replies
  • 0 views
When a co-worker is matching bank transactions for vendor ACH payments and they don't see an exact match, they are clicking "ADD" which creates an Expense transaction and duplicates the existing vendor invoice. So is there a way to convert an Expense entry into a payment and apply it to an existing AP bill? Or should I just delete the Expense entry and create a payment? This often happens when there are two or more vendor bills being paid by a single ACH payment.
Best answer by Rainflurry

@LeeWhite12341 

 

"So is there a way to convert an Expense entry into a payment and apply it to an existing AP bill?  Or should I just delete the Expense entry and create a payment? "

 

Yes, you can change the expense entry to a payment.  Locate the transaction that was added and change the Category from the expense to A/P.  That changes the expense to a vendor credit.  Then, go to Pay bills and apply the credit to the bill.  

2 replies

November 29, 2023

Hi there, @LeeWhite12341.

 

Let me share insights regarding your transaction inquiries in QuickBooks Online (QBO).

 

Converting your expense transactions into payment and applying it to an AP Bill is an unavailable feature in QBO. However, manually creating a payment and deleting the expense entry can help solve this matter.

 

To enter your bill manually, you can follow the steps below:

 

  1. Click + New icon, then select Bill.
  2. Choose a vendor from the Vendor ▼ dropdown.
  3. Enter the necessary information that applies to your bill. 
  4. When done, select Save and Close.

 

Since you added the bill manually, it will appear directly in the Unpaid tab, so you don’t need to review it. To guarantee that you won’t have duplicate transactions, we have to undo/exclude the added payment.

 

Furthermore, if you are trying to find a match when visiting your Banking page and find a similar transaction but with a discrepancy. You can enter an adjustment to resolve the difference.

 

Here’s how:

 

  1. On the Banking page, find an item with an amount that doesn’t match the transaction you entered for it.
  2. Select the item, and once the row expands, click Find Match.
  3. Choose the transaction on the Match Transactions page. Enter the search criteria at the top of the table if you can't find it.
  4.  Go to the bottom of the table and click the Resolve difference on the right when you select the transaction.
  5. Click Add new expense for money spent; click Add new deposit for money received. A second table appears. (You might need to scroll down the page to see it.)
  6.  To add an adjustment, fill out the fields in the table.
  7. Click Save when done.

 

Additionally, I’ll be leaving you this article if you want to grasp knowledge checking if your accounts are balanced and accurate: Reconcile an account in QuickBooks Online.

 

Let me know if you have further inquiries about processing your transactions in QBO by hitting the Reply button. I’m just a post away.

Rainflurry
November 29, 2023

@LeeWhite12341 

 

"So is there a way to convert an Expense entry into a payment and apply it to an existing AP bill?  Or should I just delete the Expense entry and create a payment? "

 

Yes, you can change the expense entry to a payment.  Locate the transaction that was added and change the Category from the expense to A/P.  That changes the expense to a vendor credit.  Then, go to Pay bills and apply the credit to the bill.  

AlcaeusF
December 13, 2023

Hi, Rainflurry.

 

Thank you for always sharing your knowledge here in the Community. This will surely help other users as well in the future.

 

Stay safe and have a good one.