My dept. uses spreadsheets to track "spent" items against a budget. For
instance there is a column for the budget, spent and a column for Balance.
There are about 100 line items. When a manager submits an invoice to
payables they change the amount in the spent column to reflect the new
amount. Then at the end of the quarter they compare their budget balance
against accountings budget balances as a check for errors. This job has now
been passed to me however - I would like to somehow track my entries instead
of just changing the amount. If I come up with something different than
accounting I don't want to have to pull a hundred different files looking for
invoices that hopefully match the amount that is different and then find out
I added wrong. Can someone point me in the right direction?