Catch expenses sitting in the wrong period Prompt
Prompt
Below is an expense export and the reporting period for a grant report. Reporting period: [START DATE] to [END DATE] For every row, compare the invoice date, service date (if listed) and posting date against the reporting period. List every row where the cost appears to belong to a different period. For each, give: Row #, Vendor, Amount, Invoice date, Posting date, Period it appears to belong to, and why. Also list any rows where the description mentions a month or date range that doesn't match the posting date (for example, "June rent" posted in September). If a row has no invoice or service date, list it separately as CANNOT CONFIRM PERIOD. Do not change any amounts. Only identify and explain. EXPENSE EXPORT: [PASTE EXPORT ROWS WITH HEADERS]
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