FSG: Column showing all accounts with NET debit BALANCE (as opposed to total DRs) - is it possible?

I have been asked if it is possible to show, in a single column, where the NET balance on an account, on a YTD basis, is a DEBIT... and show in a separate column where the NET balance is a CREDIT. 

i.e. one account will ONLY have a number in one of these columns.

Obviously I can ask the assignment to report on DR or CR or NET balances, but if i use NET balances I can only figure out how to get them in a single column with the rows either showing as + or -.

Any ideas?

My current thought is that I have to bring back as a single column to excel and write a macro... then give users specific procedures. However would rather be able to pull back what we want at run-time.