Latihan Nyata · Data

A monthly report with variance commentary

The head of an invented company wants a monthly profit and loss report that explains why figures differ from budget. Build three months of invented ledger entries and a budget, prepare the report, then use AI to draft variance commentary. Done means every figure traces back to the ledger, every comment matches the data, and the finance lead approves it.

Difficulty: Hard
Time: About 8 hours
Tools: spreadsheet, asisten AI percakapan
Fits: Finance & Accounting

Learn it first: Monthly reports and their commentary

What you hand in

Three months of invented ledger entries with at least 120 journals and a budget per account.
A profit and loss statement for the last month with actual, budget, variance in rupiah and variance in percent.
Variance commentary for each account more than 10 percent off budget, at most three sentences per account.
A trace sheet linking every report figure to its formula and ledger rows.
A note of AI comments that named causes not found in the data, and how you replaced them.
A finance lead's sign-off sheet with date and change notes.

0 of 6 ticked