how can a get a total amt of bills/cr notes for suppliers. Report already set up only incls bills posted to exp acs and won't capture any items posted to bal sheet acs?

Hi Dan.

Thank you for checking the help function to find more information about this. I appreciate the effort you’ve made to explore available resources and better understand how QuickBooks Online handles supplier totals. Let’s work together to generate a report that includes the information you need.

Before we start, could you please confirm if the report you mentioned is the Expenses by Supplier Summary report? If so, yes, the information you have is correct. In this report, only total amounts posted to expense (and some COGS) accounts, so anything you code to balance sheet accounts (like Prepayments/Deposits/Fixed assets) won’t show there.

To get a complete supplier total that includes those transactions, you can run the Transaction List by Supplier report instead of the Expenses by Supplier Summary report.

To do this, please follow the steps below:

1. Navigate to Reports, then choose Standard reports.
2. Look for the Transaction List by Supplier in the search bar.
3. Filter the date range.

You can customise the report according to your preferences to ensure it reflects the specific details you need. You can also use the Supplier Balance Detail report.

I hope the information above provides clarity regarding the report and helps you pull up the details you need by using the suggested reports. If you have any questions or clarification, please feel free to revisit this thread and use the Reply button below to reach out. Have a great day ahead!