Latihan Nyata · Automation

An invoice tracker with due-date flags

An invented finance team often bills late because invoices nearing their due date are not visible. Build an invoice tracker sheet with formulas that flag invoices that are almost due and overdue, using AI to help write the formulas. Done means every formula has been tested against edge cases you prepared yourself.

Difficulty: Medium
Time: About 3 hours
Tools: spreadsheet, asisten AI percakapan
Fits: AI Foundations, Finance & Accounting

Learn it first: Spreadsheet formulas that get checked

What you hand in

A sheet of 25 invented invoices with number, fictional customer, issue date, terms and payment status.
Formulas that compute due date, days left and a status label, with a one-sentence explanation each.
A list of at least 6 edge cases (month end, leap year, part-paid, zero terms) with expected and actual results.
A note of any first-draft formula from AI that was wrong or fragile and how you fixed it.

0 of 4 ticked