Retained Earnings Rollforward

The purpose of this template is to document and reconcile the changes in the equity accounts for the year.  

Entering Information

All of the information needed to generate the workpaper is entered on the Input Worksheet.  The yellow highlighted cells are calculated fields, and no data should be entered in these cells.  Gray cells are not calculated fields, but data should not be entered in these cells.

Enter the following information:

  • Beginning of year balances in the equity accounts as shown in the input table
  • Current year book income/loss
  • Dividends paid both in stock and cash
  • Transfers (Additional lines by clicking on the “Insert Row” button.)
  • Adjustments (Additional lines by clicking on the “Insert Row” button.)
  • Balance per financials