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 linked by bank account and selected a customer start date, but the 1st 2 months of transactions do not appear in QuickBooks. How can I rectify this? I have disconnected and reconnected but it hasn't made any difference. The odd thing is that the opening balance is correct - but how can I reconcile if I have 2 months missing?
I have spent ages searching help and am now completely stuck.
Thanks for bringing this matter to our attention and the detailed information about your banking concern, @millymolly. With this, I can guide you on the actions you need to help rectify your first 2 months of transactions and reconcile your account in QuickBooks Desktop (QBDT).
Before we start, you can also share with me the name of your bank or financial institution. This way, I can double-check our reports and provide you with the exact resolutions.
After you set up your accounts for Bank Feeds, you can start downloading transactions from your banks. Some will let you set a date range for downloads. If your bank doesn't have this option, you automatically get the maximum number of transactions available the first time you download. This may be 30, 60, 90 days, or more depending on the bank.
However, based on your description above, it seems that your first 2 months of transactions are already downloaded. This is because of your correct opening balance info. To avoid duplicates, I would encourage you to reach out to our Technical Support team. They can further investigate the cause of your missing transactions and guide you with a fix. Here's how:
Once all transactions are downloaded, review and match them to the existing entries in QuickBooks to keep your financial data updated.
Also, I'd recommend reconciling your accounts every month. This will help monitor your expense and income transactions and detect any possible errors accordingly. For the step-by-step guide, I'd recommend checking out this article: Reconcile an account in QuickBooks Desktop.
Please keep me posted in the comments if you have other banking concerns and questions about managing transactions in QBDT. I'm always ready to help. Take care, and I wish you continued success, @millymolly.
Thank you for your reply. I did a little further research and it would appear that quickbooks can only link the most recent 90 day period with my bank so the first 2 months I need to download manually. I have tried to do this and followed the tutorial. I thought I had sorted it, but it has download all entries as credits and not recognised what is a debit and what is a credit. How do I resolve this?
Thanks for getting back to us, @millymolly.
I want to help you bring your bank data with the proper details in QuickBooks Desktop.
First, I'd like to know if the downloaded entries as credits were the transactions you manually added by following these steps?
If so, make sure to review and use proper formatting. Here's an article you can read for more details: Import web connect (.qbo) files.
If those entries are coming from automatic updates, the information we receive is dependent upon what your bank or financial institution shares with us. With that, I recommend checking your bank website if there has been an ongoing issue about it.
Also, you can give us a call to further investigate this on our end. Still, you can follow the steps shared by my colleague Rea_M
I've also got an article that'll guide you in reconciling your accounts accurately: Reconcile an account in QuickBooks Desktop.
We're always here to help you anytime, millymolly. Keep safe and stay healthy!
Thanks for your reply.
Yes the transactions have been manually downloaded as its the only way to add them. The only way I could download the transactions was via a .csv as my bank doesn't offer the .qbo option. They are all shown accurately at my banks side so it is something in the .csv doc that isn't right. It is just very frustrating as I followed the instructions exactly as per the tutorial. I will try accessing the 'help' option suggested.
Thanks
You may need to utilize a converter tool as a workaround (i.e CSV2QBO)
https://www.moneythumb.com/?ref=110
or an importer tool
https://transactionpro.grsm.io/qbd
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.