SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Document(
    Id INT,
    [Date] date
);

INSERT INTO Document VALUES (1,'2018-01-01');
INSERT INTO Document VALUES (2,'2018-01-02');
INSERT INTO Document VALUES (3,'2018-07-01');
INSERT INTO Document VALUES (4,'2018-07-02');
CREATE TABLE DocumentAccount(
    DocumentId INT,
    Debit INT,
    Credit INT
    );

INSERT INTO DocumentAccount VALUES (1,100,200);
INSERT INTO DocumentAccount VALUES (2,150,300);
INSERT INTO DocumentAccount VALUES (3,150,300);
INSERT INTO DocumentAccount VALUES (4,160,310);
INSERT INTO DocumentAccount VALUES (4,170,320);

CREATE TABLE DocumentAccountDetail
(
    DocumentAccountId INT,
    DetailId INT 
)

Select 
   Sum(CASE WHEN d.[Date]  between '2018-01-01' AND '2018-06-21'  THEN debit ELSE 0 END) as Totledebit,
   Sum(CASE WHEN d.[Date]  BETWEEN '2018-01-01' AND '2018-06-21'  THEN credit ELSE 0 END) as Totlecredit,
   SUM(CASE WHEN d.[Date]  between '2018-01-01' AND '2018-03-30'  AND  d.[Date]  BETWEEN '2018-06-21' AND '2019-03-21' THEN debit ELSE 0 END) as Q1Debit,
   SUM(CASE WHEN d.[Date]  between '2018-04-01' AND '2018-06-30'  AND  d.[Date]  BETWEEN '2018-06-21' AND '2019-03-21'  THEN debit ELSE 0 END) as Q2Debit,
   SUM(CASE WHEN d.[Date]  between '2018-07-01' AND '2018-09-30'  AND  d.[Date]  BETWEEN '2018-06-21' AND '2019-03-21'  THEN debit ELSE 0 END) as Q3Debit,
   SUM(CASE WHEN d.[Date]  between '2018-10-01' AND '2018-12-31'  AND  d.[Date]  BETWEEN '2018-06-21' AND '2019-03-21'  THEN debit ELSE 0 END) as Q4Debit,
   SUM(CASE WHEN d.[Date]  between '2018-01-01' AND '2018-03-30'  AND  d.[Date]  BETWEEN '2018-06-21' AND '2019-03-21'  THEN Credit ELSE 0 END) as Q1Credit,
   SUM(CASE WHEN d.[Date]  between '2018-04-01' AND '2018-06-30'  AND  d.[Date]  BETWEEN '2018-06-21' AND '2019-03-21'  THEN Credit ELSE 0 END) as Q2Credit,
   SUM(CASE WHEN d.[Date]  between '2018-07-01' AND '2018-09-30'  AND  d.[Date]  BETWEEN '2018-06-21' AND '2019-03-21'  THEN Credit ELSE 0 END) as Q3Credit,
   SUM(CASE WHEN d.[Date]  between '2018-10-01' AND '2018-12-31'  AND  d.[Date]  BETWEEN '2018-06-21' AND '2019-03-21'  THEN Credit ELSE 0 END) as Q4Credit
From DocumentAccount da 
INNER JOIN Document d on da.DocumentId = d.id

Totledebit	Totlecredit	Q1Debit	Q2Debit	Q3Debit	Q4Debit	Q1Credit	Q2Credit	Q3Credit	Q4Credit
250	500	0	0	480	0	0	0	930	0