Aged A/R Balances run on 28th of each month showing receivables during the following 30-day period.

Customer runs an Aged A/R report monthly on the 28th day.  Partner wants to see what payments were collected on those aged balances during the 30-day period following the date of the report.  Basically partner wants a column on the Aged A/R displaying collections against accounts receivable.  Is there any way to do this?

  • 0
    The closest you can come easily is you can include last payment date and amount on the report. This is done by clicking on the options tab. However, that is going to show you the last payment. I don't know of any way to show following period. The question doesn't really make sense to me as how can you show what is coming - it hasn't happened yet.
  • 0 in reply to Caren2
    Caren, I may not have done a good job formulating the problem. The customer runs the report on the 28th of each month. After that time, payments come in which will decrease the balances. When the report is run on or about the 28th of the following month, some of those balances will be paid. Partner wants to see what balances were paid on an Aged A/R Report by date (date being the 28th of the prior month). I know this is pretty convoluted, but I guess the prior collections person was running the report; printing it to Excel and entering payments manually in a separate column. The new Office Manager would prefer just to provide a Transaction Listing "Payments" or Payment Register, but Partner wants to see it on the Aged A/R. Thanks for trying to respond.
  • 0 in reply to JudyW

    Sample of work product manually done by Collections Person: