Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi, there!
I'm going back through years of old transactions to reconcile them and clean up our bookkeeping. About halfway through April 2019, all of the transactions that appear in my bank statements do not appear on the register and I cannot reconcile.
Quickbooks says it is synced with my bank and the current amount in the account matches but it is clear that Quickbooks did not download many transactions over the last few years.
What do I do? Do I need to manually enter every missing transaction? At this point, it makes me wonder why I even have Quickbooks because I feel like I could do all of this much easier with an Excel spreadsheet.
Thanks!
Yes, you can manually add your older transactions in Quickbooks Online, @CBMedia. I’m here to walk you through the process and ensure you can reconcile them successfully.
When you connect your bank into QuickBooks, the system downloads up to the last 90 days of transactions. Since you need to fetch older items for your online banking, you have the option to upload them manually.
First, let's download the old transactions from your bank's website. Then, map the transactions in the following supported formats or file types. To guide you further, please follow these steps:
Once done, upload them to your QBO account. Here are things to follow:
Here are the sample screenshots for additional reference:
I've attached here an article to guide you with the process: How to upload more than 90 days of bank transactions?
I'd like to include these resources that provides more details on how to handle the imported transactions in QuickBooks Online:
Please let me know how it goes. I'll be here to help if you have other questions about your bank statements. Have a good one.
Another option, utilize MT Online as a workaround. It is designed to import into any bank or credit card in QuickBooks Online, so there is no specific setting needed.
https://www.moneythumb.com/?ref=110
Thank you, thank you! I'm going to try this in the morning.
I'm struggling with this a little bit because Quickbooks has been connected to my bank since before the missing transactions. So, there are some transactions from the period in question in Quickbooks but not ALL of them. I'm worried about ending up with duplicate transactions. Is there a way to avoid that if I manually upload? Thank you again!
Utilize the trial version of a backup restore app to lower any risk.
https://rewindio.grsm.io/quickbooks
Then you should be able to filter what you are about to import to avoid duplication.
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