← All use cases

Use case B26 · Business

Branding agency replaces its Excel project accounting with a system built with Claude

Moloko (branding agency) ·

The short version

What they did

The agency’s finance and project accounting had lived in several Excel spreadsheets. Using Claude, it built an internal system that tracks projects, stages, team assignments, time, billing status, client payments, and profitability by project and by period. The post’s author is not named on the page.

Result (as claimed)

“What changed: the hours previously spent on formula maintenance, cell formatting, and version reconciliation now go toward actual project work.” No figures are given.

Prompt

I run a small branding agency. Our project accounting is spread across Excel files: [attach project, time and billing sheets]. Last month’s finished numbers are [attach]. Help me build a simpler tool from these records.

1. Propose tables and fields for projects, stages, team assignments, hours, amounts billed, payments and profit by project and month.
2. Ask me how we calculate labor costs and profit, and clarify any unclear fields before building.
3. After I approve the layout, make the first version as one workbook with clear tabs. Explain how to compare its totals with last month’s sheets.

Use plain labels and include a short guide. Preserve the original files. Don’t treat unpaid invoices as money received or invent missing rates. List assumptions and differences for my review.

Do it yourself

These steps are my suggested way in, not Moloko’s setup.

Level: Intermediate for a working tool. A cleaner project spreadsheet is Beginner.

What you need

  • Your current project, time and billing spreadsheets.
  • A chat assistant that can read files and build simple tools, such as Claude or ChatGPT.
  • Last month’s numbers, to test against.

Start simple

  1. List what you need to see: projects, stages, people, hours, billed, paid and profit.
  2. Paste the Prompt into a chat and answer its questions about how you work.
  3. Ask it to propose the tables and fields first. Fix anything that doesn’t match your business.
  4. Have it build a first version as one spreadsheet with clear tabs.
  5. Load last month’s data and compare profit by project with your old sheets.

Take it further

  • Ask it to turn the spreadsheet into a small web tool your team can use, if the sheet starts to strain.
  • Add a monthly report of profit by project and by client.
  • Add a list of unpaid invoices by age.

Check your work

  • Totals for hours, billed and paid must match your old sheets and your accounting software to the dollar.
  • Pick two projects and work out their profit by hand.
  • Keep your accounting software as the record for invoices and taxes. This tool is for decisions.

Before you rely on it

  • This is general information, not financial, tax or accounting advice for your situation.
  • AI tools make arithmetic mistakes and misread statements, and they sound just as sure when they do. Check every number against your own records before you act on it.
  • For decisions with tax, loan, insurance or retirement consequences, talk to a qualified professional who knows your situation.

Source checked. The link, author, date and quote were confirmed against the source. The result itself has not been reproduced. Prompt adapted for this library, inspired by the case. Business size: Not stated. Results are quoted as the source claimed them and never improved. Spot an error or a broken link? Email charlie@cbarmorecpa.com.

More in Finance for owners

New cases go out every Saturday in Inside AI.