Format financial statements in Excel: dollar signs, underlines and bold

An income statement or balance sheet can have every number right and still look wrong. Readers who see statements every day expect a few small signals: a dollar sign at the top of a column and on the totals, a thin line before each subtotal, a double line under the final figure, and bold where the eye should land. This page explains those common presentation conventions, shows how to apply them with the toolbar, works through a real example, and lists the mistakes our exercises catch.

Why presentation matters

A financial statement is read top to bottom, often quickly. The formatting tells the reader how the numbers relate to each other before they read a single label. A single line says "the amounts above are about to be added up". A double line says "this is the answer, nothing more is added below". A dollar sign at the top of a column says "everything in this column is money", so it does not need repeating on every line. Bold marks the company, the statement and the result that matters most.

None of this changes a value, but a double line in the wrong place or a dollar sign on every row makes careful work look rushed. These are common presentation conventions rather than rules written into accounting standards, and firms vary on the details, but the pattern below is the one most readers expect.

The conventions at a glance

If you have not worked with the Accounting and Number formats before, the page on the Accounting number format in Excel explains what each one shows and how negatives look.

Dollar signs: top of the column and the totals

Put a dollar sign on the first amount of a column or section, and on the final total. The lines in between get the same thousands separator and two decimals, but no symbol. Because the Accounting format pins the dollar sign to the left edge of the cell, the signs at the top and bottom of a column line up exactly, and the decimal points of every line in between line up with them.

To get "comma style" on the in-between lines, choose Number from the number format list, make sure two decimals are showing (use increase decimals or decrease decimals if not), and turn on negatives in parentheses with the (1) button. The result looks like Accounting without the dollar sign, so the column stays tidy.

Single lines: above each subtotal

A single line marks the point where a list of amounts is added up. It goes under the last amount in the list, which puts it directly above the subtotal. The line belongs to the amount cell, not to the total cell.

In the toolbar, select the last amount before the subtotal and choose Bottom border from the Borders list. Choosing Top border on the subtotal cell gives the same picture on screen, but a bottom border on the last amount is the more common habit, and it is what our exercises look for.

Double lines: under the final total

A double line closes the statement. It goes under the final figure only: net income on an income statement, and both total assets and total liabilities and equity on a balance sheet. Select the total cell and choose Double bottom border from the Borders list. If the cell also needs a single line above it, Top and double bottom border sets both in one step.

Do not use a double line under a subtotal such as gross profit. The double line means "this is the end", and gross profit is not.

Bold: the headings and the result

Bold the company name and the statement title at the top, the section headings (Operating expenses, Assets, Liabilities and equity), and the final total row, both the label and the amount. Select the cells and press the B button. Keep bold for those places only; a statement where half the rows are bold has no emphasis left.

Totals are formulas

Every subtotal and total should be a formula. Gross profit is sales minus cost of goods sold, written as a formula that points at those two cells. Total operating expenses is a SUM over the expense lines. Net income is gross profit minus total expenses. A typed result goes silently wrong the moment someone corrects an amount above it. Our checker reads the formula in each total cell and rejects a typed number, even when the value matches. The page on building an income statement in Excel covers the formulas in more detail.

Worked example: an income statement

Summit Bike Repair's income statement for the year ended December 31, 2026 has the company name in A1, the title in A2 and the period in A3. Sales revenue of 361,163.86 is in B5 and cost of goods sold of 184,193.57 is in B6. Five operating expenses sit in B10:B14. The totals go in B7, B15 and B17.

• Gross profit, B7: =B5-B6 gives 361,163.86 - 184,193.57 = 176,970.29.
• Total operating expenses, B15: =SUM(B10:B14) gives 14,405.29 + 9,031.16 + 3,401.40 + 8,585.20 + 7,059.94 = 42,482.99.
• Net income, B17: =B7-B15 gives 176,970.29 - 42,482.99 = 134,487.30.

Here is the finished statement, with a note on each row about the formatting it carries.

Read down the column and the structure is clear even without the labels. In the free exercise for this lesson the dollar signs are already in place, and your job is the three formulas and the three lines.

Worked example: a balance sheet

The same company's balance sheet at December 31, 2026 shows how the conventions apply when there are two sections and two grand totals. See the balance sheet in Excel page for how the sections are built.

Check it by hand. Assets are 58,491.23 + 35,663.04 + 75,326.37 + 122,535.09 = 292,015.73. Liabilities are 21,939.83 + 793.61 + 14,938.41 = 37,671.85, and adding owner's capital of 254,343.88 gives 292,015.73. The two grand totals agree, which is the whole point of a balance sheet. If they do not, the statement has an error and no amount of formatting will hide it.

Common mistakes and how to fix them

These are the mistakes our exercises check for.

Single line under net income

A single line under the final total makes it look like one more subtotal, as if something else will be added below. Net income takes a double line. Select the cell and choose Double bottom border.

Line under the total instead of above it

Putting the single line under total operating expenses, rather than under depreciation expense, draws the line on the wrong side of the result. The line should separate the list from its total, so it goes under the last amount in the list.

Dollar sign on every line

Applying Accounting to the whole column puts a dollar sign on every row. It is not wrong arithmetic, but it is clutter. Keep the dollar sign on the first amount and the totals, and use comma style in between.

Net income not bold

Net income is the figure most readers look for first. Bold both the label and the amount so it stands out from total operating expenses just above it.

Equity left out of total liabilities and equity

Writing =B16 in the grand total repeats total liabilities and forgets owner's capital. The total then shows 37,671.85 instead of 292,015.73, and the balance sheet no longer balances. The formula needs both parts: =B16+B17.

Single line under the balance sheet grand totals

Total assets and total liabilities and equity are both final totals, so both take a double line. A single line under either one makes the statement look unfinished.

Where this fits in MO-220 practice

Preparing financial statements that others can read combines formulas, number formats, borders and font styles in one task. Our MO-220 practice exercises describe the result a reader expects, such as "a double line under net income", so you learn which toolbar choice produces it. Accounting Exercises is not affiliated with Microsoft or Certiport.