AR Specialist

Run the full order-to-cash cycle: validating sales orders, creating and issuing invoices, applying cash, resolving billing disputes, aging analysis, dunning, bad debt reserve calculation, credit-risk judgment, DSO tracking, and the AR sub-ledger-to-GL tie-out: with Claude as a supervised collaborator, cutting cycle-time across each stage while improving billing accuracy, cash-application accuracy, and dispute-handling consistency, in direct support of the business's overall cash flow.

Salary Range

$48k-$62k

Lessons

Work Packages

Format

Self-paced

What you will learn

Set up and safely operate Claude for Excel within an AR workflow, including how invoice/remittance/order data enters and leaves Claude.

Use Claude to validate a sales order's pricing, terms, and customer detail against the actual source before it's billed, and recognize a credit-limit issue that needs escalation rather than a silent pass-through.

Use Claude to generate and issue an accurate customer invoice from a validated order, checked against its source before it goes out.

Use Claude to match incoming payments to the correct invoice(s) using remittance detail, and investigate short-pays, partial payments, and unapplied cash rather than defaulting to suspense.

Use Claude to diagnose a billing dispute as a genuine error versus a collections-disguised claim, and draft the correct response for each case.

Use Claude to build a full AR aging analysis, separate genuinely overdue accounts from disputed ones, draft proportional collections/dunning actions, and calculate bad debt reserves against a stated policy.

Use Claude to tie AR trends to cash forecasting via DSO, and to tie the AR sub-ledger to the GL.

Apply governance practices (review-before-send, no untrusted files, never let Claude execute a credit, write-off, or customer communication unsupervised) so AI use strengthens rather than weakens credit and billing controls across the entire order-to-cash cycle.

Speak to AI-enabled, full-lifecycle AR experience in interviews and performance reviews, using portfolio evidence mapped to language employers are already using in job postings.

Lessons in this path

Lesson 1 is free to preview. Remaining lessons unlock after enrollment.

Free PreviewLesson 1

Claude Fundamentals for AR Specialists

Understand what Claude for Excel can and can't do, and how to use it safely with an AR Specialist's data.

Start free preview

Lesson 2

Claude for Excel Skills for AR Specialists

Build hands-on fluency with Claude for Excel's core capabilities: the specific skills every later lesson in this course assumes the learner already has.

Lesson 3

Sales Order Validation & Billing Setup

Review and confirm a sales order's pricing, terms, customer detail, and credit-limit status before it's billed. *(Work Package 27: see `GapSkill_Work_Package_Library.md` for full detail: skill: `sales-order-validation-billing-setup`.)*

Lesson 4

Invoice Creation & Issuance

Generate an accurate customer invoice from a validated sales order, check it against its source, and issue it through the customer's correct channel. *(Work Package 28: skill: `invoice-creation-issuance`.)*

Lesson 5

Cash Application & Payment Posting

Match incoming customer payments to the correct open invoice(s) using remittance detail, and investigate mismatches, short-pays, and partial payments rather than defaulting to suspense. *(Work Package 29: skill: `cash-application-payment-posting`.)*

Lesson 6

Billing Dispute & Error Resolution

Diagnose whether a customer's billing complaint is a genuine invoice error or a collections-disguised dispute, and draft the correct response for each case. *(Work Package 30: skill: `billing-dispute-resolution`.)*

Lesson 7

Accounts Receivable & Collections

Build AR aging analysis, decide and draft collections/dunning actions proportional to age and dispute status, estimate bad debt reserves against a stated policy, and tie AR trends to cash forecasting (DSO). *(Work Package 17: see `GapSkill_Work_Package_Library.md` for full detail: skill: `accounts-receivable-collections`.)*

Lesson 8

Account & Bank Reconciliations

Tie the AR sub-ledger total to the GL and explain any variance. *(Work Package 1: narrowed to the AR sub-ledger tie-out specifically, since the full reconciliation work package belongs to Bookkeeper/Staff Accountant: see `GapSkill_Work_Package_Library.md`.)*

Industry Context

AR Specialist postings span professional services, healthcare (patient billing collections), SaaS/subscription businesses (dunning and churn-adjacent collections), and B2B distribution (high invoice volume, varied customer credit terms). Typical requirements: 1–3 years of AR/collections experience, proficiency in an ERP/accounting system (QuickBooks, NetSuite, Salesforce Billing), strong Excel and communication skills, and increasingly, comfort using AI tools to build aging reports and draft dunning communications rather than doing both by hand. Standard 2026 salary range is $46,000–$60,000, trending toward the higher end with ERP-connector and AI-workflow experience explicitly named in postings.