The reports you describe are not the kind of reports that are being asked for - the Customer balance report just shows open items and does not show all transactions .... Can you please have a look at what I have mocked up in Excel and let me know how I can do this in Quickbooks.
