Is it possible to have a cell updated with the balance of an account for a specific date? E.g., last date of each month

[randy]

This is similar to how the Net Worth Tracker template in Tiller Community Solutions works. The queries are non-trivial but if you poke around in there you can pull out what you need.