How to reconcile a line of credit on Quicken for Mac

I have entered a "Line of Credit" account in Quicken for Mac. I recently had an entry in this account which is offset by an entry in my checking account. I went to reconcile the line of credit account and oddly enough Quicken shows I need to enter an adjustment entry, which would make the balance equal to my line of credit. I kind of understand why it wants to do that, but that's not what I want, obviously.

Any way to "fix" this?

Best Answer

  • UKR
    UKR SuperUser ✭✭✭✭✭
    Answer ✓
    Assuming that your Line of Credit is $10,000 ... Did you enter this amount as the account's Opening Balance?
    The account needs to be opened with a $0 balance. When you take money from the LOC, it's recorded as a transfer from LOC to your Checking account, resulting in LOC showing (for example) $-1000 and the Checking balance increasing by $1000.
    To reconcile at end of month, use the Statement Ending Balance, which probably also includes an Interest charge as a separate transaction. That Statement Ending Balance should be the amount you actually owe, + interest, - payments already made, e.g., $-1020, not $-10000.

Answers

  • UKR
    UKR SuperUser ✭✭✭✭✭
    Answer ✓
    Assuming that your Line of Credit is $10,000 ... Did you enter this amount as the account's Opening Balance?
    The account needs to be opened with a $0 balance. When you take money from the LOC, it's recorded as a transfer from LOC to your Checking account, resulting in LOC showing (for example) $-1000 and the Checking balance increasing by $1000.
    To reconcile at end of month, use the Statement Ending Balance, which probably also includes an Interest charge as a separate transaction. That Statement Ending Balance should be the amount you actually owe, + interest, - payments already made, e.g., $-1020, not $-10000.
  • That is what is so unusual about this. I believe that I did open it with a zero balance (I cannot remember now).

    Quicken says my online balance is $-3550 (my LOC is 4K and I took out $450).

    If I reconcile it wants to make an adjustment for a - 3100.00 giving me a balance of $3550. But that is how much I have in the LOC, not how much I owe.

    Is it possible that Commerce Bank just does it this way?
  • UKR
    UKR SuperUser ✭✭✭✭✭
    > Is it possible that Commerce Bank just does it this way?
    Or might it be possible that Quicken looks at the wrong data field as Online Balance?

    If you haven't done so already, I'd say it's time to call Quicken Support on the phone and request help.  Let them do a screen share session with you to review a download log file on your computer, to determine the nature of the problem and to figure out how to fix it.

    Quicken Support:

    • To contact Quicken Support, please use this link only:
      https://www.quicken.com/support#contact-support  and select Chat or Phone support.
      Support is only available during
      posted hours of operation
    • The phone number can be found at the support website.
    • To start Chat or see the support phone number, your browser must allow popup windows from https://www.quicken.com
    • If you are eligible for Premium Support (purchased separately or included as part of your subscription to Quicken 2018+ Premier or HB&R) call the number that can be found at the top of your My Account page at https://www.quicken.com/my-account  (US) or https://www.quicken.com/canada/my-account (Canada) next to "Quicken Premium Support"  when you log in with your Quicken ID.
    • Other links or phone numbers found elsewhere on the Internet, even in some posts or emails received from other Community members, may not be from Quicken or may not be up-to-date. Use those at your own risk.
    • Unlike other so-called "Quicken support providers", the real Quicken Support is free for all currently supported versions.




  • I got on a chat with them. They said there wasn't much I could do, except manually reconcile. So I will do that. Thank you for your assistance.
This discussion has been closed.