cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit

Find reconciliation discrepancies (Mac)

Your beginning balance will be incorrect if a previously cleared transaction in your register was voided, deleted, or changed, or a new transaction was added and cleared since your last reconciliation.

To resolve this issue, trace the account activity since the last reconciliation until you find the discrepancy. Running these reports can help:

Reconciliation Discrepancy report

QuickBooks Desktop for Mac 2019 has a Reconciliation Discrepancy Report to help you identify reconciled transactions that were modified, deleted, or voided.

  1. From the Reports menu, select Banking > Reconciliation Discrepancy Report.
  2. Choose the appropriate account, then select OK.
  3. Review the report to identify any discrepancies.

Previous Reconciliation report

Step 1: Open the Previous Reconciliation Detail reports

  1. From the Reports menu, go to Banking > Previous Reconciliation.
  2. On the "Reconciliation Reports Options" window:User-added image
    1. From the Account drop-down, choose the appropriate bank or credit card account.
    2. Under Type of Report, choose the Detail radio button.
    3. Choose the statement ending date.
    4. Under In this report, include: section, choose:
      • Transactions cleared at time of reconciliation, then select Ok. The Report in the PDF format showing actual cleared balance when the account was reconciled will be displayed.
      • Transactions cleared plus any changes made to those transactions since the reconciliation, then select Ok. The Report with all the changes made in the account after the reconciliation will be displayed.
    5. Have both reports on your screen so you can check and compare balances and determine the last correct reconciled transaction.

Step 2: Identify the transactions that were un-reconciled and manually calculate the difference

If a transaction is modified, it gets un-reconciled. You need to identify these transactions so you can easily calculate the difference on your ending balance and correct it.

  1. Check the transactions line by line to see which was added, modified or deleted.
  2. If the report shows that a cleared transaction was deleted, verify if it was already reentered. If not, recreate the transaction.
  3. Calculate the difference in the ending balance on the two reports. Take note of the difference. You will use it when you perform special reconciliation.ExampleUser-added image
    • The PDF report showing transactions cleared at the time of reconciliation has an ending balance of $169, 330.43.
    • The report showing changes made after reconciliation has an ending balance of $168, 463.71. Note that three transactions (a liability check for $2,739.84 and deposits for $426.56 and $3,180.00) do not show on this report which means they got modified and un-reconciled after they were cleared.
    • If you’ll do the Math, the total amount of the three transactions is equal to the amount of the ending balance difference in the two reports: $866.72.

Bank Account QuickReport

The report should help you look for recent transactions that may have been cleared or uncleared unintentionally:

  1. From the Lists menu, select Chart of Accounts.
  2. Select the affected account.
  3. Go to the Reports menu and select QuickReport.
  4. Select Customize Report.
  5. In the Columns list on the Display tab, put a check on Clr then OK.
  6. Compare transactions on the report with the status in the Clr column to identify transactions that are cleared and should not have been or vice versa. If you find one:
    1. From the Lists menu, select Chart of Accounts.
    2. Double-click the affected account to open the register.
    3. Find the transaction in the register and  the field labeled with a checkmark to clear or unclear the transaction.
    4. Select Record.
    5. Repeat steps 6.a to 6.d to clear or unclear other transactions.

Audit Trail report

  1. From the Reports menu, select Accountant & Taxes > Audit Trail.
  2. Review the report to identify deleted transactions, transaction amounts that were changed, or transactions that were added since the last reconciliation that may be affecting the opening balance on the account.

If opening balance is incorrect because previously reconciled transactions were un-reconciled after you converted from QuickBooks for Windows or vice versa, you can do a lump sum reconciliation as a workaround.

If the opening balance has reverted to zero and the file was not sent back and forth between Windows and Mac, you can:

Found a discrepancy?
  • Once you identify a discrepancy, you need to make the necessary corrections. If you need assistance on how to make these corrections, please consult your accountant.
  • If you modified previously reconciled transactions or have new transaction to add to the reconciliation period, you may need to perform a special reconciliation.