J.I. Packer has a helpful summary of biblical teaching.

• The separation of body and soul at death is both a fruit of sin and a divine judgement, Gen. 2:17; 3:19, 22; Rom. 5:12; 8:10; 1 Cor. 15:21.  This separation is a sign of the separation from God that first brought about physical death, and will be deepened after death for those who leave this life without Christ.  Death is, accordingly, to be seen as an enemy, 1 Cor 15:26 and a terror, Heb 2:15.
• For believers, death retains pain, but no longer terror.  Our Saviour has gone ahead to prepare a place for us, Jn 14:2f.  To die is ‘to depart and be with Christ, which is better by far’, Phil 1:21,23.  Being ‘away from the body’ with mean being ‘at home with Christ’, 2 Cor 5:8.
• At death the souls of believers are made perfect in holiness and are enter the worshiping life of heaven, Heb 12:22-24.
• The notions of purgatory and soul-sleep are unscriptural.  The faithful departed have a variety of relationships, activities and enjoyments, Luke 16:22; 23:43; Phil. 1:23; 2 Cor. 5:8; Rev. 6:9-11; 14:13.
• Death is gain for believers, Phil 1:21.  But it will be even greater gain to be re-embodied at the resurrection, 2 Cor 5:1-4.

(Based on Concise Theology)