To show how much is due, you can add a filter for A/R Paid then select Unpaid on the option box next to it. However, this report won’t be able to show terms information, as a workaround, you can run the Transaction List By Customer report. Customize and add the columns for terms then export the report to Excel together with the first report you’ve created. You’ll need to manually add the terms column in Excel (To export the report to Excel: you can click the export icon between the print and the gear icon on the report).
I’ll also make sure to take note of your preferred consignment report and share it to our developers for future updates.
Don’t hesitate to reach us again if you have other questions about QuickBooks.