I don't have the Accountant version and our CPA isn't currently available. My second-ever checking statement reconciliation in the online version has a different starting balance from our bank statement. (Statement balance is smaller than QBO balance.) In QB Desktop I would have simply undone May's reconciliation and started over.
The amount difference is exactly the amount paid to two different vendors every month, $166.67. Since I kept getting mixed up with matching the bank feed, having duplicate transactions after migration, and getting confused about cleared versus reconciled and why some checks are now expenses (which one of these $166.67 checks is now an expense), I think I probably marked one of these transactions uncleared, unreconciled, cleared, or reconciled in error or I may have even deleted a duplicate transaction in error. (I have a hard time understanding the Audit Log.) If I change a currently reconciled one of these $166.67 transactions to "C" or blank, it simply doubles the difference between May's ending balance and June's starting balance. Marking it back to "R" doesn't help. Any $166.67 transactions that are not marked "R" are correct; they are not to be reconciled yet. I have double-checked to make sure I haven't deleted one of these $166.67 transactions back through 2021. Both vendors have 12 payments each year. ($2,000 divided by 12 months equals $166.67)
When I go to the reconciliation screen in QBO and click the "we can help you fix it," the next screen lists only transactions "reconciled in register." None of these are the correct amount and I don't see any that added together equal $166.67.
Is there any way to correct this without having to undo the May reconciliation? Maybe with a Journal Entry or something?
Please help! This is holding up the financial reports my boss is waiting on!!
Thanks,
Lisa in The Lowcountry
