Overview

A credit note item is a type of accounting record representing a specific entry or line item within a credit note. In a credit note, there may be multiple credit note items, each representing a distinct reason for the credit adjustment. These items provide a detailed breakdown of the adjustments made, specifying the quantity, description, and amount credited for each individual issue. Credit note items provide transparency and clarity into the nature of the corrections made to the original transaction. In some cases, credit note items are used where there are no associated invoice records to link.

Credit note item records are displayed in Leapfin as follows:

Credit note item record creation

Leapfin captures the following standard and custom fields when creating credit note item records. These fields ensure that all necessary data is recorded as transactions flow in from your integrated payment service providers (PSPs), allowing you to make data-driven decisions and create precise accounting rules based on your accounting policies.

While the tables below describe the general data fields that comprise this record type, there may be nuances based on your integrated PSP. For information on how these fields are mapped for each specific integration, see the Data section of the Help Center.

Standard fields

In Leapfin, each credit note item record is comprised of the following standard data fields:

Standard fields	Description

Standard fields	Description
`objectType`	The target accounting record. For example, the `objectType`for a credit note item record is credit note item.
`id`	The unique identifier for the record. This is an external id received by Leapfin from your payment processor.
`amount`	The amount of the purchased goods or services, excluding tax and discount. This value should be negative.
`currencyCode`	The 3-digit ISO code of the `amount` field, such as USD or GBP. This code indicates the primary currency of this record.
`date`	The date and time the credit note item was created.

Optional fields

Leapfin can also bring in the following optional fields to use for reporting, determining journal entry logic, and configuring specific journal entries:

Custom fields	Description

Custom fields	Description
`description`	A description of the credit note item.
`startDate`	The start date and time of the subscription, if applicable.
`endDate`	The end date and time of the subscription, if applicable.
`exchangeRates`	A list of exchange rates used to calculate currency conversions. Each rate contains the following values: `currencyCode`: The 3-digit ISO code of the `amount` field, such as USD or GBP. This code indicates the primary currency of this record. `rate`: The conversion rate from primary currency to target currency (`amount` in primary currency * `rate` = converted amount in target currency).
`links`	The directional relationships that connect this record to other accounting records. Credit note item records are typically linked to credit note records. Leapfin adds links with the following fields: `objectType`: The target accounting record. `id`: The unique identifier for this record.
`customFields`	The additional fields related to this record.

{
    "objectType": "credit-note-item",
    "id": "credit_note_item_001",
    "amount": -30,
    "currencyCode": "USD",
    "description": "a sample credit note item",
    "date": "2021-01-16T11:28:31",
    "startDate": "2021-01-20T00:00:00",
    "endDate": "2022-01-21T00:00:00",
    "exchangeRates": [
      {
        "currencyCode": "EUR",
        "rate": 0.84
      },
      {
        "currencyCode": "GBP",
        "rate": 0.73
      }
    ],
    "links": [
      {
        "objectType": "credit-note",
        "id": "creditnote_001"
      }
    ],
    "customFields": {
      "field1": "value1",
      "field2": "value2"
    }
}

Query credit note item records in your data warehouse

Credit note item records cannot be queried in your connected data warehouse at this time.

Product Documentation

Credit note item records

Overview

Credit note item record creation

Standard fields

Optional fields

Query credit note item records in your data warehouse

Related content