Reconcile a supplier statement against your ledger

By Mezba Uddin (@mezbauddin) — mezbauddin/ai-for-public-prompts (CC BY 4.0) · Source

Submit a prompt

Overview

This prompt compares a supplier statement with a ledger extract that you paste in. It returns a table of invoice numbers, amounts on each side, the difference and a likely cause from a fixed list: missing on ledger, missing on statement, value mismatch or duplicate. The table is sorted with the largest difference first. You get a list of mismatched invoices ranked by size.

Use cases

Prompt
Copied 0
Compare the supplier statement and the ledger extract below. Output a table of: Invoice number, Supplier amount, Ledger amount, Difference, Likely cause (from this list: missing on ledger, missing on statement, value mismatch, duplicate). Sort by absolute difference, largest first.

Statement:
{paste}

Ledger:
{paste}

Can AI?

Alternatives

  • Pull invoice fields into clean JSONThis prompt asks an AI assistant to read an attached invoice and return only JSON with six named fields: supplier, invoice number, date, currency, total and line items. Dates and currency codes have fixed formats, and missing fields come back as null instead of a guess. Parsio offers it in a guide to extracting PDF data with ChatGPT, Claude or Gemini.Document intelligence
  • Audit an ecommerce welcome email seriesA prompt from email marketer Chase Dimond that checks an online store's welcome emails against ten rules, from sending the first email right away to stopping the series after a purchase. You paste your signup popup, each email in sequence with its subject, the preview line, timing and buttons, and whether the series stops on purchase. It returns fixes ranked by likely effect on sales, paste-ready rewrites for the top three in your brand voice, and any rule it could not check.Marketing
  • Extract a shareholder list into JSONThis prompt reads a company register document and returns its shareholders as a JSON array. Each entry has the name, register details, address, date of birth, number of shares, and percentage held, and the prompt includes rules for checking and removing duplicates. Share amounts are assumed to be in euros.Document intelligence
  • Build a weekly chase list and reminders for overdue invoicesBookkeeping Prompts' prompt works from an accounts receivable aging file (aging.csv) to decide who to chase this week. It lists past-due invoices by age and amount with subtotals and moves anything disputed, credited or queried into its own held list. It confirms that the three totals (to chase, held and not yet due) add up to the file total. It then drafts a reminder per customer, friendly, firm or final depending on how late they are, without inventing payment links or fees, and you send them yourself.Business automation
  • Explain a bill, statement or official letter and what to do nextThis prompt helps an ordinary person make sense of financial paperwork such as bills, statements, notices, fee disclosures, invoices and contracts. It works the way a consumer financial counselor or medical billing advocate would. You paste or describe the document, and it explains what it says, points out anything that looks wrong and suggests what to do next. You get a plain explanation and a list of next steps.Personal assistant

Bots that stopped by:✅🔥💡🎯⚠️🐢🍌🦆👾🌮🪐🐱🐶🤖wall