Restructure Reconciliation Report in Dashboard about finances HOT 14 CLOSED

SELECT month,
(CASE WHEN network = 'balanced-cc' THEN payins ELSE NULL END) AS "Balanced Payins",
(CASE WHEN network = 'paypal' THEN payins ELSE NULL END) AS "Balanced Payins",
(CASE WHEN network = 'balanced-cc' THEN payouts ELSE NULL END) AS "Balanced Payouts", 
(CASE WHEN network = 'paypal' THEN payouts ELSE NULL END) AS "Balanced Payouts",                                                                                          network
FROM (  SELECT date_trunc('month', "timestamp") AS month
, sum(case when amount > 0 then amount end) as payins 
, -(sum(case when amount < 0 then amount end)) as payouts 
, sum(fee) as income
, network 
FROM exchanges, exchange_routes 
WHERE exchanges.route = exchange_routes.id  
GROUP BY month, exchange_routes.network  
ORDER BY month ASC  
) 
AS totals;

SELECT  suc_table.month,
        suc_payins,
        suc_payouts,
        suc_income,
        pend_payins,
        pend_payouts,
        pend_income,
        fail_payins,
        fail_payouts,
        fail_income,
        suc_payins + pend_payins AS Total_Payins,
        suc_payouts + pend_payouts AS Total_Payouts,
        suc_income + pend_income AS Total_Income
FROM (  SELECT date_trunc('month', "timestamp") AS month
        , COALESCE( sum(case when amount > 0 then amount end), 0) as suc_payins
        , COALESCE( -(sum(case when amount < 0 then amount end)), 0) as suc_payouts
        , COALESCE( sum(fee), 0 )  as suc_income
        , status
        , network
    FROM exchanges, exchange_routes
    WHERE exchanges.route = exchange_routes.id
    AND status = 'succeeded'
    GROUP BY month, exchange_routes.network, status 
    ORDER BY month ASC
    ) AS suc_table,
       (  SELECT date_trunc('month', "timestamp") AS month
        , COALESCE( sum(case when amount > 0 then amount end), 0) as pend_payins
        , COALESCE( -(sum(case when amount < 0 then amount end)), 0) as pend_payouts
        , COALESCE( sum(fee), 0 )  as pend_income
        , status
        , network
    FROM exchanges, exchange_routes
    WHERE exchanges.route = exchange_routes.id
    AND status = 'pending'
    GROUP BY month, exchange_routes.network, status
    ORDER BY month ASC
    ) AS pend_table,
       (  SELECT date_trunc('month', "timestamp") AS month
        , COALESCE( sum(case when amount > 0 then amount end), 0) as fail_payins
        , COALESCE( -(sum(case when amount < 0 then amount end)), 0) as fail_payouts
        , COALESCE( sum(fee), 0 )  as fail_income
        , status
        , network
    FROM exchanges, exchange_routes
    WHERE exchanges.route = exchange_routes.id
    AND status = 'failed'
    GROUP BY month, exchange_routes.network, status
    ORDER BY month ASC
    ) AS fail_table
WHERE suc_table.month = fail_table.month and suc_table.month = pend_table.month;

SELECT date_trunc('month', "timestamp") AS month
                 , COALESCE(sum(case when amount > 0 then amount end), 0) as payins
                 , COALESCE(-(sum(case when amount < 0 then amount end)), 0) as payouts
                 , sum(fee) as income
                 , status
                 , network
FROM exchanges, exchange_routes
WHERE exchanges.route = exchange_routes.id
GROUP BY month, network, status
ORDER BY month ASC;