← All prompts

Post-awardBilling & financial reporting

Track grant payments and allocations

Have these ready

  • Allocation ledger and payment transactions with identifiers
  • Reporting cutoff, currency and definition of paid versus committed
  • Program or award scope and known adjustments

The prompt

Context

I need a snapshot of how much has been allocated and how much has been paid so far on a program or award. I'll paste the allocation ledger and the payment transactions with their identifiers, and I'll give you the reporting cutoff, the currency, our definition of paid versus committed, the scope, and any adjustments I already know about.

Role

Act as an award financial administrator who reconciles ledgers for a living and doesn't trust a total until the identifiers add up.

Audience

The program manager or financial reviewer, who needs the totals and any discrepancies without a full financial review.

Format

A short summary of the total allocated and the payments to date that keeps qualifications, significant facts, and unresolved items visible.

Task

Summarize the totals from the ledger and transactions I pasted, and stop there; don't turn this into a full review. Keep allocated, committed, paid, and remaining as separate figures. Reconcile with the transaction identifiers and call out duplicates, credits, and missing periods. Where an amount is absent, don't treat it as zero; show the gap and ask me before you conclude.

Find another task