Bank reconciled as at 30/4/2022 with correct balance as per statement 1323.92 and no outstanding transactions. but balance on TB is 1932.87 at 30/4/2022?

yvonne-dunlop · ‎August 10, 2022

Angelyn_T · ‎August 16, 2022

I appreciate you for getting back, @yvonne-dunlop. I'll help you figure out the possible reasons for the discrepancy in your reconciliation and report.

Modified or edited entries can also affect your balances. For now, you can review your transactions within this period to narrow down the result. You can also compare the data from your trial balance report and your reconciliation to see the difference. If there are unwanted entries, you can delete them from your record.

To check for changes to your transactions, visit the Audit Log history.

Sign in master admin to your QuickBooks.
Go to the Gear icon, then select Audit log.
Use the fields on the page to choose the appropriate User, Date, or Events filter.

The audit log displays you 150 records at a time. You can tap on View in the History column to open the transaction's audit history. This tells you who made the change and what they did.

In case you need to make changes to your reconciliation, use these links as your reference:

If you have follow-up concerns with your balances, let me know by adding a comment below. I'm more than happy to help you again. Keep safe!

View solution in original post

GeorgiaC · ‎August 10, 2022

Hi Yvonne, thanks for your post :)

The TB is cumulative and will include all transactions, even unreconciled transactions from outside of the period ran in the report. To check for any that may be causing this discrepancy, please compare all transactions included in the TB transaction report for that bank against the bank reconciliation report. You can also check for any unreconciled transactions by navigating to the chart of account > select 'account history' beside the bank > filter > reconciled status > set to 'not reconciled' > apply.

yvonne-dunlop · ‎August 16, 2022

I've checked for outstanding transactions and there aren't any up to the date of the reconciliation at 30/4/2022

Angelyn_T · ‎August 16, 2022

I appreciate you for getting back, @yvonne-dunlop. I'll help you figure out the possible reasons for the discrepancy in your reconciliation and report.

Modified or edited entries can also affect your balances. For now, you can review your transactions within this period to narrow down the result. You can also compare the data from your trial balance report and your reconciliation to see the difference. If there are unwanted entries, you can delete them from your record.

To check for changes to your transactions, visit the Audit Log history.

Sign in master admin to your QuickBooks.
Go to the Gear icon, then select Audit log.
Use the fields on the page to choose the appropriate User, Date, or Events filter.

The audit log displays you 150 records at a time. You can tap on View in the History column to open the transaction's audit history. This tells you who made the change and what they did.

In case you need to make changes to your reconciliation, use these links as your reference:

If you have follow-up concerns with your balances, let me know by adding a comment below. I'm more than happy to help you again. Keep safe!

Topics

Training

Community

Resources

Bank reconciled as at 30/4/2022 with correct balance as per statement 1323.92 and no outstanding transactions. but balance on TB is 1932.87 at 30/4/2022?