Expense Report Detail inquiry

Use this inquiry to see detailed information for your expense reports.

At a glance, you can see the project and phase associated with an expense report, and the activity and amount associated with an individual expense.

If needed, you can add predefined columns and view supplemental information such as the row where this expense appears in the expense report.

Using the inquiry

From the > Reports menu, click Standard Inquiries > Employee > Expense Report Detail.

Audience

Accounting staff

Standard columns

Column	Links to this inquiry	Description	Date range available
Employee	Employee	The name of the employee submitting the expense
Beginning Date		The first date covered by the expense report	x
Ending Date		The last date covered by the expense report
Description		A description of the expense Examples: Mileage, Office Supplies, Travel Expenses
Project ID & Description	Project	The ID and description of the project associated with the expense Personal expenses are not associated with a project.
Phase ID & Description	Phase	The ID and description of the phase associated with the expense Personal expenses are not associated with a phase.
Activity Description	Activity	The description of the activity associated with the expense Examples: Administration, Billable Time, Blueprints, Meetings, Mileage, Other Consultant, Photocopies, Travel, Vacation
Date		The date the expense was incurred	x
Units		The number of units associated with the expense
Cost Rate		The rate that reflects the actual cost (without overhead or profit) of the expense
Cost Amount		The out-of-pocket cost to the company for the expense
Payee		The recipient of the payment for the expense
Credit Card	Bank Account	The credit card used for expense
Personal		Indicates whether the expense is a personal expense
Notes		Any notes about the expense
Defined links:
GL Entry - Accrual	GL Entry - Accrual	A link to the GL Entry - Accrual inquiry

Predefined columns

You can add predefined columns to this inquiry. These columns are available:

Column	Links to this inquiry	Description
Expense Report Key		The database identifier of the expense report
Expense Report Company Key		Multi-company only. The database identifier of the company associated with the expense report
Expense Report Company Name		Multi-company only. The name of the company associated with the expense report
Expense Row		The row where this expense appears in the expense report
Employee Key	Employee	The database identifier of the employee submitting the expense
Project Key	Project	The database identifier of the project associated with the expense
Project ID	Project	The ID of the project associated with the expense
Project Description	Project	The description of the project associated with the expense
Phase Key	Phase	The database identifier of the phase associated with the expense
Phase ID	Phase	The ID of the phase associated with the expense
Phase Description	Phase	The description of the phase associated with the expense
Phase Order		The order of the phase associated with the expense
Project Company Key		Multi-company only. The database identifier of the company associated with the project
Project Company Name		Multi-company only. The name of the company associated with the project
Credit Card Key	Bank Account	The database identifier of the credit card used for the expense
Reference		The short description that further identifies the resource, which you can use to distinguish consultant or expense budget items
Manager Notes		Any notes about the expense from the manager
Rejected By Key		The database identifier of the person who rejected the expense
Rejected By		The name of the person who rejected the expense
Defined links:
Link - GL Entry - Cash	GL Entry - Cash	A link to the GL Entry - Cash inquiry
Link - Vendor Invoice	Vendor Invoice	A link to the Vendor Invoice inquiry
Link - Bank Entry	Bank Entry	A link to the Bank Entry inquiry