Balance sheets cannot be revalued for the previous year" in Sage 50
Sage 50 blocks currency revaluation of balance sheet accounts once the prior year is closed; here is why and what to do.
The message “Balance sheets cannot be revalued for the previous year” appears when you try to run a foreign-currency revaluation in Sage 50 that would post adjustments into a fiscal year that is already closed. In plain terms, Sage 50 is refusing to touch last year’s books. It is not saying your data is damaged. It is saying the revaluation date you chose falls inside a period the software considers locked.
Why Sage 50 blocks this
Sage 50 keeps balance sheet accounts denominated in foreign currencies at exchange rates in effect when each transaction was posted. A revaluation adjusts those balances to current rates and posts the difference to a gain or loss account. Once a fiscal year is closed, the software treats that year’s ledger as final. Posting a revaluation into it would change retained earnings and prior-year figures that reports, filings, and possibly an accountant’s working papers were built on. So it simply refuses.
What usually triggers it
The common trigger is a revaluation dated in the closed year, often because the system date or the revaluation date was left at an old value. It can also happen when someone reopens last year to record a late entry and then tries to revalue before switching the session date back to the current year. Less often, it appears after a conversion or a year-end was run twice, which can leave the year-end markers inconsistent with the dates you expect.
Fix the dates first
Check the session date and the revaluation date before anything else. Both need to fall in the open fiscal year. Set the session date to a current date, run the revaluation again, and in most cases the message disappears. This is the safest fix and it changes nothing in your historical data.
Revalue in the current year instead
If the exchange rates moved during the closed year, you generally cannot retroactively revalue, and that is by design. What you can do is revalue at the earliest date in the current year. The adjustment catches the full cumulative rate change in one entry, so nothing is lost economically; it simply lands in the current year rather than the closed one. If your accountant needs the adjustment reflected in last year’s statements, that is an accounting decision to make with them, not something the software will do for you.
When the message appears but should not
If your dates are correct, the year in question is genuinely open, and the message still appears, the year-end data may be inconsistent. That can happen after an interrupted year-end close, a restore from an old backup, or a data conversion. In that situation the file needs professional attention; retrying the revaluation will not clear it. Our engineers repair damaged Sage 50 and Simply Accounting databases, and we can tell you quickly whether this is a settings issue or real data damage. If the closed year is the problem and you would rather move the whole set of books to QuickBooks, we also handle Sage 50 to QuickBooks conversions.
A useful next step
Send us the file for a free evaluation before you attempt a year-end rollback or restore an old backup. Both of those carry more risk than the message itself, and we can usually confirm the cause from a read-only copy. You will get a plain answer on what is wrong and a free quote for the fix, with no obligation.