Year-End Rollover Explained

By Gregg Hopfeldt · 2025-04-14

The Year-End Problem

In a spreadsheet, closing a financial year means:

  1. Copying the entire sheet
  2. Resetting opening balances manually
  3. Checking every formula still references the right cells
  4. Hoping nothing breaks

It takes hours. Sometimes days. And mistakes compound silently.

How Rollover Works in Simple Fixed Assets

Click Roll Forward. That's it — for the practical steps, see how to roll over to a new year.

Here's what happens behind the scenes:

What Gets Carried Forward

  • Every active asset with updated opening balances
  • Accumulated depreciation to date
  • Asset descriptions, categories, and serial numbers
  • Your depreciation rates and methods

What Gets Archived

  • The previous period's register is locked and archived
  • Disposed assets are excluded from the new period
  • A rollover history record is created for your audit trail

Pro-Rata in the New Period

Assets purchased in the previous period get a full year of depreciation in the new period. Assets purchased mid-year in the new period are pro-rated based on your configured policy (full month, half year, or exact days).

Can I Undo a Rollover?

The previous period is always accessible in your archived registers. If something went wrong, you can review the original data and make corrections before rolling forward again.

Three seconds. Every year. No spreadsheet archaeology required.