Regarding the aging report, I need an aging report based on net balances. By this, I mean that as payments are made they are subtracted out of the invoice that it was applied to in real time. This would allow us to follow the actual amount of the outstanding invoice as it progresses through the 30-60-90-120-121+ days process.. At present, it appears that when a payment is made, it has to "catch up" to the invoice it was applied too. It's like every transaction is aged. When I run a weekly aging report, I am unable to truly determine what is actually outstanding per bucket...
With revenue accounts, we would need a report(s) with a break down of each revenue account and the ability to reconcile each of them. Also, we need the ability to generate reports per term.