Manufacturing Income Statement Template

Once the structure is set up, enter your current month's figures. If you're working from a trial balance, map your GL accounts to the pre-built line items — the categories are broad enough to accommodate most manufacturing accounting setups. The formulas calculate gross profit, operating income, and net income automatically as you fill in numbers. Work backward through prior months if you want to populate the Annual Summary and Actual vs Prior Year sheets from the start; otherwise, you can add historical data later.

The standard manufacturing income statement follows a format that cost accountants and lenders recognize: net revenue minus COGS equals gross profit, minus operating expenses (SG&A, R&D, depreciation) equals operating income, minus interest expense equals pre-tax income, minus taxes equals net income. Within COGS, direct materials typically represent 40–60% of revenue in most manufacturing segments, direct labor 10–20%, and overhead 10–15%. When material costs spike — as they did across most manufacturing segments in 2021–2023 — having those components visible as separate line items lets you model the impact of a 5% steel price increase or a labor rate change without rebuilding your entire P&L.