Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI'm fairly new to QBO, so this might be a dumb-ish question. I'm reconciling a bank account -- which we do have connected to our QBO -- and there are checks and deposits on the bank statement that aren't listed for that month in QBO. Thus, the balance is off by a couple thousand dollars. What's typically the best way to handle this?
Welcome to the Community, @MF26! I can help you in entering your missing bank transactions into QuickBooks Online.
Once the file is ready, here's how to upload it into the program:
However, if they are missing data from the current period or month, let's update your connection to obtain your available transactions. Alternatively, we can manually enter them to your bank register.
After completing your transactions, refer to these articles to reconcile your bank account:
Please feel free to reach out if you have other concerns about missing bank transactions. I'm always here to help. Have a great day!
Thanks for the info. So even if our bank account is syncing with Quickbooks, we need to do this any time there are missing transactions? Wouldn't this cause double posting for the transactions that did sync? Thanks again.
Thanks for getting back to us, @MF26.
Let me chime in and share additional information about entering missing bank transactions in QBO.
With regard to your question, it's not necessary that you'll need to manually upload CSV transactions to QuickBooks every time there are missing transactions. You can manually enter it in QBO and match it.
Manually uploading transactions can potentially cause double posting if the transactions that were already synced through automatic syncing are uploaded again. To avoid this, we can review the transactions that were manually uploaded and ensure that they haven't already been recorded in QuickBooks.
Additionally, I've added this article to manage bank transactions in QBO: Categorize and match online bank transactions in QuickBooks Online.
I encourage you to reconcile your accounts in QBO regularly. This helps monitor your income and expense transactions and detect possible errors accordingly. You can also check out this article to guide you in reconciliations in QBO: Learn the reconciliation workflow in QuickBooks.
Know that I'm here whenever you need more help handling these transactions. I'll do my best to help you. Stay safe.
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