Invoice Reconciliation Helper

Compare invoices against purchase orders and flag discrepancies

🧪 Tested by a human Beginner 👤 Finance 👤 Accounts Payable 👤 Operations
Compare these invoices against the purchase orders and flag: (1) Amount mismatches (over-billing or under-billing), (2) Missing line items, (3) Incorrect quantities, (4) Duplicate invoices, (5) Invoices without a matching PO. Present discrepancies in a table with invoice number, PO number, expected amount, actual amount, and status. Calculate total discrepancy value.

Works on

⭐ M365 Copilot (Best)

Copy & Open in

Prompt is copied to your clipboard when you click

Tips for Best Results

  • Sort by discrepancy value — address the largest first
  • Check for duplicate invoice numbers across vendors
  • Set up three-way matching as a standard process

📎 More Prompts

Budget Planning Template

●●
Create a budget planning template for [DEPARTMENT] for [FISCAL YEAR]. Include: (1) Revenue categories with line items, (2) Operating expenses by category (personnel, software, travel, training), (3) Capital expenditure section, (4) Monthly and quarterly breakdowns, (5) Variance tracking columns (budget vs actual), (6) Summary dashboard row with key ratios. Add formulas for totals, percentages, and year-over-year comparison.
⭐ M365 🟢 GPT

Cost Reduction Opportunity Analysis

●●●
Analyse our spending data and identify cost reduction opportunities. Review: (1) Subscriptions and recurring costs (look for unused or duplicate tools), (2) Vendor consolidation potential, (3) Process automation savings, (4) Licence right-sizing, (5) Contract renegotiation opportunities. For each opportunity estimate: annual savings, implementation effort, and risk. Rank by ROI.
⭐ M365 🟢 GPT

Expense Variance Analysis

●●
Analyse the expense variance between budget and actual for [PERIOD]. For each line item that varies by more than [THRESHOLD — 5% / 10% / ]: (1) State the variance amount and percentage, (2) Classify as favourable or unfavourable, (3) Explain the likely cause, (4) Recommend whether it is a one-time variance or a trend, (5) Suggest corrective action if needed. Summarise total impact.
⭐ M365
💬