Excel Magic Trick 1131: Aging Accounts Receivable Reports On Multiple Sheets With PivotTable

Download Excel Start File: https://people.highline.edu/mgirvin/Y...

Download Excel File: http://people.highline.edu/mgirvin/Ex...
TRICK ONLY WORKS IF THERE ARE NO DUPLICATES!!!!!
See how to create Aging Accounts Receivable Reports On Multiple Sheets With PivotTable when there are no duplicate records:
1. (00:08 min) Formulas: Helper Columns. (01:00 min) The correct formula for Days Late is: =TODAY()-D8.
2. (02:54 min) Pivot Table
3. (04:40 min) Options, Show Report Filter Pages

What is an Aging Report:
Aging means how many days past the due date the invoice is. Accounts Receivable Customers must pay their bill by a certain date, if they pay late, they would be listed in one of the aging reports. If they are 1-30 days late, they are listed in the first report. 31-60, the second. And so on. Further, once the customer is so late, like 300 days, the company stops wasting its time trying to collect and writes the Accounts Receivables amount as "Bad Debt" and runs that expense through the Income Statement.