I’ve been playing around with batch calculations in Client Manager, trying to find a way to run one that would allow me to verify that pension splitting was correctly optimized in our T1s. It’s a bit of a long story, but I identified a few returns in April whose split was sub optimal, so thought this would be a good verification step to make sure what we filed was best.
My initial idea was changing the response to whether the taxpayer is the pensioner/pension transferee, i.e.:
and then calculating the family balance due either way in the batch calculation report. The third column in the batch calc report would be the family balance due as filed, and then I was planning to run some logic in excel to identify anytime where the filed amount did not equal the lowest family balance due possible.
From the tinkering I’ve done, I haven’t found a way to run this type of “what if” calculation (as it requires a change to a cell response in the tax return). I’m wondering if I’m missing something though? Has anyone found a way to accomplish something similar?