Comdata Expense Management System -- CEMS |
 |
Comdata Expense Management System -- CEMS |
|
The following reports are available only to administrators and coders ().
Note: For reports including the company value, you can select a specific company or include all companies available to you.
| Report Name | Description | Role Accessible | Filter Criteria | Field List |
| Accounting File Export Report |
A report containing all data from an exported accounting file. Note: This report can only be generated after exporting an accounting file. |
Administrator and Coder | None. Must be generated after exporting an accounting file. | Cardholder Company Transaction ID Transaction Date Card Number Merchant Name Vendor Code Amount GL Account Job Number Phase Code Job Cost Type Equipment Cost Code Cost Category Gallons Project Business Unit Subledger Subledger Type Extra Sub Job Number Notes Invoice Number Invoice Date Image File Name |
| Business Unit Transaction by Date - Excel Format |
A report of all transactions coded by the business unit coding type by a specific date range. This report can be exported to a Microsoft Excel format. |
Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date |
Employee ID Name Merchant Name City State Zip Transaction Date Posted Date Transaction Amount Allocation Project Description Business Desc Cost Type Description Cost Code Description GL Account SubLedger SubLedger Desc Status Import Status Approval Status Approval Date Approver Name Account Code Customer ID Control Number Group Name |
| Cardholder Account Listing |
A list of all cardholder accounts. |
Administrator and Coder | N/A | Employee ID Name Role Division Department Code Last Login Date |
| Cardholder Statement |
A list of statements for every cardholder.
|
Administrator, Cardholder and Coder | Transaction Posted Start Date Transaction Posted End Date |
Cardnumber (header) Employee ID (header) Statement Date Range (header) Transaction Date Posted Date Merchant Name City Name State MCC Category Transaction Amount Number of Transactions (summary) |
| Coder Approver Grouping |
A grouping of Coders and Approvers with their assigned Cardholders. |
Administrator and Coder | Company Code Select Role Select Employee Selected Employee |
Company Employee ID Last Name First Name Role Division |
| Default Coding by Cardholder |
A report of every Cardholder who has default coding. |
Administrator and Coder | Company Code | CardNumber Company Employee ID MCC Number Type Company GLAccount Job Number Job Phase C.T. Equipment Number Equipment Cost Category |
| Fleet - Diesel Fuel Tax by State (on-road diesel fuel tax report by state) |
A report of the tax on diesel fuel in every state in your company's network.
|
Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Transaction ID Cardnumber Cardholder Lastname Date Code (product) Product Description Vehicle Number State MCC Quantity Price Total |
| Fleet - Fuel Usage by Cardholder - Excel Format | A report of all fuel transactions by cardholders. This report can be exported to a Microsoft Excel format. |
Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date |
Employee ID Name (cardholder) Transaction ID Cardnumber Merchant Name Transaction Date Posted Date Code (product) Product Description Vehicle ID State Quantity Price Total |
| Fleet - Fuel Usage by Cardholder | A report of all fuel transaction by cardholders. | Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date |
Transaction ID Cardnumber Merchant Name Date Code (product) Product Description Vehicle ID State MCC Quantity Price Total |
| Fleet - Fuel Usage by Vehicle ID | A report of the amount of fuel used by each vehicle. | Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date |
Transaction ID Cardnumber Code (product) Product Description State MCC Quantity Price Total |
| Fuel Purchase Top 15 Percent *Grouped by Employee and Division |
A list of the top 15% of non-diesel fuel purchases by cardholder. | Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date |
Date Merchant Name Quantity State Code (product) Product Description Gallons Amount |
| Fuel Usage by Equipment ID | Displays the transactions coded to an Equipment ID for a specified date range | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Transaction ID Card Number Merchant Name Transaction Date City State MCC Quantity Amount Product Code Product Description Product Quantity Product Price Product Total Cost |
| GL Account Code List |
A list of all GL account codes.
|
Administrator and Coder | Active Records Only All Records |
GL Account Code Account Description Code Type Equipment Category Code Equipment Category Description |
| High Dollar Transactions *Grouped by Employee ID and Division |
Allows you to search transactions by a dollar amount. For example, if you enter 100 as the amount, a detailed list will generate showing all transactions at $100.00 or more. | Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date Amount |
Date Merchant Name City State Description Total Due |
| Meals and Entertainment | Allows you to search all meals and entertainment transactions by a dollar amount. For example, if you enter 100 as the amount, a detailed list will generate showing all M&E transactions at $100.00 or more. | Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date Amount |
Date Merchant Name City State Description Total Due |
| Orphaned Transactions |
A list of all orphaned transactions. These are transactions that are not tied to a cardholder account.
|
Administrator and Coder | N/A | Cardnumber Posted Date Merchant Name City State Cardholder Key (group header) Employee ID (group header) Transaction Amount Cardholders (footer) Transactions (footer) Grant Total (footer) |
| Sub Account Transaction by date by company |
A report of all transactions with sub account coding type by date range and by company. |
Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date Import Status Status |
Account Code CustId Last Name (cardholder) First Name (cardholder) Card # Employee ID Post Date Transaction Date Control Number Transaction ID Merchant Type Coded Company Default Company Default Division GL Account GL Description Internal Order Sub Account Fuel Type Gallon Amount Approve Group Name |
| Transaction Activity by Date by Company - Excel Format | A report of transaction activity by date and company. This report can be exported to a Microsoft Excel format. | Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date Import Status - Posted, Imported, Not Flagged Status - Reviewed, Uncoded |
Account Code Customer ID Last Name (cardholder) First Name (cardholder) Cardnumber Employee ID Posted Date Transaction Date Control Number ID Amount Merchant Type Coded Coded Detail Default Code Default G/L (code) G/L Description Job Number Job Phase Phase Description CT Import Status Equipment ID Approve Status Group Name |
| Transaction Activity by Date - by Cardholder - Excel Format | A detailed report of all cardholders and their transactions in a specified date range. This report can be exported to a Microsoft Excel format. | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date Status - Reviewed, Uncoded |
Account Code Customer ID Last Name (cardholder) First Name (cardholder) Cardnumber Employee ID Posted Date Control Number ID Amount Merchant Name Type (coding) Coded (company) Coded (cost center) Default (company) Default (cost center) G/L Account G/L Description Job Number Phase Phase Description CT (cost type) Import Status Equipment ID Approval Status Group Name Department Department Description |
| Transaction Activity by Date - by Cardholder by Company - Excel Format | A detailed report of all cardholders and their transactions and their company. This report can be exported to a Microsoft Excel format. | Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date Status (Reviewed, Uncoded) |
Account Code Customer ID Last Name (cardholder) First Name (cardholder) Cardnumber Posted Date Transaction Date Control Number ID Amount Merchant Name Type (coding) Coded (company) Coded (cost center) Default (company) Default (cost center) G/L Account G/L Description Job Number Phase Phase Description CT (cost type) Import Status Equipment ID Approval Status Group Name Department Department Description |
| Transaction Activity by Date - Excel Format | A detailed report of all transactions in a specified date range. This report can be exported to a Microsoft Excel format. | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date Import Status - Posted, Imported, Not Flagged Status - Reviewed, Uncoded |
Account Code Customer ID Last Name (cardholder) First Name (cardholder) Cardnumber Employee ID Posted Date Transaction Date Control Number ID Amount Merchant Name Type (coding) Coded (company) Coded (cost center) Default (company) Default (cost center) G/L Account G/L Description Job Number Job Phase Phase Description CT (cost type) Import Status Equipment ID Approval Status Group Name Department Department Description |
| Transaction by Date - by Cardholder - Excel Format | A report of all transactions that occurred in a specified date range for each cardholder. | Administrator and Coder | From Date End Date |
Transaction Date ID Post Date Type Company Division GL GL Description Job Phase Phase Description CT Status Equip ID Merchant Approve amount Card # Company Division Last Name First Name Department Department Description |
| Transaction by Date - Excel Format | A report of transactions that occurred in a specified date range | Administrator and Coder | From Date End Date Import Status: Posted - Transaction Posted, Imported - Transaction Imported but not Posted, Not Flagged - Transaction Not Flagged as Posted or Imported |
Transaction Date ID Post Date Type Company Division GL GL Description Job Number Job Phase Phase Description CT Status Equipment ID Merchant Approve Amount Card # Company Division Last Name First Name Department Department Description |
| Transaction Coding by Cardholder | Administrator and Coder | From Date End Date |
Type Company Division G/L G/L Description Job Number Phase Equipment ID Merchant City State Transaction Date Amount Department Department Description |
|
| Transaction Coding by Cardholder and Approver |
A report of all coded transactions by the Cardholder and Approver. |
Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Type (coding) Company Code Division G/L Account G/L Description Job Phase Phase Description Job Type Equipment ID Merchant Name Date Approval Status Approval Date Amount Department Department Description |
| Transaction Coding by Cardholder with Notes |
A report of coded transactions with attached notes.
|
Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Type (coding) Company Code Division G/L Account G/L Description Job Phase Phase Description Cost Type (job) Equipment ID Merchant Name Transaction Date Amount Notes Department Department Description |
| Transaction Coding by Cardholder |
A report of coded transactions for every cardholder.
|
Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Type (coding) Company Division G/L Account G/L Description Job Number Phase Code Phase Description Equipment ID Merchant Name City State Transaction Date Amount |
| Transaction Coding by Date - Excel Format | A report of coded transactions by their posted date range. | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Date Company Code ID Posted Date Type (coding) Division G/L Account G/L Description Job Number Phase Phase Description Job Cost Type Equipment ID Merchant Name City State Amount Cardnumber Last Name (cardnumber) First Name (cardnumber) |
| Transaction Exception Coding - Cross Company | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Transaction Date ID Type (coding) Company Code Department (division) Employee ID Code Co. G/L Account Code G/L Description Job Number Phase Code Merchant Name Status Amount |
|
| Transaction Export | A detailed report of all transactions that were exported back to the ERP system. | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date Import Status - Approved, Not Approved |
Account Code Company Employee Customer ID Cardnumber Last Name (cardholder) First Name (cardholder) Employee ID Division Employee Vendor Code Cash Vendor Code Department Code Transaction ID Transaction Date Control Number Posted Date Employee ID Transaction Vehicle Number Reporting Level Merchant Code Merchant Name Merchant Address Merchant City Merchant State Merchant Zip Merchant Chain Merchant Group MCC Number Merchant Card Acceptor Status Is Checked? Approval Status Approval Use Approval Date Disputed? Import Status Group Name Group ID Auto Transaction? Amount Coded Coding Type Company Coded Division Coded G/L Account Job Number Job Phase Job Cost Type Equipment Number Cost Category (equipment) Work Order Notes Project Business Unit Project Cost Type Project Cost Code Sub Ledger Sub Ledger Type Invoiced? Invoice Date Credit or Debit Transaction Amount Department Department Description |
| Transaction Listing - Disputed | A list of all disputed transactions. | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Transaction ID Transaction Date Posted Date Merchant Name Merchant City Merchant State Cardnumber Cardholder Name Type Reason Total Due |
| Transaction Listing by Cardholder | A list of all transactions by cardholder. | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date Report Type - Detail or Summary |
Summary Cardholder Name Number of Cards Number of Transactions Total Due Detail Transaction ID Transaction Date Posted Date Merchant Name Cardnumber Total Due |
| Transaction Listing by MCC |
A list of transactions by their Merchant Category Code. | Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date Detail or Summary Report Report Value |
Transaction ID Transaction Date Posted Date Merchant Name Cardnumber Cardholder Name Total Due |
| Transaction Listing |
A detailed listing of all transactions in a given date range. |
Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Transaction ID Transaction Date Posted Date Merchant Name Merchant City State Cardnumber Cardholder Name MCC MCC Category Total Due |
| Transaction Summary by MCC | A summary of all transactions by their MCC. | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
MCC Number Category Total Due |
| Transaction Uncoded by Date - by Cardholder - Excel Format | A report of transactions that are in uncoded status by cardholder. This report can be exported to a Microsoft Excel format. |
Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Transaction Date ID Posted Date Type (coding) Company Code Division G/L Account G/L description Job Number Phase Code Phase Description CT (cost type) Status Equipment ID Merchant Name Approval Status Amount Cardnumber Company Code (default) Division (default) Last Name (cardholder) First Name (cardholder) |
| Transaction Uncoded by Date - Excel Format | A report of transactions that are in uncoded status by a specified date range. | Administrator and Coder | Import Status - Posted, Imported, Not Flagged | Transaction Date ID Posted Date Type (coding) Company Code Division G/L Account G/L description Job Number Phase Code Phase Description CT (cost type) Status Equipment ID Merchant Name Approval Status Amount Cardnumber Company Code (default) Division (default) Last Name (cardholder) First Name (cardholder) |
| Transactions Coded with Receipt Images by Job number | Allows you to pull a transactions coded with receipt images report by one or more job number. | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date Company Code Job Number |
Merchant Name Transaction Date Location Cost Type GL Account Amount Notes Product Information Transaction ID MCC Code |
| Transactions Coded with Receipt Images of Sub Account | Allows you to pull a transactions coded with receipt images report by the sub account coding type. | Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date Company Code |
Transaction Date Location GL Account Internal Order Sub Account Fuel Type Gallons Amount Product Information Transaction ID MCC Code |
| Transactions Coded with Receipt Images | A report of all coded transactions with receipt images attached. | Administrator, Cardholder, and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date Employee ID Division |
Cardholder Name Employee ID Transaction Date Merchant Name Merchant City Merchant State Merchant Zip GL Account Code Job Number Phase Code Cost Type (job) Amount Notes Transaction ID MCC Code MCC Description Receipt Image(s) Department Department Description |
| Travel - Airline Detail |
A summary report of all airline transactions.
|
Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Key Posted Date Merchant Merchant City Flight Number Origin Destination Carrier Class Travel Date Amount Passenger Name MCC Number |
| Travel - Airline Summary | A report of all airlines used and how much money was spent with each airline. This report also shows a total of all money spent on airlines. | Administrator and Coder | Company Code Transaction Posted Start Date Transaction Posted End Date |
Airline Number of Cardholders Amount |
| Travel - Hotel Detail |
A report of all cardholders and their hotel expenses.
|
Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Transaction Date Posted Date Hotel Name City State Zip MCC Code Amount Cardholder Name (grouped) Cardholder Amount (grouped summary per cardholder) |
| Uncoded Transaction by Date by Cardholder - Excel Format |
Lists all uncoded transactions within a specified date range. |
Administrator and Coder | Transaction Posted Start Date Transaction Posted End Date |
Transaction Date Employee ID Post Date Type CT Status Equipment ID Merchant Approve Amount Card number Company Division Last Name First Name |
| User Listing Report | A list of every user and their respective roles. | Administrator and Coder | N/A | Company Code Last Name (cardholder) First Name (cardholder) Employee ID Division Department Code Role User Name Status |