Has anyone created a bank register ?
Specifically I am trying to come up with a way of keeping the running total/balance.
I could keep the balance on each item but wonder how hard it will be to keep that balance up, as in the case where a previous check or deposit has to be changed or voided. This would throw off all calculations after that record.
Anyone have a better/smarter suggestion ?
Sure, as long as there is a field or fields that can be used to order the records appropriately. The balance for any given transaction is the sum of all the transactions which preceded it, including that transaction (or in this case, sum of deposits less sum of debits).