> ## Documentation Index
> Fetch the complete documentation index at: https://www.marqeta.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Credit Account Adjustments

> Use this view endpoint to retrieve credit account adjustments data for a program in either a detailed or monthly view. The data is derived from the balance-related activity on the Marqeta platform.

export const EndpointCard = ({method = "API", title, children, href, arrow = true}) => {
  const METHOD_STYLES = {
    GET: {
      bg: "mint-bg-green-400/20 dark:mint-bg-green-400/20",
      text: "mint-text-green-700 dark:mint-text-green-400",
      border: "mint-border-green-300 dark:mint-border-green-700"
    },
    POST: {
      bg: "mint-bg-blue-400/20 dark:mint-bg-blue-400/20",
      text: "mint-text-blue-700 dark:mint-text-blue-400"
    },
    PUT: {
      bg: "mint-bg-yellow-400/20 dark:mint-bg-yellow-400/20",
      text: "mint-text-yellow-700 dark:mint-text-yellow-400"
    },
    PATCH: {
      bg: "mint-bg-orange-400/20 dark:mint-bg-orange-400/20",
      text: "mint-text-orange-700 dark:mint-text-orange-400"
    },
    DELETE: {
      bg: "mint-bg-red-400/20 dark:mint-bg-red-400/20",
      text: "mint-text-red-700 dark:mint-text-red-400"
    },
    API: {
      bg: "mint-bg-black",
      text: "mint-text-white"
    }
  };
  const MethodBadge = ({method}) => {
    const style = METHOD_STYLES[method?.toUpperCase()] ?? METHOD_STYLES.GET;
    return <span className={`
          method-pill rounded-lg font-semibold px-1.5 py-0.5 text-xs leading-5 ${style.bg} ${style.text}`}>
        {method?.toUpperCase()}
      </span>;
  };
  const content = <div className="group flex items-center gap-4 border border-gray-200 dark:border-gray-700 rounded-xl p-5 hover:border-gray-400 dark:hover:border-gray-500 hover:shadow-md transition-all cursor-pointer">
      {}
      <div className="shrink-0">
        <MethodBadge method={method} />
      </div>
      {}
      <div className="flex-1 min-w-0">
        <p className="font-semibold text-gray-900 dark:text-white text-sm leading-snug">{title}</p>
        {children && <p className="mt-1 text-sm text-gray-500 dark:text-gray-400 line-clamp-2">{children}</p>}
      </div>
    </div>;
  if (!href) return content;
  return <a href={href} className="block no-underline border-b-0 mb-2">
      {content}
    </a>;
};

Use this view endpoint to retrieve credit account adjustments data for a program in either a detailed or monthly view. The data is derived from the balance-related activity on the Marqeta platform.

This endpoint supports multiple response formats, query filtering, field filtering, sorting, pagination, and currency conversion. For more information about response options, see [Response Customization](/diva-api/response-customization/).

<h2 id="_retrieve_account_adjustments_detail_json">
  Retrieve account adjustments detail (JSON)
</h2>

**Action:** `GET`\
**Endpoint:** `/views/credit/accountadjustments/detail`

Retrieve account adjustments detail information for a program. This endpoint returns a JSON object that contains an array of records matching your filter query.

<h3 id="_sample_response_body">
  Sample response body
</h3>

The following sample shows a representative response for a `GET` request to the `/views/credit/accountadjustments/detail?program=my_program&fields=amount,description,created_time` endpoint.

```json JSON expandable lines wrap theme={null}
{
  "total": 76,
  "is_more": false,
  "count": 76,
  "info": {},
  "start_date": "2021-04-01T00:00:00+0000",
  "end_date": "2021-04-01T00:00:00+0000",
  "last_run_time": "2021-04-01T00:00:00+0000",
  "schema": [
    {
      "field": "amount",
      "type": "NUMBER",
      "scale": 2.0,
      "character_maximum_length": null,
      "description": "#N/A",
      "display": "Amount",
      "units": null,
      "has_total": true,
      "is_filter_only": false
    },
    {
      "field": "description",
      "type": "TEXT",
      "scale": null,
      "character_maximum_length": 16777216.0,
      "description": null,
      "display": "Description",
      "units": null,
      "has_total": false,
      "is_filter_only": false
    },
    {
      "field": "created_time",
      "type": "TIMESTAMP_NTZ",
      "scale": null,
      "character_maximum_length": null,
      "description": "The time the ACH verification was created.",
      "display": "Created Time",
      "units": null,
      "has_total": false,
      "date_format": "YYYY-MM-DD HH:mm:ss",
      "is_filter_only": false
    }
  ],
  "records": [
    {
      "amount": 3099.4,
      "description": "Minimum Interest Fee Adjustment",
      "created_time": "2021-04-23T00:00:00.000Z"
    },
    {
      "amount": 6108.1,
      "description": "Minimum Interest Fee Adjustment",
      "created_time": "2021-05-01T08:29:12.000Z"
    },

    ...

    {
      "amount": 2705.85,
      "description": "Minimum Interest Fee Adjustment",
      "created_time": "2021-04-02T08:29:42.859Z"
    }
  ]
}
```

