American Express @ Work1 Reporting

 

User Guide

This guide provides an overview of @ Work Reporting, the self-service reporting platform for clients of American Express Global Commercial Payments. This guide covers navigation of the tool and the setup process for Standard and Customised reports. For information about the Standard and Customised formats, as well as the specific report templates we offer, please refer to the @ Work Reporting Guide, which can be found under Reporting Help on the @ Work Reporting home page.

 

For more detailed instructions we offer a concise, self-guided training module as well as live instructor-led online training sessions. Information can be found by visiting Reporting Help on the @ Work Reporting home page.

Getting Started

Basic Navigation

basic navigation main
session timer
reporting session
view reports
build reports
search
basic filter
One
One filled

The Session Timer tells you how many minutes remain in your current session. To refresh this timer perform any action on the current page.

 

 

Two
two filled

The Reporting Help link provides you with help and best practice documents.

Set Preferences for your @ Work Reporting experience such as your timezone, language, default currency, and email notifications.

Toggle the display of Alert Messages on this screen, notifying you of any system issues, scheduled upgrades, or maintenance.

 

 

three
three filled

VIEW REPORTS -

Available: All reports available for viewing.

Upcoming: A complete list of your scheduled reports.

Deactivated: A list of schedules and related reports that have been deactivated.

 

 

Four
Four filled

BUILD REPORTS -

Most Popular: A list of the most commonly used report templates to support your programmes.

All: The entire list of report templates available for your use. (Additional reports may be enableddepending on your particular programme.)

Saved: Your personally saved Customised report templates.

 

 

Five
Five filled

Search for an item in the selected page.

 

 

six
six filled

Filter the items in the selected view using helpful options.

 

 

View Reports: Available Reports

The Available Reports section allows you to view, open, and manage your previously run reports.

view reports main
sort the reports
view thumbnails
number of reports in the grouping
click arrow
view reports click on icons
One
One filled

Sort the reports in the selected view alphabetically or by date.

 

 

Two
two filled

Visual thumbnails depict the Type of report (i.e. Airplane for Airline Reports).

 

 

three
three filled

The number on the thumbnail represents how many reports are in the grouping.

 

 

Four
Four filled

Click the arrow next to the report name to reveal setup information and previous iterations of the same report.

 

 

Five
Five filled

Click on the icons to open/download your report. The icons depict the type of report and its format.

 

 

View Reports: Options

Expand the Options button next to each report to reveal actions that are available for that report and schedule.

view reports options

OPTIONS — CUSTOMISED REPORTS

Customise: Takes you to the Customised setup screen.

Delete Report: Deletes a specific report.

Export: Takes you to Export screen with options for Excel, PDF, CSV, HTML, and plain text.

OPTIONS — STANDARD REPORTS

Customise: Takes you to the related Customised setup screen with the hierarchy preselected.

Deactivate Schedule: Will no longer run automatically, moves to Deactivated page.

Delete Report:Deletes a specific report.

Delete All Reports: Deletes all reports in a group.

Delete Schedule: Deletes schedule, but not report.

Modify Setup: Takes you to Standard setup screen(or Customised schedule screen).

Rename Schedule: Quickly rename the schedule.

Rerun: Request reruns of previous months (up to13 months).

View Reports: Upcoming Schedules

The Upcoming section displays a listing of all scheduled reports.

view reports upcoming schedules
view reports upcoming title
view reports upcoming options
view reports upcoming setup
One
One filled

View the report title and use the arrow to reveal more information.

 

 

Two
two filled

Use the Options button to manage your schedule settings, request reruns, or deactivate/delete the schedule.

 

 

three
three filled

View current Setup Information.

 

 

View Reports: Deactivated Schedules

view reports deactivated

The Deactivated section displays any report schedules that have been deactivated. Deactivation of a schedule means the report will no longer be generated automatically at the scheduled frequency. Any reports that were generated before the schedule was deactivated will still be available via the corresponding File Type icon. Reports that have not been viewed or downloaded in a 120-day period are automatically deactivated.

The Options menu allows you to reactivate or fully delete report schedules, as well as delete individual reports that ran under those schedules.

Build Reports: Most Popular

