Forum Discussion
Check Register Not automatically adding or subtracting itemized transactions
It's actually kind of a stupid (excuse me please, whoever created this) formula in that template's column I, where the balance is calculated. Much more complicated than it needs to be, in that all it is saying, is
- IF you're in row 3 (i.e., the top row) then the balance is whatever is in cell $H$3 (where the creator placed an "opening balance",
- else, subtract the debit from the row above, or add the credit.
The formula has nothing at all to do with the date column.
Now, I don't know exactly what you did to "add February" -- IF you started a new page (which is NOT what you should do) -- that could explain it. What you should be doing is just continuing the register, entering check numbers and dates, descriptions, and a debit amount in the debit column, a credit amount in the credit column. It will continue to work.
OR, if you want to make it simpler, enter your starting balance in cell I3 (i.e., write over the formula that's in the cell with a number) and then use this formula in cell I4, copied to all succeeding rows.
=I3-G4+H4
See the attached file, where I've done that for you.
I do not in the least appreciate you calling me stupid. I didn't do anything but continue to add transactions to the existing register so it should have continued to work appropriately. This page or forum absolutely sucks!
- mathetesJan 03, 2023Silver Contributor
I did not at all refer to you that way: only to the formula created by the designer of the template itself, the creator of the spreadsheet that was giving you difficulty.