Profit and Loss Statement Template
Prepare a profit and loss statement from reviewed balances, then download the workbook.
$29,350
Profit for the entered period.
$76,500
$24,680
$4,670
Blank balances count as zero. Entries and downloads stay on this device.
Statement and category totals
| Category | Current | Comparative |
|---|---|---|
| Service income | $125,000.00 | $112,500.00 |
| Direct costs | $48,500.00 | $45,000.00 |
| Interest income | $250.00 | $180.00 |
| Wages and employment costs | $34,800.00 | $31,000.00 |
| Rent | $12,600.00 | $12,000.00 |
| Sales income | $125,000 | $112,500 |
| Cost of sales | $48,500 | $45,000 |
| Gross profit | $76,500 | $67,500 |
| Other income | $250 | $180 |
| Operating expenses | $47,400 | $43,000 |
| Net result | $29,350 | $24,680 |
Set the Period and Statement Categories
This profit and loss statement template calculates the period’s result from your reviewed income and expense balances. An income statement is another name for a profit and loss statement.
Enter the reporting period and comparative period. Compare periods of the same length, or explain the difference in the review notes. State the amounts’ goods and services tax (GST) basis. Changing that label never adds or removes GST from a balance.
Map sales to Sales income and direct production or delivery costs to Cost of sales. Other income holds amounts such as bank interest. Operating expenses holds indirect costs such as rent and administration wages. Rename categories to match the client’s reviewed accounts.
The Business Queensland guide to financial statements explains the distinction between direct costs and operating expenses. The template uses those groups for an internal statement. It does not select the client’s statutory reporting framework or establish compliance with an accounting standard.
Profit and cash can differ. An accrued sale can increase profit before the customer pays. Borrowing cash increases the bank balance without creating sales income. An expense in the accounts also needs a separate tax review before you claim a deduction.
Enter and Check the Result
Gross profit equals sales income minus cost of sales. The net result equals gross profit plus other income minus operating expenses. The tool applies both formulas separately to the current and comparative balances.
The fictional income statement sample starts with sales of $125,000 and cost of sales of $48,500, giving gross profit of $76,500. Interest income adds $250. Wages of $34,800 and rent of $12,600 total $47,400, leaving a net profit of $29,350.
The comparative sample has $112,500 in sales and $45,000 in cost of sales, giving gross profit of $67,500. Other income of $180 less $43,000 in operating expenses leaves $24,680. The current net result is $4,670 higher.
Enter expenses as positive amounts. A credit expense, such as a reviewed refund, uses a negative amount and reduces expenses. A negative sales balance reduces income. Blank balances count as zero. A blank category with non-zero balances needs a name before export.
The calculation retains cents. Headline results and subtotals display whole dollars, while category rows show exact cents. The workbook and print statement retain exact amounts so you can reconcile them to the source balances.
Review and Download
Download Excel XML creates an editable, Excel-compatible workbook with three worksheets. Source balances retains the original entries as text, including source references and review notes. Working balances holds numeric balances and editable categories. Statement links to those balances with formulas for the subtotals and net result.
Open the .xml workbook in a spreadsheet application that supports Excel XML. Edit balances in Working balances and retain Source balances for comparison. Keep the section keys sales, cost, other and expense unchanged. Added worksheet rows need their subtotal ranges extended. This tool does not export an .xlsx file.
Download print statement saves a separate HTML document with both periods and category totals. Open that local file and use the browser’s Print command to print or save a PDF.
Review missing accruals and prepayments against the reporting period. Reconcile opening inventory, purchases and closing inventory before entering cost of sales. Identify private items and decide their accounting and tax treatment separately. The template does not infer those adjustments from the totals.
Business.gov.au’s statement preparation guidance explains the income and expense structure and the need to state the GST basis. Where statutory financial statements are required, select the applicable presentation rules through the Australian Accounting Standards Board’s presentation standard and its scope and commencement provisions.
Entries stay in browser memory. Clear statement, leaving this page or restoring navigation clears them. A downloaded file stays where you save it. Reconcile both periods to the reviewed ledger and record any remaining adjustments before using the statement.