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

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.

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.
Solved
Best answer November 29, 2023

Best Answers
Rainflurry
Level 14

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.

@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.  

View solution in original post

7 Comments 7
Irene R
QuickBooks Team

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.

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
Level 14

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.

@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.  

FritzF
Moderator

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.

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.

LeeWhite12341
Level 1

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.

So your advice is to change the general ledger account (category) on the expenses transaction from an expense to the accounts payable account/category? 

Rainflurry
Level 14

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.

@LeeWhite12341 

 

"So your advice is to change the general ledger account (category) on the expenses transaction from an expense to the accounts payable account/category?"

 

Yes, because the expense should already be listed on the bill.  Changing the category on an Expense transaction to A/P creates a payment (debit A/P, credit bank account).  However, it will still be listed as an 'Expense' type transaction.  It's not an expense on your books anymore, that's just the type of transaction (like a deposit, check, etc.).  After changing the category to A/P, you still need to apply that payment to the bill.  Go to Pay bills (New > Pay bills) and you will have a credit.  Apply the credit to the bill and you're all set.  

 

CarolynTanner
Level 1

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.

I am following these instructions, but when I go to pay the bill with the money that should be in A/P, I can't find A/P as an option for the payment account, and there isn't any money in A/P on the balance sheet.  

AdonL
QuickBooks Team

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.

We're glad to have you here in the Community space, Carolyn. I'll provide details about changing the expense entry to a payment in QuickBooks Online (QBO).

 

If you've successfully edited an expense transaction to be a payment (posted to A/P), a credit amount will automatically appear under the Credit Applied column when you select the bill from the vendor. I suggest double-checking your entry to see these changes.

 

Once everything is sorted out, you can reconcile your bank account using our guide: Reconcile an account in QuickBooks Online. This guide includes steps to address balance issues and ways to modify completed reconciliations.

 

To help you customize your invoices and sales forms in QuickBooks Online, refer to this article:  Customize invoices, estimates, and sales receipts in QuickBooks Online. It provides detailed information on how to personalize your emails and customize them according to your needs.

 

I'll be available on this thread anytime you need additional assistance managing transactions in your account or anything else. Feel free to provide any details in the comments. Stay safe!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us