If you are just trying to see what was spent at each vendor for a particular period, there is a better report.  Go to Reports > Vendors & payables > Transaction list by vendor.  In the date picker, select the date range you are looking for.  In the Customize > […]

Resolution for 'balance total issue: 'report not showing balance total' available: Yes.

The balance total issue or error code is a known issue in Quickbooks Online (QBO) and/or Quickbooks. Support for this issue is available either by self-service or paid support options. Experts are available to resolve your Quickbooks issue to ensure minimal downtime and continue running your business. First try to resolve the balance total issue yourself by looking for a resolution described in the article. If it is a complex balance total issue or you are unable to solve the issue, you may contact us by clicking here or by using other balance total support options.

For more information about resolving issues related to balance total in Quickbooks/QBO or to get support for the issue 'report not showing balance total', click the link below: