select id_plano, plano,    
classificacao,             
sum(entrada) as entrada,   
sum(saida) as saida        
from (                     
select a.codigo, a.doc, a.dtemissao, a.id_plano,                  
b.descricao as plano, b.classificacao, a.historico,               
iif(a.tipo = 'C', a.valor, 0) as entrada,                       
iif(a.tipo = 'D', a.valor, 0) as saida,                         
iif(a.tipo = 'D', -a.valor, a.valor) as valor,                  
c.descricao as origem_lancto,                                     
iif(a.tipo = 'D', 'Dbito','Crdito') as tipo_descricao,    
d.login as usuario                                                
from caixa_movimento a                                            
left join plano b on a.id_plano = b.codigo                        
left outer join origem_lancto c on (a.id_origem_lancto = c.id)    
left outer join usuarios d on (a.id_usuario = d.codigo)           
where a.id_origem_lancto <> 0                                     
 and a.id_empresa=1
 and a.dtemissao between '2025-10-01' and '2025-10-17'
                                                         
union                                                             
select a.codigo, a.doc, a.dtemissao, a.id_plano,                  
b.descricao as plano, b.classificacao, a.historico,               
iif(a.tipo = 'C', a.valor, 0) as entrada,                       
iif(a.tipo = 'D', a.valor, 0) as saida,                         
iif(a.tipo = 'D', -a.valor, a.valor) as valor,                  
c.descricao as origem_lancto,                                     
iif(a.tipo = 'D', 'Dbito','Crdito') as tipo_descricao,    
d.login as usuario                                                
from conta_movimento a                                            
left join plano b on a.id_plano = b.codigo                        
left outer join origem_lancto c on (a.id_origem_lancto = c.id)    
left outer join usuarios d on (a.id_usuario = d.codigo)           
where a.id_origem_lancto = 1                                      
 and a.id_empresa=1
 and a.dtemissao between '2025-10-01' and '2025-10-17'
                                                         

) group by id_plano,       
plano, classificacao       
order by classificacao     