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 |
00001 - 99999 | 00001 |
blank
Account Codes | Is Between |
Range of account codes
" " to "999999999"
blank - 999999999 | blank - 999999999 |
Date Range | Is Between |
Start and end date
10/01/2024 to 10/31/2024
Any Date Range | First and Last Day of Previous Month |
Vendors | Is Between |
Range of vendor IDs
" " to "zzzzzzz"
First and last possible values for vendors
blank - zzzzzzzz | blank - zzzzzzzz |
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 |