Yes, this supplication is mentioned in *al-Kāfī*. Given that the duties incumbent on a repentant person are clearly defined and must be fulfilled in full, this supplication will surely have its remarkable effects!
عن أبی عبد الله ع قال: من قال حین یأخذ مضجعه ثلاث مرات الحمد لله الذی علا فقهر و الحمد لله الذی بطن فخبر و الحمد لله الذی ملک فقدر و الحمد لله الذی یحی الموتى* و یمیت الأحیاء و هو على کل شیء قدیر* خرج من الذنوب کهیئه یوم ولدته أمه.
الکافی (ط - الإسلامیه)، ج2، ص: 536
… Bakr ibn Muhammad narrates from Imam Jaʿfar al-Ṣādiq علیه السلام that he said: Whoever recites this supplication three times when going to bed, or before falling asleep:
«الحمد لله الذی علا فقهر و الحمد لله الذی بطن فخبر و الحمد لله الذی ملک فقدر و الحمد لله الذی یحی الموتى* و یمیت الأحیاء و هو على کل شیء قدیر».
(All praise belongs to God, exalted above all, whose will holds all things in subjection; all thanks and praise belong to God, who is beyond all appearances and knows every secret, and all that is hidden and manifest; all praise and glorification belong to God, King of kings, Creator of all beings and all the worlds, sovereign over all things and able to do all things; and all praise and thanks belong to God, who brings the dead to life and takes life from the living. He is the One who has power over all things.)
The one who recites this supplication will be completely cleansed of their sins, as on the day their mother gave birth to them.