Module 7 · Advanced · 10 min read

Profit & Loss and the Balance Sheet

You will be able to: Read Zeyto's Profit & Loss and Trading & profit and loss statements; Calculate gross profit, net profit and margins; Explain why the Balance Sheet balances and where the profit appears.

  • Read not done yet
  • Self-check: not taken not done yet
  • Lesson complete not done yet

The Profit & Loss (P&L) shows what the business earned and spent in a period. The Balance Sheet shows what it owns and owes on a date. Both come from the Trial Balance, so you can build them by hand from lesson 6's figures.

Profit & Loss

  • Reports, Profit & Loss adds up income and expense accounts for the dates you choose and ends in NET PROFIT. A minus figure is a loss.
  • Income accounts show credits less debits, so returns reduce them. Expense accounts show debits less credits, including the cost of goods sold.
  • Only posted documents count, by document date. The only filter is the period. For a month-by-month split or a branch, use P&L - Monthly.
  • Rows do not open. Use P&L - Monthly or the General Ledger report to see the entries behind an amount.
The Profit and Loss report showing income, cost of sales, gross profit, expenses and net profit for the period.

Reports, Profit & Loss: income less cost and expenses.

Reports, Profit & Loss: income less cost and expenses.

The Trading & profit and loss statement shows the same business as two cards. The trading account runs from sales and stock to gross profit. The profit and loss account carries the gross figure over, adds income and takes off indirect expenses to reach net profit. Zeyto posts cost of goods sold as each sale is made, and the stock lines are worked out from the inventory ledger, so both statements show the same profit. If stock moved in some other way, a Stock adjustment row shows the difference instead of hiding it.

Watch outFY to date counts from 1 January and This quarter is a calendar quarter. Neither follows a financial year that starts in another month. Type the From and To dates yourself.
From the Trial Balance to the P&L (AED)Sales 203,000. Cost of sales 90,000. Gross profit = 203,000 - 90,000 = 113,000. Expenses: salaries 20,000, rent 12,000, depreciation 900 = 32,900. Net profit = 113,000 - 32,900 = 80,100. Gross margin = 113,000 / 203,000 = 55.7%. Net margin = 80,100 / 203,000 = 39.5%.

The Balance Sheet

Reports, Balance sheet is cumulative up to the To date. In Zeyto it puts liabilities and capital on the left and assets on the right, each by group, with a Profit & loss account line that holds the profit of earlier periods plus this period. Both sides end in the same total. The Difference tile (assets less liabilities) should be zero. Stock appears once, as Closing stock, at the foot of the assets.

The Balance Sheet report showing assets, liabilities and equity as at a date.

Reports, Balance Sheet: assets equal liabilities plus equity.

Reports, Balance Sheet: assets equal liabilities plus equity.
AssetsAEDLiabilities and capitalAED
Cash and bank60,000Trade payables28,000
Trade receivables45,000VAT output6,000
Inventory30,000Accrued expenses5,000
Fixed assets 60,000 less depreciation 90059,100Share capital100,000
Prepaid expenses22,000Profit for the period80,100
VAT input3,000
Total219,100Total219,100

The equation is assets = liabilities + capital + profit: 219,100 = 39,000 + 100,000 + 80,100. If the Difference tile is not zero, a banner says so. Go back to the Trial Balance and Data health.

TipThe Financial statements tree shows the Trial Balance, P&L or Balance Sheet as a folding tree of accounts. Collapse all gives a summary; the exports keep the groups as you left them.

Keep a simple routine. Compare this month with last month, line by line. A large change in sales, cost of sales or one expense account is either a business event you can explain or an error you have just found.

Try it in the demo

  1. Open Reports, Profit & Loss. Type From and To for last month yourself (do not rely on FY to date) and press Run.
  2. Read Total income, Total expense and NET PROFIT. Work out the net margin.
  3. Open Balance sheet for the last day of that month. What does the Difference tile say?
  4. Open Financial statements (tree) and press Collapse all.
Open the live demo

Public demo company, sign in as admin / demoAdmin123. Data refreshes nightly.

Key takeaways
  • Net profit = total income less total expense; gross profit = sales less cost of goods sold.
  • The Balance Sheet balances because assets = liabilities + capital + profit.
  • FY to date and This quarter are calendar-based; type fiscal dates yourself.
  • Zeyto's Trading & P&L and plain P&L show the same net profit.

Check yourself

4 questions on this lesson. Not timed, not the exam, and you can try again. Score 60% or more, and read the lesson, to complete it.

1. Net profit is:

2. In Zeyto's Profit & Loss report, This quarter means a calendar quarter, even if your financial year starts in another month.

3. Sales are AED 80,000, cost of sales AED 50,000 and other expenses AED 18,000. What is the net profit?

4. Where does the current period's profit appear on Zeyto's Balance Sheet?

Practice questions for this module · Printable study sheet