Sudden change in Checking balance.

jpc437 · ‎November 02, 2022

I am a very rudimentary user of QB, I use it simply to track income and expense for apartment rentals . I do not use the reconciliation feature, I always track the checking balance against my bank account view (on-line) and am able to spot discrepancies... I'm sure there's abetter way to do this, but this has worked for me.

At least monthly I make sure the QB chart of accounts (rent checking) and the companion bank account are aligned, but without explanation I now have a $200 differential going back to the start of this year (and likely prior) - the QB balance is $200 less than the bank's. I can not find any income or expense entry that caused this. I don't believe I reconciled anything in error, as I never use that feature. Is there some other way I can troubleshoot this?

BigRedConsulting · ‎November 02, 2022

You can use the Audit Trail report to figure out what transactions were added or modified or deleted in the last few days / from the point you know it was right.

To run the report start on the QB menu at Reports | Accountant & Taxes | Audit Trail.

Set the date range at the top of the report to the last few days and then review transactions, looking for perhaps incorrect dates, like very old dates, and for transactions that have been recently deleted.

View solution in original post

BigRedConsulting · ‎November 02, 2022

You can use the Audit Trail report to figure out what transactions were added or modified or deleted in the last few days / from the point you know it was right.

To run the report start on the QB menu at Reports | Accountant & Taxes | Audit Trail.

Set the date range at the top of the report to the last few days and then review transactions, looking for perhaps incorrect dates, like very old dates, and for transactions that have been recently deleted.

jpc437 · ‎November 02, 2022

Very helpful! Using the Audit trail, I was able to see I had inadvertently changed a $200 transaction from last year, deducting that from my rental checking account. Thank you!

Topics

Training

Community

Resources

Sudden change in Checking balance.