Excel Magic Trick 1133: Aging Accounts Receivable Reports: PivotTable & Unique Identifier
Автор: excelisfun
Загружено: 2014-07-16
Просмотров: 174872
Описание:
Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download Excel File: http://people.highline.edu/mgirvin/Ex...
See how to create Aging Accounts Receivable Reports On Multiple Sheets With PivotTable where or not there are duplicate records:
1) (01:49 min) Days Late Helper Column Formula: TODAY function and relative cell reference
2) (02:46 min) Report Category Helper Column Formula using VLOOKUP
3) (03:45 min) Unique identifier Helper Column Formula using COUNTIF, expandable range and Join Symbol
4) (05:55 min) PivotTable based on Invoice Column
5) (08:48 min) PivotTable based on Unique identifier column
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.
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
