Profit and Loss Statement Template Nz

Standard Operating Procedure: New Zealand Financial Reporting — Profit and Loss Statement Template

Document ID: SOP-TR-NZ-FIN-042
Effective Date: October 24, 2023
Version: 3.2
Review Cadence: Annual
Owner: Office of the Chief Architect / Financial Systems Engineering

---

1. Executive Summary & Purpose

This Standard Operating Procedure (SOP) defines the institutional engineering standard for deploying, populating, and auditing a Profit and Loss (P&L) Statement (also designated as a Statement of Financial Performance) aligned with New Zealand regulatory frameworks.

The primary purpose is to ensure absolute structural integrity, compliance with Inland Revenue (IRD) and External Reporting Board (XRB) standards, and elimination of manual accounting discrepancies across all Template Registry subsidiary ecosystems.

---

2. Scope & Prerequisites

2.1 Scope

This document governs all financial performance reporting for legal entities operating under New Zealand jurisdiction, including Limited Liability Companies, Sole Traders, and Partnerships.

2.2 Prerequisites & Environment

• Software Requirements: Microsoft Excel (v2103+), Google Sheets (Enterprise Workspace), or Xero/MYOB API-integrated ledger systems.
• Localization Settings:
  • Currency: New Zealand Dollar (NZD, $).
  • Date Format: DD/MM/YYYY.
  • Tax Framework: Goods and Services Tax (GST) registered at 15% (exclusive of GST in line items; GST movement tracked via dedicated liability accounts).
• Reference Frameworks: XRB Tier 1–4 standards depending on entity scale; IRD Tax Administration Act 1994.

---

3. Roles & Responsibilities (RACI Matrix)

---

4. Step-by-Step Procedure

Phase 1: Template Initialization & Metadata Verification

• 1.1 Download the official Template Registry NZ P&L Master Blueprint (TR-NZ-PL-v3.2.xlsx).
• 1.2 Lock sheet protection layers, keeping only designated data-entry cells unlocked to prevent formula corruption.
• 1.3 Update the Metadata Header block with correct Entity Legal Name, NZBN (New Zealand Business Number), IRD Number, and exact Reporting Period (e.g., 01/04/2023 – 31/03/2024).
• 1.4 Verify currency formatting is locked to [$$-en-NZ]#,##0.00;[Red]($$-en-NZ)#,##0.00;'-' across all financial cells.

Phase 2: Revenue Ingestion (GST-Exclusive)

• 2.1 Input gross operating revenue from primary sales of goods and services into the "Trading Income" sub-ledger, ensuring all figures exclude 15% GST.
• 2.2 Record secondary revenue streams (e.g., interest received, dividends, foreign exchange gains) under "Other Income".
• 2.3 Reconcile total ingestion figures against the Xero/MYOB trial balance summary report for the corresponding tax period.

Phase 3: Cost of Goods Sold (COGS) & Direct Expenses

• 3.1 Enter direct material costs, freight-in, and direct labor attributable strictly to revenue generation.
• 3.2 Calculate Gross Profit via the foundational equation: $\text{Gross Profit} = \text{Total Revenue} - \text{Total COGS}$.
• 3.3 Audit COGS entries against end-of-period inventory stock-take valuations (FIFO or weighted average cost basis).

Phase 4: Operating Expenses (OPEX) Allocation

• 4.1 Populate overhead expenditure lines, categorized strictly in accordance with IRD allowable deduction guidelines:
  • Rent and building outgoings.
  • Communications, software-as-a-service (SaaS), and utilities.
  • Professional fees (legal, accounting, auditing).
  • Marketing and advertising.
• 4.2 Calculate Total Operating Expenses via summation of all OPEX sub-categories.
• 4.3 Derive Operating Profit (EBITDA): $\text{EBITDA} = \text{Gross Profit} - \text{Total Operating Expenses}$.

Phase 5: Below-the-Line Adjustments & Net Profit

• 5.1 Input statutory non-cash adjustments: Depreciation (calculated via Inland Revenue approved rates and diminishing value/straight-line methods) and Amortisation.
• 5.2 Record financing costs (interest paid on business loans, bank fees).
• 5.3 Calculate Net Profit Before Tax (NPBT): $\text{NPBT} = \text{EBITDA} - (\text{Depreciation} + \text{Amortisation} + \text{Interest})$.
• 5.4 Compute provisional or terminal income tax expense based on current NZ corporate tax rates (28% for companies) and transfer to the Balance Sheet retained earnings bridge.

---

5. Quality Assurance & Pro-Tips

5.1 Best Practices

• GST Isolation: Always extract GST from operational line items before population. Mixing GST-inclusive and GST-exclusive figures invalidates the entire reporting structure.
• Audit Trails: Maintain a parallel documentation folder containing bank statements, IRD file receipts, and supplier invoices mapped directly to each P&L ledger code.

5.2 Common Pitfalls

• Private Use Proportions: For sole traders and closely held companies, ensure mixed-use assets (e.g., motor vehicles, home office expenses) are adjusted using IRD-compliant apportionment percentages before final entry.
• Accrual vs. Cash Mismatches: Ensure end-of-year debtors and creditors are correctly journalised if reporting on an accrual basis.

5.3 Metric Thresholds

• Gross Profit Margin Target: Must be benchmarked against industry-specific ANZSIC codes (acceptable variance: $\pm 5%$ year-on-year).
• Variance Alert Limit: Any ledger category displaying a $\ge 15%$ unbudgeted variance requires mandatory manual annotation in the variance commentary section.

---

6. Frequently Asked Questions (FAQ)

Q1: Should the P&L statement include GST-inclusive or GST-exclusive figures?
A: All figures within the Template Registry P&L framework must be GST-exclusive. New Zealand businesses act as collection agents for the IRD; passing GST through income or expense lines artificially inflates financial turnover and distorts performance metrics.

Q2: How do we handle home-office expenses within the template for sole traders?
A: Calculate the total annual household expenses (rent/mortgage interest, power, rates), apply the approved floor-area ratio (or IRD square-metre rate method), and input only the business-allocated portion into the "Occupancy Expenses" ledger line.

Q3: What is the mandatory retention period for financial records under New Zealand law?
A: Under the Tax Administration Act 1994, all records, invoices, and working papers supporting this P&L statement must be retained for a minimum of 7 years from the end of the tax year to which they relate.