TOOLS CLUB TEMPLATE

Statement of Owner’s Equity Template

Your balance sheet shows equity as of one date. This statement shows how it got there — starting equity, plus what the owner put in, minus what they took out, plus net income, equals ending equity. It’s the piece that connects your P&L and balance sheet together.

Join the Tools Club — $7/mo Already a Member? Log In

Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Sole proprietors and partners tracking their real ownership stake
Business owners preparing formal financials for a lender
Anyone who has taken owner draws and wants to see the full equity picture
Students learning how the three core financial statements connect

What's included

Beginning equity balance
Owner contributions and draws sections
Net income for the period, pulled from your P&L
Automatic ending equity calculation that ties to your balance sheet

Why use a template instead of starting from scratch?

Equity changes for more reasons than just profit — an owner putting personal money into the business, or taking a draw, both move the number without showing up as a line on the P&L. Tracking these separately, in one place, is the only way to see the complete picture of how equity actually changed.

How to Use This Template

Download and open in Excel or Google Sheets

Requires a Tools Club membership — log in first to access the file.

Enter your beginning equity balance

This should match the ending equity from the prior period’s balance sheet.

Log owner contributions and draws separately

Contributions increase equity; draws decrease it — keep them as two distinct lines rather than netting them together.

Pull in net income for the period from your P&L

This flows directly from your profit and loss statement for the same period.

Confirm the ending equity matches your balance sheet

This is the built-in check that everything ties together correctly.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on whether owner draws are outpacing what the business can sustainably support given its net income trend, no accounting background required.

Common Mistakes to Avoid

Treating owner draws as a business expense

A draw is a distribution of equity, not an expense — it should never appear on the P&L, only here and on the balance sheet.

Netting contributions and draws into one number

Keeping them separate shows the full story — an owner who both contributed capital and took draws in the same period looks very different from one who did neither.

Forgetting to update beginning equity each period

Beginning equity for this period should always equal ending equity from the last period — skipping this creates a disconnect between periods.

Not reconciling to the balance sheet

If ending equity here doesn’t match the equity line on your balance sheet, a transaction was likely missed or miscategorized somewhere.

Frequently Asked Questions

What’s the difference between an owner draw and a salary?

A draw is a distribution of the owner’s equity in the business, typically used by sole proprietors and partnerships. A salary is a business expense, typically used when the owner is on payroll through an S-corp or similar structure. They’re treated very differently for tax purposes — check with a tax professional for your specific situation.

Do I need this statement if I’m the only owner?

It’s still useful even as a sole owner — it’s often requested by lenders, and it’s the clearest way to see whether your draws are sustainable relative to what the business is actually earning.

How does this connect to the balance sheet and P&L?

Net income flows in from the P&L, and the ending equity balance here should match the equity line on your balance sheet as of the same date — the three statements are meant to tie together.

What if I have multiple owners or partners?

Track contributions, draws, and each partner’s share of net income separately by owner if your partnership agreement calls for unequal splits — add a column per partner if needed.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a free Balance Sheet Template if you just need the point-in-time equity figure.

What counts as an owner contribution?

Any personal money or assets the owner puts into the business — cash deposited into the business account, or equipment contributed for business use, for example.

Can equity go negative?

Yes — if draws and losses exceed contributions and profit over time, equity can go negative. It’s worth flagging to a professional if this happens, since it can have tax and legal implications depending on your business structure.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club