Prompts • Skills • Connectors • Agents • Accounting workflows • Tools
AI Playbook for Accounting Teams
A practical guide to using AI for accounting work, starting with prompts, then skills, connected systems, and recurring tasks.
Start With Your Role
Choose the role closest to your day-to-day work. Start with one useful prompt, make it repeatable, then add the information it needs.
- Start with: close variance narrative or reconciliation-exception triage
- Save as a skill: close narrative with materiality, evidence, and reviewer rules
- Connect: close checklist, GL detail, reconciliation support, owner list
- First agent: daily close-status monitor or reconciliation exception queue
- Measure: close duration, aged breaks, and time spent preparing status
- Start with: invoice exception review or invoice coding recommendation
- Save as a skill: matching rules, coding conventions, approval matrix, and stop rules
- Connect: AP inbox, ERP/AP tool, PO/receipt data, vendor master, policy
- First agent: AP invoice exception coordinator
- Measure: exception cycle time, match rate, and duplicate-payment prevention
- Start with: collections worklist or cash forecast review
- Save as a skill: priority logic, account context, approved outreach, and escalation rules
- Connect: AR aging, payment history, CRM notes, bank balances, forecast
- First agent: collections prioritizer or cash forecast watcher
- Measure: DSO, overdue AR, forecast accuracy, and follow-up time
- Start with: forecast commentary or driver analysis
- Save as a skill: KPI definitions, source hierarchy, assumptions, and narrative format
- Connect: approved actuals, forecast model, KPI dashboard, operating-owner notes
- First agent: forecast variance monitor or month-end narrative drafter
- Measure: commentary preparation time, forecast accuracy, and unresolved drivers
100 AI Prompts for Accounting Teams
Ready-to-use prompts for month-end close, AP, AR, reporting, forecasting, tax, controls, systems, and more. Copy one, add your company context, and review the result.
Prompts for every stage of the close — from journal entries to flux analysis to final review. Copy, paste your data, and get a working first draft.
Variance explanations are tedious to draft. This prompt teaches the AI to: (1) summarize drivers, (2) use cautious language, (3) ask validation questions. Always review & add company context.
Risks: AI may overstate causation or miss context. Control: Senior accountant reviews & edits AI output. Add 1-2 sentences of business context that AI doesn't know.
Large exception lists are painful to triage manually. AI categorizes common patterns quickly. Saves 2-4 hours of manual sorting during close.
Risks: AI may misclassify edge cases. Always review AI categorization before acting. Control: Finance manager reviews all "fraud flag" items.
Close optimization requires systematic analysis. AI suggests automation opportunities & prioritizes by impact and complexity.
Risks: AI may suggest automation where controls are needed. Always layer in control requirements. Engage audit on significant process changes.
Missed accruals are one of the most common close errors. This prompt creates a systematic review against your vendor list so nothing slips through.
Risks: AI estimates are approximations only. Always validate against contracts and PO data. Control: Controller reviews all accrual estimates before posting.
Manual JE review is required for SOX but extremely time-consuming. AI can scan large volumes and flag patterns humans miss when reviewing hundreds of entries.
Risks: AI may flag legitimate entries or miss sophisticated manipulation. This is a screening tool only. Control: Audit manager reviews all AI-flagged items.
Flux analysis is repetitive but critical for catching errors and understanding balance sheet movements. AI generates the initial analysis; you add the context and judgment.
Risks: AI explanations are hypotheses, not facts. Always verify against sub-ledger detail and supporting docs. Control: Controller reviews and edits all flux narratives.
Intercompany reconciliation is one of the most painful close tasks, especially for multi-entity companies. AI matches and categorizes discrepancies systematically.
Risks: AI doesn't know your intercompany agreements or transfer pricing policies. Always validate elimination entries. Control: Corporate accounting reviews all intercompany adjustments.
Prepaid schedules are error-prone because they rely on manual tracking. AI validates the math and flags stale items that should have been fully amortized.
Risks: AI can validate math but doesn't know if underlying contracts changed. Always verify against actual agreements for large-balance items. Control: Senior accountant reviews schedule changes.
The fixed asset roll-forward is a standard audit deliverable. AI structures the calculation and flags anomalies; you verify physical existence and useful life assumptions.
Risks: AI can't verify physical existence of assets. Annual physical inventory counts are still required. Control: Controller approves all disposal and impairment entries.
ASC 606 analysis is complex and documentation-heavy. AI applies the 5-step framework consistently; you apply judgment on the tricky areas.
Risks: Revenue recognition involves significant judgment. AI output is a starting framework, not a conclusion. Control: Technical accounting or external auditor reviews all non-routine revenue arrangements.
Bank recs are required monthly but repetitive. AI matches transactions and identifies reconciling items; you verify the aged and unusual items.
Risks: AI matching is approximate — verify all matches, especially for similar amounts on the same date. Control: Controller or senior accountant reviews completed bank recs.
Close status emails follow the same structure every month. AI drafts the update from your checklist data; you add the judgment calls and context.
Risks: Preliminary numbers may change. Always caveat as "preliminary — subject to final review." Control: Controller reviews before sending. Mark clearly as draft if numbers aren't final.
ASC 842 lease accounting requires monthly calculations that are tedious but follow a consistent pattern. AI builds the entries and schedules; you validate against lease agreements.
Risks: Lease modifications and remeasurements require judgment. AI handles the standard monthly entries but flag any changes for Controller review. Control: Controller reviews all lease accounting entries.
12 Claude-Ready Accounting Skills
These are downloadable Claude Skill packages, not just longer prompts. Each includes a SKILL.md, a practical template, and reference rules your team can tailor. A copy-and-paste version is included for ChatGPT and other AI tools.
Connect Your Work
AI can only help with the information it can see. Start with one system, see what it can do, then add more when you are ready.
Easy start
Start with a limited, low-risk connection your team can test quickly.
- Access: a direct Claude connection to Xero that is read-only
- Useful for: asking about profit, cash, overdue invoices, and customers with links back to Xero
- Setup & limit: it cannot edit invoices, post transactions, or change your books
- Access: early-access coverage for expenses, cards, reimbursements, spend limits, vendor bills, and accounting records
- Useful for: reviewing spend, missing receipts, and approved finance follow-up
- Setup & limit: a Brex admin must enable it; changes are limited by the signed-in user’s permissions
- Access: a permissioned Ramp MCP connection for spend analysis and finance tasks
- Useful for: reviewing spend and approved finance work in the access level of the signed-in person
- Setup & limit: decide which actions your team will allow before turning it on
- Access: commonly used work tools such as Gmail, Drive, Calendar, Outlook, Teams, and SharePoint
- Useful for: policy search, close follow-up, and finding evidence
- Setup & limit: start with a small set of folders, mailboxes, or channels, not the whole company
Needs an administrator
These can be useful, but someone needs to set access and permissions first.
- Access: requires an admin to enable features, install the MCP Standard Tools SuiteApp, and set permissions
- Useful for: a narrow reporting or close question
- Setup & limit: use a limited role; the connector cannot run as NetSuite Administrator
- Access: Sage Intacct’s supported API and web-services routes, not a confirmed one-click AI app
- Useful for: a controlled reporting or analysis integration
- Setup & limit: an administrator must authorize access; build this as an integration project
- Access: the Agentforce Sales ChatGPT app is beta and built for sales teams
- Useful for: sales-related work only when the required Salesforce and ChatGPT licenses are in place
- Setup & limit: do not count on it as a simple finance connection
Integration project
Plan the use case, source data, permissions, and owner before connecting.
- Access: a curated warehouse view exposed through a governed interface; Snowflake documents an MCP server for selected Cortex tools
- Useful for: actuals, KPI data, and forecast drivers from an approved view
- Setup & limit: this is an integration project; start view-only and define allowed fields and questions
- Access: an approved API, report, or file source exposed through MCP or another integration
- Useful for: one small, view-only task with a named owner
- Setup & limit: this is an integration project; document access and permitted actions before building it
Good to know
Useful limits and honest gaps to keep in mind before you connect anything.
- Access: availability differs by AI product, QuickBooks plan, and country
- Useful for: reports, questions, invoices, and other finance tasks
- Setup & limit: keep payments, payroll, and accounting changes with an authorized person
- Access: no official direct ChatGPT or Claude connection is confirmed here; Gusto offers an API for approved integration partners
- Useful for: a payroll-information review after a controlled export or approved integration is in place
- Setup & limit: this is an integration project; Gusto says payroll processing stays in Gusto for user review and confirmation
- Access: a narrow report, export, or vendor-supported API after access rules and technical setup
- Useful for: a view-only close report or exception list
- Setup & limit: this is an integration project, not a one-click AI connection
- Access: no simple official ChatGPT or Claude path for Bill.com is confirmed here
- Useful for: controlled exports or copies that a person checks before they return to the system
- Setup & limit: do not assume an MCP tool can move money or edit a live Excel or Sheets model in place
Tools
Choose the AI tool and accounting software that fit your team. The goal is to make your existing systems easier to use, not replace everything at once.
ERP AI
5AI Assistants & LLMs
912 AI Agents for Accounting
An agent is an assistant for one recurring job. It gathers the right information, follows your process, and prepares the work for someone to review and decide.
A good first agent handles one task your team already does. Give it the information it needs, tell it when to stop, and have a person check the work.
# Daily Close Status Monitor ## Job to be done Give the controller one trusted daily view of close progress and blockers. ## When it runs Every close-day morning and whenever a close task becomes overdue. ## Approved context Close checklist, task tracker, account-owner roster, prior-day status notes. ## Operating loop Read task status; identify overdue, blocked, or unassigned items; compare against the close calendar; group blockers by owner and critical path; draft the escalation list. ## What it delivers A daily close dashboard with completed, at-risk, blocked, and overdue tasks; named owners; due dates; dependencies; and proposed escalations. ## Human owner Controller sets priorities and approves escalations. ## What it must never do Never change task status, reassign work, extend the close, or send an escalation without the controller’s approval. ## How to measure it On-time task completion, number of overdue critical-path tasks, close duration, and time spent preparing status updates. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# Reconciliation Exception Triage ## Job to be done Turn a raw list of reconciliation breaks into a focused investigation queue. ## When it runs When a new unmatched item appears, an item ages beyond threshold, or the reconciler requests triage. ## Approved context Reconciliation tool, GL detail, account support, prior-period notes, account-owner roster, materiality rules. ## Operating loop Classify each break by likely cause; calculate age and amount; identify evidence missing; rank by materiality and risk; assign an accountable owner and proposed next step. ## What it delivers An exception worklist with issue type, amount, age, evidence needed, owner, priority, and review question. ## Human owner Account owner investigates and approves the resolution. ## What it must never do Never clear, write off, book, or reclassify a reconciliation item. Escalate potential fraud or material breaks immediately. ## How to measure it Aged breaks, time-to-resolution, repeat exception rate, and percentage resolved with complete evidence. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# AP Invoice Exception Coordinator ## Job to be done Prepare a complete exception packet so AP can resolve invoices faster without weakening payment controls. ## When it runs A failed three-way match, duplicate-risk flag, missing PO/receipt, or policy exception. ## Approved context Invoice, PO, receipt, vendor master, coding rules, spend policy, approval matrix, prior invoice history. ## Operating loop Compare records; identify the precise mismatch; check duplicate indicators and vendor history; list missing support; determine the correct approval route; draft an internal follow-up. ## What it delivers A review packet showing matched fields, mismatch reason, evidence gap, suggested route, and a draft internal request for information. ## Human owner AP approver decides coding, exception approval, and payment action. ## What it must never do Never release payment, change vendor data, create a vendor, or post coding. Treat bank-detail changes as high-risk independent-review items. ## How to measure it Exception cycle time, match rate, duplicate-payment prevention, touchless-resolution rate, and policy-exception volume. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# Collections Prioritizer ## Job to be done Help AR focus effort on receivables most likely to improve cash collection. ## When it runs Daily aging refresh, missed promise-to-pay date, new dispute, or material balance movement. ## Approved context Open AR, invoice detail, payment history, CRM/account notes, dispute status, approved email templates, credit rules. ## Operating loop Score items using age, amount, payment behavior, dispute status, and account context; identify next-best action; draft internal notes and optional customer outreach for review. ## What it delivers A ranked collections worklist with rationale, owner, next step, due date, and a draft message where appropriate. ## Human owner AR owner approves all customer-facing communication and collection actions. ## What it must never do Never send a customer message, change terms, place an account on hold, waive a charge, or make a credit decision. ## How to measure it DSO, overdue AR, promise-to-pay kept rate, dispute cycle time, and collector time spent on prioritized accounts. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# Cash Forecast Watcher ## Job to be done Surface material cash and liquidity changes early enough for treasury to act. ## When it runs New bank feed, balance threshold breach, forecast refresh, or material AR/AP timing change. ## Approved context Bank balances, cash forecast, AR and AP timing, payment calendar, approved forecast assumptions, covenant thresholds. ## Operating loop Compare current cash and expected flows to the approved forecast; identify timing shifts and threshold breaches; list the assumptions driving the movement; prepare questions for owners. ## What it delivers A cash alert with variance amount, timing, likely drivers, liquidity impact, assumptions, and questions requiring validation. ## Human owner Treasury validates timing, funding decisions, and any proposed action. ## What it must never do Never move money, schedule payment, alter a forecast assumption, or communicate liquidity guidance externally. ## How to measure it Forecast accuracy, alert lead time, number of material surprises, and time to resolve timing uncertainty. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# Forecast Variance Monitor ## Job to be done Give FP&A a repeatable first pass on actual-versus-plan movement and owner questions. ## When it runs Actuals load, forecast refresh, or variance threshold exceeded. ## Approved context Actuals, approved forecast, prior period, driver assumptions, KPI definitions, operating-owner notes. ## Operating loop Calculate variance; identify the largest drivers; separate confirmed driver evidence from hypotheses; compare to prior trend; prepare owner questions and a first-draft narrative. ## What it delivers A driver bridge, material variance summary, confidence level, owner questions, and CFO-ready draft commentary. ## Human owner FP&A confirms drivers, assumptions, and final narrative. ## What it must never do Never change the forecast, publish an official forecast, or state causal conclusions without owner confirmation. ## How to measure it Narrative preparation time, variance explanation coverage, forecast accuracy, and number of unresolved material drivers. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# GL Anomaly Review Queue ## Job to be done Focus accounting review on unusual entries and balances without treating a statistical flag as a finding. ## When it runs New journal posted, period-end load, threshold breach, or scheduled population scan. ## Approved context GL population, chart of accounts, historical patterns, approval records, policy rules, entity and cost-center dimensions. ## Operating loop Apply approved anomaly rules; compare to historical patterns; rank by amount, unusual account combination, timing, user, and policy risk; assemble supporting detail. ## What it delivers A ranked investigation queue with the anomaly reason, evidence links, risk tier, and assigned reviewer. ## Human owner Investigator records disposition; controller reviews material or control-sensitive matters. ## What it must never do Never reverse, post, accuse fraud, or label an item erroneous. A flag is a review request, not a conclusion. ## How to measure it True-positive rate, investigation cycle time, repeat control exceptions, and number of material issues identified before close. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# Month-End Narrative Drafting ## Job to be done Reduce blank-page time for management reporting while keeping finance accountable for the final message. ## When it runs Final review package is available or the reporting calendar reaches the drafting milestone. ## Approved context Approved financials, variance drivers, KPI dashboard, prior narrative, operating-owner notes, reporting style guide. ## Operating loop Extract the relevant approved facts; compare with budget and prior period; organize headline, drivers, risks, and decisions; draft cautious language; list unsupported claims for review. ## What it delivers A first draft of the management report plus a fact-check list and open questions. ## Human owner Finance leader edits, fact-checks, and owns the final message. ## What it must never do Never distribute the narrative, add unapproved forward-looking statements, or infer a business cause without support. ## How to measure it Draft preparation time, edit rate, factual-correction rate, and on-time reporting. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# Audit Evidence Coordinator ## Job to be done Keep PBC requests moving with clear ownership and evidence status. ## When it runs New PBC request, due-date approach, owner update, or evidence upload. ## Approved context PBC list, source files, request descriptions, owners, due dates, audit liaison notes, document repository. ## Operating loop Match each request to owner and source; check whether evidence is present, current, and responsive; flag gaps; draft follow-ups; update the status for liaison review. ## What it delivers An evidence tracker with request, owner, due date, status, source link, gap, and next action. ## Human owner Audit liaison verifies completeness and submits final evidence. ## What it must never do Never certify evidence, alter a document, conceal a gap, or communicate a final response to auditors without the liaison. ## How to measure it On-time PBC completion, re-request rate, days outstanding, and time spent chasing status. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# Policy & Procedure Finder ## Job to be done Give employees grounded answers from approved accounting policies and procedures. ## When it runs A team member asks a policy or process question. ## Approved context Approved policy library, SOPs, effective dates, owner list, revision history, approved templates. ## Operating loop Find the most current relevant policy; answer in plain language; quote or link the applicable source; state exceptions and route unresolved questions to the owner. ## What it delivers A concise answer with source links, effective date, related procedure, and named owner for exceptions. ## Human owner Policy owner handles exceptions and confirms interpretations. ## What it must never do Never invent a policy, override a stated requirement, or issue technical accounting, tax, or legal advice. ## How to measure it Answer usefulness, source-citation rate, policy-owner escalation rate, and recurring question themes. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# Data-Quality Watchdog ## Job to be done Catch source-data issues before they become reporting, forecast, or control problems. ## When it runs Scheduled validation, new file load, data-model refresh, or failed reconciliation check. ## Approved context Data dictionary, exports, validation rules, control totals, prior-period baseline, source-system owner list. ## Operating loop Run approved validation checks; identify blanks, duplicates, outliers, invalid formats, and reconciliation failures; quantify impact; assign issues to source owners. ## What it delivers A data-quality report with issue type, affected records, severity, probable source, and recommended source-level fix. ## Human owner Data owner corrects the source and confirms remediation. ## What it must never do Never modify production data, overwrite source records, or silently exclude bad data from a report. ## How to measure it Issue rate, time-to-remediation, repeat-defect rate, and reporting rework avoided. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
# Vendor & Spend Review Assistant ## Job to be done Turn monthly spend data into an actionable vendor and cost review. ## When it runs Monthly spend refresh, contract renewal window, concentration threshold breach, or procurement request. ## Approved context AP spend, vendor master, contract terms, PO data, budget, renewal calendar, policy limits. ## Operating loop Analyze spend trend, concentration, renewal exposure, price movement, and policy exceptions; separate verified findings from questions; prepare owner-specific follow-ups. ## What it delivers A vendor review with material movements, concentration risks, renewal dates, contract evidence, and recommended questions or actions. ## Human owner Procurement and finance choose negotiation, renewal, sourcing, or policy actions. ## What it must never do Never change vendor terms, approve a vendor, negotiate, cancel a contract, or make a savings claim without owner validation. ## How to measure it Spend under review, renewal coverage, realized versus identified savings, concentration exposure, and review cycle time. ## Operating rules 1. Use only approved sources and follow the linked accounting skill. 2. Cite source records and separate facts from hypotheses. 3. Route missing evidence, threshold breaches, and material exceptions to the human owner. 4. Keep an auditable record of trigger, inputs, output, reviewer, decision, and override. 5. Stop and ask for human review when the policy, evidence, or approval authority is unclear.
AI for Accounts Payable
Where AI can take the manual work out of invoice review, while your team keeps control of payments.
- Prompts: invoice review, exception explanation, vendor-spend analysis
- Skills: AP invoice exception review; invoice coding recommendation
- Connect: ERP/AP, procurement, vendor master, shared invoice inbox
- Agent: AP invoice exception coordinator, prepares and routes, never releases payment
- What AI does: Reads invoice PDF/image, extracts line items, amounts, vendor, dates
- Accuracy: 95%+ on standard formats
- Human review: Always required for payment
- What AI does: Matches PO → Receipt → Invoice automatically
- Flags exceptions: Quantity, price, or date mismatches
- Reduces: Manual matching time by 70%+
- What AI does: Identifies duplicate invoices or duplicate line items
- Prevents: Duplicate payments (high fraud risk)
- Control: Flag for AP review before approval
- What AI does: Detects anomalies (unusual vendor, amount, timing)
- Limitations: Does not prevent fraud; it only alerts
- Must have: Human investigation for flagged items
- What AI does: Routes invoices to correct approvers based on rules
- Accelerates: Approval cycle by 40-50%
- Maintains: Segregation of duties & audit trail
- What AI does: Flags new or high-risk vendors
- Factors: Payment history, concentration, location
- Compliance: Supports sanctions / OFAC checks
AP Implementation Checklist
WorkflowPre-Implementation
- Select 1-2 most repetitive workflows (invoicing, approval)
- Map current process & identify exception handling
- Establish baseline KPIs (cycle time, error rate, cost/invoice)
- Define what "human review" means (invoice review vs. payment auth)
- Train AP team on new tool + workflow changes
Post-Implementation
- Monitor accuracy of OCR & matching for first 100+ invoices
- Log all AI-assisted decisions for audit trail (prompt + output)
- Review fraud flags weekly; refine detection rules monthly
- Measure cycle time, cost/invoice, and error rate vs. baseline
- Re-train team on edge cases & new vendor onboarding
- Human-in-the-loop: All invoices over threshold must have manual approval before payment
- Audit trail: Log all OCR output, matching decisions, and fraud flags with timestamp & user
- Segregation of duties: Approval reviewer ≠ Requester. Payment authorizer ≠ Approver
- Data privacy: Mask PII (SSN, bank account numbers) in stored prompts & outputs
- Accuracy monitoring: Spot-check 5% of AI-processed invoices monthly; escalate errors to vendor
- Reconciliation: Verify all AI-flagged exceptions were investigated & resolved
- Fraud response: Define escalation path for suspected duplicate/fraudulent invoices
AI for Accounts Receivable & Cash
Use AI to focus collections work, spot cash changes, and prepare better follow-up.
- Prompts: collections draft, dispute categorization, cash commentary
- Skills: AR collections worklist; cash forecast review
- Connect: AR ledger, CRM, bank/cash, customer communications
- Agent: collections prioritizer or cash forecast watcher, drafts and flags for review
- What AI does: Predicts customer payment likelihood based on history & behavior
- Improves: Collection timing & resource prioritization
- Typical accuracy: 75-85% on 30-day prediction window
- What AI does: Drafts collection emails, escalation sequences, payment reminders
- Personalization: Tailors message to payment risk & customer segment
- Control: Human review before send; tone & legal review required
- What AI does: Assigns risk score based on payment history, industry, size
- Flags: High-risk customers for tighter credit terms or earlier collection
- Updates: Dynamically as new payment data comes in
- What AI does: Predicts weekly/monthly cash inflows using payment patterns
- Enables: Better working capital planning & liquidity management
- Accuracy: Improves with more historical data (6+ months)
- What AI does: Auto-classifies disputes (quality, quantity, pricing, documentation)
- Routes: To correct resolver (sales, support, finance)
- Reduces: Manual triage time by 60%+
- What AI does: Analyzes deduction reasons & suggests responses
- Flags: Suspicious or repetitive deductions for investigation
- Improves: Recovery rate & customer relationship intelligence
AR & Cash Implementation Checklist
WorksheetPlanning Phase
- Assess data quality (payment history, customer master)
- Identify worst-performing customers (high DSO, delinquency)
- Define cash forecast accuracy baseline (weekly/monthly)
- Map collection workflow & approval process
- Establish customer communication guidelines (tone, frequency)
Monitoring & Control
- Review AI-drafted collection emails before send (legal & tone)
- Track payment prediction accuracy monthly; adjust model if needed
- Monitor forecast accuracy vs. actual inflows; refine model
- Log all AI-assisted decisions with audit trail & user approval
- Measure DSO improvement & cash conversion cycle gains
- Collections communication: All AI-drafted messages reviewed by senior AR person before send
- Escalation protocol: Define thresholds for human intervention (e.g., disputes >10K, legal escalation)
- Customer communication: Maintain tone & brand consistency; no aggressive/automated feel
- Dispute resolution: Track all disputed items; AI categorization is advisory only
- Risk scoring: Review high-risk scores monthly; override if business relationship warrants
- Data privacy: Mask PII in AI outputs; restrict forecast data access to finance team only
- Model monitoring: Measure forecast accuracy monthly; retrain if accuracy drops >5%
AI for Month-End Close & Reconciliation
Use AI to prepare close work, explain variances, and surface items that need attention.
- Prompts: variance narrative, reconciliation exception triage, close gap analysis
- Skills: balance-sheet reconciliation prep; close command center; GL anomaly review
- Connect: ERP/GL, close system, reconciliation support, task tracker
- Agent: daily close monitor; reconciliation exception triage; GL anomaly review queue
- What AI does: Suggests accruals, reversals, reclassifications based on patterns
- Speed: Reduces manual journal entry drafting by 50%+
- Control: Always human-reviewed & approved before posting
- What AI does: Drafts narrative explanations for budget vs. actual variances
- Inputs: KPI table, drivers, one-time items
- Quality: 70-80% requires human editing; catches 90% of obvious drivers
- What AI does: Flags unusual GL balances, journal entries, intercompany transactions
- Detects: Mispostings, duplicates, roundtrip errors
- False positives: Expect 10-20%; requires human investigation
- What AI does: Auto-matches bank transactions to GL, identifies unreconciled items
- Coverage: 95%+ of standard/recurring reconciliations
- Edge cases: Manual review required for unusual/multi-month exceptions
- What AI does: Tracks close task completion, escalates overdue items
- Visibility: Real-time dashboard of close status by task/owner
- Speed: Reduces close cycle by 2-5 days typically
- What AI does: Categorizes reconciliation exceptions (timing, missing docs, errors)
- Recommends: Resolution approach & owner for each exception
- Control: Human signs off on resolution strategy
Close & Reconciliation Control Checklist
ControlsPre-Close Setup
- Define which reconciliations can be auto-matched vs. manual review required
- Establish tolerance thresholds (variance % or absolute amount)
- Map GL account → reconciliation owner & reviewer (segregation of duties)
- Document exception handling process (who investigates, who approves resolution)
- Set baseline for close timeline & define target reduction with AI
Close Cycle Execution
- Review all AI-suggested journal entries before posting (accounting team)
- Approve all variance explanations; add balance-sheet context & audit points
- Investigate all AI-flagged anomalies; document findings & resolution
- Verify auto-reconciliation results; manually validate sample of matches
- Log all AI outputs (prompts, explanations, exception decisions) for audit trail
- Do NOT: Post journal entries without human approval. AI can suggest, never auto-post.
- Do NOT: Make accounting judgment calls (capitalization, revenue recognition, fair value adjustments). Humans decide.
- Do NOT: Rely on AI-generated variance explanations for board reporting. Always have finance team review & add context.
- Do NOT: Override controls for "convenience". If AI can't explain a decision, human must.
- Do NOT: Automate away reconciliation reviews. Control owner must visually verify key reconciliations.
- Do NOT: Use AI to mask or explain away internal control deficiencies. Fix controls first.
- Do NOT: Deduct AI decision time from close budget without adding review/validation time.
AI for Reporting & FP&A
Use AI to prepare scenarios, forecasts, and management commentary. Your team still owns the interpretation.
- Prompts: forecast commentary, board summary, CSV data review
- Skills: forecast driver analysis; scenario planning; KPI commentary
- Connect: planning model, BI dashboards, ERP actuals, approved assumptions
- Agent: forecast variance monitor or month-end narrative drafter
- What AI does: Runs sensitivity analyses, models "what-if" scenarios at scale
- Speed: Tests 100+ scenarios in hours vs. days manually
- Limitation: Assumes historical patterns; unpredictable events still need human judgment
- What AI does: Projects revenue, expense, headcount based on trends & drivers
- Accuracy: 85-95% for recurring items; worse for new/volatile categories
- Control: Always overlay with business logic & management assumptions
- What AI does: Identifies KPI trends, seasonal patterns, inflection points
- Detects: Outliers, accelerations, decelerations vs. historical norms
- Drives: Follow-up questions for business owners
- What AI does: Drafts executive summary of monthly/quarterly results
- Format: Highlights key drivers, misses, opportunities
- Caution: Requires 30-50% human editing; verify data & tone
- What AI does: Formats data, creates charts, drafts story/narrative flow
- Control: CFO must review & own all narratives for board
- Red flag: If you can't explain a chart, remove it or add human context
- What AI does: Auto-generates variance bridge from prior period to current
- Identifies: Largest drivers of change (organic, pricing, FX, M&A)
- Validates: Always reconcile bridge to GL totals manually
FP&A Data Validation Checklist
ControlsBefore AI Analysis
- Reconcile input data to GL & source systems (100% match)
- Validate data completeness (no gaps, periods consistent)
- Flag one-time items, unusual transactions that distort patterns
- Document any manual adjustments or assumptions applied to data
- Review prior forecast accuracy (if available); note systematic biases
After AI Analysis
- Validate forecast reasonableness vs. historical actuals & plan
- Overlay management assumptions (headcount, pricing, M&A, cost inflation)
- Compare AI scenario outputs vs. executive expectations; explain gaps
- Document all assumptions & model versions for audit trail
- Measure forecast accuracy vs. actual; refine model for next cycle
- Data quality: AI forecast accuracy = input data quality. Garbage in = garbage out. Audit data before forecasting.
- Model refresh: Retrain models quarterly; if accuracy drops >10%, investigate & adjust assumptions.
- Seasonality: AI needs 24+ months of data to capture seasonality accurately. Use caution with shorter histories.
- Business context: AI cannot know about planned initiatives, M&A, or market disruptions. Always layer management assumptions.
- Board narratives: AI-generated text should be edited by finance leader; remove jargon & ensure alignment with strategy.
- Scenario sensitivity: Document all assumptions (revenue growth %, cost inflation, headcount). AI can vary them; humans validate logic.
- Trailing edge: Use forecasts for planning, not as "ground truth". History informs; assumptions drive results.
Set Up & Get Running
If you already use prompts, this is how to turn one into a repeatable skill and then a useful first agent. Start with a task that already works.
From prompt to first agent
- Choose a task you already do every week or month
- Use a real example, not a hypothetical exercise
- Good first choices: close variance draft, recon triage, or AP exception review
- Write down what to give the AI, what you want back, and who checks it
- Try the skill on real work at least three times
- Improve it when the result is unclear or a special case appears
- Start with files or reports your reviewer already trusts
- Connect one source at a time and start with view-only access
- Make sure someone owns each source and its permissions
- Start with a monitor or review task, not payments or journal postings
- Set when it runs, then have a person check what it produces
- Track issues found, reviewer changes, and adoption notes
It is useful, low-risk, and easy to check. It gathers close-task status, flags blockers, and prepares a controller’s morning worklist. It does not post entries, make payments, send external messages, or make accounting decisions.
Copy these builders
Use the first after a prompt works. Use the second only after the skill has been tested on real work.
Days 1-30: Foundation
- Assign AI champion (finance manager with tech interest)
- Pick 1 pilot workflow (e.g., AP invoice processing)
- Establish baseline KPIs (cycle time, error rate, cost/transaction)
- Evaluate 2-3 tools; run proof-of-concept
- Document current process & define review controls
- Train 5-10 power users on approved tool
- Deploy to pilot; monitor daily for first 2 weeks
Days 31-60: Expand
- Roll out pilot to full AP team (or first workflow team)
- Launch 2nd workflow (e.g., close variance explanations)
- Integrate tool with ERP / close system (if possible)
- Measure KPI progress vs. baseline; adjust if needed
- Document lessons learned; refine controls
- Create prompt library; publish to team
- Brief audit on AI controls & audit trail setup
Days 61-90: Standardize
- Expand to 3rd workflow (e.g., AR collections or FP&A forecast)
- Finalize & publish AI usage policy
- Establish governance framework (finance AI committee, roles)
- Create SOP docs; train full team on approved workflows
- Document reviewed outcomes, issues, and next-step decisions
- Present results to leadership; plan next wave (new tools, workflows)
- Audit sign-off on controls & 1st cycle proof
Implementation Success Metrics
Measurement30-Day Targets
- Pilot tool deployed to power users (no errors on first 100 transactions)
- Cycle time reduced by 15-20% (vs. baseline)
- Controls documented & tested; audit trail confirmed
- Team feedback collected; 80%+ confidence in tool accuracy
60-Day Targets
- Cycle time reduced by 30% (vs. baseline); error rate cut by 25%
- Tool in production for full team; no workarounds needed
- 2nd workflow piloted & controls validated
- Cost per transaction and license cost, reviewed against the baseline
90-Day Targets
- 3+ workflows running on AI; business case approved for broader rollout
- Cycle time and reviewer effort, reviewed against the baseline
- Governance policy adopted; team trained & compliant
- Audit report: no findings on AI controls. Ready for SAOx testing.
- Leadership buy-in: budget approved for next wave (new tools or workflows)
Week 1: Kick-off email from CFO. Announce AI initiative, pilot workflow, champion name. Explain benefits & address concerns.
Week 2-4: Weekly 30-min team sync. Demo tool, answer Q&A, celebrate early wins. Publish tips & tricks.
Day 30: 30-day review presentation. Show pilot observations, accuracy checks, and team feedback. Answer what went wrong & plan fixes.
Days 31-60: Bi-weekly syncs. Launch 2nd workflow. Publish SOP docs & prompt library. Normalize AI in daily work.
Day 60: 60-day business review. Present to leadership (CFO, CEO, audit committee). Pilot findings, next steps, and a decision on the next wave.
Days 61-90: Monthly syncs. 3rd workflow launch. Policy finalization. Team training on governance.
Day 90: 90-day celebration & planning. Announce results, recognize team, unveil year 2 roadmap.
How the Pieces Fit Together
Start with a prompt. Save the ones that work. Add the systems and files they need. Then use an agent for recurring work, with someone checking the result.
- Ask AI to do one clear task
- Use it for a quick draft, analysis, or explanation
- Check the result before you use it
- Save the step-by-step instructions for a task your team repeats
- Add the information, examples, and review steps that make it useful
- Update it when your process or policy changes
- Bring the right systems, files, and knowledge into the task
- Avoid copying and pasting information by hand
- Start with only the sources the task really needs
- Set a skill to run at a regular time or when something happens
- Gather the information, prepare the work, and flag issues
- Leave approvals, judgment calls, and system changes with people
Where AI Can Help Accounting Teams
Use it to get routine accounting work into a clearer first draft. Keep the accounting judgment and approval with your team.
- Prepare variance explanations from approved figures
- Sort reconciliation exceptions and missing support
- Make an owner-based follow-up list
- Prepare invoice and vendor exception reviews
- Prioritize collection follow-up
- Draft internal worklists and customer-message starters
- Turn approved numbers into first-draft commentary
- Compare assumptions and identify open questions
- Make board and management reporting easier to prepare
- Accounting treatment, payments, entries, and policy decisions
- Final review of anomalies, fraud flags, and supporting evidence
- Any action that changes the books or commits the company
Governance, Controls & Risk Management
Simple rules for using AI safely in accounting.
- AI suggests; humans decide on material transactions
- Define $ thresholds (e.g., invoices >$10K require manual approval)
- Override capability mandatory for all AI recommendations
- Log all overrides for trend analysis
- AI requester ≠ AI approver ≠ payment authorizer
- Close owner ≠ variance explainer reviewer
- Map roles to workflows & validate in system controls
- SAOx / audit testing must include AI-assisted processes
- Log all AI outputs: prompt, timestamp, user, decision, override
- Variance explanation drafts must show AI version + human edits
- Reconciliation exception investigations: log decision & evidence
- Retain logs for 7-10 years (per statute)
- Document all system prompts used for AI analysis
- Version control prompts; track changes (what changed, when, why)
- Publish approved prompts to team; prevent ad-hoc workarounds
- Archive old prompts; audit trail if disputes arise
- Approved tools & approved use cases only
- No PII, confidential data, or bank account details in prompts
- Data residency compliance (where data stored, who can access)
- Consequence for unapproved AI use (retraining, escalation)
- Mask SSNs, bank accounts, customer names in AI inputs
- Use entity IDs or reference numbers instead of PII
- Restrict AI access to only needed GL accounts/cost centers
- Never store confidential data in AI vendor systems without legal review
- AI results contradict known business facts → investigate immediately
- Consistency drop in prediction accuracy → retrain or pause model
- Unexplained variance explanations → remove from draft until fixed
- Repeated same override on same rule → rules need adjustment
- Journal posting (AI suggests; humans approve)
- Fraud investigations (AI flags; humans investigate)
- Accounting judgment (AI informs; humans decide)
- Communication with auditors (humans own, AI supports)
Governance Self-Assessment Checklist
ControlsStrategy & Oversight
- CFO / controller assigned as AI governance sponsor
- Finance AI committee established (accounting, IT, audit, legal)
- Approved list of tools & use cases documented
- AI usage policy drafted & communicated to team
- Training delivered to all finance staff using AI tools
Execution & Monitoring
- All AI prompts documented, versioned, stored in shared repository
- Audit trail enabled on all AI-assisted transactions
- Monthly review of AI outputs (sample of 5-10%)
- Quarterly deep-dive: accuracy trends, override patterns, exceptions
- Data privacy controls in place (PII masking, access restrictions)
Purpose: Define responsible use of AI tools in accounting operations. Ensure controls, compliance, & audit readiness.
Approved Tools: [List specific tools by category, e.g., Bill for AP, FloQast for close, ChatGPT for drafting]
Approved Use Cases:
- AP: Invoice extraction, 3-way match, approval routing, fraud flagging
- AR: Payment prediction, collection drafts, dispute categorization, risk scoring
- Close: Variance explanation drafting, anomaly detection, reconciliation, exception triage
- FP&A: Forecasting, scenario modeling, narrative summaries
- General: Email drafting, policy writing, data analysis, CSV review
Prohibited Use Cases:
- Posting journal entries without human approval
- Making accounting judgment calls (revenue recognition, fair value, capitalization)
- Sending communications to external parties (customers, vendors, auditors) without review
- Using confidential data (PII, bank accounts, contracts) without legal approval
- Unapproved tools or modifications to approved tools
Data Security:
- No PII (SSN, bank accounts, passport numbers) in AI prompts
- Use entity IDs, reference numbers, or masked values instead
- Sensitive data (customer list, contract terms) requires legal review before AI use
- No storage of data in AI vendor systems without data processing agreement
Audit & Documentation:
- All AI prompts versioned & stored in repository (Confluence, SharePoint, etc.)
- Audit trail required: user, timestamp, prompt, output, decision, override (if any)
- Monthly review of AI-assisted transactions (5-10% sample) by finance manager
- Quarterly metrics: accuracy, override rate, cycle time improvement
Training & Compliance:
- Annual training for all users on approved tools & policy
- Role-based training (AP users vs. close accountants vs. FP&A analysts)
- Non-compliance consequences: retraining (first offense), escalation (repeat)
Review & Approval: CFO (sponsor), Finance AI committee, Legal, IT Security