Month-end close documentation — variance commentary, management narratives, board pack summaries — consumes more accountant hours than any other recurring task. The numbers don't change fundamentally: you pull the trial balance, calculate variances, explain the movements, and format the output for whoever's reading it. The same task, every month, for every client. Claude Cowork for month-end close is built exactly for this: document-heavy, structured, repeatable work where the first draft is the bottleneck.
This guide is part of the Claude Cowork for accountants series. It covers the specific month-end close setup in detail: the 6-step workflow, the complete checklist, the variance analysis prompt templates, and a before/after time comparison based on actual CPA firm deployments. For the full list of accounting workflows, see 9 CPA firm Cowork workflows.
The Month-End Close Problem Cowork Solves
Before Cowork
Export trial balance. Open prior period. Build variance spreadsheet manually. Write commentary account by account. Format for client report. Repeat for every client with a monthly close cycle. A 15-account close takes 3–4 hours. In a 20-client practice, that's 60–80 hours per month on close documentation alone.
With Cowork
Drop both trial balances into the Cowork canvas. Set your materiality threshold. Run the Month-End Variance Skill. Review and annotate the output. Export to your report template. A 15-account close takes 45–60 minutes. The same 20-client practice recovers 40–60 hours per month on close documentation.
The 6-Step Cowork Month-End Close Workflow
The following workflow is the standard setup deployed across CPA firms using Claude Cowork for month-end. Each step includes what you do, what Cowork does, and what the output looks like.
Export and Prepare Your Trial Balance Files
Export your current-period trial balance from your accounting system (QuickBooks, Xero, NetSuite, or your client's ERP) as a CSV or Excel file. Export the prior-period comparative as a second file. If you have a budget, export that as a third file. Cowork reads all three simultaneously.
File format: CSV or Excel with columns for account code, account name, and period balance. Cowork handles both debit/credit format and net balance format — specify which you're using in your prompt.
Load Files into the Cowork Canvas
Open a new Cowork session and drag all three files into the canvas. Name them clearly in the session — "current_tb", "prior_tb", "budget" — so your prompts can reference them directly. If you have the QuickBooks or Xero connector configured, you can pull current data directly without the export step.
For the connector setup, see our guide to Cowork + accounting software integration.
Run the Variance Analysis Prompt
Use the variance analysis prompt template (see below) to generate the initial variance calculation and flag material items. Set your firm's materiality threshold — typically a combination of absolute dollar amount and percentage. Cowork calculates all variances and returns only the material ones, with a note on the total number of accounts reviewed.
Variance Analysis PromptGenerate Management Commentary
Once you have the variance list, run the commentary generation prompt. This is where Cowork's value is highest: it writes a professional narrative for each material variance, in the format and tone appropriate for your client's management report or board pack. For a 15-account flagged list, Cowork produces 800–1,200 words of commentary in under 3 minutes.
Commentary Generation PromptReview, Annotate, and Correct
Read through the Cowork-generated commentary. Your review focuses on three things: (1) accuracy of the narrative against your knowledge of the client's business, (2) items where you have context Cowork doesn't — one-off transactions, strategic decisions, known issues — and (3) tone calibration for the specific client (more technical for finance-sophisticated boards, more accessible for owner-managed businesses).
Average review time for a 15-account commentary: 15–20 minutes. You're annotating, not rewriting.
Export to Client Report Template
Use the Cowork Client Report Builder Skill to insert the reviewed commentary into your firm's report template. If you've built the template as a Cowork Skill, this step takes under 5 minutes: specify the client name, reporting period, and any additional notes, and Cowork formats the full document ready for partner sign-off.
Alternatively, copy the commentary into your existing Word or PDF template manually. Either way, you're inserting reviewed, professional prose — not starting from blank.
The Cowork Month-End Close Checklist
Use this checklist to ensure each month-end close run using Cowork meets quality standards before the report reaches the client.
Pre-Close: Data Preparation
Cowork Run: Quality Gates
Pre-Submission: Report Quality
Before vs After: Month-End Time Analysis
The following time comparison is based on deployments at CPA firms managing 10–50 monthly close clients. Individual results vary based on client complexity, trial balance size, and how well-configured the Cowork Skills are.
| Close Task | Manual | With Cowork | Saved |
|---|---|---|---|
| Variance calculation (15 accounts) | 45 min | 4 min | 41 min |
| Management commentary writing | 2.5 hr | 20 min review | ~2 hr 10 min |
| Report formatting | 30 min | 8 min | 22 min |
| Total per close | ~3.8 hr | ~32 min | ~3.2 hr |
For a 20-client practice with monthly closes, that's 64 hours recovered per month — roughly 1.6 full-time weeks of senior accountant capacity redirected to higher-value work. For the full ROI calculation across all close-related tasks, see our Claude Cowork ROI for accountants.
Three Tips for Better Cowork Close Output
1. Add Business Context to Every Commentary Prompt
The single biggest improvement to Cowork commentary quality comes from giving it business context before it writes. If headcount grew by 12 in Q3, if the company launched a new product line, if there was a one-time restructuring charge — tell Cowork. Without context, it writes technically accurate but generic commentary. With context, it writes commentary that sounds like it came from an accountant who knows the business.
2. Build Separate Skills for Different Client Types
A monthly management accounts report for a £5M owner-managed business has a very different tone than a board pack for a $200M private equity-backed portfolio company. Build separate Cowork Skills for each client type, with the appropriate tone, format, and technical depth pre-configured. Switching between client types is then a matter of running the right Skill, not rewriting prompts.
3. Use the QuickBooks/Xero Connector to Eliminate the Export Step
The most significant workflow friction in month-end is the export-upload cycle: pull from the accounting system, save the CSV, upload to Cowork, repeat. The QuickBooks Online and Xero connectors eliminate this entirely. With live data access, you open Cowork and the current trial balance is already available. Setup takes 30–45 minutes once; it saves 10–15 minutes per close session indefinitely. See our accounting software integration guide for setup instructions.
FAQ
Does Cowork work with all accounting software trial balance formats?
Cowork reads any CSV or Excel file that contains account codes, account names, and period balances. QuickBooks Online, Xero, Sage, MYOB, NetSuite, SAP — all export in formats Cowork can read. The main variation is whether balances are presented as debit/credit pairs or net amounts. Specify this in your prompt and Cowork handles both correctly. For systems that don't export clean CSVs, PDF trial balances can also be parsed, though CSV is preferred for accuracy.
How do I handle month-end close for clients with 100+ accounts?
For high-account-count clients, materiality thresholds become more important. Set a dollar threshold that naturally filters to your 15–25 most material items. You can also instruct Cowork to group accounts by category before generating commentary — e.g., generate one narrative paragraph for all payroll-related accounts rather than account by account. This produces commentary at the right level of abstraction for most management reports. If you need account-level commentary for all 100+ accounts (e.g., for audit support), run the prompt in batches of 25–30 accounts.
Can Cowork generate a complete management accounts pack, not just the commentary?
Cowork generates text-based content — commentary, narratives, executive summaries, and formatted text outputs. It does not generate financial statements with embedded charts or produce formatted PDF board packs directly (for that, you'd combine Cowork's commentary with a tool like Claude for Excel or a document automation tool). The most common workflow is: Cowork generates all the narrative content, and your existing report template provides the structure and formatting. If your firm needs a fully automated month-end pack builder, our Cowork deployment service includes custom workflow design for this use case.
Stop Writing Month-End Commentary From Scratch. Every Single Month.
Book a free call with a Claude Certified Architect. We'll walk through your specific month-end workflow, build the Cowork Skills for your firm, and have you saving 3+ hours per close within two weeks.