cancel
Showing results for 
Search instead for 
Did you mean: 
teamchambie
Level 3

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

How do you mark a bill from a vendor paid when you downloaded the payment from the bank feed?  I have put the bill in the system, but I need to match the two up.  I've looked everywhere to figure it out but I can't find an answer for Desktop.  Thanks.

35 Comments 35
Anonymous
Not applicable

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

You can't download a Payment from a bank feed. At that time it's a deposit.

Instead, record payments when you get them, and the record the deposits when you make them.  Then match them up when you download from the bank.

teamchambie
Level 3

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

Sorry....this is in the wrong category...It should've been posted in the vendor bills section.  Can this whole post be moved or taken down?

qbteachmt
Level 15

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

@teamchambie

 

In banking feeds, on each transaction row, go to the far Right. Use the dropdown for Add More Details. Then, in the next screen, you see the tab for Bills and here you can match that this is a bill payment.

 

Remember that you don't always need to enter Bills first. If this is, for instance, a recurring payment on the credit card, just use Banking menu > Enter Credit Card Charge and Memorize it. Let the program enter it automatically and monthly, for example.

 

If that is a Check or paperless ACH or EFT or debit card, that is Banking menu > Write Check. Then the Banking finds the exact match, already. You don't need to use Bills first, unless you are an accrual basis entity and the date of the bill is not when it got paid, or when you got inventory.

teamchambie
Level 3

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

Nope none of those....

 

First off..."In banking feeds, on each transaction row, go to the far Right. Use the dropdown for Add More Details. Then, in the next screen, you see the tab for Bills and here you can match that this is a bill payment" doesn't work for me...ever.  I would love to use this feature.

Since that doesn't work and I don't have a lot of time when I enter my transactions, I just enter it without matching it to the bill.

So now, I'm left with an outstanding bill.  How can I go back into the bill and mark it as paid and match it to the correct payment? 

qbteachmt
Level 15

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

Honestly, if you are going to do this: "I just enter it without matching it to the bill."

 

You just Doubled the Expense. Instead, as I noted: you took the time to use Enter Bill; Instead, Banking menu > Write Check. Now the Banking would have already Matched to the existing entry and you would not have had to do Any More work. I open the Banking, it matches 35 entries automatically, nothing is marked for review, and I am Done in 5 seconds.

 

Instead, you now have 4 steps:

1. Enter the bill.

2. Get the banking and Add as if that is a New Transaction.

3. Edit the transaction and change the Expenses entry to AP for that vendor.

4. Open Pay bills to apply the credit to the bill.

 

I was pointing out that you don't have to work this hard. Sure, a bookkeeper that is paid by the hour might use unscrupulous additional steps to take more time doing the work. Most business people doing their own bookkeeping would rather be doing things that generate revenue or move the business forward.

 

And you are right about this: "First off..."In banking feeds, on each transaction row, go to the far Right. Use the dropdown for Add More Details."

 

Because I just checked and the Option for a CHK is "Select Bills to Mark as Paid." You would use Match to Existing Transaction if the CHK in banking download need to be matched to the bill Payment Check you already made in QB. I was thinking of the function I use every month, which is "Add More Details" for the one large ACH download that I need to match to 41 customer Invoices.

 

And you didn't tell us, but the assumption that this is QB US, and the Banking Feeds Mode is set to Express, not Classic. Please see my attachment.

Pgaff
Level 1

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

That's not right.  Payments made by monthly bank drafts will come through the bank feed, they are not deposits.  The question is how to match the bank drafts to bills that are entered.  

HoneyLynn_G
QuickBooks Team

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

Hi there, teamchambie.

 

Allow me to join this conversation and help you match the bank draft to your bill entered in QuickBooks Desktop.

  1. Go to your Bank Feeds page.
  2. Put a check mark on the transaction.
  3. Go to the Action column.
  4. Choose Select Bills to Mark as Paid.
  5. Enter the appropriate information.
  6. Select Add to QuickBooks.

For in-depth information, please check this article: Add and match Bank Feed transactions.

 

Let me know if there's anything else you need or you have follow-up questions about bills. Wishing you all the best!

qbteachmt
Level 15

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

@Pgaff 

 

Which part is Wrong? In desktop, in the Banking Center, where you see the transactions that Need Review, far Right, for the transaction type CHK that you Checkmark as what you want to work on, you see the option is worded:

Select Bills to Mark as Paid

 

That gives you the pop up for you to select Vendor, and you see their Open Bills. That is how you Link them.

Pgaff
Level 1

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

I was responding to BRC response.  Unfortunately when I hit reply it put it at the bottom of the feed not after his response.  Sorry for the confusion.  

Anonymous
Not applicable

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

@Pgaff 

RE: That's not right. Payments made by monthly bank drafts will come through the bank feed, they are not deposits. The question is how to match the bank drafts to bills that are entered. 

 

Sorry. I got turned around and thought you were asking about AR and customer payments.

 

For AP it's a similar issue.  You can't download a check/payment from the bank and record it as a Bill Payment. Instead, record the Bill Payment transactions using Pay Bills when you initiate them, and then when you download them from your bank, they'll match based on date and amount.

teamchambie
Level 3

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

Hi,

 

It's been a while, but this issue doesn't happen that often, but it just did.  Please see my photo below.  When I try to check these invoices to mark as paid, it will NOT let me.

Thanks.QB Issue.png

AlcaeusF
Moderator

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

Hello teamchambie,

 

Let's perform some basic troubleshooting to determine what's causing the issue to happen when marking them as paid. You can start with running the Verify and Rebuild Data Utility to identify and self-resolve most data issues.

 

