Known Issues

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.1

• 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.

V25.5

• 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.

V25.4

• 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.

V25.3

• 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.

V25.2

• 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.