look at the difference between your spread sheet, your checkbook and bank statement.

  • if the difference is twice one of the entries, then you've added instead of subtracting a check you wrote.
  • if the difference is one of the entries then, the banks have not recorded the transaction
  • if it is some odd number then, did you leave out one of the numbers?
    entered $9.45 instead $99.45 easy to do and hard to catch.


If you still have a problem, narrow down the mistake by checking at the middle of the week instead of at the end of the week. If your halfway point is okay then the mistake is in the later half of the week, if the mistake shows up halfway through, then the mistake is in the first half of the week.

I use the sum function "=sum($b$2: $b$25)" kind of thing. use positive number for deposits and minus sign when I withdraw. This way, I'm not dependent on writing out some big equations.