Skip to content

Ageing Analysis in Excel Using IF Formula & PivotTables | Accounts Receivable Report

      In this video I demonstrate how to perform ageing analysis in Excel. We want to show overdue invoice amounts in four columns: 0-30 days overdue; 31-60 days overdue; 61-90 days overdue and over 90 days overdue. The process is: Calculate when the invoice is due Calculate the number of days the invoice is overdue… Read More »Ageing Analysis in Excel Using IF Formula & PivotTables | Accounts Receivable Report