Restaurant P&L analysis: find the drivers of profit

Restaurant P&L analysis explains how net sales become profit through food, labor, occupancy and other expenses. Compare locations over the same trading period, calculate their cost rates, and reconcile the profit movement before assigning an action to a manager.

The useful question is specific: did a location earn less because it sold less, spent more for each sales dollar, or carried costs that did not adjust? The general P&L analysis method covers the statement line by line; restaurant analysis adds prime cost, trading calendars and location mix.

Start with comparable exports

Bring the location P&L export, sales summary, inventory movement report and payroll detail. Keep location identifiers and period dates in every file. A payroll payment date is not the same as the date employees earned their wages.

The SEC's financial statement guide distinguishes an income statement, which measures a period, from a balance sheet, which records a point in time. That distinction matters when a food delivery arrives before the period closes but remains unused in storage.

Use a consistent reporting map:

Food purchases alone are not food consumption. The IRS explanation of cost of goods sold subtracts closing inventory from goods available for sale. Use that inventory logic for the management reconciliation, while keeping any tax-specific accounting choices separate.

Build a location comparison

Consider a fictional US restaurant company with two locations. Budget and actual both cover the same four-week operating period. All amounts below are USD. Other expenses include every remaining location operating expense under the company's policy; financing, income tax and corporate costs are outside this location measure.

In a worksheet, put the four location rows in rows 2 through 5, with location in A, period in B, sales in C and the four cost categories in D:G. Location profit in H2 is:

=C2-SUM(D2:G2)

Prime cost percentage in I2 and location margin in J2 are:

=(D2+E2)/C2
=H2/C2

Fill down. For a location with no sales, flag the ratio as undefined rather than reporting zero. To total actual sales without including budget rows:

=SUMIFS(C2:C5,B2:B5,"Actual")

Microsoft documents SUMIFS as summing amounts that meet specified criteria. Covirage is not affiliated with Microsoft.

Read prime cost before blaming sales

The ratios below use the preceding cost and sales rows. Percentages are rounded to one decimal place after calculation.

Company sales are unchanged, but prime cost rises from $187,200 to $198,300. Downtown has higher sales and lower profit. Lakeside's absolute labor cost falls, yet labor takes a larger share of its reduced sales. Cutting dollars does not necessarily restore the cost rate.

Always divide company totals. Averaging the two location margins would give each site equal weight regardless of sales. For a business with merchandise returns and markdowns, retail P&L analysis applies a different operating lens.

Prove the profit movement

Use actual sales multiplied by each location's budget cost rates as the comparison baseline. This is an arithmetic bridge, not a claim that every labor or other expense varies directly with sales.

Downtown's budget food, labor and other rates total 77%, leaving 23% before occupancy. Its extra $10,000 of sales therefore contributes $2,300 at budget rates. Lakeside's corresponding rates total 78%, so its $10,000 sales reduction removes $2,200. Together, sales moving between the sites adds $100.

The independent check is $300,000 of sales minus $274,400 of costs, also $25,600. The location profits must sum to that amount and reconcile to the corresponding ledger accounts. Use flux analysis to investigate individual account movements behind an unexplained difference.

Assign the food variance to purchasing and kitchen operations for investigation, and the labor variance to operations and payroll. Separate supplier prices, waste and portion changes before changing menu prices. Review schedules against covers and opening hours before treating the full labor-rate movement as excess staffing.

Where it goes wrong

• Unequal trading periods. Different weekday counts, closures or a payroll week crossing the cutoff can look like an operating change.
• Purchases counted as consumption. A stock build raises purchasing without necessarily raising food consumed; missed spoilage can overstate closing stock.
• Changing labor definitions. Moving employer taxes or management salaries between categories breaks prime-cost comparisons.
• Unreconciled deductions. Discounts, refunds, sales tax and amounts collected for others need a consistent treatment before comparing sales with costs.
• Location profit presented as company net income. Corporate costs, financing and income taxes still need their own bridge.

Analyze your restaurant exports in Covirage

Upload your location sales and cost workbook, including the budget and matching periods. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, then set up your business and bring a sample of your own data.

See Covirage for hospitality teams for the supporting industry context.