<h2 id="_retrieve_account_adjustments_by_month_file_export">
  Retrieve account adjustments by month (file export)
</h2>

**Action:** `GET`\
**Endpoint:** `/views/credit/accountadjustments/detail/{export_type}`

Retrieve account adjustments detail information and export to a file. This endpoint asynchronously generates a file in the specified format and returns a job token for retrieving the file when it is completed. The file contains a list of records matching your filter query.

<h3 id="_url_path_parameters">
  URL path parameters
</h3>

| Fields                                       | Description                                                                              |
| -------------------------------------------- | ---------------------------------------------------------------------------------------- |
| export\_type<br /><br />string<br />Required | File format in which to export the data.<br /><br />**Allowable Values:**<br /><br />csv |

<h3 id="_query_parameters">
  Query parameters
</h3>

| Fields                                   | Description                                                                                                                               |
| ---------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| compress<br /><br />string<br />optional | Type of file compression for the exported file.<br /><br />**Allowable Values:**<br /><br />gz, zip<br /><br />**Default value:**<br />gz |

<h3 id="_sample_response_body_2">
  Sample response body
</h3>

```json JSON lines wrap theme={null}
{
  "token": "111122226c444d8888888a9999ae11111db63da4.csv.gz"
}
```

<h2 id="_retrieve_schema_for_account_adjustments_detail">
  Retrieve schema for account adjustments detail
</h2>

**Action:** `GET`\
**Endpoint:** `/views/credit/accountadjustments/detail/schema`

Retrieve a JSON representation of the account adjustments detail schema. The schema object contains an array of objects that describe the available columns and the data type of each column.

<h3 id="_sample_response_body_3">
  Sample response body
</h3>

The following sample shows a representative response for a `GET` request to the `/views/credit/accountadjustments/detail/schema?program=my_program` endpoint. The schema can vary based on the data you are authorized to access (based on the credentials you provide in your request).

```json JSON expandable lines wrap theme={null}
[
    {
        "field": "token",
        "type": "character varying(36)",
        "display": "Token",
        "description": "#N/A",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "account_token",
        "type": "character varying(36)",
        "display": "Account Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "original_ledger_entry_token",
        "type": "character varying(36)",
        "display": "Original Ledger Entry Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "external_adjustment_id",
        "type": "character varying(36)",
        "display": "External Adjustment Id",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "adjustment_detail_token",
        "type": "character varying(36)",
        "display": "Adjustment Detail Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "related_detail_token",
        "type": "character varying(36)",
        "display": "Related Detail Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "amount",
        "type": "numeric(14,2)",
        "display": "Amount",
        "description": "#N/A",
        "units": "USD",
        "has_total": true,
        "is_filter_only": false
    },
    {
        "field": "currency_code",
        "type": "character varying(3)",
        "display": "Currency Code",
        "description": "The three-number code of the currency.",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "description",
        "type": "character varying(16777216)",
        "display": "Description",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "note",
        "type": "character varying(16777216)",
        "display": "Note",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "reason",
        "type": "character varying(16777216)",
        "display": "Reason",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "created_time",
        "type": "timestamp without time zone",
        "display": "Created Time",
        "description": "The time the ACH verification was created.",
        "date_format": "YYYY-MM-DD HH:mm:ss",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "report_load_timestamp",
        "type": "timestamp without time zone",
        "display": "Report Load Timestamp",
        "description": "UTC time when the record was loaded into Marqeta's reporting system",
        "date_format": "YYYY-MM-DD",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    }
]
```

<h2 id="_retrieve_account_adjustments_by_month_json">
  Retrieve account adjustments by month (JSON)
</h2>

**Action:** `GET`\
**Endpoint:** `/views/credit/accountadjustments/month`

Retrieve a sum of all credit account adjustments for a given month grouped by account. This endpoint returns a JSON object that contains an array of records matching your filter query.

<h3 id="_sample_response_body_4">
  Sample response body
</h3>

The following sample shows a representative response for a `GET` request to the `/views/credit/accountadjustments/month?program=my_program&fields=amount,description,created_time` endpoint.

