Hello there, @sdppm.
I'm here to share some information on how you can manage your bank transactions after transferring data from QuickBooks Desktop (QBDT) to QuickBooks Online (QBO).
Once you connect your bank to online banking, QuickBooks will automatically download the latest transactions. It will suggest matching transactions that are already in QuickBooks, and all you need to do is approve the match if it's correct.
Here are the steps to match with an existing transaction:
For more details, please see this article: Match online bank transactions in QuickBooks Online
You can also manage your future transactions seamlessly with the guidance of this article: Categorize and match online bank transactions in QuickBooks Online
If you need to enter old transactions to update your financial data, please see this article for a step-by-step guide: Manually upload transactions into QuickBooks Online.
Please let me know if you have any other banking concerns or questions about managing transactions in QBO. I'm here to help.
I'm struggling with (what I think is) this same issue. I've migrated my data successfully from QB Desktop, and the start guide had me match a few of the transactions, and created rules to auto-match many of them. Ok, great. Except it seems like it's pulling a bunch of old transactions that were previously reconciled. My ending balance from when I exported from QB was correct when I first started, but now that I've connected my bank account it's waaaay off. Do I need to manually match every single old transaction? If I "close my books" for everything 2023 and prior will that make it stop pulling old transactions in? Should I just delete everything and start over without linking my bank?
Hello there, blatchford. I'm here to provide some help regarding this matter.
In QuickBooks Online, connecting your bank account will automatically download your transaction up until the recent transaction. Given that you already have a transaction in your company file in QuickBooks Desktop, it will likely create a duplication of transactions. To resolve this, you can Exclude the transactions that were reconciled first. If there are transactions that aren't reconciled, you can match them. Kindly follow the steps below:
If the transactions were reconciled:
If the transactions weren't reconciled:
Also, please know that closing your books will not stop downloading old transactions since this is not how bank feeds work in QBO.
In addition, regarding if you'll delete and start over, this will depend on the situation. If you see that it cannot be fixed anymore, you may consider restarting your company file again to QBO. However, please know that this will overwrite the current QBO data.
I'll leave these materials for you to see if you'd want to learn more about connecting your bank and credit card accounts to QuickBooks Online:
Afterward, you can reconcile an account in QuickBooks Online to balance your accounts so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.
If you have further questions, please leave a comment below and I'll be glad to help you out.
So if I'm migrating from desktop to online, it will duplicate every transaction that's not reconciled and I'll have to manually match them all? Is there no way to choose a start date for the bank imports?
So if I migrate from desktop to online, it will duplicate all of my transactions that aren't reconciled and I'll have to manually match them all? Is there no way to choose a start date for bank imports? I can't say I want to just start importing my bank feed as of 1/1/2025?
So if I'm migrating from desktop to online, it will duplicate all of my transactions that aren't already reconciled and I'll have to go through and match them all manually? Is there no way to choose a start date for bank imports, like have them start on 1/1/2025?
It will only duplicate if you made the same transactions and imported it twice—once from the desktop data and again from the bank feed in the online platform, Lila. All questions will be answered promptly below.
When you connect your bank account to QuickBooks Online, the system typically imports transactions from the last 90 days by default. QBO doesn't have an option to specify a start date for the initial bank feed download. It depends on what your bank allows.
You can explore this article: Move your QuickBooks Desktop file to QuickBooks Online. For more details about the process of migrating data in QBO.
For future reference on how to manage your transactions in QuickBooks, you can visit these articles:
Feel free to tag me in the comments below if you have any other questions about managing your transactions or migrating your data in QuickBooks. I will respond as quickly as I can.
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