Go to brightwheel
All Collections
Brightwheel Billing
Reporting
Sum and Filter in Google Sheets
Sum and Filter in Google Sheets
Leverage any spreadsheet software to find totals in the billing reports after it has been exported.
Sabrina avatar
Written by Sabrina. Updated over a week ago

This content is for our legacy billing platform. Update to our newest experience!

Brightwheel has a number of great reports, and many more to come. This article focuses on our billing reports and how you can use some simple formulas and filters in Google Sheets, a common spreadsheet software, to gather crucial information about your school. 

Please note that this article walks through how to perform these actions in Google Sheets only. However, view the linked articles if needed to understand how to perform these actions in Excel and LibreOffice.

Table of Contents

Filtering Data

Subtotals and Totals

Filtering Data

Adding filters to spreadsheets helps to narrow down the data reduce unnecessary and distracting information. 

  1. Export and download your desired report

  2. Upload and open the report in Google Sheets

  3. Click on row 1 in the top-left corner of the sheet to highlight the entire row

  4. Click the Create a filter icon on the toolbar

    1. Once clicked, the filter view will automatically apply to all columns

  5. Click the green filter icon on any column header to open the filter options and configure as you want (e.g., filter for just 'Online payment' under the Transaction Type column).

  6. Click OK to save changes in any columns you filter

Subtotals and Totals

Gather total and subtotal data by using the SUM function in Google Sheets as outlined below:

  1. Go to the column you want to sum (e.g., the Amount column)

  2. Go to the next open cell in that column

  3. Click Insert on the toolbar

  4. Select Function > SUM
    Note: A pop-up will appear in the cell your cursor is in

  5. Click the first cell in the range you want to capture

  6. Drag your cursor down until you've reached the last cell in the range you want to capture
    Note: Capture the sum of a total column by highlighting all cells in it or capture a subtotal of a column by only highlighting select cells. The range displayed in the open cell for the function will auto-update with whatever you've highlighted.

  7. Click the Enter or return button on your keyboard to see the sum of the range selected (in this example, the total sum of all payments in the selected range is $7,295)

    Note: If you need to modify the sum, double-click the cell it's in to prompt the range selector to pop-up again and adjust as needed!

Did this answer your question?