Build Reports: All

This view displays all the reports that apply to your organisation’s programme with American Express. Refer to the Report Guide under Reporting Help for details about all of our reports.

build reports all
start button to begin setup process
click on report name
build reports all view sample
One
One filled

Click the Start button to begin the report setup process (for reports that are available in both Standard and Customised formats, you will be prompted to choose your format on the screen that follows).

 

 

Two
two filled

Click on the report name for information about available formats.

 

 

three
three filled

Find more information and screenshots of the available formats via the View Sample link.

 

 

Report Builder: Create a Standard Report

Once you have chosen to run a Standard report, follow the onscreen steps to set up the report to run automatically. Keep in mind that Standard reports will not run immediately; timing is based on the  of the report as well as your programme’s billing cycle. For example, monthly reports run every month after your programme’s cycle ends. Once a report has run it will be posted to your Available Reports list and you will receive a notification.

report builder
report builder filter
report builder hierarchy
report builder selection
report builder save
report builder next
One
One filled

Use the Filter when searching for specific types of programme hierarchies.

 

 

Two
two filled

Select the desired Hierarchy or hierarchies and click the right arrow icon to move your selection to the right side of the screen.

 

 

three
three filled

Your selection will appear here.

 

 

Four
Four filled

To save this hierarchy selection for future reports,click the Save as Default button.

 

 

Five
five filled

Click Next to continue with the setup process.

 

 

create standard report
report builder frequency
report builder additonal
report builder request
report builder run
six
six filled

Set the Frequency of the report in the bill date section. In this example, Monthly is the only option, however some Standard reports let you choose between monthly, quarterly, etc.

 

 

Seven
seven filled

Additional Options allow you to rename your report, set currency, language, format, and more.

Recommendation: Update the name of your report for easier identification when it appears on the Available Reports page.

 

 

Eight
eight filled

Check this box to request a report from the previous available billing period. All subsequent reports will be delivered to your Report List after each billing cycle.

 

 

nine
ten filled

Once you have selected your options, click Run Report.

 

 

Standard Report Results

Standard reports can be viewed in either PDF or Excel formats. The PDF format offers on-screen insights highlighting and summarising key data. The Excel format offers additional data elements.

PDF Version

pdf version
pdf report name
pdf summary level
One
One filled

Report name, month, currency and other report-specific details.

 

 

Two
two filled

Summary level data highlighting key insights.

 

 

Excel Version

 

excel version
excel report name
excel summary level
excel use
One
One filled

Report name, report month, reporting Group and other

report-specific details.

 

 

Two
two filled

A summary of the report.

 

 

three
three filled

Use the Excel version to manipulate, sort and analyse data.

 

 

eAccount Review

 

eAccount review

Available in PDF or PowerPoint, this unique Standard Report provides a summary of your programme including key metrics and meaningful insights into your company’s spend.

› Multiple pages with data and insights tailored to your programme.

› Charts and graphs provide visual representation of overall programme spend.

› Key insights to help you make important, informed decisions.

Note: The first page of the PDF provides key insights and the following pages provide details.Use the PDF version to gain insight into your programme, print this version for a portable summary of key metrics.

Report Builder: Create a Customised Report

Customised reports run immediately and provide useful filter and additional data element options. Your results will be delivered to your browser where you can perform additional filtering and export to various formats including PDF and Excel. You can also save your Customised report templates and set them to run on a schedule if desired.

report customized
report customized breadcrumb
report customized search
report customized filter
report customized hierarchy
report customized selection
report customized save
report customized next
One
One filled

The breadcrumb trail will show where you are in the setup process.

 

 

Two
two filled

Enter a programme hierarchy name or number in the Search field to find the desired hierarchy for your report.

 

 

three
three filled

Use the Filter when searching for specific types of programme hierarchies.

 

 

four
four filled

Select the desired hierarchy or hierarchies and click the right arrow icon to move your selection to the right side of the screen. Hold the shift or control keys to select multiple items.

 

 

five
five filled

Your selection will appear here.

 

 

six
six filled

To save this hierarchy selection for future reports click the Save As Default button.

 

 

seven
seven filled

Click Next to continue with the setup process.

 

 

