Skip to main content

Billing Reports: Total Balance

Claire Frank
  • Updated

The Billing Reports: Total Balance tab (Billing > Billing Reports > Total Balance) shows the total balance for each payer, grouping charges, credits, and payments into a single balance figure.

Who can access this feature?

Admin Account Types: System Admin, Admin, User
Permissions: Financial

💡Quick Answers

  • Where is the Total Balance report? Under Billing > Billing Reports > Total Balance tab.
  • How do I filter the report? Use the term picker, date range, and Filter Options (grade, payment type, category, etc.) to narrow the results.
  • How do I export the Total Balance report? Use the Download Report menu to export as a CSV or PDF.

In this Article

Display Options

In the section directly below the report tabs, you'll find a variety of options for displaying the data within the report.

Display options in the Billing Category report.

Show Reports By

Note: Unlike the on the Billing Category tab, this report only shows the totals (it doesn't break them down by category).

Account Name

  • Selecting this populates the report to only show the name of each individual with a billing account (typically the parent).
  • It also displays the total account balance in the Total column on the right.
  • Clicking the Account name brings you to their record.

Show by Account on the Total Balance tab.

Student Name

  • Selecting this populates the report based on the Students and shows their totals in the Totals column on the right.
  • Clicking on the Student name brings you to their record.

Show by Student on the total Balance tab.

Both

  • Selecting this shows the Account's overall total and all students associated with the account’s total.
  • Clicking on the Account or Student names will bring you to their record.

Show By Both on the Total Balance tab.

View

Charge, Credit, and Payment Breakdown

  • By default, only the totals column is displayed in the report. Selecting this option includes a breakdown of the Charges, Credit, and Payment totals for each Billing Category.
  • Clicking the names brings you to their record.
  • The selection you make under Show Report By dictates how these breakdowns display. 

Example of adding the additional columns for Charge, Credit, and Payment while filtering by Account.

Using the View charge, credit, and payment breakdown.

Select Date Range

Select Date Range allows you to filter the report to see results based on your selected date range.

Location of the Select Date range Filter Option.

Filter and Export Options

Filter Options

Below the Show options box, expand the Filter Options button to view and select from the filters.

Filter options menu.

Filter Options include: 

  • Term
  • Grade
  • Payment Type
  • Category
  • Category Group
  • Payment Method
  • Account First Name (text box)
  • Account Last Name (text box)

Export Options

Using the Download Report menu, you can Export the report to a CSV or PDF.

Export options within this report.

Additional Resources

Related articles

Comments

0 comments

Article is closed for comments.