Your Weekend Retirement Reset: Turn Scattered Accounts into a Starting Plan

In its October 24 report, MarketWatch cited an Evergreen.ai survey finding that 42% of Americans had never calculated their retirement needs. That is a reported survey finding, not a diagnosis of any individual household. It offers a useful prompt for a weekend project: make your starting numbers visible.

A retirement worksheet becomes easier to maintain when each number has a job. What do you own today? What might you spend later? What are you contributing between now and then? This special edition walks through those questions without requiring a market forecast or a trade.

1. Saturday morning: build the account map

Start with one row per account. Record its owner, brokerage, purpose, balance date, and whether the money is intended for retirement or another goal. An old workplace account, a taxable brokerage account, and next year’s renovation fund may all appear on your net worth statement, but they serve different needs.

Next, reconcile that list against statements. Mark missing accounts and any cash or investments that your data connection does not represent. Avoid counting the same account once in a connected total and again as a manual entry. A complete inventory is a useful result even if you stop there today.

InvestSheet can bring connected brokerage holdings into Google Sheets. Keep manual assets and debts in clearly labeled rows beside those inputs. That gives you a working view while preserving the distinction between refreshed holdings and numbers you must update yourself.

2. Saturday afternoon: give the balances context

Use InvestSheet’s holding value, cost basis, and unrealized gain or loss as three separate inputs. Here is a hypothetical example for connected holdings; these are demonstration amounts, not live market data:

=IVS_BROKERAGE("value")      → $240,000
=IVS_BROKERAGE("costBasis")  → $200,000
=IVS_BROKERAGE("gainLoss")   →  $40,000

The $40,000 difference describes unrealized appreciation in this example. It is not annual income or a complete investment return calculation. Contributions, withdrawals, and realized activity need their own records. Likewise, a connected holdings total should not automatically be treated as your entire retirement balance.

For a particular position, add its ticker, such as =IVS_BROKERAGE("value", "AAPL"). Divide that value by the appropriate portfolio total in a separate spreadsheet cell to inspect its weight. That calculation does not reveal exposure held indirectly through funds; review those separately if concentration is a concern.

3. Sunday morning: write down the assumptions

Create a second tab for expected spending. Separate recurring essentials, flexible spending, and occasional large expenses. Give each estimate a date and note whether it is expressed in today’s purchasing power or future dollars. Inflation assumptions must be consistent when you compare those amounts.

Add your expected retirement timing and ongoing contributions. As one reference point, Fidelity’s savings guideline suggests working toward 15% of pretax income annually, including employer contributions. Its example assumes saving from age 25 to 67; your starting balance, timing, and lifestyle can change the amount required. Treat it as a comparison point, not a personalized prescription.

Keep the worksheet honest about uncertainty. Label growth assumptions as assumptions. Explore how a different retirement date or spending estimate changes the picture using a dedicated planning tool. InvestSheet provides portfolio inputs; it does not turn a balance into a guaranteed retirement income.

4. Sunday afternoon: choose the next review

Finish by writing down one practical next step: locate an old statement, complete a missing spending category, or prepare questions for a qualified adviser. Set a review date and save a dated snapshot so you can distinguish changes in your inputs from changes in your assumptions.

The weekend’s deliverable is a page you can explain: the accounts included, the goals they support, the estimates still unresolved, and the next action on your calendar. With InvestSheet maintaining the connected holdings inputs, your next review can begin with the questions that matter to your plan.

Start with the accounts you have today

Bring connected brokerage holdings into Google Sheets with InvestSheet, then build your own weekend review around value, cost basis, and unrealized gains or losses.