Skip to main content
Billing Reports

Learn how to track your payment and report on data logged

Courtney Ambielli avatar
Written by Courtney Ambielli
Updated over 2 months ago

Billing administrators can track and pull reports on all payment data in Playground. This article will review how to locate reports and the functionality of each report available.


Generate a Billing Report

  1. From your Admin Dashboard, navigate to the Reports tab on the left-hand side and select the Payments tile.

  2. Choose your Report Type. See the table below for a description of all report types.

  3. Set your report parameters and then click Generate Report.

    1. Reports generated within Playground can be customized by using the ⚙️ icon to add and reorder column headers.

  4. Each report can be exported to CSV or printed by using the blue buttons in the top right of the report after it has been generated. Below is a summary of each Report Type.

Report Type

Summary

Accounts Receivable Aging

Lists the amount of money that is owed per student and how late that payment is.

Amounts owed are categorized by if they were due 0-30 days ago, 30-60 days ago, 60-90 days ago, or 90+ days. 0-30 days indicates the money may not be overdue yet.

Accounts Receivable Aging (Non Zero)

Lists the amount of money that is owed per student, and how late that payment is. Removes all rows with no aging balance

Check Deposits

Lists all checks

Deposits

Lists all cash and checks that are to be deposited into the bank for a given date range. "Other" includes all other offline payments.

Discounts

Summary and detailed view of discounts applied for a given period

Forgiven Fees

Lists all forgiven fees forgiven on a given date range

Grouped Ledger

Ledger report with all transactions grouped by item and discount

Grouped Transactions

Shows the amount of money billed and paid for each transaction item type. The Item types are pulled from your list of saved items.

Ledger

When generating this report, it will download a CSV file with every single transaction, this includes all charges and payments made.

Any column header with an ID is a Playground internal code.

Account codes can be customized under Settings > Payments in the Admin Dashboard.

The Fee column of this report refers to the Playground processing fees. If you entered an offline payment, you'll see the Type of payment made in the far right column.

Monthly Subsidy

Subsidies received in the last year, by month

Overdue Debits

List all payments that became overdue in a given date range

Payment Methods

Lists the payment methods in Playground per student.

This report will let you know how many payment methods the student has on file, if the guardians have enabled autopay, the default payment method if there is more than one payment method on file, and the expiration date of the payment method. If a student has more than one payment method, they will only be listed once on this report with the default payment method.

To view the student's alternative payment methods, you will need to go to the student's Payment tab on their profile.

Payouts

List all payout information by date

Received Subsidy

Subsidies received per time frame

Revenue Overview

Overview of revenue over time. This calculates gross collected revenue, which does not include any refunds or disputes. E.g. a $100 payment refunded $25 will show as $100 here

Revenue Source

Groups the amount of money processed by each payment source per student, for a specific time period. The column headers across the top show each unique payment source with a total amount to the very right.

Revenue Summary

Downloads a CSV file to your computer for the specified date range. This report has three main sections: Revenue, Credit, and Payment. Each section has categories listed underneath with a total of the section at the bottom.

The Revenue section shows all sources of income per item type. These item types can be found in your Saved Items list under Billing > Overview. The Credit section shows any credits recorded for students using the Add credit button. The Credit section does not include discounts. The Payment section includes all Offline payments itemized by payment type.

Transactions

The Transactions report shows which charges have been paid off for a particular date range. The report shows three different dates:

  • Invoice date: date the charge was posted to guardians

  • Due date: the date the charge is due from the guardians

  • Paid date: date the payment was made

Transactions (detailed)

Lists all credit transactions at the school

Transactions (inc. unpaid)

Lists all transactions at the school, including unpaid debits


How to Use the Transactions Tab to Filter and Generate Detailed Reports

💡 While the reports listed above are extremely useful, we've found that many providers can quickly access the specific information they need through the Transactions tab.

The Transactions tab offers two key tools to help you break down the information you need: the Filter option and the Gear icon. These features allow you to customize your view and easily access specific transaction details.

Filter Tool

The Filter tool makes it easy to find exactly what you need by allowing you to filter transactions by classroom, programs, due dates, and service start dates.

  1. To access your transactions, navigate to the Billing tab on the right side of your screen and click on Transactions.

  2. On the right side, you'll find the Filters button.

  3. Clicking on Filters will provide options to refine your search by classroom, programs, due dates, and service start dates.

    1. Classroom and Programs: These options allow you to break down the report by specific classroom and program.

    2. Due Dates and Service Start Dates: Use these to select a specific date or a range of dates for your report.

      1. "Is Equal To" allows you to choose a single date.

      2. "Is Between" lets you select a time period.

  4. Once you've made your selections, click Done to save your changes, or click Reset to start over.

  5. To download the report click Download view to the left of the filters button.

Gear Icon ⚙️

The Gear icon allows you to adjust the columns by adding or removing information. Customize your view to focus on the data that matters most to you, streamlining the way you manage and review transactions.

  1. To access your transactions, navigate to the Billing tab on the right side of your screen and click on Transactions.

  2. On the right side, you'll see the Gear Icon button. Click on it to customize your view.

  3. Select columns by clicking the grey button to the green

  4. Organize your columns by clicking and holding the six dots to the left of each title. You can easily drag and drop to rearrange them in your preferred order.

  5. Your selected columns will save automatically. To close the settings, simply click the "X" button.

  6. To download the report click Download view to the left of the filters button.


Did this answer your question?