cancel
Showing results for 
Search instead for 
Did you mean: 
ReymondO
Moderator

How do you mark a bill paid when you downloaded the payment from the bank feed?

Hey there, @Wambat3591.

 

Are you using the Online Bill Pay feature to pay your contractors in QuickBooks Desktop (QBDT)? If so, the option to pay multiple vendors using a single ACH transaction is unavailable in the program. For now, you can only select one vendor/contractor at a time once creating a payment

 

Additionally, after you accept your categorized bank transactions, the program will automatically add them to your account. To clear these transactions, let's follow these steps:

 

  1. Go to List and select Chart of Accounts.
  2. Look for the bank, then double-click it to open.
  3. Find the bank transactions that you've categorized. They will be marked as with a lightning strike under the Checked (/) column. 
  4. Click the mark, then you'll be prompted if you want it to be marked as cleared. Simply select Yes to change its status.
  5. Repeat the steps for the rest of the transactions you want to clear and close the window to exit.

lighting.PNG

Once you review and match your downloaded transactions, QuickBooks will separate them into 3 categories. Follow the steps in this article on how to categorize them: Add and match Bank Feed transactions in QBDT.

 

Let me know if you need further assistance with this. I'm always around to provide answers and clarifications to your questions. Have a great day ahead and take care.

Wambat3591
Level 1

How do you mark a bill paid when you downloaded the payment from the bank feed?

Thank you for the response.

 

I am not using the online function to initiate ACH transactions in the QuickBooks Desktop version.  I am initiating ACH transactions through my bank portal.  The transaction is present in the bank feed as a single transaction and I a trying to determine if I can clear multiple vendor bills that were paid with that one transaction.

 

Maybe I should switch over to the Online bill pay feature, but before I do, I need to figure out how to address the transactions I have already completed.

MichelleBh
Moderator

How do you mark a bill paid when you downloaded the payment from the bank feed?

Thanks for the prompt reply, @Wambat3591.

 

I appreciate you for providing extra information about your concern. I'm here to present steps on how to clear multiple vendor bills that are already paid with that one transaction. 

 

Let's match the transaction by going to the Banking menu, as my colleagues mentioned on the first page. After that, choose Bank Feeds, then pick Bank Feeds Center. From there, review the transactions in each category, and from the Action column, pick Match to Existing Transaction.

 

advanced mode.PNG

 

Ensure that you're in Advance mode. To check that, please refer to this sample screenshot below. 

 

 

If you wish to continue switching over to the Online bill pay feature, you can visit these articles for the frequently ask questions: 

 

 

I've also added some pages that might help you manage your contractor's transactions, categorize bank data, and other associated topics. 

 

 

If you have any other questions about bill pay, please feel free to add a comment below. I'm happy to serve you. Have a great day. 

StratImpact
Level 1

How do you mark a bill paid when you downloaded the payment from the bank feed?

When I select the action "Select bills to mark as paid" it opens up a window as several people have indicated. However, the screen is all messed up. When I select the vendor it does not actually show me any open bills (even though I have open bills) and then when I try to add I get the message "The total amount does not match the downloaded transaction amount!" I cannot get this function to work.

Catherine_B
QuickBooks Team

How do you mark a bill paid when you downloaded the payment from the bank feed?

I can help you manage your bank transactions, StratImpact.

 

We can try a few troubleshooting steps before we match your bank feed transaction to the open bill. To start, let's update QuickBooks to the latest release and then perform the Verify and Rebuild Data utility process. 

 

Then, match the transaction and ensure that the vendor name and amount are the same so the system can recognize a match. However, if the same thing happens though you have verified that both transactions match, we can try to repair QuickBooks

 

Meantime, you can exclude the transaction and manually pay the bill. Doing this avoids creating duplicates. 

 

Feel free to mention me if there's anything else that you need help with. Take care and stay safe!

sachinmathur
Level 1

How do you mark a bill paid when you downloaded the payment from the bank feed?

Hello, I have the same issue but am unable to use the match transaction feature in QB desktop 2019. My situation is that I paid multiple vendors through a single ACH transaction ($11K) through my bank. The transaction came in the bank feed, which I would like to apply to four vendor payments (in effect apply the $11K to four transactions to four vendors. I have four unpaid bills and one unmatched ACH transaction in my bank feed. 

- $3.3K to Vendor 1 (against their invoice)

- $1.7K to Vendor 2

- $5K to Vendor 3

- $1K to Vendor 4

 

How can I properly record this in QB such that all four bills show paid, and the bank feed transaction gets added correctly? Should I be doing a journal entry or does QB have a function I should use.

 

Thank you.

Sachin

MariaSoledadG
QuickBooks Team

How do you mark a bill paid when you downloaded the payment from the bank feed?

Let's make sure that you'll be able to record all your bank transactions correctly, sachinmathur.

 

For now, matching a single downloaded transaction to multiple vendor transactions isn't possible. You'll want to exclude the bank feeds transactions by clicking the Ignore button which is highlighted in green color. I've added a screenshot for your visual guide:

 

 

Then, manually pay the bills in Quickbooks Desktop. I've added this article for the steps: Pay Bills In QuickBooks Desktop. Additionally, you may need to review your accounts in QuickBooks to make sure they match your real-life bank and credit card statements. Please check this article for your reference: Reconcile An Account In QuickBooks Desktop.

 

Fill me in if you have further questions about matching transactions. Remember, the Community is always here 24/7.

sachinmathur
Level 1

How do you mark a bill paid when you downloaded the payment from the bank feed?

Thank you, @MariaSoledadG . Your response is very helpful.

TSOSNJ
Level 3

How do you mark a bill paid when you downloaded the payment from the bank feed?

Thank you!!!

I cannot believe how difficult it was to find this. Every single answer was for QB Online even though I added desktop to my question. 

MichelleBh
Moderator

How do you mark a bill paid when you downloaded the payment from the bank feed?

You're most welcome, @TSOSNJ.

 

I'm so happy that you see this post and help fix your problem. You can also visit our Banking FAQs for your future reference.  

 

If you have any questions about banking, don't hesitate to drop me a line. I'd be happy to offer you some advice, and I'll be here should you need anything.

jmredondo
Level 1

How do you mark a bill paid when you downloaded the payment from the bank feed?


@JamesDuanT wrote:

Thanks for joining in on the thread, LTambo.

 

We can no longer apply a bank transaction as bill payment if you have already Added it to your register. We still need to remove it from your register and then, Match to the bill payment.

 

To remove the added bank transaction, you can follow these steps:

  1. Click Banking at the top menu and select Bank Feeds > Bank Feeds Center.
  2. Select the connect bank account and click Transaction List.
  3. Click the ADDED/APPROVED colored bar.
  4. Look for the added transaction and click Delete.
  5. Select Yes to confirm the action.

After that, you can go back to the Bank Feeds to match the bank transaction to the partial bill payment you've made in QuickBooks Desktop. You can use this link for reference: Add and match Bank Feed transactions in QuickBooks Desktop.

 

If you haven't created a partial bill payment within QuickBooks Desktop, I'd recommend creating one so you can match it to the bank transaction. You can use this link for reference: Pay bills in QuickBooks Desktop.

 

Keep us posted so we can further assist you in managing your bills.

 

 


Hi! I found out that payments for Bills were not applied after I did the Bank Reconciliation. So I have to Undo the Bank reconciliation, before I can Delete the Added/Approved ? 

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

Need to get in touch?

Contact us