Tie the report back to your books Prompt
Prompt
Below are (1) the totals from our draft grant report for [FUNDER NAME] and (2) the general ledger totals for the same grant and period. 1. Build a tie-out table: Report line, Report amount, GL amount, Difference. 2. For each difference, list the most likely causes (timing, reclassifications not yet posted, mapping differences, allocations, rounding). 3. Mark each line as TIES, EXPLAINED DIFFERENCE, or UNEXPLAINED. 4. List the specific entries or rows I should check to resolve each UNEXPLAINED difference. Do not adjust any numbers to make them match. Only compare and explain. DRAFT REPORT TOTALS: [PASTE] GL TOTALS FOR THIS GRANT AND PERIOD: [PASTE] ADJUSTMENTS ALREADY MADE THIS QUARTER (IF ANY): [PASTE OR "NONE"]
Watch out for
Risks: AI can misapply funder rules or make math errors, and it only knows what you paste. Control: Your finance lead checks every total against the general ledger and makes all allowability and submission decisions.
Used by
Finance TeamsExecutives