Version 26.2 now available! Support for a Personal Holding Company!

Known Issues

Back to Help Overview

Here is a list of issues (bugs) that we are aware of and working on. If you discover something new please contact us so we can fix it!

V26.2

After entering a birthdate or marriage date in yyyy-mm-dd format, the displayed date format may be different due to system settings. This is a display issue only and does not affect the spreadsheet's calculations.
The federal RRSP contribution limit is applied to contribution room from previous years. It should be applied only to new earned income. This may affect people with large carry forward amounts; however, optimized projections are typically contribute less than the federal limit.

When importing previously exported data, some percentage values may be displayed in exponential form, for example 3.5E-02. To correct, enter the value followed by a percent sign. In the example given, enter "3.50%" without the quotes. You may need to save and reopen the spreadsheet to see the change.
When there is an extra debt payment beyond the minimum, the Expenses on the Snapshot do not add properly. It does not affect the other spreadsheet calculations.
The spreadsheet's RRSP income attribution rule warning appears one year too early. The spousal contributions themselves are calculated properly.
In certain cases, the spreadsheet may move funds into a RRIF before age 71 to claim the pension tax credit when it is not necessary to do so due to eligible pension income from a LIF or a spouse.
In the event that an investment loan persists beyond the lifetime of the borrower, the tax deductible interest expense is not deducted from the surviving spouse's income.

Fixed upper tax brackets do not increase when lower tax brackets approach them due to inflation. This overstates future taxes of ON and YT residents with taxable incomes in the top tax brackets.
Estate calculations are incorrect for loans entered in the advanced worksheets when the spouses' death years do not coincide.
When calculating the non-registered deposit limit to avoid income attribution, the spreadsheet assumes 50/50 ownership when other real estate is sold.
The RRSP income attribution warning appears one year early.
The income attribution hint is sometimes missing.
Extra debt payments are not displayed properly on the Snapshot worksheet.
Mortgage Payments Received/Made are not displayed properly on the Snapshot when a mortgage exists.
Sometimes the Optimized state is not detected.

Pensions or annuities start no later than age 65 despite the age entered in the Data Entry worksheet or retirement age.
Other Assets and ACB (an advanced feature) are allocated to the deceased spouse in the last year of the projection when one spouse pre-deceases the other.
The Pension Income Amount for the tax credit may be calculated incorrectly when pension splitting is enabled and one spouse is younger than the other.
The Ontario surtax is not added to the marginal tax rate. This is a display issue only and does not affect projection calculations.
Charitable donations are not expired properly when there are multiple consecutive years of unclaimed donations.
Unused charitable donations are not applied to estate tax.
On export/import, Mac users may have incorrect birthdates and/or marriage dates. Month and day may be flipped.
If a LIRA unlock age is not specified for person 2, person 1's retirement age is used. Workaround this by specifying a LIRA unlock age for person 2.

Upon death, LIRA and LIF balances transfer to the spouse's non-registered fund, when they should transfer to their RIF.
On newer Macintosh computers, trying to export your data gives an error.

In the Income and Expenses columns on the Snapshot worksheet, Retirement Fund Withdrawals and RRSP Contributions are shown incorrectly in the event that they happen concurrently. The underlying math, the projection and the amounts in the Accounts section of the Snapshot are correct.
The LIRA/LIF jurisdiction always defaults to Federal after an import and must be manually changed.

Group RRSP contributions are missing from the Snapshot worksheet although the RRSP/RRIF Balance at End of Year is correct.
LIRA/LIF to RRSP/RRIF unlock transfers are not shown in the Snapshot worksheet although the LIRA/LIF and RRSP/RRIF Balances at End of Year are correct.
One-time expenses are included in the Expenses on the Snapshot worksheet which results in double counting in the Uses of Cash. The projection calculations in the rest of the spreadsheet are correct.
In some circumstances the provincial tax tables may not update when the inflation rate is changed in the Dashboard.
In the Projection Summary when showing amounts in current dollars, the current value of real estate is calculated using the general inflation rate rather than the real estate inflation rate. This is only significant if you have overridden the general inflation rate for real estate.
The previous year's tax reconciliation is included in the estate tax for any given year, not the current year's tax reconciliation.
The As Needed and Last Resort retirement fund withdrawal strategies do not take into account funds in an RRIF.

Page updated

Report abuse