Who is this assistant for?

Your accountant sends the P&L and you read it like a blood test without a doctor. You have a meeting with the bank or a partner and need to defend your numbers without hesitating. You run two locations and cannot compare one month against another without drowning in tabs.

The P&L arrives from the accountant in a language that is not the owner's, and the decision gets postponed another month. This assistant, pasted into an agent that can read and create files (Claude with Cowork or Claude Code), takes your income-statement spreadsheet as it arrives, audits it (duplicated lines, months that don't reconcile, mixed costs), translates it into the house structure —sales, cost of sales, prime cost, operating expenses, profit— and delivers the verdict with the three lines that took the most profit versus last month. It closes by building you a monthly reading file so the P&L stops being a document and becomes a decision routine.

AI assistant · N5 Complete system

◆ Included in the annual plan🏦 Financial Intelligencev1.2.0 · 2026-08-25🛠 Delivers a file · use in Cowork

This assistant builds files (dashboard, board, report). Use it in Claude with Cowork or Claude Code: paste the prompt there and receive the tool ready. In a plain chat you will get the design and the instructions, not the files. With a paid plan, also download the Universal Kit in My Library: the input these tools start your project with.

📁 Needs an AI that builds files — Claude with Cowork or Claude Code📊 Works best with an AI that reads Excel or Sheets (Claude for Excel, ChatGPT, Copilot in Microsoft 365)

AI P&L Spreadsheet Analyzer for Restaurants

Hand your P&L spreadsheet to the AI and receive the verdict in owner's language: where the profit went, which line got out of control, and a monthly reading file ready to rerun.

Depth

9/23

Your data

Compatible AIs

Steps to use it

Depth of the resulttap a level to see what you get

◀ Put out today's fireRun the year ▶

🏛️

N5Complete system

Several chained pieces you install and operate over time, with their review cadence. It changes how the business runs, not one decision.

◆ This assistant 110 of the 164 published assistants are at this level

Is this for you?

What it does and what you get

The P&L arrives from the accountant in a language that is not the owner's, and the decision gets postponed another month.
This assistant, pasted into an agent that can read and create files (Claude with Cowork or Claude Code), takes your income-statement spreadsheet as it arrives, audits it (duplicated lines, months that don't reconcile, mixed costs), translates it into the house structure —sales, cost of sales, prime cost, operating expenses, profit— and delivers the verdict with the three lines that took the most profit versus last month.
It closes by building you a monthly reading file so the P&L stops being a document and becomes a decision routine.

What you end up with

Three pieces: the spreadsheet audit with each finding and its cell; the month's verdict —the P&L translated into the house structure, the 3 lines that took the most profit versus last month in your currency, prime-cost and break-even traffic lights, and the 5 decisions with owner and deadline—; and the lectura_pyg.html file ready to rerun the reading every month.

EXAMPLE This is what you getAn example built with Sazón de Origen, the house's fictional restaurant.Not your data: your result is built with YOUR restaurant's.See the full example →

Sample result

Sazón de OrigenFictional contemporary Colombian restaurant in Medellín, 2 locations, 6 years in business. Every sample result in the library comes from this same case. Fictional restaurant

The owner asked this: «Here are June and July P&Ls for my two locations. Tell me what changed and where to look first.»

No line gets discussed before its total reconciles. Four of them did not.

Finding	Sheet and cell	Severity	Proposed fix	Who confirms
Norte's rent is charged to both locations in July	P&L!C18 and D18	🔴	Leave it on Norte only; July's total drops 4.2 M	Accountant
«Other expenses» holds 9.2% of sales with no breakdown at all	P&L!row 41	🔴	Split into 4 lines before the next reading	Manager
July delivery came in net of commission and June gross: sales are not comparable	P&L!C6 vs D6	🟡	Redo July gross and move the commission to channel cost	Manager
Depreciation appears in neither month	absent	🟡	Confirm whether it is kept on another sheet	Accountant

Line	June	July	Change in money	Change in %	Traffic light
Sales	148.2 M	141.6 M	−6.6 M	−4.5%	🟡
Cost of sales	46.1 M	47.9 M	+1.8 M	+2.7 pts of sales	🔴
Payroll	34.7 M	32.7 M	−2.0 M	−0.3 pts of sales	🟢
Prime cost	54.5%	56.9%	—	+2.4 pts	🔴
Operating profit	11.3 M	4.1 M	−7.2 M	−4.7 pts	🔴

The 3 thief lines, in money: Centro's cost of sales (−2.9 M, and the file shows purchases flat: that is inventory or waste, not price); double-charged rent (−4.2 M, a recording error, fixed before deciding anything); reclassified delivery commission (−0.9 M, not a new loss — sales that were never yours).

July's break-even, recalculated with the contribution margin from the file itself: 132.4 M a month, that is 4.4 M a day, about 94 covers a day at the 46,900 average ticket the file yields.

SUPUESTO: prime cost is compared against the ceiling this house declared on its own card, not against a sector average. If this house's real ceiling were 3 points higher, July would stop being red and turn amber, and the first decision would change line.

Illustrative example generated with a fictional restaurant. Not a promise of results, not a client case.

This is 2 of 3 parts. Behind the wall are **the decisions template and the three questions for your accountant** —each backed by its cell— plus the lectura_pyg.html file with its NEXT MONTH zone.

See the full example — free account

Works with these AIs

Claude para Excel — the best for this assistant The only one that enters YOUR spreadsheet instead of working on a copy: it reads your tabs, calculates and leaves the result in a new dated tab without overwriting anything. Ask it for the sheet map before it calculates.

How to use it

Open Claude with Cowork or Claude Code and attach your income-statement spreadsheet (one or several months): this assistant READS files and a plain chat cannot.

Copy the full assistant and paste it there; fill in your restaurant data where you see the fields in braces.

Receive the file audit first and confirm the corrections before the verdict.

Receive the owner-language report and the monthly reading file to rerun when the next P&L arrives.

Which of your data it uses

of 23

This assistant works with 9 of the 23 fields in «My Restaurant», among them Restaurant name, Business type and Number of locations. It does not ask out of curiosity: these are what make the answer speak about YOUR scale instead of an industry average — the same calculation on a business of another size returns a number you cannot decide with. You fill them once and they apply across the library, so the second assistant you open already starts with them in place. Whatever you leave blank, the assistant asks for one thing at a time instead of inventing it, and says so before answering, so you know what it is working from.

Restaurant nameBusiness typeNumber of locationsTeam sizeAverage monthly salesApproximate food cost (%)Approximate labor cost (%)Active sales channelsMain goal this year