Alternative splicing regulates trans-synaptic adhesions and synapse development, but supporting in vivo evidence is limited. PTPd, a receptor tyrosine phosphatase adhering to multiple synaptic adhesion molecules, is associated with various neuropsychiatric disorders; however, its in vivo functions remain unclear. Here, we show that PTPd is mainly present at excitatory presynaptic sites by endogenous PTPd tagging. Global PTPd deletion in mice leads to input-specific decreases in excitatory synapse development and strength. This involves tyrosine dephosphorylation and synaptic loss of IL1RAPL1, a postsynaptic partner of PTPd requiring the PTPd-meA splice insert for binding. Importantly, PTPd-mutant mice lacking the PTPd-meA insert, and thus lacking the PTPd interaction with IL1RAPL1 but not other postsynaptic partners, recapitulate biochemical and synaptic phenotypes of global PTPd-mutant mice. Behaviorally, both global and meA-specific PTPd-mutant mice display abnormal sleep behavior and non-REM rhythms. Therefore, alternative splicing in PTPd regulates excitatory synapse development and sleep by modulating a specific trans-synaptic adhesion.