List and Balance (or Totalled) reports are both useful, however, they do have some differences. When you're trying to figure out which report is the most appropriate for your needs, knowing some basic information about the two reports is helpful.

What is the difference between a List report and a Balance report?

A List report gives you the items without showing the balance column or total.

A Balance or Totalled report gives you balances remaining or total sales, amounts due, etc.

For example:

  • The Supplier or Contact list report shows the customer name, address, and phone number, but does not give a customer balance column or total.
  • The Transaction List by Date has "list" in its title and show numbers, but will not provide a total.

How to get a total in a List report with amounts

  • If you run a report and it doesn't have a balance column or total, double check the title of the report. There's a good chance that the report has “List” in the title.
  • A List report with amounts can be exported and customised in Excel to provide a total. To do this:  Select Export, then choose Export to Excel.
Note: Need more help? Check out exporting reports to Excel.

How to display the Total column on reports

Display columns only appear in Balance (Totalled) reports because List reports don't display totals.

  1. Go to Reports.
  2. Search for and open your preferred report.
  3. From the Display columns by ▼ drop-down, select Total Only.
  4. Select Run report.
Note: Want to save your changes? You can memorise the report so you have a saved copy of it.

You now know the difference between List reports and Balance (Totalled) reports.