ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Profit and loss statement (P&L)
Excel template · P&L

Profit and loss statement template

Enter revenue and expenses for 12 months: the template calculates gross profit, EBITDA, net profit and each line as a share of revenue.

Updated:
Valtera_PL_template_EN.xlsx · 12 KB · Sheets: Guide, P&L
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_PL_template_EN.xlsx — P&L · Preview with sample data
Profit tax rate0
Line itemJanFebMarAprMayJunJul
REVENUE
Sales revenue52,00048,00061,00066,00070,00064,00058,000
Other income500500500500500500500
Total revenue52,50048,50061,50066,50070,50064,50058,500
Cost of sales30,20027,80035,40038,30040,60037,10033,600
Gross profit22,30020,70026,10028,20029,90027,40024,900
Gross margin42.5%42.7%42.4%42.4%42.4%42.5%42.6%
OPERATING EXPENSES
Payroll and social contributions9,5009,5009,5009,5009,5009,50010,500
Rent2,5002,5002,5002,5002,5002,5002,500
Utilities and telecom600600600600600600600
Marketing1,5001,8002,1001,5001,8002,1001,500
Admin and other1,8001,8001,8001,8001,8001,8001,800
Total operating expenses15,90016,20016,50015,90016,20016,50016,900
EBITDA6,4004,5009,60012,30013,70010,9008,000

What the template includes

  • Revenue: sales and other income.
  • Cost of goods sold and gross profit, gross margin.
  • Operating expenses: salaries, rent, utilities, marketing, admin.
  • EBITDA and EBITDA margin, depreciation, interest expense.
  • Profit tax (rate can be changed) and net profit.
  • Annual totals and each line as a share of revenue.

How to use it

  1. At the end of each month, copy revenue and expenses from your accounting data into the yellow cells.
  2. Enter all amounts excluding VAT.
  3. If you pay simplified tax, set the profit tax rate to 0% and put the simplified tax in the "Admin and other" line.
  4. Watch how margins change month by month: if a margin falls, the cause is in prices, costs of goods or the cost structure.

Profit is not cash. You can be profitable and still run short of cash: to see this, use it together with the 13-week cash flow forecast.

To calculate margin by product, use the product costing template; to calculate profit tax, the profit tax calculator.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.