Free Excel template · ASC 505 / ASC 810 / ASC 718

Equity Rollforward Template (Corporation and LLC)

An equity rollforward proves that every change in equity is explained: opening balance, net income, other comprehensive income, dividends or distributions, issuances, repurchases, stock-based compensation and other changes, to the closing balance. Reviewers use it to find unrecorded entries and to confirm the statement of changes in equity.

Standard
ASC 505 / ASC 810 / ASC 718
Format
Excel (.xlsx)
Cost
Free
Access
No sign-up

What it is

An equity rollforward proves that every change in equity is explained: opening balance, net income, other comprehensive income, dividends or distributions, issuances, repurchases, stock-based compensation and other changes, to the closing balance. Reviewers use it to find unrecorded entries and to confirm the statement of changes in equity.

The Corporate tab carries two years, with the current-year opening balance linked to the prior-year closing, by component plus a share count. The Members Capital tab handles an LLC or partnership with up to six members, allocating net income by percentage and checking that the allocation equals net income.

When to use it

What’s inside

Standard cited

This template follows ASC 505 / ASC 810 / ASC 718. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.

Download free Excel template (.xlsx)

Questions

What sign should treasury stock and distributions have?

Negative. Treasury stock, dividends, distributions and repurchases reduce equity, so enter them as negative amounts. Deficits in retained earnings are negative too.

Does it handle special allocations?

Percentage allocation of net income is built in. Guaranteed payments and special allocations are entered in a separate row, outside the percentage allocation, so that the total check still works.

Does the rollforward replace the audit of equity?

No. It organizes the work. The auditor still agrees issuances, repurchases and distributions to board minutes, agreements and bank records.

Related templates

Last updated 11/05/2026. All free templates.