All CruzFly Budget Approvers and Food & Entertainment Approvers are given access to enhanced reporting options, and have the ability to run reports that display the details and statuses of expense reports and/or transactions.
Useful reporting templates have been shared with Approvers, and are accessible through the ANALYTICS section of your CruzFly account.
To open the Analytics section, click on the hamburger menu in the upper left hand corner of your account dashboard and select ANALYTICS. This will open a separate tab of your current web browser.
From the “Shared Reports" tab, open the following folders and subfolders:
- University of California – Santa Cruz
- Shared Content
- CruzFly Admin
- Approver Reports
The “Approver Reports” folder contains useful report templates that have been shared with all approvers. Although these reports may be run from this location, it is highly recommended that approvers “favorite” these reports from the Analytics section, so that they are more easily accessible from your CruzFly account dashboard. This is a one-time step that will allow these reports to be run directly from your CruzFly account rather than through the Analytics section.
To do so, right-click on the individual reports and select “Add To Favorites”.
Once reports have been added as favorites, they will be able to be run from the “Reports” section, found in the hamburger menu of your CruzFly account.
The reports will be shown under the “Ad Hoc” section, under “Favorites”. By clicking “RUN REPORT”, you will be prompted to apply various filters to filter the results.
Please note that the “Department” filter pertains to the department on record for the expense owner, which may not always be accurate. An expense owner may submit an expense report using the funding of one department, but they may be associated with a different department. Filtering by the expense owner(s) or Level 4 Org(s) is recommended when possible.
Approver Reports:
Unreconciled Expenses Report
This report will display expenses that have not yet been posted to the general ledger. This will include expenses that have not yet been submitted, as well as those that have been submitted but are still pending further action prior to posting to the ledger.
Report Filters and Full Column Descriptions:
Optional filters
Expense Owner - The cardholder that made the purchase
Department - Refers to the department that the expense owner is associated with, which may differ from the funding used on the expense.
Full Column Descriptions:
Column |
Title |
Description |
A |
Statement Date |
Refers to the date on which the expense posted to US Bank |
B |
Transaction Date |
Refers to the date on which the transaction occurred |
C |
Expense Owner |
The expense owner is the cardholder that made the purchase |
D |
Department |
The department on record that is associated with the expense owner |
E |
Email Address |
Expense Owner’s email address (If the expense owner’s CruzFly account is no longer active, the email address will display as “xxxxx.ucsc.edu@chromewallet.com”) |
F |
Report ID |
Unique identifier of the Expense Report in CruzFly that contains the expense |
G |
Report Name |
Name given to the expense report |
H |
Expense Type |
Determined by the user when choosing their expense. This Expense Type will also determine if F&E Approval is required |
I |
Submit Date |
Date that the expense report was submitted. This will be blank for expenses that have not been submitted |
J |
Report Status |
Status of the expense report that contains the specific expense
- Not Used = Not yet submitted
- Submitted = Pending approval or already approved and pending posting. Approval Status in column K will provide further details
- Returned = Returned back to the expense owner from one of the approval workflow steps
|
K |
Approval Status |
Status of the specific expense item
RET = Returned, PEND = Pending Approval, APP = Approved and awaiting posting, BLANK = not yet submitted
(For more details on expense items that are pending approval, refer to the Pending Expenses - Approval Routing report) |
L |
Amount |
Total amount of expense |
M |
Fund |
Fund code used on the expense |
N |
Org |
Org code (6 digit) used on the expense |
O |
Account Code |
Account code used on the expense |
P |
Activity Code |
Activity code used on the expense. This will display only on the report as "888888" when an activity code is not used. |
Q |
Level 4 Org |
Refers to the level 4 (4-digit) Org code that the 6-digit Org used on the expense rolls up to. CruzFly approvals are routed to queues based on this level 4 Org code |
R |
Report Link |
Opens a PDF of the expense report that contains the specific expense. You must be logged in to CruzFly with your default web browser for the link to open properly. |
click to view full size image
Pending Expenses - Approval Routing
This report will display submitted expense items that are currently pending approval or awaiting posting to the general ledger, and will indicate the current approval status and workflow step. This report displays each individual pending expense item and will not include unsubmitted expenses and those that have been posted to the ledger.
Report Filters and Full Column Descriptions:
Optional filters:
Expense Owner - The cardholder that made the purchase
Department - Refers to the department that the expense owner is associated with, which may differ from the funding used on the expense.
Level 4 Org - Refers to the level 4 (4-digit) Org code that the 6-digit Org used on the expense rolls up to. CruzFly approvals are routed to queues based on this level 4 Org code.
Full Column Descriptions:
Column |
Title |
Description |
A |
Statement Date |
Refers to the date on which the expense posted to US Bank |
B |
Transaction Date |
Refers to the date on which the transaction occurred |
C |
Expense Owner |
The expense owner is the cardholder that made the purchase |
D |
Department |
The department on record that is associated with the expense owner |
E |
Email Address |
Expense Owner’s email address (If the expense owner’s CruzFly account is no longer active, the email address will display as “xxxxx.ucsc.edu@chromewallet.com”) |
F |
Report ID |
Unique identifier of the Expense Report in CruzFly that contains the expense |
G |
Report Name |
Name given to the expense report |
H |
Expense Type |
Determined by the user when choosing their expense. This Expense Type will also determine if F&E Approval is required |
I |
Rank |
A required column to specify the current workflow step in column J |
J |
Workflow Step |
Refers to the step of the current approval queue for the specific expense |
K |
Queue Name |
The group approval queue that the expense is pending approval from, or from where the expense was returned.
- L3 = Accounts Payable
- BA = Budget Approval
- FE = Food & Entertainment
|
L |
Approver |
The specific approver that the expense is pending approval from, or the approver who returned the expense |
M |
Approval Status
|
Status of the specific expense item
RET = Returned, PEND = Pending Approval, APP = Approved and awaiting posting, BLANK = not yet submitted
(For more details on expense items that are pending approval, refer to the Pending Expenses - Approval Routing report) |
N |
Fund |
Fund code used on the expense |
O |
Org |
Org code (6 digit) used on the expense |
P |
Account Code |
Account code used on the expense |
Q |
Activity Code |
Activity code used on the expense. This will display only on the report as "888888" when an activity code is not used. |
R |
Level 4 Org |
Refers to the level 4 (4-digit) Org code that the 6-digit Org used on the expense rolls up to. CruzFly approvals are routed to queues based on this level 4 Org code |
R |
Report Link |
Opens a PDF of the expense report that contains the specific expense. You must be logged in to CruzFly with your default web browser for the link to open properly. |
S |
Amount |
Total amount of expense |
T |
Report Link |
Opens a PDF of the expense report that contains the specific expense. You must be logged in to CruzFly with your default web browser for the link to open properly. |
click to view full size image
Pending Expense Reports - Summary
This report will display a summary of expense reports that are currently pending approval or awaiting posting to FIS. This report displays each expense report as one row, regardless of the number of transactions included.
Report Filters and Full Column Descriptions:
Optional filters:
Expense Owner - The cardholder that made the purchase
Department - Refers to the department that the expense owner is associated with, which may differ from the funding used on the expense.
Level 4 Org - Refers to the level 4 (4-digit) Org code that the 6-digit Org used on the expense report rolls up to.
Full Column Descriptions:
Column |
Title |
Description |
A |
Expense Owner |
The expense owner is the cardholder that made the purchase |
B |
Department |
The department on record that is associated with the expense owner |
C |
Email Address |
Expense Owner’s email address (If the expense owner’s CruzFly account is no longer active, the email address will display as “xxxxx.ucsc.edu@chromewallet.com”) |
D |
Report ID |
Unique identifier of the Expense Report in CruzFly that contains the expense |
E |
Report Name |
Name given to the expense report |
F |
Amount |
Total amount of the expense report, which is the sum of all included expenses |
G |
Report Link |
Opens a PDF of the expense report that contains the specific expense. You must be logged in to CruzFly with your default web browser for the link to open properly. |
click to view full size image
Pending Expense Reports - Detail
This report will display the expense items included in a specific expense report that are currently pending approval or awaiting posting to FIS, and will only return results for expense reports that are either pending approval or awaiting posting to FIS. This report displays each individual expense item included in a specific expense report, and will indicate the current approval status and workflow step for each expense item.
The Report ID (unique report identifier) is required to run this report. The Pending Expense Reports - Summary Report contains a link embedded in the Report ID listed, and will download this Detail report when clicked. You must be logged into CruzFly using your default internet browser for the report link to download properly.
Report Filters and Full Column Descriptions:
Required filter:
Report ID - Unique identifier of the Expense Report in CruzFly ( 12-digit number)
Full Column Descriptions:
Column |
Title |
Description |
A |
Statement Date |
Refers to the date on which the expense posted to US Bank |
B |
Transaction Date |
Refers to the date on which the transaction occurred |
C |
Expense Owner |
The expense owner is the cardholder that made the purchase |
D |
Department |
The department on record that is associated with the expense owner |
E |
Email Address |
Expense Owner’s email address (If the expense owner’s CruzFly account is no longer active, the email address will display as “xxxxx.ucsc.edu@chromewallet.com”) |
F |
Report ID |
Unique identifier of the Expense Report in CruzFly that contains the expense |
G |
Report Name |
Name given to the expense report |
H |
Expense Type |
Determined by the user when choosing their expense. This Expense Type will also determine if F&E Approval is required |
I |
Rank |
A required column to specify the current workflow step in column J |
J |
Workflow Step |
Refers to the step of the current approval queue for the specific expense |
K |
Queue Name |
The group approval queue that the expense is pending approval from, or from where the expense was returned.
- L3 = Accounts Payable
- BA = Budget Approval
- FE = Food & Entertainment
|
L |
Approver |
The specific approver that the expense is pending approval from, or the approver who returned the expense |
M |
Approval Status
|
Status of the specific expense item
RET = Returned, PEND = Pending Approval, APP = Approved and awaiting posting, BLANK = not yet submitted
(For more details on expense items that are pending approval, refer to the Pending Expenses - Approval Routing report) |
N |
Fund |
Fund code used on the expense |
O |
Org |
Org code (6 digit) used on the expense |
P |
Account Code |
Account code used on the expense |
Q |
Activity Code |
Activity code used on the expense. This will display only on the report as "888888" when an activity code is not used. |
R |
Level 4 Org |
Refers to the level 4 (4-digit) Org code that the 6-digit Org used on the expense rolls up to. CruzFly approvals are routed to queues based on this level 4 Org code |
R |
Report Link |
Opens a PDF of the expense report that contains the specific expense. You must be logged in to CruzFly with your default web browser for the link to open properly. |
S |
Amount |
Total amount of expense |
T |
Report Link |
Opens a PDF of the expense report that contains the specific expense. You must be logged in to CruzFly with your default web browser for the link to open properly. |
click to view full size image
Posted/Exported Expenses
This report will display expenses that have been fully approved and posted to FIS, and includes the FOAPAL used. This report displays each individual expense item.
(Missing or invalid FOAPAL information is corrected upon posting to FIS/Banner, please reach out to cruzfly-help@ucsc.edu for more information if you notice a discrepancy between FIS/Banner and the report data.)
Report Filters and Full Column Descriptions:
Required filter:
Bank Statement/Posting Date - This is the actual date that the expense was posted to US Bank, referred to as the “Statement Date” on the report.
Optional filters:
Expense Owner - The cardholder that made the purchase
Department - Refers to the department that the expense owner is associated with, which may differ from the funding used on the expense.
Level 4 Org - Refers to the level 4 (4-digit) Org code that the 6-digit Org used on the expense rolls up to.
Full Column Descriptions:
Column |
Title |
Description |
A |
Statement Date |
Refers to the date on which the expense posted to US Bank |
B |
Transaction Date |
Refers to the date on which the transaction occurred |
C |
Expense Owner |
The expense owner is the cardholder that made the purchase |
D |
Department |
The department on record that is associated with the expense owner |
E |
Email Address |
Expense Owner’s email address (If the expense owner’s CruzFly account is no longer active, the email address will display as “xxxxx.ucsc.edu@chromewallet.com”) |
F |
Report ID |
Unique identifier of the Expense Report in CruzFly that contains the expense |
G |
Report Name |
Name given to the expense report |
H |
Expense Type |
Determined by the user when choosing their expense. This Expense Type will also determine if F&E Approval is required |
I |
Amount |
Total amount of expense |
J |
Fund |
Fund code used on the expense |
K |
Org |
Org code (6 digit) used on the expense |
L |
Account Code |
Account code used on the expense |
M |
Activity Code |
Activity code used on the expense. This will display only on the report as "888888" when an activity code is not used. |
N |
Level 4 Org |
Refers to the level 4 (4-digit) Org code that the 6-digit Org used on the expense rolls up to. CruzFly approvals are routed to queues based on this level 4 Org code |
O |
Report Link |
Opens a PDF of the expense report that contains the specific expense. You must be logged in to CruzFly with your default web browser for the link to open properly. |
click to view full size image