1) If any of the cells in the columns with numbers are formatted as text instead of as currency, they will not be included in the sum. Select the entire column(s) and format as currency just to be sure none are text.
2) If the text is even slightly different (other than case), it won't be included in the sum. Copy/paste one of the cells of text to your deposit or expenses sheet rather than trying to type them in the same. That way you will know for sure they are the same.
In general, I recommend using a pop up menu cell type for your categories so that you are 100% sure there are no spelling differences or double spaces or whatever. You can select all the categories in your register table and change the format to pop up. It will not change the values of any of your existing entries but will change all those cells to pop up menus. You can then use that pop up menu in your new rows and copy/paste it into your other tables.