Back to the drawing board, as they say.
I got it sorted out today, and I already know what the problem is. Luckily, I get paid at the end of the week, so I get a chance to start over again.
What happened was I was paying my basic expenses and putting the rest of my money onto my Line of Credit. My rationalization was that if I ran out of $$ I could tap into the LOC. Then when I ran out of money, I would berate myself for considering using the LOC, and use my credit card instead.
Now I have a $300 credit card bill to pay off, and tracking the expenses has mucked up my pretty spreadsheet.
For June the new goal is to keep at least $300 in my account and shelve the credit card. For good, I hope.