Net Income on a Worksheet: Where Profit and Loss Go
On a 10-column accounting worksheet, net income is the income statement credit subtotal minus the debit subtotal. Enter a profit in the income statement debit column and the balance sheet credit column so both sets of columns balance. For a net loss, reverse it: income statement credit, balance sheet debit. Profit raises retained earnings; a loss lowers them.
The debit placement can look surprising. Revenue normally has a credit balance (see debits and credits for a refresher on normal balances), and earning a profit increases equity. The worksheet debit is simply the amount that brings the smaller income statement column total up to match the larger one, after you have measured profit. The credit in the balance sheet pair shows the increase that will flow into retained earnings.
How to place net income on a worksheet
New to the worksheet? A 10-column worksheet is an informal spreadsheet accountants use at the end of a period. It has five pairs of debit and credit columns: trial balance, adjustments, adjusted trial balance, income statement, and balance sheet. To extend a balance means to copy it from the adjusted trial balance into the income statement or balance sheet columns. The row where you enter the profit or loss is often called the net income line. If the adjustments themselves feel shaky, review adjusting entries first.
First confirm that the adjusted trial balance agrees. Extend each adjusted account balance into one of the two statement pairs, keeping its debit or credit side. Revenues and expenses go to the income statement pair. Assets, liabilities, and equity-related balances go to the balance sheet pair. Once the balances have been sorted, compare the two income statement subtotals.
| Before the balancing row | Result | Income statement placement | Balance sheet placement |
|---|---|---|---|
| Credits exceed debits | Net income | Debit the difference | Credit the difference |
| Debits exceed credits | Net loss | Credit the difference | Debit the difference |
| Debits equal credits | Break-even | No balancing amount | No balancing amount |
The differences in the two pairs must be equal in amount and opposite in direction. All accounts came from a balanced adjusted trial balance. If one pair has $500 more credits than debits, the other pair must have $500 more debits than credits, provided every adjusted balance was extended once to its original side.
How does net income flow into retained earnings?
Use the hypothetical retailer Juniper Stationery from the complete 10-column worksheet example. At March 31, sales revenue is $8,600 and interest revenue is $30. Together they give $8,630 of income statement credits. Cost of goods sold and the other expenses bring income statement debits to $6,020.
| Stage | Income statement debit | Income statement credit | Balance sheet debit | Balance sheet credit |
|---|---|---|---|---|
| Before balancing | $6,020 | $8,630 | $22,930 | $20,320 |
| Net income | $2,610 | — | — | $2,610 |
| After balancing | $8,630 | $8,630 | $22,930 | $22,930 |
The income statement will report $2,610 once as March net income. The worksheet needs the amount twice because it connects two sets of columns. The balancing row itself authorizes no entry in the journal. Posting it as an additional revenue or expense would count a result that the underlying accounts already explain.
So how does the profit actually reach the ledger? Through closing entries. After the statements are prepared, revenue and expense balances are closed into retained earnings, often through a temporary account called Income Summary. Dividends are closed to retained earnings too. The worksheet only previews that result. See closing entries for the four steps.
From the worksheet to ending retained earnings
Juniper began March with $2,000 in retained earnings and declared $400 in cash dividends. Ending retained earnings are $2,000 + $2,610 − $400 = $4,210. The balance sheet uses this ending equity amount. The separate dividends debit on the worksheet tells you how much to deduct when preparing the retained earnings statement.
Don’t expect the worksheet totals to match the formal balance sheet. Juniper’s balance sheet debit column totals $22,930, yet its formal balance sheet reports total assets of $22,260. The worksheet column still includes the $400 dividends debit, and contra-asset accounts such as accumulated depreciation sit in the credit column instead of being subtracted from the assets they reduce. Same accounts, different layout.
How do you show a net loss on a worksheet?
Consider a different hypothetical company, Oak Quay Services. Its income statement credits are $17,200 and its income statement debits are $18,300. Expenses exceed revenue by $1,100. Write $1,100 as a positive number in the income statement credit column. Both sides now total $18,300.
Before balancing, Oak Quay’s balance sheet columns show $28,900 of debits and $30,000 of credits. Place the same $1,100 in the debit column to bring both sides to $30,000. The debit captures a decrease in equity. If beginning retained earnings were $7,000 and dividends were $500, ending retained earnings would be $7,000 − $1,100 − $500 = $5,400.
Can a balanced worksheet still be wrong?
Return to Juniper. A student places its $400 dividends debit in the income statement columns as an expense. Income statement debits rise from $6,020 to $6,420. The student calculates a profit of $2,210. The balance sheet debit subtotal falls by the same $400 because the dividends debit was moved out of that pair.
Both column pairs still balance after the student enters $2,210. To find the error, ask what caused the $400 debit. Juniper distributed earnings to shareholders. A dividend is a distribution of earnings to shareholders, not a cost of earning revenue, so it never belongs in the income statement columns. Move the debit back to the balance sheet debit column and recalculate profit. The corrected net income is $2,610.
A different symptom calls for a different check. Suppose the income statement gap is $2,610 but the balance sheet gap is $2,510. Trace each adjusted balance across its row and retotal the columns. An omitted or duplicated $100 amount is one possibility. Wait until both gaps agree before entering a balancing amount.
Net Income on a Worksheet: Interactive Exercise
Apply the worksheet rules in a separate Uptown example. Practice extending its adjusted trial balance items into the income statement and balance sheet columns, then placing its $12,200 net income.
Choose one answer for each question, then select Check answers. Dr. means debit and Cr. means credit.
Worksheet reminder: The net income balancing row connects the two statement column pairs; it is not a separate journal entry.
Review the source facts
Uptown extends all debit and credit items from the adjusted trial balance into the corresponding income statement or balance sheet columns. It then totals the income statement columns.
Revenues exceed expenses by $12,200, so Uptown has net income of $12,200. To balance the income statement columns, this amount appears in the income statement debit column. Uptown also enters $12,200 in the balance sheet credit column as an increase in retained earnings.
Practice questions and answers
1. Revenue credits are $12,400 and expense debits are $9,950. Where does the difference go?
$2,450 net income. Enter $2,450 in the income statement debit and balance sheet credit columns. The credit-side revenue surplus is the profit for the period.
2. A worksheet shows $14,600 of income statement debits and $13,900 of credits. Beginning retained earnings are $4,000, with no dividends. What is ending retained earnings?
$3,300. The $700 loss belongs in the income statement credit and balance sheet debit columns. Subtract $700 from opening retained earnings.
3. A student enters beginning retained earnings as income statement revenue. Will the worksheet necessarily go out of balance?
No. A credit transferred once to the wrong pair can leave both pairs arithmetically balanced. Beginning retained earnings represent prior periods’ accumulated results. Move that credit to the balance sheet pair before measuring current income.
Key takeaways
- Net income on a worksheet is the income statement credit subtotal minus the debit subtotal, measured before the balancing row.
- A profit goes in the income statement debit column and the balance sheet credit column. A loss goes in the opposite two columns.
- The two gaps must be equal. If they aren’t, find the error before you enter a balancing amount.
- The net income line is not a journal entry. Closing entries move the result into retained earnings.
- Ending retained earnings equal beginning retained earnings plus net income minus dividends. For Juniper: $2,000 + $2,610 – $400 = $4,210.
Frequently asked questions
Is the income statement debit for profit another expense?
No. It is the balancing figure left over after all revenues and expenses have been extended. On the formal income statement, net income appears as the result below the expenses, not as an expense line.
Can I use the adjusted trial balance totals to calculate profit?
No. Those totals include assets, liabilities, and equity as well as revenues and expenses, and they are always equal. Use only the income statement columns to calculate the period’s result.
What if the company breaks even and pays dividends?
The income statement needs no balancing amount. Dividends still reduce retained earnings. With no other changes, ending retained earnings equal beginning retained earnings less dividends.
Why is net income entered as a debit on the worksheet?
Because it is a balancing figure, not an expense. When revenue credits are larger than expense debits, you add the difference to the smaller debit column so both income statement columns match. The matching credit in the balance sheet columns shows that equity went up.
Where do dividends go on a 10-column worksheet?
In the balance sheet debit column. Dividends are a distribution of earnings, not an expense, so they never go in the income statement columns. They reduce retained earnings when you prepare the statement of retained earnings.
For an independent worked illustration, see OpenStax on the income statement and balance sheet worksheet columns.
Learn with Farhat Lectures
Try the free sample course →About the author
Mansour Farhat, CPA, CIA, DBA, is the professor behind Farhat Lectures. He teaches financial accounting, intermediate accounting, and CPA exam topics through this site and the Farhat Lectures YouTube channel.
Responses