Account Schedules Totalling

keedy

I am trying to create a trial balance report with four columns. The columns should show the following:

1) Sum of all Debit Transactions
2) Sum of all credit Transactions
3) Balance on account Debit
4) Balance on account Credit
For 3 & 4 this shoudl show the account balance whether it be a debit or credit balance as in the following:

Account 1234 - 1) Total value of Debits 18,000 2) Total value of credits 21,0000 3) Debit Balance 0.00 4) Credit Balance 3,000

Does anyone know how this can be done??

Thanks

jijuoommen

Your requirement is not clear..

Can you explain in more detail?