---

Merchant Analysis

Displays each transaction by Merchant Name within Merchant Type. It is a detailed report, which lists each transaction by reference number, statement date and transaction date. Values for Net, Tax and Gross amounts of the transactions are displayed. It also reports the average transaction Net and Gross values for each Merchant.

This report is useful in examining the usage of merchants to see with whom the Account Holders are dealing. The grouping of merchants by type allows the examination of the number of merchants used for similar categories of goods and services, giving the opportunity to seek better terms by consolidating vendors.

The report requires the following parameters:

Parameters

· Programmes · Account Types · Admin Ctrs. · Status · Transaction Groups · Date Type · From Date · To Date · Display Currency · Sort By · Output Format · When

Tips:

· Use the From Date and To Date parameters for ad-hoc reporting (not suitable for auditable statement submission).

· Delete Programmes by selecting them and clicking the Delete selected Programme icon.

· Delete Account Types by selecting them and clicking the Delete selected Account Type icon.

· Delete Admin Ctrs. by selecting them and clicking the Delete selected Admin Ctrs. icon.

· Delete Status by selecting them and clicking the Delete selected Status icon.

· Delete Transaction Groups by selecting them and clicking the Delete selected Expense Groups icon.

The report generates the following fields:

Fields

· Programme ID · Reference Number · Card Type · Effective Transaction Date · Merchant Name · Transaction Description · Short Description · User Name · Unit ID · Location Name · Transaction Code · Status · Status Graphic

· Merchant Category Code · Account Ref No · Tax Code · Line Description · Merchant Number · Tax Receipt · Commit Description · Base Currency Type · Base Currency Rate · Report Currency Type · Report Currency Rate · Original Amount · Report Currency Amount

Notes:

· Programme ID - Programme ID as stored in the warehouse database.

· Programme Description - Programme description as stored in the warehouse database.

· Card Type - Account type.

· Short Description - Account type description.

· User Name - Account Holder's user name.

· Unit ID - Admin Centre of the Account Holder.

· Status Graphic - Status image file name.

· Line Description - Line item description.

· Merchant Number - Merchant number from transaction.

· Commit Description - Purpose.

· Base Currency Type - Standard currency type.

· Base Currency Rate - Standard rate as of transaction date.

· Report Currency Type - Requested currency type for report.

· Report Currency Rate - Currency rate of the requested currency type as of transaction date.

· Local Line Amount - Gross line amount in original currency.

· Converted Amount - Gross line amount in requested currency.

Inlogik Pty Limited