Summary

The Payment Balance Report displays a listing of payments, balances, or a combination of payments and balances. The report can display in detail or summary in addition to totals.

Step by Step

1Open thePayment Balancewindow (TC Reports Payment Balance).

2Configure the report.

• TheReport Datefield defaults to today's system date. Enter or select a reference date for the report.
• TheStatusfield is used to determine what the report will report on.
  • Balance – Select balance to report on balances.
  • Payment – Select payment to report on payments.
  • Payment/Balance – Select payment/balance to report on payments and balances.
• TheYear FromandYear Tofields are used to enter a beginning and/or ending year to define a range of years to include in the report.
• TheSequence FromandSequence Tofields are used to enter a beginning and/or ending sequence to define a range of sequences to include in the report. Click the field search buttonto select a sequence from a list.
• TheInstallment FromandInstallment Tofields are used to enter a beginning and/or ending installment number to define a range of installments to include in the report. Leave these fields blank to include all installments.
• TheInterest Datefield us used to enter or select the date you wish to calculate the interest (penalty).
  • Interest (Penalty) may be calculated when processing a report with status = balance or status = payment/balance with no trans date range entered or if using a trans date range equal or greater than the current system date. The Interest (Penalty) date entered must be equal to or greater than the current system date.
  • The calculations are based on the Interest/Penalty Table associated with the bills Year/Sequence setup, due date, and purpose codes.
• ThePurpose Tablefield is used to enter or select a purpose table to define the summary codes and purpose codes to be included in the report. Click the field search button to select a purpose table from a list.
  • Note: To print purpose detail and/or summary detail within the detail portion of the report, the print checkbox on the purpose table must be checked. To print purpose code and/or summary code totals on the totaling pages of the report, the total checkbox on the purpose table must be checked.
• TheTransaction Date FromandTransaction Date Tofields are used to enter a beginning and/or ending date range to define the dates to be reported. Leave the date range blank to include all dates.
  • Note: if processing a report with status = Balance, use the To date range to reflect balances as of a specific date. When processing a report for status = Balance, the From date is not available/applicable. If processing a report with status = Payment/Balance, the From will only be used for payments.
• TheDue Date FromandDue Date Tofields are used to enter a beginning and/or ending due date range to define a range of due dates to be included on the report.
• TheInstallment Due FromandInstallment Due Tofields are used to enter a range to define the total Inst/Payno/Qtr amount due to be reported if selecting bills based on the balance of the payment numbers. Leave these fields blank to process regardless of the payment number balances.
  • Installment Balance range refers to the balance due before any interest/penalty has been calculated. If however if a partial payment was previously made, then the remaining balance of interest/penalty will be included. Only purposes selected are used when determining if this condition is true or false for the installment and bill.
• TheTotal Due FromandTotal Due Tofields are used to enter a total due range to define a total amount due range to be reported. Leave these fields blank to process regardless of the total amount due.
  • The total due condition can be used in a balance or payment report. If a total due range is specified on a payment/balance report, only the balance column will use the total due condition.
  • The total due from field represents the lowest value; the total due to field represents the greatest value.
  • If processing a Balance or Payment/Balance report and you wish to select debit balance bills only, you must enter .01 in the Total Due From field, otherwise bills with credit balances will be included. If you wish to only include credit balances, you must enter -.01 in the Total Due To field.
  • The total due range refers to the balance due before any interest/penalty has been calculated. If however if a partial payment was previously made, then the remaining balance of interest/penalty will be included. Only purposes selected are used when determining if this condition is true or false.
• TheBatch Number FromandBatch Number Tofields are used to enter or select a batch range to define a range of batches to be reported. The batch number range is only available when processing a Payment or Payment/Balance report and a transaction date range is specified.
• TheParcel Tablefield is used to enter or select a parcel table to define a range of Parcel IDs to be used in processing or leave blank to include all Parcel IDs. Click the field search button to select a parcel table from a list.
  • Check theExclude Specified Parcel Tabletoggle to exclude the Parcel IDs found on the selected Parcel Table.
  • If a parcel table is selected and the Exclude checkbox is unchecked, only those Parcel IDs found on the Parcel Table will be included.
• Check theSummary Onlytoggle to print one line per bill. The Acct No/ID, Bill No, Name, and total balance and/or payment will print. The report will sort/print by account no or ID within each year/sequence.
• TheSort Byfield is used to sort the report by Bill Number or ID. This option is not available when the Summary Only toggle is checked.
• ThePrintsection is used to determine if the Status Code, School Code, Roll Section, and Assessment information (Land Assessed, Total Assessed, Total Taxable, and Exemptions) should be included in the report. Check the toggle next to each item that should be included.
• TheReport Totalssection is used to specify how report totals will be displayed.
  • Check the Brief - Totals Only toggle to only print the totaling pages of the report. This will disable and clear the selections in the Print section to the left.
  • Check the District toggle to print totals to by district.
  • Check the Installment toggle to print totals by installment.
  • Check the Grand Totals toggle to include grand totals in the report.
  • Check the Year/Seq toggle to print totals by year/sequence.
• TheTotals Sortfield is used to sort the report totals by Year/Sequence or Sequence/Year.

3Print the report.

• Once the required report settings have been specified, click the Print button to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule iconnext to the Print button in order to schedule the report to generate at a later date and time.
  • Enter a Date and Time to generate the report and clickSUBMIT.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. Hover over the Info icon to view the parameters on the previous report.
  • This section will display the last three times the report was generated.