```json JSON expandable lines wrap theme={null}
{
  "total": 109,
  "is_more": false,
  "count": 109,
  "info": {},
  "start_date": "2021-04-01T00:00:00+0000",
  "end_date": "2021-04-01T00:00:00+0000",
  "last_run_time": "2021-04-01T00:00:00+0000",
  "schema": [
    {
      "field": "account_token",
      "type": "TEXT",
      "scale": null,
      "character_maximum_length": 36.0,
      "description": null,
      "display": "Account Token",
      "units": null,
      "has_total": false,
      "is_filter_only": false
    },
    {
      "field": "total_amount",
      "type": "NUMBER",
      "scale": 2.0,
      "character_maximum_length": null,
      "description": null,
      "display": "Total Amount",
      "units": null,
      "has_total": false,
      "is_filter_only": false
    },
    {
      "field": "month_key",
      "type": "DATE",
      "scale": null,
      "character_maximum_length": null,
      "description": null,
      "display": "Month Key",
      "units": null,
      "has_total": false,
      "date_format": "YYYY-MM",
      "is_filter_only": false
    }
  ],
  "records": [
    {
      "account_token": "<account_token>",
      "total_amount": 0.99,
      "month_key": "2022-08-23T00:00:00.000Z"
    },
    {
      "account_token": "<account_token>",
      "total_amount": 1.01,
      "month_key": "2022-08-01T08:29:12.000Z"
    },

    ...

    {
      "account_token": "<account_token>",
      "total_amount": 2.07,
      "month_key": "2022-08-02T08:29:42.859Z"
    }
  ]
}
```

<h2 id="_retrieve_account_adjustments_by_month_file_export_2">
  Retrieve account adjustments by month (file export)
</h2>

**Action:** `GET`\
**Endpoint:** `/views/credit/accountadjustments/month/{export_type}`

Retrieve account adjustments by month and export to a file. This endpoint asynchronously generates a file in the specified format and returns a job token for retrieving the file when it is completed. The file contains a list of records matching your filter query.

<h3 id="_url_path_parameters_2">
  URL path parameters
</h3>

| Fields                                       | Description                                                                              |
| -------------------------------------------- | ---------------------------------------------------------------------------------------- |
| export\_type<br /><br />string<br />Required | File format in which to export the data.<br /><br />**Allowable Values:**<br /><br />csv |

<h3 id="_query_parameters_2">
  Query parameters
</h3>

| Fields                                   | Description                                                                                                                               |
| ---------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------- |
| compress<br /><br />string<br />optional | Type of file compression for the exported file.<br /><br />**Allowable Values:**<br /><br />gz, zip<br /><br />**Default value:**<br />gz |

<h3 id="_sample_response_body_5">
  Sample response body
</h3>

```json JSON lines wrap theme={null}
{
  "token": "111122226c444d8888888a9999ae11111db63da4.csv.gz"
}
```

<h2 id="_retrieve_schema_for_account_adjustments_by_month">
  Retrieve schema for account adjustments by month
</h2>

**Action:** `GET`\
**Endpoint:** `/views/credit/accountadjustments/month/schema`

Retrieve a JSON representation of the account adjustments by month schema. The schema object contains an array of objects that describe the available columns and the data type of each column.

<h3 id="_sample_response_body_6">
  Sample response body
</h3>

The following sample shows a representative response for a `GET` request to the `/views/credit/accountadjustments/month/schema?program=my_program` endpoint. The schema can vary based on the data you are authorized to access (based on the credentials you provide in your request).

```json JSON expandable lines wrap theme={null}
[
    {
        "field": "account_token",
        "type": "character varying(36)",
        "display": "Account Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "total_amount",
        "type": "numeric(14,2)",
        "display": "Total Amount",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "month_key",
        "type": "date",
        "display": "Month Key",
        "description": null,
        "date_format": "YYYY-MM",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "report_load_timestamp",
        "type": "timestamp without time zone",
        "display": "Report Load Timestamp",
        "description": "UTC time when the record was loaded into Marqeta's reporting system",
        "date_format": "YYYY-MM-DD",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    }
]
```


## Related topics

- [About Credit Account Disputes](/docs/developer-guides/about-credit-account-disputes.md)
- [Reports In-depth](/docs/developer-guides/reports-in-depth.md)
- [About Credit Account Ledger Entries](/docs/developer-guides/about-credit-account-ledger-entries.md)
- [About Credit Account Journal Entries](/docs/developer-guides/about-credit-account-journal-entries.md)
- [About Credit Account Statements](/docs/developer-guides/about-credit-account-statements.md)
