Transaction Detail Roll-up - MS Excel (Report # R101E)

Description

This report can be used to monitor the purchases for each account. Transactions as well as line items and payments are excluded. A CAD converted Transaction Amount and a USD converted Transaction Amount are also presented for single currency roll-up. This report is best viewed in Excel format.

Report Columns

• Transaction ID

• Transaction Date

• Post Date

• Transaction Amount

• Conversion Rate (Settled Currency to CAD)

• Transaction Amount (CAD)

• Conversion Rate (Settled Currency to USD)

• Transaction Amount (USD)

• Merchant Surcharge

• Account Number

• Cardholder Last Name

• Cardholder First Name

• Cardholder Middle Initial

• Central Bill Account

• Billed To Account

• Diversion Account

• Parent Merchant Name

• Merchant Name

• Original Merchant Name

• MCC

• MCC Description

• Merchant Type

• Merchant Address 1

• Merchant Address 2

• Merchant City

• Merchant State/Province

• Merchant Country

• Merchant Postal Code

• Transaction Code

• Transaction Code Reason Code

• Sales Tax

• GST/HST

• PST/QST

• Settled Currency

• Original Currency

• Original Amount

• Exchange Rate

• Item Description

• Item Unit Price Amount

• Item Quantity

• Item Detail Tax Amount

• Line Item Total

• Chart of Accounts

• 1099 Indicator

• Socio-Economic Indicator 1

• Socio-Economic Indicator 2

• Transaction Item COA Segment Value 1

• Transaction Item COA Segment Value 2

• Transaction Item COA Segment Value 3

• Transaction Item COA Segment Value 4

• Transaction Item COA Segment Value 5

• Transaction Item COA Segment Value 6

• Transaction Item COA Segment Value 7

• Transaction Item COA Segment Value 8

• Transaction Item COA Segment Value 9

• Transaction Item COA Segment Value 10

• Hierarchy ID

• Hierarchy Description

• Reference Number

• Transaction Convenience Check Number

• Transaction Authorization Number

• Customer Code

• Transaction Type

• Dispute Indicator

• Dispute Status

• Transaction Export Status Code

• Transaction Approval Status

• Approval Indicator 1

• Transaction Approver Name 1

• Approval Indicator 2

• Transaction Approver Name 2

• Approval Indicator 3

• Transaction Approver Name 3

• Approval Indicator 4

• Transaction Approver Name 4

• Approval Indicator 5

• Transaction Approver Name 5

• Custom Field Value 1

• Custom Field Value 2

• Custom Field Value 3

• Custom Field Value 4

• Custom Field Value 5

• Custom Field Value 6

• Custom Field Value 7

• Custom Field Value 8

• Custom Field Value 9

• Custom Field Value 10

• Transaction Notes

• Order ID

• Order Status

• Requestor