Hi, I am having a bit of a problem with reconciliation.
Recently, I realized there are 2 uncleared transactions(deposits) that were overstating/understating the QB bank balance, which made my report inaccurate. The thing is these 2 uncleared transactions are from last year (2022) and are duplicates of transactions that have been reconciled. It only showed up as uncleared in the reconciliation report for the month of March 2023. I didn't realize it would be a problem until it is.
I searched many sources from the community and found that since the uncleared deposits cannot be voided, it could only be deleted from the bank registry. Since it was an uncleared transaction, I thought it was fine to delete it, however, when I delete the 2 uncleared transactions. It actually messed up with my reconciliation, stating that I had a difference of RM1620 (810 +810). This is when things get weird, when I deleted the duplicate transaction, it actually deleted the correct transaction that has been reconciled as well. Almost like it was linked. I checked the categorized banking feeds and find that there were no duplicates of the transaction that has been added. The duplicates only show up when I try to reconcile.
Then I tried to change the amount of the duplicate (RM810) to 0, to test my theory of the duplicate being linked to the original transaction, and yes, my theory was correct. When I changed the uncleared amount, it made a difference of RM810. I honestly have no idea if the duplicate transaction is a glitch or not.
Below is a screenshot of the uncleared transaction with the reconciled one (the correct one). The duplicate one is a deposit but it is on the payment column for some reason.How do I solve this?
Solved! Go to Solution.
It looks to me like the bank account was used in the detail area of the deposit, creating both a debit and a credit for the same bank account.
To determine if that is the case, edit the deposit and note the detail account. If it's the bank account, change that to something appropriate like an income account.
It looks to me like the bank account was used in the detail area of the deposit, creating both a debit and a credit for the same bank account.
To determine if that is the case, edit the deposit and note the detail account. If it's the bank account, change that to something appropriate like an income account.
Thank you so much, you were right. You really helped me so much. But now another problem is that the 2022 account has already been audited, I can't just change it
Simplify payday and set payroll to run automatically in QuickBooks.
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
These cookies are strictly necessary to provide you with the services and features available through our site. Because these cookies are strictly necessary to deliver the site, you cannot refuse them without impacting how the site functions.
These cookies are used to make advertising messages more relevant to you and your interests. They also perform functions like preventing the same ad from continuously reappearing, ensuring that ads are properly displayed, and in some cases selecting advertisements that are based on your interests.