Skip to content

Business Excel & Job Interview Challenges · Exercise 6 of 10 · Finance · Advanced · 30 min · Premium

Accounts Receivable Aging

Build an aging report as of a given date: days overdue, an aging bucket per invoice that ignores paid invoices, and the money sitting in each bucket.

What you will practise: Measure how late each invoice is from an as-of date, assign it to an aging bucket with careful boundaries, and total the unpaid amounts by bucket.

Premium

This is a Premium exercise

Premium members can open this exercise and practise it in the spreadsheet.

Open exerciseNot a member? See Premium plans