Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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:
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.
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?
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
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here