Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Transactions appear to be unreconciled after Mac conversion

Transactions appear to be unreconciled after converting file from Mac to Windows or vice versa. Also, the reconciliation window looks different.

Why this is happening

This is a known issue that occurs due to the way reconciliation works in Mac vs. Windows. QuickBooks for Mac 2012 and previous years still use the "old" reconciliation module, whereas the Windows reconciliation module was changed as of QuickBooks 2002. In Windows, the opening balance is now the sum of all transactions that have been reconciled through the reconcile module. In QuickBooks for Mac, the opening balance is created by check marking the transaction in the register.

QuickBooks for Mac 2013 does support the round tripping of reconciliation data with QuickBooks for Windows.

How to fix it

To correct this, you can do a lump sum reconciliation so all unreconciled transactions will be cleared in one batch.

QuickBooks for Windows:

Correct issues with transactions that have become unreconciled:

  1. From the Banking menu, click Reconcile.
  2. Enter the ending balance and the date of the last completed reconciliation.
  3. Click Continue.
  4. In the Reconcile window, all previously reconciled transactions are displayed with a check mark.
  5. Verify that the Difference showing in the lower right-hand corner of the Reconcile window is zero.

Note: If balance is not zero, check the balance against actual bank statements. There is an option to accept the difference and enter an adjustment.

  1. Click Reconcile Now.
  2. All transactions have now been reconciled in one lump reconciliation.

Resolve issue where the reconciliation window looks different:

  1. From the Banking menu, click Reconcile.
  2. Enter an ending balance.
  3. Click Continue.
  4. Click Columns to Display.
  5. Choose the columns you want to see (the defaults are usually Check, Date & Payee under Checks & Payments, and Check, Date & Memo under Deposits & Other Credits).
  6. Click OK and then cancel or continue reconciliation.

QuickBooks for Mac:

Workaround for issue with transactions that have become unreconciled:

  1. From the Banking menu, click Reconcile.
  2. Enter the ending balance and the date of the last completed reconciliation.
  3. In the Reconcile window, all previously reconciled transactions are displayed with a check mark.
  4. Verify that the Difference showing in the lower right-hand corner of the Reconcile window is zero.

Note: If the difference is not zero, transactions have been manually cleared (by checking off) in the bank register. 

  1. Click Done.
  2. All transactions have now been reconciled in one lump reconciliation.

Note: Reconcile window does not change in Mac.

KB ID# SLN41172
12/8/2016 9:43:19 PM
PPRDQSSWS400 9138 Pro 2017 8538a8