>>I'm assuming you want balances for the 'As of' date? Payments would be added back in, Credits would be subtracted out. Not sure what you mean by allowances, but basically you'd want to reverse the sign.
>>
>>
>
>The problem is that we have defined many different columns. Open accounts, Accounts Paid, Closed accounts without payment, etc. This is there it's getting too tricky... We need to see what accounts were opened as of date, etc.
>
>Allowance is just a special type of payment, but it has to be reflected in its own column.

Assuming that y'all are keeping Closed Dates and Open Dates on Accounts, it's easy to figure out what accounts were open on a specific date. An account is either open or closed.

Somewhere there has to be code to handle each specific type. Find that code and reverse the operation. if addition, subtract; if subtraction, add