Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
I am reconciling my January books and my quick books told me my balance is off. When viewing the reconciliation discrepancy report it appears the issue is with some transactions from October. In October I had some transactions accidentally get deleted and I had to manually re-enter them. I didn't have any issue reconciling October, November or December after that. When I view my report I see several transactions from October plus the ones that were deleted. Many more than what is on my bank statement. How do I tell if some transactions are doubled and how do I proceed to fix the discrepancy in the balance.
Let's review your transactions so that you can ensure your records are accurate, Sarah_HM.
Duplicate transactions can cause discrepancies when reconciling. To avoid this, you can review your transactions and look out for duplicates.
When you come across duplicate transactions in QuickBooks Online (QBO), you have two options to resolve them. You can either exclude them or delete them. If you choose to exclude a transaction, it won't show up again in the bank feeds. However, if you delete it, QBO will recognize it as missing and download it again. To avoid any reconciliation issues, I'd recommend that you exclude duplicates. Let me guide you on how to do this.
If you want to learn more about how to fix issues while reconciling, you can check out this article: Fix issues for accounts you've reconciled in the past in QuickBooks Online.
In case you ever need to undo a reconciliation, you can follow this guide: Undo or remove transactions from reconciliations in QuickBooks Online.
I'm here to help you, Sarah_HM. If you need more assistance with reconciliation, feel free to click the Reply button.
What is the best way to determine if the issues are caused by duplicate transactions?
Let's figure out a way to determine the issues caused by duplicated transactions, @Sarah_HM.
One way to determine issues caused by duplicated transactions is to review your Profit and Loss if income or expenses are inflated.
Here's how:
On the other hand, we can do a quick reconciliation review to see if the balances match the statement.
In addition, you may want to check this article to learn how to close your books and prevent changes to past transactions: Close your books in QuickBooks Online.
I'm always available if you need more help managing your duplicate transactions and any QuickBooks-related queries. Keep safe.
In viewing my reconciliation discrepancies report, I figured out the transactions that were entered twice and throwing off my reconciliation. How do I delete them?
I appreciate you for checking the discrepancies, @Sarah_HM.
To remove the duplicate transaction, open the Account register to find these transactions.
Here's how:
On the other hand, I recommend reaching your accounting professional to guide you in checking and correcting your balances. If you don't have one, you can find a professional through this link: Find an accountant.
I'm adding this article to guide you further in reviewing and correcting your balances: Fix issues for accounts you've reconciled in the past.
Keep us posted if you have other questions about reconciliation. We'll do our best to fix it promptly. Take care.
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