To move an income statement to Excel, give each period its own column, keep the year-to-date column as printed, store expenses as positive numbers with a sign column that says how each line counts, and tag every row as an item, subtotal or total. Then one formula recalculates net income for each column and compares it with the printed figure.
The worked example is a fictional retailer, Quarry Street Cycles Inc., whose bookkeeper sent a first-quarter 2026 income statement as a PDF with January, February, March and year-to-date columns. Every name and amount is an example. The months add to the year-to-date column, and net income checks in every column.
Income statement layouts clients send: monthly, quarterly and year to date
Income statements arrive in a few standard layouts: one year-to-date column, months or quarters side by side, or a period beside the same period last year. Keep whatever layout the client sent. Give each printed column its own Excel column with the period in the header, and keep the year-to-date column even though it can be recalculated.
Here is the Quarry Street Cycles statement laid out in Excel. Column A tags the row, column B names the section, column C holds the sign (1 for income, -1 for costs and expenses), and the amounts follow.
| A: Type | B: Section | C: Sign | D: Line | E: Jan | F: Feb | G: Mar | H: YTD |
|---|---|---|---|---|---|---|---|
| item | Revenue | 1 | Sales | 42,000 | 38,500 | 51,500 | 132,000 |
| item | Cost of goods sold | -1 | Cost of goods sold | 25,200 | 23,100 | 30,900 | 79,200 |
| subtotal | Gross profit | Gross profit | 16,800 | 15,400 | 20,600 | 52,800 | |
| item | Operating expenses | -1 | Wages | 9,000 | 9,000 | 9,500 | 27,500 |
| item | Operating expenses | -1 | Rent | 3,200 | 3,200 | 3,200 | 9,600 |
| item | Operating expenses | -1 | Utilities | 650 | 700 | 550 | 1,900 |
| subtotal | Operating expenses | Total operating expenses | 12,850 | 12,900 | 13,250 | 39,000 | |
| subtotal | Operating income | Operating income | 3,950 | 2,500 | 7,350 | 13,800 | |
| item | Other income | 1 | Interest income | 40 | 35 | 45 | 120 |
| item | Other expense | -1 | Interest expense | 420 | 410 | 400 | 1,230 |
| total | Net income | Net income | 3,570 | 2,125 | 6,995 | 12,690 |
Keeping the printed year-to-date column gives you a free check. In every item row, January plus February plus March should equal the year-to-date amount: =H2-SUM(E2:G2) returns zero for each row here. A nonzero result means one month was misread, or the year-to-date column includes an adjustment posted outside the three months.
Quarterly layouts work the same way with four columns. A comparative layout, such as March 2026 beside March 2025, needs care with headers, because the current period is not always on the left. Type the period into each header before any formula reads the column.
Expense signs on an income statement in Excel
Expense signs on an income statement in Excel can follow either of two conventions: expenses stored as positive numbers and subtracted by formula, or expenses stored as negative numbers and added. Either works if it is applied to every row. Mixing them, so that some expenses are positive and others negative, is what breaks a net income formula.
Storing expenses as positive numbers matches how many printed income statements look, so the Excel grid can be compared with the PDF line by line. The sign column then carries the arithmetic. In the example, sales and interest income have a sign of 1, and every cost has -1. No amount needs retyping, and anyone reading the sheet sees the same numbers the client printed.
Negative amounts on the page need attention. An income statement may show a refund, a return or a reversal in parentheses inside an expense section, such as (300) under supplies. That is a negative expense, and it should be stored as -300 in the positive-expense convention, so the sign column subtracts a negative and adds it back.
Parentheses can arrive in Excel as text after a PDF conversion, and text amounts drop out of every sum. The fixes for parentheses, dashes and numbers stored as text are set out in balance sheet to Excel pitfalls.
The same item, subtotal and total tagging that keeps a balance sheet's structure also keeps an income statement's; the guide on keeping balance sheet line hierarchy and subtotals in Excel explains the level and line-type columns in detail.
What is a net income check on an Excel income statement?
A net income check on an Excel income statement is a formula that adds every income item, subtracts every cost and expense item, and compares the result with the net income the statement prints. When the two agree, every line was read and placed correctly. When they differ, the gap shows how far off the conversion is.
With the layout above, the check for January is:
=SUMIFS(E:E, $A:$A, "item", $C:$C, 1) - SUMIFS(E:E, $A:$A, "item", $C:$C, -1) - E12
The first SUMIFS adds every item with a sign of 1. The second adds every item with a sign of -1. Row 12 holds the printed net income. Microsoft's SUMIFS function reference explains the paired criteria ranges these formulas use. Copy the formula across to columns F, G and H.
For Quarry Street Cycles, January works out like this:
| Step | Amount |
|---|---|
| Income items: sales 42,000 plus interest income 40 | 42,040 |
| Cost items: 25,200 + 9,000 + 3,200 + 650 + 420 | 38,470 |
| Recalculated net income | 3,570 |
| Printed net income | 3,570 |
| Check | 0 |
The other columns check the same way: February recalculates to 38,535 less 36,410, which is 2,125, and March to 51,545 less 44,550, which is 6,995. The year-to-date column recalculates to 132,120 less 119,430, which is 12,690.
Wrap the check in the ROUND function at two decimals if the statement carries cents, so a floating-point remainder does not show as a difference. Checking the subtotals the same way, gross profit and operating income each against their own items, narrows any difference to one section.
Income statement and balance sheet in one Excel workbook
An income statement and a balance sheet in one Excel workbook can share a single net income figure. Put each statement on its own tab, and point the balance sheet's current-year earnings line at the income statement's net income cell. A correction on the income statement then flows into equity, and the balance sheet check shows whether it still balances.
Name the tabs IS and BS, without spaces. The current-year net income line on the balance sheet then reads =IS!H12, the year-to-date net income for Quarry Street Cycles. Microsoft's page on creating or changing a cell reference describes the sheet-name, exclamation-point, cell form, and the single quotes a sheet name with spaces would need.
The periods must match. A balance sheet as of March 31, 2026 pairs with a year-to-date income statement through March 31, 2026, so the link goes to column H, not to the March column. Linking a balance sheet to a single month's net income understates current-year earnings by every earlier month in the year.
If the business's fiscal year does not start in January, "year to date" means from the first day of the fiscal year. Confirm the start date on the statement header before linking.
Once both statements live in one workbook, a balance sheet that still does not balance after the link has a narrower list of causes. The walkthrough for a balance sheet that does not tie to the trial balance covers dates, mapping and late entries. Comparing several years of linked statements side by side is a separate task; see dollar and percent change columns across statement years.
Income statement to Excel errors from cost of goods sold and other income sections
Income statement to Excel errors cluster in the sections outside the main operating block. Cost of goods sold gets counted twice when its detail lines and its total are both tagged as items. Other income and other expense get dropped because they sit below operating income, often after a page break, where a conversion stops reading.
Cost of goods sold counted twice. Many statements list cost of goods sold detail, such as purchases, freight in and the change in inventory, followed by a total. If the total row is tagged as an item, the net income check comes out short by exactly the cost of goods sold total. In the example, that would be 25,200 in January.
Gross profit added as income. Gross profit is a subtotal. If a conversion tags it as an item with a sign of 1, it is added on top of sales, and January's check would be off by 16,800.
Other income dropped. Interest income, gains on sale of equipment and similar lines often sit in a small block near the bottom. If the conversion stopped at operating income, the check is off by the net of other income and other expense. In January, the missing 40 of income and 420 of expense leave the recalculated figure 380 too high.
Other expense filed as operating expense. Interest expense moved into operating expenses does not change net income, but it does change operating income. Check the operating income subtotal against its items as well as the net income total.
Section headers read as lines. A header such as "Operating expenses" with no amount can pick up the amount from the next row in a poor conversion. A line count that does not match the PDF is the clue.
When should I ask for an income statement export instead of a PDF?
Ask for an income statement export instead of a PDF when the client keeps books in accounting software and someone there can run the report. An export arrives with amounts already in cells, so there is nothing to read from an image. A PDF is fine for a short statement; a scan should be the last choice.
An export is clearly better in three cases. The first is a wide report: twelve monthly columns plus a total will often wrap across pages in a PDF, and putting the pieces back together is slow and easy to get wrong. The second is a long report, with dozens of expense accounts. The third is any report the firm will receive every month, where a standard export saves the same work twelve times.
A PDF is reasonable when the statement is one page with a single column and the client does not have direct access to the books, such as an owner who received the statement from an outside bookkeeper. A scan, or a photo of a printed page, needs the most checking; how character recognition handles scanned statements and where it goes wrong is the subject of financial statement OCR compared with retyping.
Wherever the figures come from, extraction into consistent rows (label, amount, period, section) is what makes the checks above possible; financial statement extraction covers that step in depth. For a business return, the income statement is one item on a longer list, and the small business tax prep checklist shows what else to request alongside it.
When the income statement comes in as one attachment among many, Schema CPA sorts it from the bank statements and receipts around it, reads it, and exports the figures to Excel or CSV for a layout like the one above; the export step in the homepage workflow describes what it sends today.