QB Premier - Cash Statement

Hi there,

Reconciling accounts is vital for making sure your books are correct. I'd be happy to assist you with making sure you're able to reconcile your accounts. 

There several reasons that can cause your balances not to match up. Here are a few:

• Previously cleared and reconciled transactions were voided, deleted, or modified.
• The file was converted from a different version of QuickBooks.
• Possible data damage

To find the transactions causing the discrepancy, run any of these reports:

Reconcile Discrepancy report

1. Go to the Reports menu, then select Banking, then Reconciliation Discrepancy.
2. Choose the appropriate Account, then select OK. You now have a list of transactions that were changed since the last reconciliation. Use this report to identify the transaction/s causing the issue.
3. If you find a discrepancy, note the transaction date and the Entered/Last Modified, which will tell you when the change occurred.

Audit Trail report

1. Go to the Reports menu, then select Banking, then Previous Reconciliation.
2. Select the appropriate account being reconciled.
3. Select the most recent statement date. Choose Transactions cleared at the time of reconciliation. (Report is displayed as a PDF file) then Display.
4. Note the statement and the reconciliation creation date.
5. Go to the Reports menu, then select Accountant & Taxes, then Audit Trail.
6. Set the Account filter to the account being reconciled.
   1. Select Customize Report.
   2. Go to the Filters tab, then choose Account from the filters.
   3. From the Account drop-down, select the appropriate account.
7. Go to the Display tab. Set the Date filter with the From field blank and the To date set to the statement date.
8. Select OK.
9. Set the Entered/Modified filter with the From date set to the previous reconciliation creation date from the PDF, and the To field as today's date.
10. See if any of the transactions in the report can account for the discrepancy.

Previous Reconciliation report

Note: If you are using QuickBooks Desktop Pro, you can only access the last reconciliation report. To keep a copy of the other reports, you can save a PDF copy on your hard drive. See view previous bank reconciliation reports to learn more.

1. Go to the Reports menu, then select Banking, then Previous Reconciliation.
2. Select the appropriate Account and Statement Ending Date. Select Display.
3. Compare this report to past statements from your financial institution.

For more information on this, I encourage you to check out this helpful article here: Fix beginning balance issues in QuickBooks Desktop. 

Give this a try and if you're still having issues, I recommend contacting our support team using this link.