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	2743	April 30, 2020
:trophy: Account Register - Google Sheets Show & Tell tcs-gallery , tcs-acct-register	75	6348	May 29, 2024
Manual transactions & updating balances Google Sheets google-sheets , how-to	7	2279	December 27, 2023
Simple Account Reconciliations Show & Tell tracking	25	2138	May 13, 2023
Statement Details question Google Sheets tcs-statements	5	550	August 28, 2022

Tracking Checking Account

Related topics