Have you heard of Fina Money? SpreadSheet works, but Fina tries to make it easier to analyze and visualize your finance data from sheets + live banks. It solves the problems you mentioned.