Projects·Project·Lesson 61 of 62Pro

Freelancer invoices: who owes what

A closing project, using what the course has covered.

What you’ll do

A freelance designer’s invoices for the first quarter. Some are paid, some aren’t. As of the date in J1, find what’s late and who owes what.

3 steps

1
In G2, work out how many days the invoice is overdue as of J1. Unpaid invoices past their due date count; everything else is 0. Fill it down to G13.
2
In J3, count the invoices that are overdue.
3
In J6, total what the client in I6 still owes on unpaid invoices. Fill it down to J9.

Project locked

Pro opens every drill, practice set, scenario, project and section review. One payment, yours to keep.