My apologies if I put this in the wrong forum.... I have built a checkbook register spreadsheet that rounds my totals of debits or credits up or down depending on the transaction. Mostly it just rounds to the nearest $1 so I can sort of buffer "extra" cash. Ultimately, it works fine. However, when I was doing it by hand in a regular check register, on paycheck day I would round that check to the nearest $5 or $10 depending on how much I needed to buffer (or save). I need to figure out how to keep all transactions as the normal $1 estimations, but when I deposit something like a paycheck or large sum of money, to only estimate $10 for those transactions.