As I'm not an accounting person (although have heard the terms Accounts
Receivable Aging), I'm not exactly sure what you are looking for. What do
you mean by "proper bucketing"?

"Kristineandwill" wrote:

We have purchased another company and their programming for their AR Aging
report does not accurately apply credits against debits. The report looks
like there old invoices due but usually net to zero. Is there a quick
function or calculation in Excel that can help with the proper bucketing of
these amounts??