Does mixing those tenses really stop anyone from understanding you?

I see all these complaints about saying "I have seen that movie yesterday" and people act like it ruins everything. If the meaning comes through, the sentence did its job. Just write it out and you'll sort the details by using it more.