Not sure if this will help anyone, but I have my Account Reconciliation sheet set up to constantly be updating, and I find it very satisfying to see the green numbers all the way down the sheet!
To set-up:
COLUMN B:
selected each account in cells B5-B12 (I have 8 accounts).
Then in cell b13, I put
=B6
and I dragged that down the page.
COLUMN C:
c5
= today()
c6 I put
=c5
and dragged that down to c12
c13 =
=eomonth(C5,-1)
and drag that down
Column I:
=(eomonth(C5,-1))+1
Column D:
=iferror(INDEX('Balance History'!I:I, MATCH(1,('Balance History'!D:D=B5)*('Balance History'!B:B=C5),0)),iferror(INDEX('Balance History'!I:I, MATCH(1,('Balance History'!D:D=B5)*('Balance History'!B:B=(C5-1)),0)),iferror(INDEX('Balance History'!I:I, MATCH(1,('Balance History'!D:D=(B5))*('Balance History'!B:B=(C5-2)),0),""))))
Column J:
=iferror(INDEX('Balance History'!I:I, MATCH(1,('Balance History'!D:D=B5)*('Balance History'!B:B=I5-1),0)),iferror(INDEX('Balance History'!I:I, MATCH(1,('Balance History'!D:D=B5)*('Balance History'!B:B=(I5-2)),0)),iferror(INDEX('Balance History'!I:I, MATCH(1,('Balance History'!D:D=(B5))*('Balance History'!B:B=(I5-3)),0),""))))
**NOTE: these pull the last day of the month from the balance history sheet. If the last day of the month is not there, it looks for 1-2 days prior.
Columns E-G stay the same.
This setup might not work for everyone (especially if you don’t have old balances in balance history), but it helps me a lot. Sometimes I will manually adjust transactions, and this helps me to confirm that I didn’t erroneously change an old deposit/withdrawal or accidentally delete anything.
BTW - I’m obsessed with tiller, as a CPA turned lawyer I do not get to play with spreadsheets as much as I used to, and dare I say I enjoy updating my tiller sheet…? Thanks for all you do!!
