Expenses spreadsheet: certain transactions not being included in summary

I’m making a spreadsheet to track my personal spending. You’ll notice that there are two currencies - I’m an American and I split my time between Thailand and the United States. I’ve gone as far as I can go on my own, so I’ll split my questions into separate posts, so I can get answers to individual questions separately.

Questions:

• See the screenshot. There’s a table for transactions where I enter each transaction when I spend some money. I make a new row, enter today’s date (it would be great if the date would auto-populate when I make a new row, but that’s not my questions here). I choose a category in a drop down menu and enter the amount in either a column for Thai baht or US dollars, which is converted to US currency for the summary calculations. In a separate table, my spending is all summed by category, but as you can see in the screenshot, not all of them are being summed. I entered $1 into groceries and 33 baht into bike stuff, but as you can see, they are not being included in the itemized spending table. My formula in the spending table is SUMIFS(Spent,Transactions::B,B$1,Transactions::C,$A4) for groceries, for example. What am I doing wrong?

The rest of this post is superfluous to the question, but advice is always welcome. Ultimately, the sheet will live in my iCloud Drive so I can enter transactions from my iPhone or iPad as I spend. Here’s a summary of how I’d like it to work:

• There will be a table for entering transactions as they happen. I will add a new row in the table when I spend some money and enter the date, choose a category of spending (such as eating out, paying rent, etc) for this transaction, and enter an amount in US dollars or Thai baht. The Thai baht is converted to US currency in a separate column so I can see all of my results in dollars.

• I want the categories to be summed by month in a separate table you can see in the picture - how much I spent on eating out, bike stuff, groceries, etc for each month.

• At the bottom, I would like to track a ‘per diem’, how much I’m spending per day.

• On a separate sheet, a line graph will show me spending over 2019, both overall and separated by category.

• Another table lists all of my recurring costs, many of which are automated payments - subscriptions, student loans, iCloud, Netflix, health insurance, etc.

• I have savings goals, so I will also have a table showing income versus spending plus recurring costs. A formula will calculate how much (or how little, to be accurate) I can spend per day to ensure I save my $500 a month savings goal.

• There will also be a table for income, to record what I receive from my online job as well as other sources, like selling stuff on eBay or Craigslist.

• I’ll make a chart and enter amounts from all of my accounts every month so I can graph that as well.

• I am in the process of starting a small business, which will inhabit it’s own sheet, but that hasn’t happened yet.

Thanks for your help!