Report totals

Hi - I work for a charity which is planning a switch to QBO after using QB desktop for years.  I'm tasked with re-making our memorised reports.  A typical report lists the transactions from a few income accounts and a few matching expenditure accounts.  Columns include credit, debit, and amount.  These all work fine till you get to the very bottom line of totals.  The credits and debits total correctly but the 'amount' total is total credits PLUS total debits, as opposed to QB desktop where the 'amount' total would be credits MINUS debits to give an overall balance.  Is there a way of changing this behaviour or adding some sort of total balance to the report?  Example: Say that we received a total of £800 and spent a total of £600.  I want to see that there is £200 left to spend, not to be told that £800 + £600 = £1400.  Thanks!