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

1     Open the Payment Balance window (TC> Reports> Payment Balance).

2     Configure the report.

• The Report Date field defaults to today's system date. Enter or select a reference date for the report.
• The Status field 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.
• The Year From and Year To fields are used to enter a beginning and/or ending year to define a range of years to include in the report.
• The Sequence From and Sequence To fields 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 button to select a sequence from a list.
• The Installment From and Installment To fields 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.
• The Interest Date field 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.
• The Purpose Table field 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.
• The Transaction Date From and Transaction Date To fields 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.
• The Due Date From and Due Date To fields 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.
• The Installment Due From and Installment Due To fields 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.
• The Total Due From and Total Due To fields 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.
• The Batch Number From and Batch Number To fields 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.
• The Parcel Table field 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 the Exclude Specified Parcel Table toggle 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 the Summary Only toggle 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.
• The Sort By field is used to sort the report by Bill Number or ID. This option is not available when the Summary Only toggle is checked.
• The Print section 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.
• The Report Totals section 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.
• The Totals Sort field is used to sort the report totals by Year/Sequence or Sequence/Year.

3     Print 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 icon next 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 click SUBMIT.
• 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. This section will display the last three times the report was generated.