Accounts receivable aging report in Excel: buckets in one formula

Build an accounts receivable aging report in Excel from a plain list of open invoices. Days overdue, aging buckets with one IFS formula, a customer summary with SUMIFS, % of total and 90+ highlighting, step by step. Chapters 0:00 The finished AR aging report 0:10 The open-invoices list and the as-of date 0:23 Days overdue (and the "shows a date" fix) 0:53 Aging buckets with one formula (IFS, or LOOKUP in older Excel) 1:22 Customer summary with UNIQUE and SUMIFS, tied to the invoice list 2:11 % of total per bucket 2:22 Highlight 90+ with conditional formatting 2:36 Aging by due date vs invoice date 3:04 Invoices in Xero? Aged Receivables with XO Report Formulas used Days overdue: =$B$1-D4 Bucket: =LOOKUP(F4,{-99999,1,31,61,91},{"Current","1-30","31-60","61-90","90+"}) Customer list (Excel 365): =UNIQUE(A4:A15) Summary: =SUMIFS($E$4:$E$15,$A$4:$A$15,$I4,$G$4:$G$15,J$3) % of total: =J9/$O$9 Conditional formatting rule for A4:G15: =$G4="90+" All customers and figures in this video are demo data. Try XO Report free for 14 days: https://xo-report.com Guide: Xero Aged Receivables report in Excel: https://xo-report.com/xero-to-excel/a... Music: "Wallpaper" by Kevin MacLeod (incompetech.com), licensed under CC BY 4.0