Excel Magic Trick 1131

Ageing Accounts Receivable Reports On Multiple Sheets With PivotTable

DESCRIPTION

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

What is an Ageing Report?
Ageing 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 ageing 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.

WORKBOOKS




Be the first to comment

Leave a Reply