Here's how to Verify Data:

 

  1. Click the Help tab at the top menu bar.
  2. Click Utilities.
  3. Click Verify Data.

To Rebuild:

 

  1. Click the Help tab at the top menu bar.
  2. Click Utilities.
  3. Click Rebuild Data.

For additional information on this, please see the following article:

 

Verify and Rebuild Data in QuickBooks Desktop.

 

If the steps above don't work, you can try repairing the QuickBooks program this time. The steps are outlined in the screenshot I'm adding down below:

 

 

Please feel free to let me know how the troubleshooting goes. If you should have any questions, I'm just a click away. 

teamchambie
Level 3

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

How do I post a question in the community?  You guys need a button on the home page that says post question here.  I spend a half hour figuring this out every time and this time I'm too tired to keep searching.  Thanks.

ShiellaGraceA
QuickBooks Team

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

Hello teamchambie,

 

We can post questions in the Community forum by starting a discussion. Let me guide you how.

  1. Go to https://quickbooks.intuit.com/learn-support/.
  2. Click the Community drop-down, and select QuickBooks Q&A.
  3. Choose a topic from boxes of which you need help with.
  4. Click the Start a discussion button.
  5. Enter a title or overview of your concern and Details.
  6. Click Post.

I've added some screenshots for you.

 

You can also visit our page about troubleshooting issues and errors if you need some help articles for your future tasks.

 

Please know that you're always welcome to post anytime if you need help with anything else.

 

 

 

lgc-rcw
Level 1

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

I entered a vendor invoice in QB. Then I paid that invoice online through the vendor's website using my bank checking acct routing & acct #. How do I mark that invoice in QB as paid? Thanks!

Jen_D
Moderator

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

Glad to have you here, @lgc-rcw,

 

For payments processed outside the program, simply apply a Bill Payment transaction towards the vendor bill to mark it as paid. Here's how:

 

  1. From the top toolbar, select Vendors then pick Pay Bills.
  2. Choose which Bill you want to pay from the list of open transactions.
  3. Enter all necessary information before clicking Save & Close.

To learn more about paying bills in QuickBooks Desktop, see this article: Pay bills in QuickBooks Desktop.

 

Let me know if you need further assistance about this. I'm always here to provide additional insights and help. Have a lovely day!

 

teamchambie
Level 3

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

It's me again!  I am still having issues with marking a bill as paid....I don't think that I should have to do the rebuild, etc....these functions should just WORK!  Please see my attached file to show what I am talking about. Honestly, again, I can't believe how many issues I have with QB but I am stuck with it.  Can someone give me a SIMPLE explanation on why this is happening?  My invoice is clearly in there, but I can't mark it as paid!

JonpriL
Moderator

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

Hello @teamchambie,

 

You'll have to click Select Bills to Mark as Paid instead of the Match to Existing Transaction option. This way, you can add your downloaded credit card transaction as the bill payment.

  1. Go to Banking then Bank Feeds.
  2. Click Bank Feeds Center.
  3. Under BANK ACCOUNTS, select your credit card account.
  4. Select Transaction List.
  5. Find your downloaded credit card transaction.
  6. On the ACTION column, select the drop-down menu.
  7. Click Select Bills to Mark as Paid.
  8. Under Vendor, choose Economy Rentals.
  9. Select your existing bill.
  10. Click Add to QuickBooks.

Here's an article you can read to learn more about marking a bill as paid with a downloaded transaction: Add and match Bank Feed transactions in QuickBooks Desktop.

 

You can also read this helpful article in case you wanted to start reconciling your credit card: Reconcile an account in QuickBooks Desktop.

 

Feel free to visit us anytime if you have other questions or if you need help with QuickBooks. Always around to help.

Maleeya_TheBookkeper
Level 1

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

Not sure if this has been resolved but what I did is this - (after download)

link the payment  to the vendor

locate the check in the vendor center (open it up)

on the expenses tab use the account and use your a/p account

where customer job would be it will say vendor instead, use the vendor (this will change into "credit" sorta)

save it.

go to the bill

select pay bill

then use the credit available.

LTambo
Level 1

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

I am curious if this was ever resolved, as I am dealing with the same issue.

Entered a bill, made a partial EFT payment on the bill. Payment came into bankfeed and I have already received it into the register without matching it up (didn't know I could do that)

How do I apply the payment so I can see what I still owe?

JamesDuanT
Moderator

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

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.

 

 

LTambo
Level 1

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

Thank you for the information, I don't see added/approved on the transaction list.  Can you send me a picture of where it is located?   Also, I have already received the payment in the check register, should I start there and delete it/void it?   Second question, if I know an EFT is paid can I post this payment through bill pay?  I only see options to pay via check or credit card not EFT.

Thanks so much I really appreciate your help.

ZackE
Moderator

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

Thanks for following up with the Community about this, LTambo.
 

Once you've reached your Bank Feeds Center, you'll want to find the Items Reviewed area. From there, you can choose an account to work with.
 

Here's how:

  1. Pick an account.
  2. Click Items to Delete.
  3. Tick the transaction(s) you'd like to remove.
  4. Press Delete Selected, then select Yes.


Now your transaction will be removed from the register and you can match it with its appropriate bill payment. Detailed steps for matching transactions can be found in JamesDuanT's post. As for posting bill payments, they'll be automatically recorded since you're using our Bank Feeds feature. They can be matched once they're downloaded.
 

You'll also be able to find many useful resources about using QuickBooks in our help article archives.
 

I'll be here to assist if there's any additional questions. Have a wonderful day!

Wambat3591
Level 1

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

 

Situation:  Paying multiple contractors monthly using a single ACH transaction and want to clear the bank transaction.

Need to get in touch?

Contact us