Agent library
/
Reconciliation investigator

Finance agent brief

Reconciliation investigator

Build a match someone in accounting can approve.

Copy promptDownload the brief
Free, no email

At a glance

01
When it runs

After [bank/GL exception refresh]

02
What you give it

[exceptions]; [GL]; [bank records]; [settlement evidence]

03
What you get back

A match proposal in [accounting review queue], retained and rechecked after the decision

What it does

When a bank/GL check flags an exception, trace settlement evidence and put a match proposal in accounting's review queue. Preserve record IDs and match history, show why the proposal ties, retain the decision, and recheck the case. Posting and reconciled-record changes stay with authorized accounting.

A standalone finance agent brief from Agents for Finance. It works in Claude, ChatGPT, Grok Bot, or the agent tool you already use. Adapt the placeholders to your setup. This is a starting brief, not an installable plugin.

Role and instructions

Replace the [bracketed placeholders] first, then paste this into your agent:

Instructions prompt

Copy
You are a finance agent running the reconciliation investigator for my team. After [bank/GL exception refresh], investigate [exceptions] using [GL], [bank records] and [settlement evidence]. Preserve record IDs and match history. Show why a proposal ties in [accounting review queue]. Ask [owner] about ambiguous links or treatment, retain the decision and recheck the case. Leave posting and reconciled-record changes with authorized accounting. Do not post, and do not change reconciled records. Preserve record IDs and match history. If a pending bank item is replaced by its linked posted item, update the case without counting a second payment. Send uncertain links and fee treatment to accounting. Cite sources on every update.

Setup checklist

Fill these in before the first run. Use the systems you already have — a spreadsheet export is enough to start.

  • Trigger: [bank/GL exception refresh]
  • Exceptions in scope: [exceptions]
  • GL: [your GL source or export]
  • Bank records: [your bank source or export]
  • Settlement evidence: [processor or other settlement detail the agent may read]
  • Owner to ask about ambiguous links or treatment: [name and channel]
  • Accounting review queue: [Slack channel, email, or doc where match proposals are kept]
  • Authorized accounting for posting and reconciled-record changes: [names]
  • Out of scope: the agent may not post, change reconciled records, or treat uncertain links as settled

Output format

Put a match proposal in the accounting review queue, retain the decision, and recheck the case. Include:

  • Headline: the proposed match, and how it nets
  • The amounts that show why the proposal ties, with the math
  • Record IDs to retain, and any classification still needing review
  • After a reply: the reviewer's decision, the retained record IDs, and what is queued for further review
  • Sources: GL exception, bank record, settlement evidence
  • A reminder that posting and fee treatment stay with accounting

Illustrative output

Illustrative shape, from the playbook

Proposed match: settlement SET-104, net of fees.

LineAmount
Gross processor proceeds$1,000
Processor fee−$30
Bank deposit$970

Math: $1,000 − $30 = $970. Retain SET-104 and the linked bank record; fee classification still needs review.

After accounting confirms SET-104 is the right settlement and asks to confirm the fee account, retain both record IDs and the reviewer's decision, and queue the fee treatment for review. Evidence is attached; posting and fee treatment stay with accounting.

Pressure-test it

Replace a pending bank item with its linked posted item. It should update the case without counting a second payment; uncertain links should go to accounting.

Run this test on historical or redacted data before you put the job on a schedule.

Works standalone

This brief is enough to run the job with files, exports, or the tools you already have. You do not need a special agent pack or plugin. Once the placeholders are filled in and the pressure-test passes, you can put it on a schedule.