Receipt Reconciliation & Exception Tracker

Watches Slack and email for receipts, parses card statements, asks once for missing context, and produces a reconciled expense log plus a short exception list for manager review.

financeaccountingexpensesreconciliationreceiptsautomationslackemailocrmonth-end-close

Premium Prompt

Expertly crafted & tested

What the agent does

These are the instructions your agent follows. It asks you for what it needs, then does the work in chat.

Goal

Automate month-end receipt collection and transaction reconciliation. Deliver a fully matched expense tracker ready for accounting import and a short, prioritized exception list that only needs manager attention.

Inputs to gather

• Statement period or date range to reconcile (defines search windows and statement files).
• Slack workspace details: channels/DMs to scan and granted scopes (to fetch receipt messages).
• Email inbox or mailbox to search, plus any labels or search criteria (to pull emailed receipts).
• Card statement sources and formats—file paths, portal URLs, or web credentials (to obtain transactions).
• Payment sources to include (e.g., corporate cards, employee reimbursements) and their cardholder-to-employee mapping (for accurate matching and outreach).
• Chart of accounts, key expense policy rules, and approval routing matrix (for categorization and manager escalation).
• Employee roster with emails/Slack IDs and their direct managers (for one-time receipt/context requests).
• Desired output locations: Google Sheet / Excel workbook name, CSV export path, and a folder for stored attachments (so results land where finance expects them).

Before doing any work, ask the user for these inputs in ONE message. Skip anything they already provided. If they tell you to decide, choose sensible defaults and say what you chose.

Workflow

Confirm and record all provided inputs, highlighting any gaps or ambiguities for immediate user clarification.
Retrieve card transactions for the chosen period via Files or WebFetch; normalize fields (transaction_id, dates, merchant_raw, amount, currency, card_last4, cardholder, memo) and deduplicate.
Search Slack channels/DMs and the specified email mailbox for receipt-like content within the period, download attachments, and capture message metadata (link, sender, timestamp). Also scan designated file folders.
Run OCR on images or scanned PDFs; directly parse digital PDFs/HTML. Extract vendor, total, tax, tip, currency, date/time, last-4, order numbers, employee identifiers, and any project codes. Hash content for deduplication.
Match each receipt to transactions using amount tolerance, date proximity, merchant similarity, and card hints. Score candidates, pick the best match above threshold, and note duplicates or multi-line summaries.
Categorize transactions against the chart of accounts and policy keywords; flag potential violations or missing data (project codes, attendees, etc.).
Build or update the Receipt Tracker Sheet with all normalized fields, match confidence, receipt_status (matched, needs-receipt, ambiguous, duplicate, policy-exception, personal-possible), and source links.
Draft ONE consolidated Slack or email message per employee/cardholder covering every transaction still in needs-receipt, ambiguous, personal-possible, or policy-exception. Request missing receipts, business purpose, project codes, and tip splits; set a clear due date and send.
Monitor incoming replies/uploads; ingest new receipts, re-run parsing and matching, and update tracker statuses accordingly.
Assemble the Exception List of any items still unresolved or out-of-policy after the deadline, summarizing reason codes and linking supporting evidence.
Route the Exception List to the appropriate manager(s) for approve/deny/clarify actions; write decisions back to the tracker.
Export final deliverables: reconciled expense log (CSV + Sheet), exception list (CSV/Sheet), outreach summary, and a timestamped audit log of all actions.
Notify finance/ops of completion with links to outputs and schedule the next reconciliation cycle.
• For lengthy periods or large data sets, pause after Step 7 to show the initial tracker and confirm before sending employee outreach, and pause again after Step 10 for manager review.

Output

A set of files placed at the user-specified destinations:

Receipt Tracker Sheet with fully normalized, categorized, and status-tagged transactions, including links to matched receipts.
Reconciled Expense Log in CSV (import-ready for accounting software).
Concise Exception List (Sheet/CSV) with one-line reasons and evidence links.
Outreach Summary listing who was contacted, when, and outstanding items.
Comprehensive Audit Log detailing data sources, parsing steps, matches, decisions, and exports.

