Claude Cowork walkthrough

Monthly consolidation in Claude Cowork: email to audited workbook

Entity packs arrive by email, the consolidation file has formulas everywhere, and the summary gets written last at 11pm. This walkthrough shows Cowork reading the packs from your inbox, auditing its own numbers, rebuilding the consolidation and running it again next month on a schedule.

▶ Interactive · 9 steps6 minFor controllers, group finance and FP&A
Click through it. Use Next, the arrow keys or the dots. Orange boxes show where to look.Expand ⤢ for full screen

Illustrative recreation of the Claude Cowork desktop app with fictional sample data. Not the actual product; screens and labels can change as Cowork ships updates.

Nine screens from inbox to scheduled close

The connector setup, the one-prompt report, the consolidation rebuild and the skill that makes it repeatable.

  1. Connect your mailbox

    Add Gmail or Outlook under Customize > Connectors so Cowork can find the monthly entity reporting emails.

  2. Start with read-only permissions

    Read tools on always-allow, write and delete tools on needs-approval.

  3. Write one prompt for the whole report

    Search rule, what to extract, where to save attachments, the summary shape and an audit, in one request.

  4. Check the audit

    Claude tests each headline number against its source and explains any difference before you trust the summary.

  5. Rebuild the consolidation

    Use last year's file as the template. Formulas, eliminations and entity tabs carry over; spot-check totals.

  6. Save it as a skill in a project

    Package the run as a skill and add it to a Monthly Consolidation project with clear instructions.

  7. Rerun with one line

    Inside the project, "run the monthly consolidation" is enough.

  8. Schedule the monthly run

    A scheduled task calls the skill, writes to the project folder and runs on day 3.

  9. Run now and confirm

    Test the task once from its detail page and check the output before relying on the schedule.

How JayOh sets this up

Close automation with controls built in

We map the actual reporting flow first (who sends what, when, in which format), then build the skill and the audit around it. For the revenue data side, see RevOps for finance.

  • Standardize the inbound. One subject convention and one pack template per entity.
  • Template-driven rebuilds. The prior-period file is the spec, so formulas and eliminations stay intact.
  • Audit tab by default. Every run ties consolidated figures back to each pack.
  • Scheduled, then reviewed. The run happens on day 3; a controller reviews flags before anything goes to the board.
Guardrails we set first

Keep a human in the loop

  • Mailbox read-only until drafts are explicitly needed.
  • No auto-send of summaries outside finance.
  • Human review of every flagged variance and of eliminations.
  • Approved folders only for packs with sensitive data.
9screens in this walkthrough
20reconciliation points in the sample audit
$2,130killustrative consolidated revenue
Day 3example scheduled run

Common questions

Short answers before you set this up.

Can Claude Cowork read reports from my email?

Yes, through the Gmail or Microsoft 365 connector. Set the read-only tools to always-allow and keep write tools on needs-approval. Cowork can search by subject, extract figures from the body and save attachments to a folder.

Will Cowork keep my consolidation formulas?

If you give it last year's workbook as the template, it rebuilds the new period with the same structure, formulas and eliminations tab. Always spot-check totals and ask for an audit tab.

How do I make a Cowork prompt repeatable?

Ask Claude to turn a successful run into a skill, add the skill to a project with clear instructions, then rerun it with a one-line prompt or a scheduled task.

Where does Claude Cowork run?

Cowork runs in the Claude desktop app on Mac or Windows on a paid plan. It works on folders you grant it on your computer, can use connectors to apps like Gmail, Google Drive, Slack and HubSpot, and can control a browser or desktop apps when you allow it. The website is Chat, not Cowork.

Want your close running on skills, not heroics?

JayOh designs and builds Claude workflows for finance and RevOps teams, with the audit trail and approvals your controller expects.

Talk to JayOh