I just started using this template, and it’s great, thanks!
I have a suggested enhancement that I’ve added to my local copy. As the title to my post suggests, I call it Bank Balance. This helps me when I reconcile my latest monthly account statement. I copied column G, Balance, to column H, then renamed it “Bank Bal”. Here is the formula for cell H3:
=IF (ISBLANK(D3), H2, H2-E3+F3)
This says that if the transaction has not been recorded, then don’t include it, otherwise do. You can use this column to compare to your statement’s closing balance. So it saves you from having to do the reconciliation yourself.
Hope others find this helpful.