Differentiate between bill payments and direct payments on transaction reports, reports to show totals

The reporting system only shows a catchall 'payment' or 'bill' in the type column of a report.  As there are no balances or totals offered I have to export to excel then drill down into each transaction to see if it is a bill payment or a payment made directly from the bank account.  A column showing a balance would be useful as would the reference column to show the actual bill number, not the one that Reckon One has created.