Use AI to Explain a Weekly Restaurant P&L: Cash vs Profit

Two copyable prompts, a fictional week with a missing invoice and complete cash notes, the answers a manager should expect, a cash-versus-profit bridge that ties to the bank, and a human review.

Quick answer: an AI assistant can turn a weekly profit and loss statement (P&L) into plain English for a new manager, if the file is complete and labeled, the prompt forces shown calculations and questions instead of guesses, and a person checks the result. Run two passes: the numbers as entered, then the manager's answers to what was missing. The restaurant is fictional; the example answers show what to look for and are not captured from a live AI session.

Pass 1: the file as entered

Harbor Street Noodle Bar is invented. One week in one sheet:

Line	Amount	Note in the file
Net sales	$21,400	After discounts and comps; excludes sales tax and tips
Sales tax collected	$1,391	Owed to the state; not remitted this week
Card tips collected	$2,180	To be paid to staff with next week's payroll
Food and beverage inventory	$5,200 start, $5,800 end	Verified Sunday-night count; includes whatever is left of Saturday's produce
Purchases entered	$7,300	All paid this week
Saturday produce delivery	Unknown	"Invoice in office, not entered"
Hourly wages, manager salary, employer payroll taxes	$5,350, $1,250, $505	Earned and paid this week
Rent	$6,500 a month	Paid on the 1st; nothing paid this week
Card fees	$590	Withheld from card deposits
Supplies, repairs and marketing	$780	Paid this week
Utilities	$520	Estimate; bill not arrived or paid
Loan payment	$900	$180 interest, $720 principal; paid this week
New blender	$1,100	Paid this week

The file also states a fictional accounting policy: equipment of $1,000 or more is a capital purchase, not a weekly expense, and weekly profit is before depreciation and income tax. Real policy is set with your accountant; some businesses would expense a blender.

You are helping a restaurant manager understand one week of results.
Use only the attached file. Do not estimate or invent any amount.
1. Restate the period and every total you used.
2. Build a simple P&L: net sales; food and beverage cost (beginning
   inventory + purchases - ending inventory); gross profit; labor; one
   week of rent (monthly rent x 12 / 52); other operating costs;
   interest; profit before depreciation and income tax. Follow the
   accounting policy in the file. Show each calculation.
3. Show food cost, labor and profit as a percent of net sales.
4. List anything missing or estimated and which way it moves profit.
   Ask me for missing amounts; do not guess.
5. Do not explain the bank balance yet. List the cash information you
   would need to do that.
Plain English. No tax or legal advice.

A good first answer. Food cost: $5,200 + $7,300 − $5,800 = $6,700 (31.3%). Labor: $7,105 (33.2%). Average weekly rent allocation: $6,500 × 12 ÷ 52 = $1,500. With fees, utilities, supplies and interest, costs below gross profit total $10,675. Profit before depreciation and income tax, as entered: $21,400 − $6,700 − $10,675 = $4,025 (18.8%).

It must flag the produce invoice without guessing. Because the verified count already includes whatever produce was left, the missing invoice understates purchases and food cost by exactly its amount, and overstates profit by the same. It should mark utilities as an estimate and ask for deposits, payments and bank balances before discussing cash.

Pass 2: the manager's answers

The produce invoice is $640, due in 15 days, unpaid.
All sales, sales tax and tips collected this week were deposited this week, net of the $590 card fees (so fees are not a separate payment).
No other money moved: no receivables, old bills, tax remittances, tip payouts, owner draws, contributions or transfers.
Bank balance: $18,450 Monday morning, $25,646 Sunday night.

Here are my answers. Update the P&L. Then, using only the file and
these notes, explain line by line why the bank changed by a different
amount than profit, and check it against the two balances. If it does
not tie, say by how much.

A good second answer. Food cost becomes $7,340 (34.3%), and profit before depreciation and income tax $3,385 (15.8%). The bridge:

Bridge item	Amount
Profit before depreciation and income tax	$3,385
Rent counted but not paid this week	+$1,500
Utility estimate not paid	+$520
Produce invoice not paid	+$640
Inventory up from start to end of week	−$600
Loan principal	−$720
Blender (capital purchase under the file's policy)	−$1,100
Sales tax held for the state	+$1,391
Tips held for staff	+$2,180
Bank balance change	+$7,196

$18,450 + $7,196 = $25,646: it ties. Card fees need no line; they are in profit and came out of deposits. Of the $7,196, $3,571 belongs to the state and staff, and rent is due on the 1st.

Red flags: reject the answer if it

fills in an amount for the missing invoice, or does not mention it;
counts sales tax or tips as sales, or card fees twice;
treats loan principal as an expense, or expenses the blender contrary to the file's stated policy;
calls the bank increase profit, or explains cash before it has the cash notes;
explains a cause not in the file, such as weather or a new menu.

If the AI and your records disagree, correct the AI. Change a source record only if you independently verify it is wrong against the invoice, payroll report or bank statement; never change the books to fit the AI.

The human review

Re-add food cost and labor, and recalculate one percentage.
For every flagged item, find the document or label the line an estimate.
Tie the bridge to the bank statement balances.
Save the file, both AI answers and your corrections, initialed and dated.

Tool notes: Gemini as one documented example

Try this with an AI assistant your company has approved for financial records; that is no promise it will read your file correctly. Google's Gemini Apps Help, read September 23, 2026, says:

Up to 10 files per prompt, subject to availability, and up to 100 MB per supported non-video file; a Google AI plan raises some limits. The web app can chart an uploaded spreadsheet.
Very large uploads can produce answers that miss details. One small sheet reduces that risk; it does not remove it.
With a work account, "how your data is handled depends on your Workspace license."

Data handling varies by account, service and edition. Check current official terms and get company approval before uploading real records; practice with fictional data. This is not permission to share payroll or employee personal data: upload totals and remove names, IDs, pay rates and other identifiers. Google also notes Gemini can make mistakes.

Sources

Google, Upload & analyze files in Gemini Apps: file limits, availability and plan notes, charts and large-upload warning. Read September 23, 2026.
Google, Use Gemini Apps with a work or school Google Account: feature availability and data handling depend on your Workspace license. Read September 23, 2026.
The restaurant, its numbers, policy and example answers are fictional and were checked with an independent recalculation for this guide.

Use AI to Explain a Weekly Restaurant P&L Without Mistaking Cash for Profit