Report Builder: Create a Customised Report – Additional Options

report customized run report
report customized additional
report customized breadcrumb additional
report customized reports
report customized timeframe
report customized update
One
One filled

Follow the breadcrumb trail to complete the steps to build your report. The Additional Options step must be filled out prior to continuing.

 

 

Two
two filled

Some customised reports provide several views. These views may impact the date, filters, and additional data options in the selection process.

 

 

three
three filled

Choose the timeframe for your report. Depending on the template, you may see several different date options, including Bill Date, Charge Date, and Business Process Date. You can select a custom date range or choose a predefined date option. If you plan to set your report to run on a schedule, use a predefined date option. For example, if you select a Bill Date = Previous Month, the report will return data for any cycle(s) that closed during the previous calendar month.

 

 

four
four filled

We recommend that you update the name of your report for easier identification when it appears on the Available Reports page. (e.g. Hotel Activity for Western Division)

 

 

five
five filled

Click Next to further customise your report with Filters and Additional Data elements, or click Run Report to use the default selections.

 

 

Report Builder: Create a Customised Report – Filters

Filters are optional and allow you to narrow your results prior to running the report.

report customized filter
report customized quick filters
report customized clear
report customized advanced
customized filter next run
One
One filled

Use the Quick Filters for the most common filtering options.

 

 

Two
two filled

Clear All Selections button to remove all selections in this step and return to the default selections.

 

 

three
three filled

Use the Advanced Filter selections to choose more granular options. Examples of popular choices are provided in the Appendix at the end of this guide.

 

 

four
four filled

Click Next to further customise your report with Additional Data elements, or click Run Report to use the default selections.

 

 

Report Builder: Create a Customised Report — Additional Data

Each Customised report template comes with default data elements (i.e. columns) pre-selected, however you can add, remove, or reorder them as needed.

report builder additional data
additional data checkboxes
additional data display
additional data clear
additional data run
One
One filled

Use the check boxes to add or remove elements from your reports.

 

 

Two
two filled

The Data Display Order and Calculation Display Order boxes show you the order the columns will appear on your report. Use the arrows to the right of the boxes to change your column order.

 

 

three
three filled

Use the Clear All Selections button to remove all selections.

 

 

four
four filled

Once you have made your selections, click Run Report.

 

 

Report Viewer: View Your Customised Report Results

Report Results will be displayed in an on-screen Report Viewer. You can manipulate your results on screen or export them to your computer.

report viewer
report viewer navigation
report viewer report result
report viewer change report
One
One filled

Use the Navigation Bars to perform simple tasks such as: sort columns, display in graph view, and export your report. Hover over each icon to reveal tool tip text.

 

 

Two
two filled

View your report results in an easy-to read format. Click on column headers to sort columns, right click on column headers to reveal advanced functionality. Click on hyperlinked data elements to drill further into your report data.

 

 

three
three filled

Use the Change Report Selections button to re-prompt your report and make changes to your report criteria.

 

 

Appendix: Understanding the Prompts and Filters

Example: Filtering by a Cardmember Account Number

click cardmember

1. Click Cardmember Acct. No. from Available box, click on right arrow to select it.

click value

2. Click on Value link, enter value into box, click OK.

display report

3. Click on ID1 link, then select DISPLAY_REPORT.

equals

4. Click on Equals to change selection logic (if needed).

equals

Some filters require you to select the specific value(s) you’re seeking. Expand the selections using the +. Once you have made your selection use the arrows between the boxes to select your choice.

COMMON FILTER COMBINATIONS

match selections

Tip: When selecting multiple values on a single filter, always select the “Any selection” radio button option if it appears. This will ensure the correct logic is applied.

Terms & Conditions

 

1Use of American Express @ Work ® is restricted to employees, contractors and/or agents that the Company, and its representatives designate for the sole purpose of performing Online Account queries and maintenance, including accessing and/or creating reports relating to the Company's American Express® Corporate Card programmes. @ Work is available to all companies with an American Express Corporate Card programme.

 

Enrollment is required. To enroll in @ Work please contact your American Express Representative or call 1-888-800-8564.

© 2020 American Express.

Was this helpful?

Additional Resources