>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.