Summary/Use Case
Report Summary
The "Purchases by Account Number" report provides a detailed breakdown of purchases categorized by account number, displaying transaction details such as vendor, invoice, PO number, and total cost. This report is beneficial for fleet managers in tracking expenditures by account number, helping identify spending patterns and monitor budget adherence.
Use Case
Analyze purchase transactions by specific account numbers for budget tracking.
Identify vendors associated with high purchase volumes.
Support financial audits by providing a comprehensive purchase record.
Monitor spending within specified date ranges for fiscal control.
Assist in cost allocation for departmental budgeting and financial planning.
Location: Where to Find It
Reports > RTA Standard Reports > Parts > Purchases by Account Number
Data Filter Prompts
You will be prompted for filtering of the Data to specify and narrow down the data that will be pulled. See Data Filter List Below for Options.
Data Filter List
Filter Name | Recommended Filter Condition(s) | Value (Options) | Value (Default) | Value (Notes) |
|---|---|---|---|---|
Facility | Equal To | Specific facility ID | 00001 | blank |
Account Codes | Is Between | Range of account codes | " " to "999999999" | First and last possible values for account codes |
Date Range | Is Between | Start and end date | 10/01/2024 to 10/31/2024 | Represents the full month of October 2024 |
Vendors | Is Between | Range of vendor IDs | " " to "zzzzzzz" | First and last possible values for vendors |
Report Output and Data Elements
The "Purchases by Account Number" report displays a structured list of purchase transactions by account number, with data organized to show vendor details, invoice numbers, purchase orders, and the received dates. Totals are calculated per account number and a grand total is provided at the end of the report, summarizing the expenditures.
Report Output
Report Data Elements
Column Number | Column Title | Data Notes |
|---|---|---|
1 | Account Number | Identifies the account associated with the purchase |
2 | Vendor | Name or ID of the vendor involved in the transaction |
3 | Invoice | Invoice number for the purchase |
4 | PO Number | Purchase order number related to the transaction |
5 | Received Date | Date the items were received |
6 | Total Cost | Total cost of the items in the transaction |