Skip to main content
mark212
January 10, 2021
Question

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

  • January 10, 2021
  • 3 replies
  • 0 views
Original commenter did not share additional details

3 replies

JonpriL
January 11, 2021

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!

mark212Author
January 12, 2021

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
January 12, 2021

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.

Terms & ConditionsAccessibility statement