Online Banking does it for you, user51506.
QuickBooks has the Online Banking feature that allows us to connect a bank or credit card account into QuickBooks. We'll have to do it on the computer or mobile web first, and once connected we automatically sync any information in your mobile app.
I'll show you how to connect:
Downloaded transaction are from as far as 24 months. From there, we can assign, add, or match transansaction. If the credit card account is not on the list, we can manually upload then from a CSV file.
You can check out this article on how to record customer payments.
Let me know if you need anything else. Thanks!