Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have recently started with QB online and successfully connected all my accounts but capital one credit card. It seems it's history is limited to 90 days (I suspect it's the limitation of the interface, as I can see all history in capital one app)
How do I import the rest?
Thanks
If you can download *.qbo files from your bank, you can import past transactions into your QBO account. Another option, use MT Online or one of the converter tools (e.g csv2qbo).
https://www.moneythumb.com/?ref=110
I appreciate you for visiting the Community, Paul. I'm here to help you import your transactions from your Capital One Credit Card to QuickBooks Online (QBO).
Yes, you're right. As QuickBooks automatically downloads the latest available transactions, we can't download your bank transactions from Capital One Credit Card for the past 90 days.
For the time being, we can manually upload your transactions to QBO after downloading them from your bank.
To enable us to enter older transactions into QuickBooks, let us first ensure we have the downloaded .qbo or CSV file data of your transactions from your financial institution. You may visit your bank's website for this.
Once you've reviewed the downloaded transactions, let's manually upload them to QBO. Here's how:
For further information about manually importing your transactions, refer to this article: Manually upload transactions into QuickBooks.
Moreover, you check out these helpful resources that you can use in the future:
By doing so, you'll receive instructions on resolving any errors you encounter when downloading transactions and ensure that they match up after uploading.
You're always welcome to get back to us if you have any additional queries about importing transactions to QBO. I'd be more than willing to assist you. Keep safe!
Thanks for following up with the Community, proreo. I'm happy to hear FateCandylaneT was able to help with manually uploading transactions and provide some additional useful information.
You're correct, any limitations on how far back you can download transactions come from your financial institution. Some banks will let you download an account's last 90 days of transactions, while others can go as far back as 24 months.
I've also included a detailed resource about working with bank feeds which may come in handy moving forward: Connect bank & credit card accounts
I'll be here to help if there's any additional questions. Have a lovely day!
Capital One apparently has QBO export functionality and can do it up to 25 month back.
Will QuickBooks recognize if I import the same transaction twice (i.e. imported automatically and then from the QBO file)?
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