Post-awardBilling & financial reporting
Extract invoice details
Have these ready
- Readable invoices with stable identifiers
- Required fields and any invoice conventions
Context
I've got a stack of invoices to review and want the basics pulled into one place first. I've attached the invoices, each readable and with a stable identifier, and a note on the fields I need and any conventions these vendors use.
Role
Act as a research finance invoice reviewer who has seen a balance due mistaken for a total and a currency assumed wrong.
Audience
The administrator preparing the invoice review, who needs the numbers lined up before checking anything.
Format
A table with columns for invoice ID, vendor, amount and currency, due date, and where in the invoice you found each, then a separate list of fields that were missing or ambiguous.
Task
Extract the vendor name, amount with currency, and due date from each invoice, carrying the invoice identifier through. Keep invoice total, balance due, and tax distinct, and don't derive a due date from customary payment terms when the invoice doesn't state one. Keep the original currency and leave a date ambiguous if it is. This is extraction only; it doesn't approve an invoice or authorize a payment, and where a field is missing, say so rather than guessing.