This post has been closed and is not open for comments or answers.
Quicken Community Home Page

How Do I Reconcile Using QE for Mac?

I don't understand what dates and figures I should use for Beginning Balance and Ending Balance when reconciling account?  I'm used to Q for Mac 2007 where I'd simply enter the online balance.  I'd then receive a report of outstanding items and whether or not it balanced to my Quicken register.  That made sense.  But I can't seem to make any sense of QE for Mac.
  • The reconcile process with QE is not as intuitive as it was with earlier versions. Additionally I cannot fine a way to set an auto reconcile as I did with my previsions versions. I would also like some more insight.
Hi All,
This thread should help with reconciling: https://qlc.intuit.com/post/show_post_full_view/aDuwn0k9ur37otacfAralO?ppid=128565358

HTH,
Quicken Kathryn
    I have found Reconciling somewhat simpler on QE for Mac versus the Windows version.

    Try this:

    On top line click> Account > Reconcile Account
    A drop-down window will appear on the top.  The beginning date & beginning balance should be entered from your bank statement.  Then enter the end date & ending balance also listed on your bank statement.  In other words, this is the range of transactions your bank statement is reporting to you and you will be reconciling your transactions to the bank's records.

    After you have entered the date and amounts, Click > Start Reconciling.  If your QE records match your banks records, then the "Difference" box will show "0".  If there is a difference, than check your bank's statement against your Quicken transactions and determine if you are either missing an item or have an incorrect amount in a transaction.  

    When the "Difference" box equals "0" then Click > Finish  Reconciling.  The blue checked square boxes in the "Reconcile" column will become green checked circles and you are done.
     
    The key is to make sure you download your transactions from your bank or credit card company prior to reconciling and that you do not have any duplicate transactions.  I like this format since you never leave the account transaction page so it is easier to spot and correct errors.

    I hope this helps you.

    Jack
    • I am having the same issue.  Furthermore, when I set the time to the beginning of the account and the current date, and I am working with reported online balances, I cannot seem to get the balance to "zero."  I have even tried this on a couple of small checking accounts that have very few transactions and I get ridiculous delta's.  I would very much appreciate any advice or guidance.
    If I understand your question correctly, you may be comparing apples to oranges.  Reconciling is usually done to compare your account register to your bank statement, not to an online balance.  In other words, during the statement period (i.e. from start to end dates) did you enter transactions (deposits & withdrawals) correctly and have you marked (checked) all the transactions either via QEM download or manually that have cleared on your bank statement.  Reconciling will identified when you fail to enter a transaction or did it incorrectly, such as transposing numbers such as 9.95 instead of 9.59.

    I never compare my QEM register balance with my online balance since deposits and withdrawals may not have cleared yet.
    • "A drop-down window will appear on the top. The beginning date & beginning balance should be entered from your bank statement. Then enter the end date & ending balance also listed on your bank statement. In other words, this is the range of transactions your bank statement is reporting to you and you will be reconciling your transactions to the bank's records."

      the drop-down window has a random date and the balance box is blank. The balance never matches the online balance. It's frustrating as heck. I haven't used a bank statement to reconcile since 1985 and neither does Quicken for PC or did Quicken for Mac 2007. Why in the world would it have been changed for QE?

      This is HORRIBLE