What are the 3 columns in a balance sheet?

The standard three-column balance sheet contains: (1) the current reporting period balance (e.g., Mar 2026), (2) a comparison period balance — either the prior year equivalent period or the budget for the same period — and (3) a variance column showing the dollar difference. FASB ASC 210 and SEC Regulation S-X Rule 3-01 both require comparative presentation for public companies, making the three-column format the baseline for any auditable or board-level balance sheet.

How do I add a variance column in Google Sheets?

Place your current period balances in column B and comparison period balances in column C, then set column D to `=B7-C7` for each line item. For percentage variance, use `=IFERROR((B7-C7)/ABS(C7),"N/A")` — the `ABS` wrapper prevents sign errors on negative prior-period balances (common with contra accounts). Apply conditional formatting to column D to highlight variances above your materiality threshold; $500K is a reasonable starting point for a mid-size company with $15–50M in assets.

Should I use budget or prior year for the comparison column?

It depends on the audience. Prior year is better for audit packs, lender covenant reporting, and any context where trend matters more than plan adherence. Budget is better for in-year board packs and operating reviews where you're explaining performance against expectations. If you need both, put them on separate tabs rather than adding a fourth column — a four-column balance sheet becomes unreadable quickly and buries the variance that actually matters. --- [Try ModelMonkey free for 14 days](/install) — it works in both Google Sheets and Excel.

Balance Sheet 3 Columns: Structure & Formulas (2026)

The variance column is what separates a reporting artifact from an analytical tool. Without it, your CFO is doing mental arithmetic in the board meeting. With it, you've already flagged that receivables are up $4,217,000 YoY and inventory is down $342,600 — before anyone asks.

Why a Balance Sheet Needs 3 Columns, Not 2

Most templates ship with one column. That's fine for a trial balance, useless for management reporting.

The two-column format — current vs. prior — at least shows direction. But it makes your reader do the subtraction. A three-column balance sheet precomputes it, flags the sign correctly (asset increases are favorable, liability increases aren't always), and makes it scannable in 30 seconds flat.

FASB ASC 210 requires comparative financial statement presentation for public companies, and SEC Regulation S-X Rule 3-01 mandates two years of comparative balance sheet data in annual filings. The three-column format is the practical implementation: current period, comparative period, variance. Every Big 4 audit pack, every PE portfolio review deck, every bank covenant compliance report follows this structure. If yours doesn't, someone is rebuilding it before the meeting.

The column configuration question is binary:

Format	When to use
Current / Prior Year / $ Variance	Standard management reporting, audit prep
Current / Budget / $ Variance	In-year performance reviews, board packs
Current / Prior Year / Prior Year Budget	Rarely — only for multi-scenario reconciliation

Stick with one comparison column per sheet. Two comparison columns make the variance math ambiguous and the layout unreadable on a 1080p screen.

Building a 3-Column Balance Sheet Structure in Google Sheets

The fastest setup: a dedicated Assumptions tab holds your period labels, and the balance sheet tab pulls from it. This way you flip reporting periods by changing two cells, not hunting through 40 formulas.

Tab structure:

Assumptions — period labels, toggle for YoY vs. Budget comparison
BS — the balance sheet itself, with three data columns
GL or TB — the source trial balance data

In BS, columns B, C, and D carry the three balance sheet columns. Column E is a check column (=B5+C5-D5 style — you want this visible during build, hidden in the final pack).

Period header formulas (row 3):

B3: =Assumptions!$B$3          ← "Mar 2026"
C3: =Assumptions!$B$4          ← "Mar 2025" or "FY2026 Budget"
D3: ="$ Variance"

Account balance lookup (assuming your GL tab has account numbers in column A and period balances in columns B and C):

B7: =SUMIFS('GL'!$C:$C, 'GL'!$A:$A, ">="&1100, 'GL'!$A:$A, "<="&1199)
C7: =SUMIFS('GL'!$D:$D, 'GL'!$A:$A, ">="&1100, 'GL'!$A:$A, "<="&1199)
D7: =B7-C7

Accounts 1100–1199 is a typical cash and equivalents range. Adjust the account range to match your chart of accounts.

Current assets block with realistic figures:

Account	Mar 2026	Mar 2025	$ Variance
Cash & equivalents	$3,841,200	$2,104,500	$1,736,700
Accounts receivable	$8,923,400	$4,706,400	$4,217,000
Inventory	$2,147,800	$2,490,400	($342,600)
Prepaid expenses	$318,600	$291,200	$27,400
Total current assets	$15,231,000	$9,592,500	$5,638,500

The parenthetical formatting on inventory is intentional. Inventory decline isn't inherently bad (could be improved turns), but it reads differently than cash growth and should be visually distinct.

Variance Column Formula Conventions

Asset variances: positive = favorable when the balance increased (more cash, more receivables — usually). Liability variances: positive = unfavorable when the balance increased (more debt). The sign convention depends on context, and this is where most balance sheet templates quietly break.

The cleaner approach: don't bake judgment into the variance sign. Just show =Current - Prior, and let the reader interpret direction by account type. Reserve conditional formatting for highlighting absolute changes above a threshold — say, anything over $500K in red or green depending on account class.

For a percentage variance column (optional, useful when balances are very different in magnitude):

E7: =IFERROR((B7-C7)/ABS(C7), "N/A")

The ABS in the denominator prevents sign-flipping when the prior period balance is negative — which happens with contra accounts.

Keeping the Three Statements Tied

The balance sheet doesn't live alone. Cash on your BS should tie to the ending cash on your cash flow statement. Retained earnings should roll from your P&L. If these don't reconcile to within $0.01, you have a model integrity problem.

The three-statement reconciliation is covered in detail in the three-statement model troubleshooting guide, but the short version: build a Checks tab that explicitly computes BS Cash - CF Ending Cash and flags anything outside a 0.01 tolerance. A three-column balance sheet with bad ties is worse than no balance sheet — it gives the wrong answer with confidence.

For the GL wiring, ModelMonkey can pull your trial balance directly into the GL tab, so your SUMIFS always run against fresh period data without a manual export step. It's the difference between a live model and a frozen snapshot.