It's very difficult to use this report for the accountability. What we would need is: . Gross Unit price of service . applied rebate in $ . Amount to pay before taxes . taxes (qst, gst) . Amount to pay . Credit applied . Final amount paid (credit, debit or card). I'm currently stuck to create a bunch of pivot tables and try to guess why a customer didn't pay full price for a service in order to properly import sales in quickbooks.