For consolidating accounts, use checkboxes to dynamically calculate the balance

[jonathan-irvin]

When you need to find a rouge amount, allow the user to checkboxes next to a debit or deposit and dynamically calculate the balance to "hone in" on the point in which the balance deviates.