Summary Metrics

Ledger Entry Report

Generate Reports

This report contains all level 2 and 3 enhanced data sent by Visa and Mastercard for cleared fleet transactions. Report data can be obtained for a specific time period.

Overview

Data for this report is available as follows:
- **Earliest available**: 18 months from today
- **Latest available**: Current day and time

Data Availability

| Field name | Data type | Description |
|:---|:---|:---|
| created_at | DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ) | The date when the transaction was posted to the financial account. |
| card_product_id | String | Unique identifier for the card product. |
| card_product_name | String | Name of the card product. |
| account_holder_id | String | Unique identifier for the account holder. |
| payment_card_id | String | Unique identifier for the payment card. | 
| payment_network | String | The payment network: `VISA` or `MASTERCARD`. | 
| financial_event_id | String | Unique identifier for the financial event. | 
| transaction_id | String | Transaction lifecycle identifier. For example, two transaction events (AUTH and CLEAR) make up one complete transaction lifecycle, so both events will have the same transaction lifecycle id. Multi-clearing transaction events with different `financial_event_id`s will share the same `transaction_id`. |
| network_reference_id | String | A value used by the payment network to reference the transaction. The value may not be unique across all the networks' transactions. |
| merchant_category_code | String | Merchant Category Code (MCC) is a four-digit number listed in ISO 18245 for retail financial services. MCC is used to classify the business by the type of goods or services it provides. |
| merchant_id | Number | Identifier for the merchant. |
| merchant_name | String | The name of the merchant where the transaction took place. |
| merchant_description | String | The merchant name and locations where the transaction took place. | 
| requested_amount | Decimal | The amount of funds requested for each transaction event type. |
| requested_amount_currency_code | String | The currency code for `requested_amount`. | 
| approved_amount | Decimal | The amount approved from the authorization for the transaction. | 
| approved_amount_currency_code | String | The currency code for the `approved_amount`. | 
| total_posted_amount | Decimal | The amount that Highnote posts to the Highnote Ledger for each cleared transaction event. | 
| total_posted_amount_currency_code | String | The currency code for the `total_posted_amount`. | 
| purchase_type | String | Specifies whether the transaction was fuel only or mixed (fuel and non-fuel). |
| fuel_sale_amount | Decimal | The total amount for only fuel purchased. | 
| fuel_sale_amount_currency_code | String | The currency code for the `fuel_sale_amount`. |
| fuel_unit_price | Decimal | The price per unit for fuel purchased. | 
| fuel_unit_price_currency_code | String | The currency code for the `fuel_unit_price`. |
| fuel_unit_of_measure | String | The unit of measure utilized for fuel purchased. |
| fuel_quantity | Decimal | The quantity of fuel purchased. | 
| fuel_type | String | Contains the product code for fuel purchased. | 
| odometer_reading | Number | The odometer reading if entered by the cardholder. | 
| fleet_id | String | An alphanumeric value representing either a vehicle, driver, or generic ID if entered by the cardholder. |

Report Fields

Fleet Enhanced Data Summary Report

Issue Your First Card

Test Your Integration

Using Ledgers

Controlling Authorizations with Spend Rules

Order Physical Cards

Managing Financial Accounts

Highnote API

Search & Filters

Events and Notifications

Client Tokens and SDKs

Quick Start Templates

Dashboard

Issue Cards

Control Authorizations

Transfer Funds

Handle Transactions

Manage Credit

Onboard Accounts

Compliance

Card Design

Get Started

Test the API

Accept Payments

Simulate Payments

Offer Rewards

Highnote Overview

Intro to GraphQL

Using the Highnote API

Rotating API Keys

API Rate Limiting

Request Complexity

API Error Handling

Search

API Status and Changes

Using the Dashboard

Notifications

Events

Events Reference

Launch Checklist

Basics

Issuing Overview

Virtual Cards

Physical Cards

Digital Wallets

Design Your Card Experience

Marketing and Collateral

Cards in Marketing

Co-Brands

Onboard an Account

Request Documents for Application Review

Onboard Authorized Users

Update Account Information

