There is no norm, sadly.
Some DNS hosting services and software require it (BIND, Google Cloud DNS, many others) as it was written in the RFCs.
Others try to be "helpful" and add an implicit trailing dot whether you put one there or not (EasyDNS, some other one).
And then there are the frustrating ones like PowerDNS and GoDaddy that will not accept the trailing dot.
I thought I read (or wrote?) something listed more specifics about which software / services require . and which don't, and which won't accept it. But I can't find it.
I would always put the . there to start (since it is the RFC-right thing to do) and you will never get a silent misconfiguration (worst you get a parse error from PowerDNS or GoDaddy), and which point you accept the unfairness of the world and take it out.