Cut routine close-support tasks (reconciliations, error-checking, journal entries, AR/AP processing) by 40–50% while improving accuracy, using Claude as a supervised collaborator (not a replacement for judgment.
Lesson 1 is free to preview. Remaining lessons unlock after enrollment.
Claude Fundamentals for Staff Accountants
Understand what Claude for Excel can and can't do, and how to use it safely with Staff Accountant's data.
Start free previewClaude for Excel Skills for Staff Accountants
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.
Account & Bank Reconciliations
Match two data sources, identify and explain discrepancies, document resolution. *(Work Package 1: see `GapSkill_Work_Package_Library.md` for full detail.)*
Data Extraction, Cleanup & Categorization
Turn raw, unstructured, or messy financial data into clean, structured, correctly categorized records ready for reconciliation, close, or reporting. *(Work Package 11.)*
Month-End Close Support
Execute the tasks that close the books on schedule. *(Work Package 2.)*
Adjusting Journal Entries: Accruals & Deferrals
Calculate and draft the period-end adjusting entries that get the GL from cash-recorded to accrual-basis correct, with the underlying calculation shown. *(Work Package 14: skill: `adjusting-journal-entries`.)*
Fixed Asset & Depreciation Management
Maintain the fixed asset register and depreciation schedules, and make capitalization vs. expense and disposal decisions correctly. *(Work Package 15: skill: `fixed-asset-depreciation`.)*
Inventory Adjustments & Costing
Apply the correct costing method to inventory, calculate period-end adjustments, and tie the result to COGS and the balance sheet. *(Work Package 16: skill: `inventory-costing-adjustments`.)*
Accounts Receivable & Collections
Read an AR aging report and recognize what needs escalation, without owning the collections process itself. *(Work Package 17: skill: `accounts-receivable-collections`. As of 2026-06-23, full ownership of this work package moved to the AR Specialist role: see `GapSkill_Module_AI-Enabled_AR_Specialist.md` for the full dunning/reserve/DSO depth.)*
Accounts Payable & Vendor Payments
Read a 3-way-match result and a payment run, and recognize an exception that needs escalation, without owning the payment cycle itself. *(Work Package 18: skill: `accounts-payable-vendor-payments`. As of 2026-06-23, full ownership of this work package moved to the AP Specialist role: see `GapSkill_Module_AI-Enabled_AP_Specialist.md` for the full 3-way-match/payment-run/DPO depth.)*
Staff Accountant postings span healthcare/healthcare tech, manufacturing, professional services, and nonprofit sectors, typically requiring a Bachelor's in Accounting/Finance, 1–5 years' experience, and proficiency with NetSuite or QuickBooks plus advanced Excel. Standard 2026 salary range is $68,000–$90,000 (manufacturing runs $75,000–$85,000). The qualifying line increasingly appearing in real postings: "interest in or experience applying AI or automation tools to improve accounting workflows": is exactly what this module is designed to satisfy. (Full source detail in `GapSkill_Standard_Job_Descriptions_2025-2026.md`.)