Receivables Report

The Receivables Report is used to view unpaid invoices. It can be pulled based on the facility, student, date range, and more.

Generating the Receivables Report

1. In the Billing menu, click Receivables Report.

Receivables Report

The Receivables Report tab is opened by default.

Receivables Report

2. Select the Current check box to include current invoices (today to 30 days old) in the report.

3. Select the 31 to 60 Days check box to include invoices that are 31 to 60 days old.

4. Select the 61 to 90 Days check box to include invoices that are 61 to 90 days old.

5. Select the 91 and Over check box to include invoices that are 91+ days old.

Receivables Report

6. Use the As Of Date text box to pull invoices as of a specified date (Invoice Date).

7. Use the Invoice Date Range text boxes to enter a beginning and an ending date in order to pull invoices generated over a specific timeframe.

8. Enter a Customer/Student ID in the text box to pull invoices that pertain to the specific customer or student only.

9. Enter an Invoice Number in the text box to pull a specific invoice into the report.

10. To pull invoices as they pertain to specific facilities, select them from the Facility pull-down.

11. To pull invoices as they pertain to specific funding sources, select them from the Funding Source pull-down.

12. Select the Waived check box to include invoices that have been waived.

13. Select the Include Paid check box to include invoices that have been paid.

Receivables Report

14. When all search criteria has been entered, click Run Report to generate the report.

Receivables Report

The Receivables Report displays the Invoice Date, Invoice #, Customer/Student ID, Customer Name, Invoiced Amount, Outstanding Balance, Item, Paid Amount, Payment Source, Funding Source Invoice #, Waived, Due Date, Current, 31-60 Days, 61-90 Days, and 91+ Days.

Receivables Report

When Educational Credit is received via Funding Sources > Receive Payment tab, the amount of the credit shows in the Paid by Deferral column.

  • When running the report and selecting the box to “Include Paid,” the Paid by Deferral and Total Deferred Amount columns match if all money has been received.
  • The overage checks do not affect outstanding balances in either report after the money has been received from the funding source.

The columns displayed are included in the report; however, if you find specific columns unnecessary, you can remove columns by clicking Toggle Columns. To hide a column from the report, clear the selected check box. To include the column, select the check box.

Receivables Report

If a column has been hidden from the report, upon navigating away from the screen, the column will remain hidden until the check box is selected via Toggle Columns.

The Current Page Totals and Grand Page Totals are listed at the bottom of the report.

The Current Page Totals displays the total for select columns, such as the Invoiced Amount total for the selected page.

The Grand Page Totals displays the total for the entire report for select columns, such as Outstanding Balance. This amount will be the same regardless of the page selected, as it is the grand total.

Note: These totals change based on any applied filters to the data. For more information on using Filters, see Additional Features.

Receivables Report
Generating the Customer Report

The Customer Report displays unpaid invoices by customer (student).

1. From the Billing menu, click Receivables Report.

Receivables Report

2. Click the Customer Report tab.

Receivables Report

3. Select the Current check box to include current invoices (today to 30 days old) in the report.

4. Select the 31 to 60 Days check box to include invoices that are 31 to 60 days old.

5. Select the 61 to 90 Days check box to include invoices that are 61 to 90 days old.

6. Select the 91 and Over check box to include invoices that are 91+ days old.

Receivables Report

7. Use the As Of Date text box to pull invoices as of a specified date (Invoice Date).

8. Use the Last Invoiced Date Range text boxes to enter a beginning and an ending date in order to pull invoices generated over a specific timeframe.

9. Enter a Customer/Student ID in the text box to pull invoices that pertain to the specific customer or student only.

10. To pull invoices as they pertain to specific facilities, select them from the Facility pull-down.

Desktop

11. Select the Include Paid check box to include invoices that have been paid.

12. Select the Hide Fully Deferred check box to hide all invoices that have been deferred and are to be paid by a funding source or other.

13. Select the District-Wide Balances check box to calculate and display the district-wide outstanding balance, which overides selected facilities upon generating the report.

Desktop

14. When all search criteria has been entered, click Run Report to generate the report.

Desktop

The Customer Report displays the Customer/Student ID, Customer Name, Invoiced Amount, Total Paid, Paid By Student, Outstanding Student Balance, Paid By Deferral, Total Deferred Amount, Outstanding Deferred Balance, Customer Credit, Last Invoiced, Outstanding For, Current, 31-60 Days, 61-90 Days, and 91+ Days.

Desktop

Invoiced Amount - (Total Deferred Amount + Paid By Student) = Outstanding Student Balance.

When Educational Credit is received via Funding Sources > Receive Payment tab, the amount of the credit shows in the Paid by Deferral column.

  • When running the report and selecting the box to “Include Paid,” the Paid by Deferral and Total Deferred Amount columns match if all money has been received.
  • The overage checks do not affect outstanding balances in either report after the money has been received from the funding source.

The columns displayed are included in the report; however, if you find specific columns unnecessary, you can remove columns by clicking Toggle Columns. To hide a column from the report, clear the selected check box. To include the column, select the check box.

Desktop

If a column has been hidden from the report, upon navigating away from the screen, the column will remain hidden until the check box is selected via Toggle Columns.

The Current Page Totals and Grand Page Totals are listed at the bottom of the report.

The Current Page Totals displays the total for select columns, such as the Invoiced Amount total for the selected page.

The Grand Totals displays the total for the entire report for select columns, such as Outstanding Student Balance. This amount will be the same regardless of the page selected, as it is the grand total.

Note: These totals change based on any applied filters to the data. For more information on using Filters, see Additional Features.

Desktop
Additional Features

You have the ability to save your report options before or after running the report.

a. To save a report, click the floppy disk icon.

Receivables Report

b. Enter the Report Name and click Save.

 

Desktop

c. To edit a report name after saving, select the report in the pull-down, and then click the blue arrow icon.

Desktop

d. Edit the Report Name and click Save.

Desktop

e. In order to generate a saved report, from the Receivables Report screen, select the saved report from the pull-down; your report will generate automatically.

Desktop

f. To delete a saved report, select the report from the pull-down and click the trash can icon.

Desktop

g. Click OK in the confirmation message.

Loading Article

To navigate through the listed pages, click the Prev and Next buttons. To jump to a specific numbered page, type the number in the Page text box and press Enter.

Receivables Report | Billing | SIS Administrator Help | TOC | Documentation for Administrators | ScreenSteps

Click the Excel icon in the Export section to export the report to an Excel spreadsheet, where it can then be saved to your computer.

To print the report, click the Print icon in the Export section.

Receivables Report

Click Filter to further breakdown your report without having to change the report criteria and rerun the report.

Receivables Report

a. You can add more than one filter to a column by clicking the green plus sign.

b. To delete an additional filter, click the red minus sign.

c. For additional filtering options, click the gray arrow for a filter pull-down.

See Filters for more information.