I recently discovered a strange bug in google sheets that occurs for QUERY’s on my Transactions tab – if the header is passed to QUERY, some transactions are not counted for some categories. This resulted in an overestimation of funds in the AVAILABLE column.
Since QUERY automatically intuits how many rows to leave for the header, removing the header argument in T6 and W6 was sufficient to get rid of the bug.
PS: My apologies for the vague nature of this report. I unfortunately don’t have the time to know why only transactions in the Category: Restaurants & Food Delivery are truncated for a few days, or whether this behavior would continue/get worse if I didn’t fix it.