Close an Account

Manage Card Profiles

Print Physical Cards

Issue Preprinted Physical Cards

Display Cards and Balances

Manage Cards

Add Cards to Digital Wallets

Print Cards in Bulk

Transaction Lifecycle

Simulate Transactions

Simulate Fleet Transactions

Build a Transaction Feed

Deliver Statements

Fees

Chargebacks and Disputes

Configure Spend Rules

Configure Velocity Controls

Collaborative Authorization

Add Funds to your Balance

Connect External Accounts

Add Funds to an Account

Transfer between Financial Accounts

Move Funds Out of Highnote

On-demand Funding

Payroll Advance

Create Credit Plans

Find Variable Interest Rates

Assign a Credit Line

Simulate Application Denial

Collaborative Application Decisioning

Create Secured Deposit Offer

Set and Update a Credit Limit

Schedule Repayments

Handling Account Delinquency

Simulate Delinquency

SCRA and MLA

Create Reward Earn Rule

Configure Reward Redemption

Redeem Rewards

Adjust and Find Rewards

Using Reports

Card Interchange Activity Report

Card Transaction Activity Report

Consumer Credit

Commercial Charge

Consumer Charge

Secured Commercial Charge

Fleet

AP Automation

Consumer Prepaid

Commercial Prepaid

Payroll

IssuingRe

Client Tokens

Card Viewer SDK

Secure Inputs SDK

Document Upload SDK

Support

SDKs

Acquiring Overview

Online Payments

Recurring Payments

Simulate Authorizations and Declines

Display Transactions

Acquiring

Field name	Data type	Description
created_at	DateTime (ISO 8601: YYYY-MM-DDTHH:MM:SSZ)	The date when the transaction was posted to the financial account.
card_product_id	String	Unique identifier for the card product.
card_product_name	String	Name of the card product.
account_holder_id	String	Unique identifier for the account holder.
payment_card_id	String	Unique identifier for the payment card.
payment_network	String	The payment network: `VISA` or `MASTERCARD`.
financial_event_id	String	Unique identifier for the financial event.
transaction_id	String	Transaction lifecycle identifier. For example, two transaction events (AUTH and CLEAR) make up one complete transaction lifecycle, so both events will have the same transaction lifecycle id. Multi-clearing transaction events with different `financial_event_id`s will share the same `transaction_id`.
network_reference_id	String	A value used by the payment network to reference the transaction. The value may not be unique across all the networks' transactions.
merchant_category_code	String	Merchant Category Code (MCC) is a four-digit number listed in ISO 18245 for retail financial services. MCC is used to classify the business by the type of goods or services it provides.
merchant_id	Number	Identifier for the merchant.
merchant_name	String	The name of the merchant where the transaction took place.
merchant_description	String	The merchant name and locations where the transaction took place.
requested_amount	Decimal	The amount of funds requested for each transaction event type.
requested_amount_currency_code	String	The currency code for `requested_amount`.
approved_amount	Decimal	The amount approved from the authorization for the transaction.
approved_amount_currency_code	String	The currency code for the `approved_amount`.
total_posted_amount	Decimal	The amount that Highnote posts to the Highnote Ledger for each cleared transaction event.
total_posted_amount_currency_code	String	The currency code for the `total_posted_amount`.
purchase_type	String	Specifies whether the transaction was fuel only or mixed (fuel and non-fuel).
fuel_sale_amount	Decimal	The total amount for only fuel purchased.
fuel_sale_amount_currency_code	String	The currency code for the `fuel_sale_amount`.
fuel_unit_price	Decimal	The price per unit for fuel purchased.
fuel_unit_price_currency_code	String	The currency code for the `fuel_unit_price`.
fuel_unit_of_measure	String	The unit of measure utilized for fuel purchased.
fuel_quantity	Decimal	The quantity of fuel purchased.
fuel_type	String	Contains the product code for fuel purchased.
odometer_reading	Number	The odometer reading if entered by the cardholder.
fleet_id	String	An alphanumeric value representing either a vehicle, driver, or generic ID if entered by the cardholder.