Skip to main content

View Credit Card Transactions by Statement

If your organization has activated the Statements feature, you may view credit card transactions grouped by statement, making it easy to add them to expense reports, see at a glance where that month's expense items are in the approval process, and automatically reconcile them with the corresponding credit card bill.

This is especially helpful for users of individually billed cards, who can easily determine when a statement is due, which transactions have already been added to an expense report, and whether those transactions have been approved, exported and paid.

  • Note: Customers who do not wish to activate the Statements feature may still request to have corporate credit card transactions grouped by statement date for most credit card transaction feeds that provide the statement date. A configuration change to the credit card feed may be necessary. If you are interested in taking advantage of this feature, please submit a case via the Chrome River Help Desk.

Group Expenses By Statement

You can easily add all the expenses on one statement to an expense report directly from the eWallet.

1. On the All tab of the eWallet, click the GROUP BY drop-down at the top of the list.

Or just click the STATEMENTS tab in the eWallet.

2. You will see the dates of the statement and the last four digits of the corresponding credit card. Click the arrow next to the total number of items to view all the transactions.

3. If necessary, click the arrow at the bottom of the Expense Type tile to change the expense type.

S - Change Expense Type.png

4. Click the arrow next to the vendor name to view further details.

5. To add all the transactions on that statement to an expense report, click the check box in the upper right to select all and then click the blue plus button.

6. You will have the option to add them to an existing draft expense report or to create a new one.

7. You will have the opportunity to enter details about each expense as it is added to the report.

8. Click the arrow in the gray bar under Downloaded Details to view further information about a transaction—for example, if you need help selecting an expense type.

9. All of the selected transactions will be created as line items on your report.

Personal Cardholder Statements Dashboard

If you have a credit card that you use for business expenses but are individually responsible for paying, the My Statements dashboard will show you your statement details at a glance.

S - Statements Dash.png

  • Current: The number of transactions on the current statement awaiting reconciliation and their total value.
  • Prior: The number of transactions on previous statements still awaiting reconciliation, along with their total value.
  • Upcoming Due: The days until the statement due date. Once the transactions are expensed, the number resets to 0. A negative number indicates that the newest statement was not loaded.

1. Click on CURRENT or PRIOR to be taken to the Bank Statements dashboard in the desired view.

  • The statement's complete details will be displayed on the right.
  • By default, only that statement's transactions unexpensed transactions will be displayed on the left.
  • Click ALL to see every transaction on the statement.
  • Click EXPENSED to see the transactions that have already been added to an expense report.

2. Warning indicators allow you to see each item's status at a glance:

  • A red warning triangle indicates an item that has not been submitted on an expense report.
  • An orange warning triangle indicates an item that has been submitted and is awaiting approval.

3. Click on an item to see more details in the pane on the right. If the item has been submitted, the Tracking section shows you where it is in the approval routing process and who is assigned to approve it.

4. You may use the View drop-down menu to filter what you see on the dashboard.

Cardholder Statements Inquiry Report

1. To access Inquiry Reports, click the MENU button in the upper left corner and then click INQUIRY.

2. Select MY CREDIT CARD STATEMENTS. This report provides the status of all expense items associated with a credit card statement. If you have multiple credit cards, the report will automatically group statements by card.

3. Drag the Statement column heading onto the blue report header bar to group the results by statement.

4. For users who have multiple cards, drag the Account Last Four column heading onto the blue report header bar to create an expandable group of results by the last four digits of each credit card number.

For complete details on using this screen, see View Inquiry Reports on Expense Activity.

Corporate Accounts Payable Statement Management

If you are a member of the Accounts Payable team, you can easily manage centrally billed credit card statements via the Company Statements dashboard. This allows you to see at a glance which transactions are remaining to be approved and who is responsible for expensing and approving outstanding transactions.

S - Co Statements.png

  • Unexpensed Cardholders: The number of cardholders with unexpensed transactions.
  • Unexpensed Statements: The number of statements still awaiting reconciliation.
  • Upcoming Due: The days until the statement due date. A negative number indicates that the newest statement was not loaded.

Click on CARDHOLDERS or STATEMENTS to be taken to the Card Statements dashboard in the desired view.

Cardholders

1. In Cardholders view, you will see a list of all cardholders, the number of items and the total unexpensed amount of these items. Use the search box at the top to search by card holder name or account number.

2. Click on a cardholder to view user details—email address, title and account status—on the left and a list of all transactions for that user on the right.

3. Use the filter drop-down in the upper right to sort the Cardholders list.

Statements

Click the STATEMENTS tab to view details of individual statements.

Approvers

Click the APPROVERS tab to view all the transactions awaiting approval, grouped by approver.

Credit Card Statements Reconciliation ANALYTICS Reports

These reports allow you to view detailed information on statement expenses. You can view statement owners, total amounts spent, transaction status, and links to individual transactions that have not been reconciled.

1. Click the MENU button in the upper left corner and then click REPORTS.

2. Under Expense, select either Credit Card Statements Reconciliation Detail or Credit Card Statements Reconciliation Summary, depending on the level of detail you want.

For complete details on using ANALYTICS Standard Reports, see In-App Standard and Ad Hoc Analytics Reports.

Was this article helpful?