Purchases by Account Number

Owned by Andrew Finch
Last updated: Nov 13, 2024
2 min read

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

image-20241111-164237.png

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

image-20241111-164521.png

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Filter Name

Recommended Filter Condition(s)

Value (Options)

Value (Default)

Facility

Equal To

00001 - 99999

00001

Account Codes

Is Between

blank - 999999999

blank - 999999999

Date Range

Is Between

Any Date Range

First and Last Day of Previous Month

Vendors

Is Between

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

image-20241111-164411.png

Report Data Elements

Column Number

Column Title

Data Notes

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