Foreign Taxes Paid

I've never had trouble with this in past years in TT, but....

 

I have foreign taxes paid on US based investments in two RICs and 1 Canadian stock reported on a 1099 which I downloaded from the investment company directly into TT.   Some comes from qualified dividends, some does not.

I also have foreign taxes paid on two Canadian retirement funds that pay taxes on required distributions.  

My spouse will also have foreign taxes paid on US based investments (but I haven't got there yet.)

All are passive income.

No matter how I work through the step-by-step (this is what, the 6th time through), the TT process does not correlate to form 1116.  It seems to jumble information between sources and makes no sense.  Can anyone provide a clear step by step guide about how to deal with this?  Am I missing something or is TT dysfunctional here as some seem to think?