Undeposited Funds on balance sheet out of balance to Make Deposits

Hi Amy.  You will have to do a reconciliation of your Undeposited Deposits account.  Somewhere there is a $100 discrepancy which you need to find.  Have a look at the account and you should be able to track this back.  When was the last time that it reverted to zero - in other words when did the banking side clear the balance of the Undeposited Funds account back to zero?  It could even be that a change has been made in something gong back in time.  However, tracking that zero balance in the account, should enable you to readily discover where this discrepancy has occurred.
John L G

Amy.  First thing here is I need to check your terminology.  You say that before you do ?make deposits? the balance was debit $5,100.  Are you sure about that?  Does that mean that the balance in the actual general ledger accounts was showing in red?  The only time to my knowledge that the balance would be debit (showing in red) is when a ?make deposits ?is completed as it tends to appear before all other individual receipts recorded on that same date.  It is starting to sound to me that a deposit for a subsequent date has been recorded with an earlier date than it should have.  This is the only way that I can see that the balance can be debit (in red).  Perhaps it is by pure chance that your two amounts are so close together.
Based on my testing, any other extraneous transaction in Undeposited Funds will cause that to show up in the ?make deposits? window.  If something strange has occurred with a deposit, perhaps it might show up in a bank reconciliation.
If none of the above seems to make any sense in your situation, then there is something else that you can do.  Initially go to ?file>utilities>verify data ?and run than and see if that reveals any errors.  If not, or irrespective, then go to ?file>utilities>rebuild data? and run that three times and see if that corrects the problem.  
John L G

Hi Amy.  Thanks for the clarification.  I needed to know exactly what you meant, as I have no knowledge of your overall understanding of bookkeeping in general.  Obviously you know double entry bookkeeping.
If you make the journal entries that you propose and end up with an amount in the Make Deposits window, are you not able to do a single deposit for that $100?  If you do, then you would end up with a bank deposit which doesn't exist.  You could even deposit that $100 to the Suspense account that you use in the Journal and that in turn might wipe that balance clean.  Somewhere along the way, it seems that you need to create that journal, make a deposit of $100 as mentioned, and hopefully that will clear up the problem for good.  To me that is a better option than having the $100 sit forever in the make deposits window.  
I agree that there does not seem to be much logic as to how this problem came about, but there does seem to be a solution to resolve it, one way or the other.
John L G

Amy.  To me it seems that you are trying to correct the transaction the wrong way around.  To clear the balance, you need to put a debit to undeposited funds which will then enable you to have a further $100 in that account to enable you to make that elusive deposit which will finally clear the balance.  You could credit that deposit to whatever Asset account you use in the Journal entry, because you cannot use your normal bank account or you will have an outstanding deposit to get rid of.  On the other hand, this might not work because I suppose it will only increase the balance of undeposited funds as well.  Very confusing.  Without actually going through the process it is difficult for me to work out what will work.
John L G