Is there a way to track the running balance of my checking account that includes unreconciled manual transactions? Basically I want to be able to see my account balance including the uncashed checks I’ve written. I know manual additions won’t update on the balances or insights tabs, and the statemen…

You would have to expand the hidden columns by clicking the + above column H and then modify the queries in cell R5 (which would require expanding the list of ranges listed in columns I-L). Once that was done, you’d need to modify the queries in cell B3. Overall not super complex, but a bit of a pa…

Tracking Checking Account

Google Sheets

jpfieber October 27, 2022, 1:12pm 4

I just posted a template called “Account Register” that I think does what you’re looking for. Have a look and let me know!

1 Like

Topic		Replies	Views
Checking balance (for manual future transactions) Google Sheets how-to , tracking	6	2736	April 30, 2020
Manual transactions & updating balances Google Sheets google-sheets , how-to	7	2248	December 27, 2023
Simple Account Reconciliations Show & Tell tracking	25	2103	May 13, 2023
Statement Details question Google Sheets tcs-statements	5	547	August 28, 2022
Statement Details help Google Sheets tcs-statements	5	289	September 27, 2023

Tracking Checking Account

Related topics