Checking account reconciliation with a negative balance

jbh61464
jbh61464 Member ✭✭
Quicken won't accept a negative balance when entering the month end balance on my bank statement.

Answers

  • UKR
    UKR SuperUser ✭✭✭✭✭
    Is this account truly a checking account or are you trying to reconcile a Line of Credit account that you owe money on?
    LOC / HELOC accounts need to be defined as credit card accounts, not loan/mortgage type accounts. When you owe money in a credit card account, the Ending Balance in the Reconcile dialog is entered as an unsigned postive number. (Only if a credit card account were overpaid and the bank owes money to you would you enter a negative ending balance)
    Give us a little more detail on the specifics of your situation, please.
  • Sherlock
    Sherlock SuperUser ✭✭✭✭✭
    I have no difficulty providing a negative ending balance for any type of register when I reconcile using a statement.

    Note: Quicken only uses the Ending statement date and the Ending balance amounts specified.  The Prior balance amount specified is ignored.  The Prior balance used is the total of all of the Reconciled (R) transactions in the register.
  • jbh61464
    jbh61464 Member ✭✭
    > @UKR said:
    > Is this account truly a checking account or are you trying to reconcile a Line of Credit account that you owe money on?LOC / HELOC accounts need to be defined as credit card accounts, not loan/mortgage type accounts. When you owe money in a credit card account, the Ending Balance in the Reconcile dialog is entered as an unsigned postive number. (Only if a credit card account were overpaid and the bank owes money to you would you enter a negative ending balance)Give us a little more detail on the specifics of your situation, please.

    It's a checking account just like I said. If it was something else I would have said so.
  • jbh61464
    jbh61464 Member ✭✭
    > @Sherlock said:
    > I have no difficulty providing a negative ending balance for any type of register when I reconcile using a statement.
    >
    > Note: Quicken only uses the Ending statement date and the Ending balance amounts specified.  The Prior balance amount specified is ignored.  The Prior balance used is the total of all of the Reconciled (R) transactions in the register.

    Well good for you but that doesn't help me.
  • UKR
    UKR SuperUser ✭✭✭✭✭
    jbh61464 said:
    > @UKR said:
    > Is this account truly a checking account ...

    It's a checking account just like I said. If it was something else I would have said so.
    I just started Reconcile for both Checking and Credit Card account types in my Q Subscription R 38.29 and in both cases, the Reconcile dialog allowed me to enter a negative amount in the Ending Balance field.
    Please show us what's going on when you try to reconcile your account. What do you enter where? What error message do you get? What is the account type, as shown in Edit Account Details, General tab.

    Can you please capture one or more images of the parts of your Quicken window showing the issue, sensitive information blacked out as necessary to protect your privacy but annotated to describe the situation, and attach the image(s) here?
    https://community.quicken.com/discussion/7867159/faq-how-do-i-post-a-screenshot-in-the-community-from-windows

    https://community.quicken.com/discussion/7663259/faq-how-do-i-post-a-screenshot-in-the-community-from-a-mac

    Please save images to files of file type PNG, JPG, or GIF only. They're easier to work with than PDF files.

    Also please tell us what  version, edition level (Starter, Deluxe, etc.) and release (R xx.xx) of Quicken are you using? US, Canadian or other country version?
     

  • Sherlock
    Sherlock SuperUser ✭✭✭✭✭
    jbh61464 said:
    > @Sherlock said:
    > I have no difficulty providing a negative ending balance for any type of register when I reconcile using a statement.
    >
    > Note: Quicken only uses the Ending statement date and the Ending balance amounts specified.  The Prior balance amount specified is ignored.  The Prior balance used is the total of all of the Reconciled (R) transactions in the register.

    Well good for you but that doesn't help me.
    I suggest you contact Quicken Support: https://www.quicken.com/support/quicken-support-options
  • jbh61464
    jbh61464 Member ✭✭
    > @UKR said:
    > I just started Reconcile for both Checking and Credit Card account types in my Q Subscription R 38.29 and in both cases, the Reconcile dialog allowed me to enter a negative amount in the Ending Balance field.Please show us what's going on when you try to reconcile your account. What do you enter where? What error message do you get? I DON'T GET ONE! What is the account type, CHECKING AS I ALREADY SAID. as shown in Edit Account Details, General tab.
    > Can you please capture one or more images of the parts of your Quicken window
    > showing the issue, sensitive information blacked out as necessary to protect
    > your privacy but annotated to describe the situation, and attach the image(s)
    > here?
    >
    > https://community.quicken.com/discussion/7867159/faq-how-do-i-post-a-screenshot-in-the-community-from-windows DOESN'T WORK ON FIREFOX
    >
    > https://community.quicken.com/discussion/7663259/faq-how-do-i-post-a-screenshot-in-the-community-from-a-mac N/A
    >
    >
    > Also please tell us what  version, edition level (Starter, Deluxe, etc.)
    > and release (R xx.xx) of Quicken are you using? US, Canadian or other country version?
    >  See attached picture where it asks for ending balance. I used a closed account as my example. It's doing the same thing.

    H & B 2017 and it just updated.
  • UKR
    UKR SuperUser ✭✭✭✭✭
    > "H & B 2017 and it just updated. "
    That does not compute ... if you're on Q 2017, that's unsupported and can't have "just updated", not the software versions and not any transaction updates, either.
    Please click Help / About Quicken and tell us the version and release number (R xx.xx) as shown in the popup view.
    As far as the negative Ending Balance is concerned: I'm puzzled. AFAIK, that shouldn't happen.

    If you haven't done so already and if you're on a supported version of Quicken Subscription (2018-2022), I'd try the following actions:

     

    Validate and Supervalidate instructions

    First save a backup file prior to performing these steps

    Validate: 

    1. File
    2. Validate and Repair File...
    3. Validate File
    4. Click OK
    5. Close the Data Log
    6. Close Quicken (leave it closed for at least 30 secs)
    7. Reopen Quicken and see if the issue persists.

    Super Validate:

    1. File
    2. Hold CTRL + Shift and click Validate and Repair File...
    3. Supervalidate File
    4. Click OK
    5. Close the Data Log
    6. Close Quicken (leave it closed for at least 30 secs)
    7. Reopen Quicken and see if the issue persists.

  • Sherlock
    Sherlock SuperUser ✭✭✭✭✭
    To work around the issue, I suggest you add a temporary transaction in the register to offset the negative balance.  After you have reconciled to the non-negative balance, delete the temporary transaction.
  • jbh61464
    jbh61464 Member ✭✭
    > @jbh61464 said:
    > > @UKR said:
    > > I just started Reconcile for both Checking and Credit Card account types in my Q Subscription R 38.29 and in both cases, the Reconcile dialog allowed me to enter a negative amount in the Ending Balance field.Please show us what's going on when you try to reconcile your account. What do you enter where? What error message do you get? I DON'T GET ONE! What is the account type, CHECKING AS I ALREADY SAID. as shown in Edit Account Details, General tab.
    > > Can you please capture one or more images of the parts of your Quicken window
    > > showing the issue, sensitive information blacked out as necessary to protect
    > > your privacy but annotated to describe the situation, and attach the image(s)
    > > here?
    > >
    > > https://community.quicken.com/discussion/7867159/faq-how-do-i-post-a-screenshot-in-the-community-from-windows DOESN'T WORK ON FIREFOX
    > >
    > > https://community.quicken.com/discussion/7663259/faq-how-do-i-post-a-screenshot-in-the-community-from-a-mac N/A
    > >
    > >
    > > Also please tell us what  version, edition level (Starter, Deluxe, etc.)
    > > and release (R xx.xx) of Quicken are you using? US, Canadian or other country version?
    > >  See attached picture where it asks for ending balance. I used a closed account as my example. It's doing the same thing.
    >
    > H & B 2017 and it just updated.

    Yes it updated and my subscription renewed in December. Version R38.30 Build 27.1.38.30 It is supported because I'm paying for a subscription. There's no way to show you what's going on. I can enter an amount but it won't let me make it a negative amount.
  • UKR
    UKR SuperUser ✭✭✭✭✭
    There's no way to show you what's going on. I can enter an amount but it won't let me make it a negative amount.

    In that case and 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 the situation on your computer, to determine the nature of the problem and to figure out how to fix it.

    Quicken Support:


  • jbh61464
    jbh61464 Member ✭✭
    > @jbh61464 said:
    > > @jbh61464 said:
    > > > @UKR said:
    > > > I just started Reconcile for both Checking and Credit Card account types in my Q Subscription R 38.29 and in both cases, the Reconcile dialog allowed me to enter a negative amount in the Ending Balance field.Please show us what's going on when you try to reconcile your account. What do you enter where? What error message do you get? I DON'T GET ONE! What is the account type, CHECKING AS I ALREADY SAID. as shown in Edit Account Details, General tab.
    > > > Can you please capture one or more images of the parts of your Quicken window
    > > > showing the issue, sensitive information blacked out as necessary to protect
    > > > your privacy but annotated to describe the situation, and attach the image(s)
    > > > here?
    > > >
    > > > https://community.quicken.com/discussion/7867159/faq-how-do-i-post-a-screenshot-in-the-community-from-windows DOESN'T WORK ON FIREFOX
    > > >
    > > > https://community.quicken.com/discussion/7663259/faq-how-do-i-post-a-screenshot-in-the-community-from-a-mac N/A
    > > >
    > > >
    > > > Also please tell us what  version, edition level (Starter, Deluxe, etc.)
    > > > and release (R xx.xx) of Quicken are you using? US, Canadian or other country version?
    > > >  See attached picture where it asks for ending balance. I used a closed account as my example. It's doing the same thing.
    > >
    > > H & B 2017 and it just updated.
    >
    > Yes it updated and my subscription renewed in December. Version R38.30 Build 27.1.38.30 It is supported because I'm paying for a subscription. There's no way to show you what's going on. I can enter an amount but it won't let me make it a negative amount.

    > @UKR said:
    > In that case and 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 the situation 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
    >
    > See https://community.quicken.com/discussion/7870684/faq-talk-to-support-does-not-respond#latest
    > * 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. Place the call using the phone whose number is recorded in your account profile.
    >
    > * 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 might back up my files and reinstall first to see if that takes care of it. I just don't have time yet. Got my better computer back with new hard drive so I'm switching to it and will have a fresh install of everything.
This discussion has been closed.