Agentic Workers is a game-changer for anyone! It makes AI feel approachable and useful for everyday people. The library is extensive and you can create your own prompts as well. If you are ready to work smarter, not harder, give it a try!

Mari P

Verified

Key Benefits

Discover how our intelligent prompt chain enhances your workflow

Large time savings through end-to-end automation

Automates the full month‑end flow — confirming scope, ingesting card statements, searching Slack/email/files, OCR/parsing receipts, deduplicating, and scoring matches — so finance teams no longer manually hunt for or attach receipts. The structured matching rules (amount/date/card heuristics, merchant normalization, and tolerance windows) reduce false positives and speed reconciliation. As the system normalizes merchants and maintains hashes/dictionaries, users quickly learn common patterns in their data (e.g., vendor variants, recurring charge formats), further decreasing manual intervention over time.

Manager workload minimized with a short, high‑signal exception list

By scoring matches, applying policy rules, and closing clean matches automatically, the workflow surfaces only true edge cases (no receipt after a single batched request, ambiguous matches, policy exceptions, potential personal spend). The process compiles a focused exception sheet with one‑line reasons and evidence links and provides approve/deny/need‑more‑info actions for managers, letting them decide only the few transactions that need judgment. This concentrated feedback also highlights recurring policy gap areas, enabling managers to learn where policies or employee guidance should be improved.

Single source of truth and accounting‑ready outputs with auditability

Creates and maintains a consolidated receipt tracker (Sheet/CSV) with standardized fields (txn_id, normalized merchant, category, status, links, confidence, notes) and exports reconciled logs ready for accounting import. An audit log records sources, parsing steps, matches and manager decisions, providing transparency for audits and retrospectives. That traceable output accelerates onboarding and teaches users how transactions flow from raw statements to accounting entries, revealing mapping choices and areas to refine (chart of accounts rules, normalization dictionaries, timezone/currency handling).

Higher‑quality employee responses and fewer repeat exceptions

Sends a single, batched outreach per employee with clear instructions, examples and a secure upload path, plus a gentle reminder plan and a due date. OCR confidence checks and re‑upload guidance (flat, well‑lit, full receipt) improve incoming receipt quality; requested fields (business purpose, project code, splits) standardize metadata up front. This one‑shot, structured interaction reduces notification fatigue, increases first‑time completeness, and creates a feedback loop so employees learn how to submit correct receipts — reducing exceptions in future periods.

Transform Your Workflow Today

Join thousands of professionals already using our premium prompts to enhance their productivity.

Unlock premium features instantly

Why This Agentic Worker Is Valuable

10x Faster Results

Save hours of work with our optimized prompt structure that delivers superior results in minutes.

Expert-Crafted

Developed and refined by industry experts to ensure consistent, high-quality outputs.

Consistently Reliable

Tested across multiple AI models to ensure dependable performance every time.

Time Saved

Users report saving an average of 4-6 hours per week using this optimized prompt compared to traditional methods.

ROI Impact

Premium users constantly improvement in their AI output quality and consistency.

Frequently Asked Questions

One click and your agent runs it. Sign in, pick which of your agents should take it on, and it starts the skill in chat — asking you for whatever it needs along the way. No copying, pasting, or browser extension.

Yes. The skill is written as model-agnostic instructions, so it runs on whichever model your agent is configured with, Claude included.

Our prompt chains are expertly crafted and tested across multiple AI models. Unlike single prompts, our chains combine multiple optimized prompts that work together, including specific instructions, context layers, and output formatting. Teams using our prompt chains report 3x better results and seamless collaboration.

The Agentic Workers dashboard automatically tracks your prompt usage, time saved, and output quality. You can view your history and productivity gains directly in your dashboard.

Yes! While the prompt chain is optimized out of the box, you can modify variables and parameters to match your specific use case. The base structure ensures quality results even with customization.

Users report saving 4-6 hours per week using this optimized prompt compared to traditional methods. The structured output and refined instructions eliminate the need for multiple iterations.

We're constantly expanding our library with new prompt chains and features. We release new optimized prompts weekly based on user requests and industry needs. Premium members get early access to new prompts and can request specific prompt chains for their use cases.

Ready to unlock this Agentic Worker?

Join thousands of professionals who are already using our premium prompts to enhance their work.