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

Reconcile Credit Card Transactions with Bills/Invoice Numbers

I use my credit card to fulfill the payment for invoices/bills already uploaded in QB Enterprise. I upload my credit card transactions through the Batch Enter Transactions feature. There is no way for me to assign an invoice number to specific credit card transactions to know the bill/invoice was paid. 

My only workaround is not uploading the transactions used to pay bills and manually marking the bill as paid. However, that throws off my reconciliation with the credit card payment. 

 

Is there a best way to reconcile credit card transactions when they are used to fulfill payments for invoices/bills already in QB?

3 Comments 3
katherinejoyceO
QuickBooks Team

Reconcile Credit Card Transactions with Bills/Invoice Numbers

Hello there, @CasperTheG

 

Thanks for sharing your reconciliation concerns here in the Community today. 

 

When you connect your bank and credit card account or manually download your bank transactions in QuickBooks, you'll need to review and match the transactions. Here's how: 

 

  1. Go to the Banking menu.
  2. Select Bank Feeds, then select Bank Feeds Center
  3. Review the transactions in each category.

 

Depending on the banking mode you’re using the steps will be different to recognize them. Check out this article to learn more: Add and match Bank Feed transactions in QuickBooks Desktop.

 

I've got you a guide to help you in balancing your bank statements with your transactions in QuickBooks to make sure they're added to your books. Read through this article for more insights: Learn the reconcile workflow in QuickBooks

 

Get back to me if you have additional questions. I'm always around to be your QuickBooks guide. 

 

 

CasperTheG
Level 1

Reconcile Credit Card Transactions with Bills/Invoice Numbers

I upload my credit card statement through batch enter transactions so they come in categorized and ready to go. It doesn't seem like there is a way to tie an individual credit card transaction to an invoice in QB Enterprise as the fulfillment method. 

It appears I have 2 options:

1. Mark the invoices as paid manually. However, this would make it look like I am paying invoices twice because the invoices are mark as paid and the credit card transactions would include the payment. 

2. Specifically don't upload the credit card transactions that were used to fulfill invoices in QB. Then when I reconcile my bank drafts, I would reconcile part of the credit card payment to invoices and the remaining portion to the actual credit card account. 

Am I thinking about this correctly?


JoesemM
Moderator

Reconcile Credit Card Transactions with Bills/Invoice Numbers

Thanks for the prompt reply, @CasperTheG. I appreciate you for sharing detailed information about your concern.

 

Since you upload your credit card statement through batch enter transaction, QuickBooks automatically puts them into Undeposited Funds. Though, you can follow option 1 that you've shared so you can post the payments to Undeposited Funds. 

 

Here's how to enter a payment from a customer

 

  1. From the Customers menu, select Receive Payment.
  2. In the Received From the drop-down, select the customer's name.
  3. Enter the Amount received.
  4. Make sure the date is correct, then choose the payment method.
  5. Select the invoice or invoices you'd like to pay.
  6. Click Save & Close.

 

For detailed steps, see this article: Deposit payments into the Undeposited Funds account in QuickBooks Desktop.

 

Once done, you can record a bank deposit and combine the payments in QuickBooks. All payments in the Undeposited Funds account automatically appear in the Bank Deposit window.

 

You can also refer to this article to know more about how bank feeds work in QuickBooks Desktop: Get started with Bank Feeds for QuickBooks Desktop. This will provide you links on how to manage your transactions as well as steps to edit your bank account.

 

Stay in touch if you have any follow-up questions about managing transactions. Just add a comment by clicking the Reply button below. I'm always around to help you out. Have a good one.

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

Need to get in touch?

Contact us