Build a receivables ageing report
Reconcile invoices and receipts, then age outstanding balances at a fixed date.
What you will be able to do
- Reconcile outstanding ₹22000 and overdue ₹18000 as at 30 June 2026.
Suggested preparation: Analyse Excel data with AI ·
Try the task
- Use the supplied due dates, not invoice dates. Outstanding equals invoice less matched receipt. Days overdue equals max(0, review date minus due date). Due today is current.
- Use fictional or permitted inputs. Identify missing information before asking AI to help.
- Attempt the task yourself, then use the prompt to compare methods. Keep the source with your working.
- Check the result against the worked answer and complete the checkpoint. Correct an error before saving completion.
Fictional practice data
Invoice,Party,DueDate,InvoiceAmount,MatchedReceipt I001,Sample A,2026-04-30,10000,4000 I002,Sample B,2026-05-30,12000,0 I003,Sample C,2026-06-30,5000,1000
Try this prompt
At 30 June 2026, match the fictional receipts to invoices and calculate outstanding, days overdue and current/1–30/31–60/61–90 buckets. Reconcile totals and flag missing matches.
Your working notes
Check your result
Use only the supplied facts. This checkpoint validates these specific calculations or decisions; it does not certify professional competence.
Worked answer and review criteria
₹27000 invoices − ₹5000 receipts = ₹22000 outstanding. Sample A ₹6000: 61 days; B ₹12000: 31 days; C ₹4000: current. Overdue total ₹18000.
- Every amount reconciles to the supplied data.
- Missing facts and unsupported conclusions are identified.
- The result can be independently reproduced.
Try the checkpoint yourself before relying on this answer.
What to do next
Read the full practical guide →
Understand what AI can and cannot do →
30-day daily practice plan → · Long-term AI mastery reference →