cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
mark212
Level 1

Can i imprt a vendors detail from Excel and match the transaction paid by my creidt card.the transaction is linked to QB

 
3 REPLIES 3
JonpriL
Moderator

Can i imprt a vendors detail from Excel and match the transaction paid by my creidt card.the transaction is linked to QB

Hello @mark212,

 

Before we can accomplish your task for today, can you tell me more of the help you need saying you need to import vendor detail? Are you creating a list of your vendors' names or a list of your vendor transaction for matching?

 

Hope to hear from you soon. Stay safe!

mark212
Level 1

Can i imprt a vendors detail from Excel and match the transaction paid by my creidt card.the transaction is linked to QB

I place  the detail invoice from a purchase into excel. I paid the invoice through credit card and it is linked to QB. How do a put the detail invoice as an attachment to the payment

 

MaryAnn_E
QuickBooks Team

Can i imprt a vendors detail from Excel and match the transaction paid by my creidt card.the transaction is linked to QB

Hi there, @ mark212.

 

You can create an expense attached to the Account payables. Once done record a bill payment then, link the expense to the bill payment to mark as paid.

 

You can easily record this bill payment in QuickBooks Online (QBO) by doing a few simple clicks. All you need to do is follow the easy steps below. 

 

 Note: Review this guide before recording the payment

 

If you paid for the bill with a credit card or cash

 

  1. Press the +New button on the left-hand menu bar. 
  2. Choose Pay Bills under the "Vendors" portion. 
  3. Pick the account you paid the bill through from the Payment Account drop-down. 
  4. You can enter the starting check no. if you chose a checking or savings account. 
  5. Enter the payment date
  6. Type in the amount you paid towards the bill in the Payment column. 
  7. Tap Schedule payments online to learn about available payment processing options. 

 

If you paid for the bill with a check

 

  1. Hit the +New button. 
  2. Select the Check option under the "Vendors" portion. 
  3. Pick the Vendor you paid from the Payee drop-down. 
  4. Press Add to add an open bill to the check. 
  5. Choose the account you made the check payment from the Bank account drop-down. 
  6. Enter the check amount. 
  7. When you're ready, click Save and new or Save and close

 

You're on the right track in clicking the Pay Bills option to record the supplier payments. However, QBO suggests possible matches if the transactions have the same date and amounts. That's why the system doesn't auto-match the payment (lump sum) to the bills you've created since they have different figures

 

. Thus, I recommend clicking the Find match button to select the transactions and manually resolve the differences. To learn more about this process, see this article: Categorising And Matching Bank Transactions

 

I'll be right here to help if you need further assistance. I'm cheering on your continued prosperity while using QBO.

Need to get in touch?

Contact us