Previous

Next

Print

Expenditure analysis reports

Transaction search - company

This report allows an administrator or manager to view any transactions made by employees within their company. If report scheduling is enabled for your company, additional search options will appear.

Within Additional Fields, the SE Group option stands for Service Establish Group and SE Type stands for Service Establish Type. This is a way to classify suppliers similar to merchant category codes and merchant category groups, but is specific to AMEX and Diners data, whereas the merchant category code classification is specific to Visa and Mastercard data.

Transaction - enhanced data

This report allows a user to see which transactions exist in the system with enhanced data.

Enhanced data analysis

This report allows a user to see which transactions exist in the system with enhanced data and which transactions exist without enhanced data. Note: It only returns merchant-related transactions (ie. purchases or credit vouchers) as other transaction types aren't typically supplied with enhanced data. If report scheduling is enabled for your company, additional search options will appear.

Statement Issuer. This option restricts the search to a particular statement issuer.

Statement Period. This option restricts the search to a particular statement period. To restrict the search by date range instead of period, leave the field blank.

Account Type. This option restricts the search to a particular account type, eg. corporate card, requisition card, or all account types.

Start Date/End Date. Set a date range for the period you want to review.

Posting Date. This option searches for transactions with a posting date (the date the transaction was lodged at the bank) that falls inside the date range specified in the Start Date/End Date fields.

Transaction Date. This option searches for transactions with a transaction date (the date the purchase was actually made) that falls inside the date range specified in the Start Date/End Date fields.

Enhanced Data. This option restricts the search at the transaction level of the report to only those transactions with or without enhanced data (extra information appended to a transaction at the point of sale), or both.

Summary By. This option displays the first screen of high-level results (the summary view) by enhanced data category, merchant group, account, or as a single list of transactions.

Group By. This option groups information on the lowest, most-detailed results view by enhanced data category or merchant category.

Enhanced Data Category. This option restricts the search to a particular enhanced data category. To search by all categories, leave the field blank. To search by an additional category, click More..

Type. This option restricts the search to a particular enhanced data type for the selected enhanced data category. To search by two or more enhanced data types within the same category, click More.. To search by all data types, leave the field blank.

Value. This option allows you to search for a particular piece of enhanced data for the selected enhanced data category and enhanced data type. The search returns anything starting with or containing the value you enter. To search for all values for the selected category and type, leave the field blank.

Report Mode. This option allows you to run the report in employee mode, which restricts the search to accounts mapped to an employee, or account mode, which returns accounts based on the account hierarchy used by the issuer (accounts linked to a 'parent' billing or control account). Note that the selected mode changes the names of some search fields. For example, Employee First Name Forename vs Account Holder Forename and Company Unit vs Hierarchy Node.

Merchant information

Supplier Name. To restrict the search to a particular supplier, enter the full or partial name in the field. For example, ‘sm’ would return suppliers beginning with 'sm', such as Smith Holdings.

Merchant Group. This option restricts the search to transactions from suppliers belonging to a specific merchant group.

Merchant Category. This option restricts the search to transactions from suppliers belonging to a specific merchant category. To define the merchant category, type its full or partial name. For partial names, use the wildcard character %. For example, if you enter %or, the search could potentially find transactions for suppliers belonging to the Florists or Book Stores merchant categories.

Preferred Supplier. This option restricts the search to transactions from preferred suppliers, suppliers that don't fall into the preferred category, or both.

Employee information

Employee ID. To restrict the search to a particular individual, enter their unique employee ID in the field.

Employee First Name/Employee Last Name. To restrict the search to a particular name, enter the full or partial name in the fields. For example, ‘dan’ as a first name would return account holders with names beginning with Dan, such as Daniel or Danny. Entering ‘%dan’ returns names containing dan, such as Daniel or Brendan.

Company Unit. If your organization uses company units, you can restrict the search to a particular unit (and anything lower in the hierarchy), all units or any employees not allocated to a unit. Company units are displayed in the list according to the company's hierarchical structure.

Selected Node Only. This option restricts the search to the node selected in the Hierarchy Node field, and ignores anything lower in the hierarchy.

Currency & amount

Source Currency. This option restricts the search to transactions made in a particular currency.

Billing Currency. If your organization operates in more than one country, you can restrict the search to transactions billed (charged) in a particular currency.

Transaction Amount. To restrict the search by billing amount, use the comparison operators (=, <, >, <=, >=) in the drop-down box and enter an amount in the text box.

Enhanced data details

This section allows you to define what enhanced data fields display in your report. Selecting an enhanced data category will apply all summary and detail-level enhanced data fields for that category to your report. To view or select a subset of these fields, click Right-facing white arrow in orange square. Note that not all enhanced data fields will display for an enhanced data category; only those currently populated within any transactions loaded into the application to date for the company.

Report templates

This section allows you to save defined search parameters as a template for quick and easy future use.

Spend Wizard analysis

This report allows an administrator or manager to analyze the use of Spend Wizards across their company.

Spend - employee

This report allows a manager to view all spend made by an employee for a selected period.

Spend - financial coding

This report allows a manager to view spend across an entire department or division, or all spend against a particular finance code. This report is only available to the manager of the particular code; however managers of codes higher in the hierarchy can also drill into this report.

Suppliers - company

This report allows an administrator or manager to view detailed data about the suppliers used within their company. If report scheduling is enabled for your company, additional search options will appear.

Suppliers - employee

This report allows an employee to view the suppliers they have personally used. If you are a manager, you can also view the suppliers used by the employees you are responsible for.

Suppliers - top spend

This report allows an administrator or manager to see which suppliers the company's employees have transacted with the most.

Analysis - company

This report allows senior managers to analyze spending patterns across their entire company.

Analysis - employee

This report allows managers to analyze the spending pattern of the employees they manage. It includes information on total spend per month, average spend and transaction count.

Analysis - expense report

This report allows users to view transactions that have been linked to an expense report. Note: The name of the report is controlled by the value assigned to the implementer-level setting Item Label - Expense Report.

Environmental impact

This report shows an administrator how much paper their organization has saved by using this online transaction management system.