Creating New Expenses from My Imported Credit Card Transactions

Follow

The My Imported Credit Card Transactions tool, which uses data from the Reconciliation and Accruals Workbench, holds your own credit card transaction data from a corporate credit card feed. This report can be helpful to reconcile and find transactions that were either deleted or did not import into your Certify Wallet

This article shows you, a report submitter, how to create new expenses from My Imported Credit Card Transactions

Please Note: If you are using a small business, or personal credit card feed, please see: Recovering Credit Card Expenses.

Step 1: On your account home page, select Analytics

my_imp_cc_tran_3.png

Step 2: Open My Imported Credit Card Transactions under Travel and Expense Analysis.

 my_imp_cc_tran_1.png

Step 3: Use the search parameters to filter your results.

my_imp_cc_tran_2.png

Step 4: The report will not only detail credit card expenses that imported to your wallet correctly, but it will also detail deleted expenses, as well as expenses that did not import correctly. 

  • Deleted expenses will be highlighted in red.
  • Unmatched (did not import) expenses will be highlighted in yellow.

Columns include:

• Credit Card Date: The date of the transaction
• Credit Card Posting Date: The posting date of the transaction
• Card Number: Last four digits of the credit card number
• Cardholder Name: The cardholder name
• Transaction ID: The transaction ID from the credit card transaction
• Credit Card Amount: The amount from the credit card transaction
• Credit Card Currency: The currency from the credit card transaction
• Credit Card Orig Amount: The original amount from the credit card transaction
• Credit Card Orig Currency: The original currency from the credit card transaction
• Credit Card Vendor: The vendor from the credit card transaction
• Credit Card Location: The location from the credit card transaction
• P-Card Program: The P-Card Program the file is tied to
• Match Status: This will contain one of 3 values:

--> MATCHES TO -->: if there is a matching expense in Certify

*** NO MATCH ***": if there is no matching expense in Certify

*** DELETED ***": if the expense was in Certify but has since been deleted

Step 5: Use the Create Expense link next to the unmatched (yellow) or deleted (red) expense. 

raw_3.png

Step 6: In the new window, select whether to create a single expense or up to 50 at once. 

raw_4.png

Step 7: You will see a confirmation page when the expenses have been created. Refresh the report if necessary. 

raw_5.png

Was this article helpful?
3 out of 4 found this helpful
Have more questions? Submit a request

Comments