ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Accounts Receiveable Aging (https://www.excelbanter.com/excel-worksheet-functions/151999-accounts-receiveable-aging.html)

Kristineandwill

Accounts Receiveable Aging
 
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??



Barb Reinhardt

Accounts Receiveable Aging
 
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??




All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com