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

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.

[SyedMuzammilMahasanShahi]

Awesome Mike with EXCELlent video on Aging accounts

[TimSheets]

Regardless of the usage, that Analyze | Options | Show Report Filter Pages trick is pretty freakin' awesome!

[mikeburton]

Thanks for another great video Mike, really awesome series!!

[mohammedshameelv]

Thank you sir

Sir i have one doubt, if we received money then how we do

[excelfan]

What a great video series. Thank you as always I love something new to work on to keep the cogs turning. I'm guessing you could insert 2 columns and create a unique list of names with & " " & and invoice number or the expandable countif from Excel Magic Trick  187. I am a very happy Excel Fan    

[excelisfun]

Excel Magic Trick 1131: Aging Accounts Receivable Reports On Multiple Sheets With PivotTable
TRICK ONLY WORKS IF THERE ARE NO
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
2. (02:54 min) Pivot Table
3. (04:40 min) Options, Show Report Filter Pages

[xezox]

The last field of report category should be 91 >= Days Late <= 365 or >= 91 days late if more than 366 days late

[livinindubai]

I can only watch a youtube Excel video with your commentary =P