- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Under banking, what is included in the "In Quickbooks" total? I have reconciled my bank. There is a big difference in the "In Bank" and "In Quickbooks" amount.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
I'm thrilled to have you here, @info-urbansteelw.
Let me help you clear things up about the In Bank balance and QuickBooks Balance.
If your QuickBooks balance doesn't match your actual bank balance, several factors may cause this. Below are the lists of reasons:
- Outstanding transactions
- New transactions for a connected account
- Duplicate transactions
- Edited or deleted transactions
- Credit card (liability) account
Moreover, QuickBooks balance is affected by all your transactions in the register and the ones you haven't reviewed yet. While the bank balance is solely determined based on the transactions on the register.
Additionally, to help you manage your bank transactions, you can read these articles:
- Set up bank rules to categorise online banking transactions in QuickBooks Online.
- Categorise and match online bank transactions in QuickBooks Online.
Don't hesitate to post again here if you have other questions or concerns with QuickBooks tasks and navigations. I'm always around and happy to help. Take care and stay safe!
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Hello Bryan_M
Thank You for your reply! I appreciate your assistance.
Just to clarify please,
By "Outstanding Transactions", would this include transactions such as invoices due for payment?
Or where else would these transactions be found? As mentioned, my bank has been reconciled. So where do I find these missing transactions? The QB balance is higher than the bank balance.
TIA.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
I'm pleased to see you again, info-urbansteelw. I will provide further information regarding your concerns about the discrepancy between your Bank and In QuickBooks balances.
The "outstanding transactions" in QuickBooks refer to any financial transactions that have not yet been fully completed or reconciled. These include unpaid invoices, unreconciled bank transactions, and pending bills or expenses.
You can generate a quick report to locate the missing transactions that result in discrepancies between the two balances. I'll walk you through the steps:
- Navigate the Accounting tab at the left panel.
- Select Chart of accounts.
- Locate the account.
- Click the dropdown arrow beside View register and choose Run report.
- Tap Switch to classic view.
- Change the Report period to All dates.
- Click on Run report.
These guidelines will assist you in identifying the transactions that could cause a discrepancy between your bank balance and the balance in QuickBooks.
Additionally, I would like to share this article that offers guidance on verifying the accuracy of bank and QuickBooks balances and troubleshooting techniques for resolving account reconciliation problems.: Learn the reconcile workflow in QuickBooks.
I'm still available to back you up if you need further assistance with banking issues or any related concerns. Take care!