Is the Transactions tab a table?

In Google Sheets, it depends on how the cells are referenced. There are certain ways to format cell references in Google Sheets formulas so that they’re dynamic and grow as the table grows.

I’d recommend reviewing this guide:

Tiller’s Template Builder’s Reference