Canned Reports
TickeTrak comes with a number of Canned Reports that cover a number of common Report functions and uses. These Reports should not be edited. Instead, if you wish to make changes to them, save the Report under a different name.
The following is a summary of the current Canned Reports, formatted as:
Appeal
Tables can't be imported directly. Please insert an image of your table which can be found here.
All Open Appeals by Date
List of Tickets with the On Appeal status. Includes Online and Manual Appeals.
All Open Online Appeals
List of Tickets with the On Appeal status. Only includes Online Appeals.
Appeal Results by Judgement Date
List of Appeals with Judgements.
Hearing Schedule
Hearing Schedule sorted by Hearing Date.
On Appeal with Note Search - Manual or Online
List of Tickets with On Appeal status. Includes Online and Manual Appeals.
Enter the Manual On Appeal Code for Tickets Appealed Manually, or enter the Online Appeal Code for Appeals made Online. This Report cannot include both types of Appeal without producing duplicate entries.
Online Appeals by Appeal Date
List of Tickets that were Appealed Online.
Boot/Tow
Tables can't be imported directly. Please insert an image of your table which can be found here.
Boot Tow
Boot/Tow records with Account ID and License Plate.
Code Listing
Tables can't be imported directly. Please insert an image of your table which can be found here.
Active Permit Types
List of active Permit Types.
Fee Code Listing
List of Fees.
Template Letter Listing
List of Template Letters.
Vehicle Makes and Models
List of Vehicle Makes and Models.
Violation Listing
List of Violations.
Finance
Tables can't be imported directly. Please insert an image of your table which can be found here.
Aged Account Receivable
Account Receivable report, grouped by the time frame specified.
All Payment Report by Transaction Date
All Payments received by Transaction Date.
Includes Permits created, pending, denied, and approved, and Tickets paid In Office and Online.
All Transactions by Type
Ticket and Permit payments with Payment Types, sorted by Payment Date.
Cash Drawer Reconciliation Report by Cash Drawer
Cash Drawer report by Cash Drawer Number and Transaction Date, with Date, Time, Cashier, Pay Type, Receipt, Amount and Drawer Closed information.
Cash Drawer Reconciliation Report All
Cash Drawer report for all Drawers, with Date, Time, Cashier, Pay Type, Receipt, Amount, and Drawer Closed information.
Cash Drawer Reconciliation Report Date Range
Cash Drawer report by Date Range, sorted by Cash Drawer.
End of Day by Type *
List of payments by Payment Type, Transaction Date, and Cash Drawer Number.
End of Day Listing *
All transactions by Date, with detail.
End of Day Summary *
All transactions by Date, grouped by Payment Types.
Office Transaction Report by Transaction Date
All transactions by Transaction Date. Only includes payments taken In Office for Permits and Tickets.
Online Payments by Transaction Date
All transactions by Transaction Date. Only includes payments taken Online for Permits and Tickets.
Online Permit Billing Export by Payment Type
All Online Permit payments by Payment Type, with Receipt, Reference Number, and Export field.
Online Permit Pending and Denied by Transaction Date
Online Permit requests that are Pending or Denied by Transaction Date, with Person information.
Online Permits with Status by Transaction Date
Online Permits with Status, Transaction Date, Amount, and Person information.
Permit Payments by Transaction Date
Permits by Transaction Date and Amount, with Account ID, Person, Permit Type, and Permit Number information.
Sales Tax Collected
Lists Tax payments and Transaction Dates.
Submitted to Collection
List of Tickets submitted to Collection.
Ticket Collection Export Report by Issue Date
List of Tickets that have been sent to Collection, by Issue Date.
Voided Payments by Void Date
List of Tickets that have been Voided, by Void Date.
Write Off
List of all Fines and Fees that have been Written Off, by Write Off Date.
*E-commerce transactions for Pending Permits will only show on the End of Day Reports on the day they are requested. Once they are approved they will no longer show on the End of Day Reports.
Late Fees
Tables can't be imported directly. Please insert an image of your table which can be found here.
Late Fee Level 1
List of Tickets that have a Level 1 Late Fee by Late Fee Date, including Ticket Issue Amount, Vehicle, and Current Amount Due information.
Late Fee Level 2
List of Tickets that have a Level 2 Late Fee by Late Fee Date, including Ticket Issue Amount, Vehicle, and Current Amount Due information.
Late Fee Level 3
List of Tickets that have a Level 3 Late Fee by Late Fee Date, including Ticket Issue Amount, Vehicle, and Current Amount Due information.
Tickets with Late Fees All
List of Tickets with any Level of Late Fee by Late Fee Date, including Ticket Issue Amount, Vehicle, and Current Amount Due information.
Notices
Tables can't be imported directly. Please insert an image of your table which can be found here.
Notice Level 1
List of Tickets with Notice Level 1 by Notice Date, with Ticket, Vehicle, and Person information.
Notice Level 2
List of Tickets with Notice Level 2 by Notice Date, with Ticket, Vehicle, and Person information.
Notice Level 3
List of Tickets with Notice Level 2 by Notice Date, with Ticket, Vehicle, and Person information.
Tickets with Notices All
List of Tickets with any Level of Notice by Notice Date, with Ticket, Vehicle, and Person information.
Payment Plans
Tables can't be imported directly. Please insert an image of your table which can be found here.
Payment Plans - Active
List of active Payment Plans with Payment Due Dates.
People
Tables can't be imported directly. Please insert an image of your table which can be found here.
Duplicate Person Search
Search for more than one Person record by Last Name using a wildcard (LastName%).
Person Credits Report
List of Person Credits by ID, including Credit Amount and Account Amount Due balances.
Person Import by Entry Date
List of Persons included in Import by Entry Date.
Permit
Tables can't be imported directly. Please insert an image of your table which can be found here.
Duplicate Permits by Account ID
List of Persons who have more than one non-expired Permit.
Permit Address Labels Online Permit
Labels for Online Permit Batch Letters.
Permit Refunds/Credits
Includes all Person Credits.
Will produce duplicates if more than one Credit has been applied to the Person Account.
Permits by Issue Date
Permits by Issue Date, with Person and Licenses Plate and State information.
Permits by Active Date
Permits by Active Date search.
Permits by Expire Date
Permits by Expiration Date search.
Permits by Person Type
List of Permits by Person Type.
Permits by Permit Type
List of Permits by selected Permit Types and Active Date.
Replacement Permits
List of Permits by Issue Date with Issue Amount less than or equal to the chosen Amount.
Permit Billing
This section currently has no Canned Reports.
Reserve Lot Waiting
This section currently has no Canned Reports.
Scofflaw
Tables can't be imported directly. Please insert an image of your table which can be found here.
Scofflaw by License
List of all Active Scofflaws by License Plate, including Scoff Description, License Plate and State, Issue Date, and Source information.
Scofflaw Listing by Scoff Description
List of all Active Scofflaws grouped by Scofflaw Description, with Licenses Plate and State, Issue Date, and Source information.
Statement
Tables can't be imported directly. Please insert an image of your table which can be found here.
Statement Report by Statement Date
List of accounts that have been sent a Statement, by Statement Date.
Ticket
Tables can't be imported directly. Please insert an image of your table which can be found here.
Boot
List of License Plates with five or more unpaid Tickets, by Issue Date.
Chalk Time
List of Tickets with Chalk Time by Issue Date, including Location and License Plate and State information.
Handheld vs Handwritten
List of Tickets by Issue Date, grouped by entry method.
Hold or Encumbered Tickets
List of Tickets that have been placed on Hold or Encumbered, with Local ID, Person Type, and Ticket Number information.
Hold or Encumbered Tickets Today
List of Tickets that have been placed on Hold or Encumbered today, with Local ID, Person Type, and Ticket Number information.
Issued Tickets
List of Tickets that can be grouped by Officer, Location, Issue Date, Issue Time, or Violation.
Officer Statistic Report
List of Tickets by Officer, with Ticket Number, Violation, Status, and Amount Due information.
Ownerless Tickets by Issue Date
List of tickets with a License Plate but no Account ID by Issue Date.
Ownerless Tickets Grouped by Plate/State
List of Tickets with a License Plate but no Account ID, grouped by License Plate and State.
Ticket Amount Due by Issue Date
List of Tickets with an Amount Due by Issue Date, with Violation 1, Location, and Amount Due information.
Ticket by License
List of Tickets issued to a specified License Plate.
Ticket Chalk Time and Location
Search for a specific Ticket Number showing Chalk Time and Location information.
Ticket Number Search with Details
Search for a specific Ticket Number for Issue Date, Violation, Location, License Plate and State, showing Vehicle Make and Model information.
Tickets and Payment by Issue Date
List of Tickets by Issue Date with Total Fines/Fees Due and Payment information.
Ticket Reprint
Search for a specific Ticket Number to reprint all fields from the original Ticket.
Tickets Issued per Account Count
List of Tickets Issued to an Account, grouped by Account Number.
Tickets Issued per Vehicle Count
List of Tickets Issued to a Vehicle by the number of Tickets Issued.
Tickets Paid by Issued Date
List of Tickets paid by Issue Date.
Tickets Paid by Payment Date
List of Tickets paid by Payment Date.
Tickets per Account
List of Tickets for a specific Account ID with Issue Date, Amount Due, and Violation information.
Time Gap
List of Tickets per Officer within an Issue Time range.
Unpaid Tickets by Issue Date
All unpaid Tickets grouped by Issue Date.
Unpaid Tickets by Violation Code
All unpaid Tickets grouped by Violation Code
Voided Tickets
List of Voided Tickets that can be grouped by Officer, Location, Issue Date, Issue Time, or Violation.
Voided Tickets by Void Date
List of all Voided Tickets by Void Date.
Timed Parking
Tables can't be imported directly. Please insert an image of your table which can be found here.
Timed Parking Vehicles
List of Vehicles in Timed Lots.
Vehicle
Tables can't be imported directly. Please insert an image of your table which can be found here.
DMV Responses
List of Vehicles that have been sent to or returned from the DMV.
Duplicate Vehicles by License Plate
List of Vehicles where there is more than one Vehicle with a given License Plate.
Duplicate VIN Report
List of Vehicles where there is more than one Vehicle with a given VIN.
License Plate by State
List of Vehicles by Entry Date, grouped by License State.