dhardersen
Level 1

How can I enter a negative balance when reconciling?

 
Solved
Malcolm Ziman
Level 10

Banking

Do you mean entering the statement balance?
dhardersen
Level 1

Banking

Yes.  When I go to reconcile and put in the ending balance from the statement, it won't take a negative number.  I work for a  school and some of our sports carry a negative balance sometimes.
Malcolm Ziman
Level 10

Banking

It should take a negative for the bank statement balance. Is this a bank statement? What do you mean by "sports"?
josh7
Level 1

Banking

It's not a very good program.  Just write down the negative number in a different text program so if it's "-7" then copy and paste it in.
Malcolm Ziman
Level 10

Banking

I though you meant the sports program
lyndaartesani
Level 6

Banking

 Just  enter it like this:   -23.17.  Then you should be able to reconcile. 

View solution in original post

Malcolm Ziman
Level 10

Banking

LOL. how else did they try? Maybe in brackets or in a red font?
lbg3093
Level 2

Banking

I can enter the negative balance but it will not reconcile.  I just get a blank screen rather than the normal reconciliation screen.  Now it is impossible to reconcile anything.

 

RCV
QuickBooks Team
QuickBooks Team

Banking

Let's get this sorted out and display the transactions in the Reconcile page, lbg3093.

 

Let's make sure the Hide transactions after the statement's end date option is not turned on in the Reconcile page. You can uncheck that option located on the top right of the screen to see the transactions for that period (if it is activated).

 

If not, it's possible there's a damaged data on the company file preventing the transactions to appear. You can follow the steps in this article to troubleshoot the issue: Resolve data damage with your QuickBooks Desktop company file.

 

Then, try accessing the Reconcile page again to see the transactions for Checks, Payments, Deposits and other Credits.

 

To learn more about reconciliation, you can check out these articles:

 

If the same thing happens, I'd suggest contacting our Customer Support Team. They'll investigate what's causing this issue.

 

Here's how:

 

  1. Click Help on the top menu.
  2. Choose QuickBooks Desktop Help.
  3. Enter your concern in the Search field.
  4. Tick the Search icon
  5. Tap the Contact Us link.
  6. Choose Get a callback to connect with us.

QBDT Help 01.PNGQBDT Help 02.PNG

 

Please go back to this thread if you need anything else with reconciling your bank account. I'm here to help.

mayinNV
Level 1

Banking

I'm having the same problem when reconciling a CC with a negative balance.  When I try to enter the - sign, it gives me the calculator, not a negative sign. 

I'm using a mac. Maybe that's why?

AileneA
Moderator

Banking

Hello, mayinNV. 

 

Thank you for reaching out to the Community. Let's go ahead and pull up the discrepancy report to view what's causing the difference.  

 

 

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

Once already figure out the discrepancy, make sure to correct it and start the process of reconciling.  

 

To guide you with the reconciliation process, Here are the articles for you:  

However, If all fails, let's consider to verify and rebuild data. It could be the file is corrupted.  

 

Please know that you can always get back to this post If you have any other questions. I'll be right here to help. Stay safe!

mgarcia1274
Level 1

Banking

you did not answer her question. She doesn't have a discrepancy she has an ending negative balance for her account.  Her statement was a negative amount, however Quickbooks doesn't let you enter a negative balance amount in the reconciliation. I am using mac

Candice C
QuickBooks Team

Banking

Hey there, @mgarcia1274

 

Thanks for joining in on this thread.

 

If none of these steps are helpful to you and your business, then I recommend contacting our Customer Support Team so we can take a further look at your account. Here's the link: 

 

Contact QuickBooks Desktop for Mac

 

Keep us updated on how the call goes. I'll be waiting for your response! 

 

mgarcia1274
Level 1

Banking

I was able to copy and paste the number from excel and was able to enter the negative number as the ending balance.  It shouldn't have to be that way especially with QB's being around so long. oh well.