Summary

The Transaction report lists Tax Collection transactions, such as charges, adjustments, abatements, payments, refunds, and transfers (TC> Reports> Transaction). Use it to review the activity on bills for a range of years, sequences, dates, or installments, or to total that activity by purpose code, adjustment code, group, or transaction date.

You choose which transaction types to include in the Codes list, narrow the transactions with the Dates, Ranges, and Tables sections, and control the level of detail and the columns with the Options, Print Options, and Sort sections. All of the report settings display on one page.

Step by Step

1     Open the Transaction window (TC> Reports> Transaction).

• The Codes list displays on the left side of the window. The Dates, Ranges, Tables, Options, Print Options, and Sort sections display on the right.
• If you enter a value that is not valid, an error message displays below the field or section. Correct the value before you print the report.

2     Select the codes to include.

• The Codes list displays each adjustment and transaction type code with its description, sorted by description. Only transactions with a selected code print on the report.
  • Click a code to select or clear it.
  • Check the box at the top of the list to select all codes. Clear it to clear all codes.
• You must select at least one code. If no code is selected, the message "At least one code is required" displays at the top of the list.

3     Complete the Dates section.

• The Report Date field defaults to today and prints on the report. It does not filter the transactions. This field is required.
• Enter a Trans Date From and Trans Date To to include only transactions posted within that date range. Leave both fields blank to include all transaction dates.
• Enter a Due Date From and Due Date To to include only transactions with a due date within that date range. Leave both fields blank to include all due dates.
• The From date cannot be later than the To date.

4     Complete the Ranges section.

• Enter a Year From and Year To to include only bills within that range of tax years. Leave both fields blank to include all years.
• Enter a Seq From and Seq To to define the range of sequences to include. Both fields are required.
  • Type the sequence code, or click the search icon to select a sequence.
  • Sequence codes are whole numbers of up to two digits, and Seq From cannot be greater than Seq To. To report on a single sequence, enter the same code in both fields.
• Enter an installment From and To to include only transactions for that range of installment numbers. Leave both fields blank to include all installments.
  • The labels on the installment fields use the Payment No Heading set in the Collection Profile (TC> Setup> Collection Profile> Display/Report tab> Column Headings). For example, if the heading is Inst, the fields display as Inst From and Inst To.
• Enter an installment Due From and Due To to include only installments whose transactions on the report total an amount within that range. Leave both fields blank to include all installments.
• Enter a Total Due From and Total Due To to include only bills whose transactions on the report total an amount within that range. Leave both fields blank to include all bills.
  • To include only bills with a debit total, enter 0.01 in the Total Due From field.
  • To include only bills with a credit total, enter -0.01 in the Total Due To field.
• Enter a Group From and Group To to include only transactions with a group value within that range. Each field accepts up to 35 characters.
• For each range, the From value cannot be greater than the To value.

5     Complete the Tables section.

• Enter or select a Purpose Table to include only the purpose codes on that table. Leave the field blank to include all purpose codes.
  • Click the search icon to select a purpose table. You can also create a new purpose table from the selection window.
• Enter or select a Parcel Table to limit the report to the parcels on that table. Leave the field blank to include all parcels.
  • By default, the report includes only the parcels on the selected table.
  • Check Exclude to include every parcel except the parcels on the selected table. The Exclude checkbox is available only when you select a Parcel Table. If you clear the Parcel Table field, Cirrus disables Exclude again.
• Enter a Signature Label to print beneath the last signature line on the report. This field is available only when Signature lines is checked in the Print Options section.

6     Complete the Options section.

• Check Summary only to print totals by the options selected in the Sort section instead of each transaction. If you leave this unchecked, the report prints the detail for each transaction, including the year, sequence, and bill number.
• Check Grand totals only to print only the grand totals page.
• When you check Summary only or Grand totals only, Cirrus disables every option in the Print Options section except Signature lines.

7     Complete the Print Options section.

• The print options add information to each transaction on a detailed report.
  • Check Account number to print the bill's account number.
  • Check Owner name to print the owner name.
  • Check Owner address to print the owner mailing address.
  • Check Location address to print the location address (street number, unit, street name, direction, city, state, and zip code).
  • Check Original taxable to print the original taxable value.
  • Check Original amount to print the original amount billed.
  • Check Notes to print the note entered on each transaction.
  • Check Vehicle ID, Vehicle year, Vehicle make, and Vehicle reg. no. to print the vehicle information on the bill.
• Check Signature lines to print three signature lines at the end of the report. This option is unchecked by default and is available for detailed, summary, and grand totals reports.
  • When you check Signature lines, the Signature Label field in the Tables section becomes available.

8     Complete the Sort section.

• The Sort grid has three rows. Each row sets one level of sorting. The report sorts by the first row, then by the second row, then by the third row.
• Click the Sort cell in a row and select a sort option: Parcel ID, Year/Seq/Bill No, Adjustment Code, Group, Purpose Code, or Trans Date.
  • You must select a sort option in at least one row, even when Summary only or Grand totals only is checked. If no row has a sort option, the message "At least one sort option is required" displays above the grid.
• Check Page Break in a row to start a new page each time the value of that sort option changes.
• Check Subtotal in a row to print a subtotal each time the value of that sort option changes.

9     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 PDF to print the report in the default Springbrook PDF format.
  • Select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once a print option is selected, that option will automatically be selected the next time you access the report. For example, if you select Excel from the drop-down menu, the next time you access the report the Excel button   will be displayed by default.
• 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. Hover over the Info icon   to view the parameters on the previous report.
  • This section will display the last ten times the report was generated.

10     Review the report.

• The report lists the selected transactions in the order set in the Sort section. Within each sort group, transactions print in the order they posted.
• Subtotals print for each sort row with Subtotal checked, and grand totals print at the end of the report.
• When Signature lines is checked, three signature lines print at the end of the report, with the Signature Label beneath the last line.