> ## Documentation Index
> Fetch the complete documentation index at: https://developers.pleo.io/llms.txt
> Use this file to discover all available pages before exploring further.

# How to Apply Data Mapping

export const WhatComesNext = ({children, href}) => <div className="mt-4">
    <a href={href} className="
        inline-flex items-center justify-center
        rounded-full
        bg-black text-white dark:bg-[#1f262b]
        px-5 py-2.5 text-sm font-medium
        no-underline border-0
        hover:bg-[#ffe6ea] dark:hover:bg-[#2b1f23]
        hover:text-black
        transition-colors
      ">
      {children} →
    </a>
  </div>;

export const DataMappingDiagram = () => {
  const diagram = `
%%{init: {"themeVariables": {"fontSize": "22px"}}}%%
flowchart LR
    S1["1. Map Mandatory Datapoints"] --> S2["2. Map Invoice Datapoints"] --> S3["3. Map Optional Datapoints"] --> S4["4. Apply VAT Handling Rules"] --> S5["5. Build Final Entry Structure"]

click S1 "#1-map-mandatory-datapoints"
click S2 "#2-map-invoice-datapoints-if-applicable"
click S3 "#3-map-optional-datapoints"
click S4 "#4-apply-vat-handling-rules"
click S5 "#5-build-final-entry-structure"

style S1 white-space:normal
style S2 white-space:normal
style S3 white-space:normal
style S4 white-space:normal
style S5 white-space:normal
`;
  return <Mermaid chart={diagram} />;
};

export const WorkflowDiagramTopNavASERP = ({highlight}) => {
  const highlightStyle = highlight ? `style ${highlight} stroke:#f63b92,stroke-width:5px` : "";
  const diagram = `
%%{init: {"themeVariables": {"fontSize": "30px"}}}%%
flowchart LR
    
    WF1["Pleo APIs"] 

    subgraph ERP["AS/ERP"]
    direction LR
        START1[" "]  
        A["1.Determine Bookkeeping Method"] --> B["2.Apply Accounts Mapping"]
        B --> C["3.Apply Data Mapping"]
        C --> D["4.Transfer Attachments"]
        D --> E["5.Assign Accounting Period"]
        E --> F["6.Apply Posting Behaviour"]
    end

    WF2["Pleo APIs"] 

    WF1 --> A
    F --> WF2

    %% Click actions
    click WF1 "/docs/current/how-tos/accounting-integrations/how-to-fetch-export-item-data-for-as-erp-processing"
    click A "/docs/current/how-tos/accounting-integrations/how-to-determine-the-bookkeeping-method-for-as-erp-processing"
    click B "/docs/current/how-tos/accounting-integrations/how-to-determine-accounts-mapping-for-as-erp-processing"
    click C "/docs/current/how-tos/accounting-integrations/how-to-apply-data-mapping-for-as-erp-processing"
    click D "/docs/current/how-tos/accounting-integrations/how-to-transfer-attachments-for-as-erp-processing"
    click E "/docs/current/how-tos/accounting-integrations/how-to-assign-accounting-periods-for-as-erp-processing"
    click F "/docs/current/how-tos/accounting-integrations/how-to-apply-posting-behaviour-for-as-erp-processing"
    click WF2 "/docs/current/how-tos/accounting-integrations/how-to-update-export-items-for-as-erp-processing"

    %% Styling for wrapping
    style A white-space:normal
    style B white-space:normal
    style C white-space:normal
    style D white-space:normal
    style E white-space:normal
    style F white-space:normal

    %% Make subgraph transparent with black border
    style START1 fill:transparent,stroke:transparent,color:transparent
    style ERP fill:none,stroke:#000000

${highlightStyle}
`;
  return <Mermaid chart={diagram} />;
};

export const NoteCallout = ({title, children, icon = "💡"}) => <div style={{
  backgroundColor: 'var(--recommended-bg)',
  borderLeft: '4px solid #3beaf6',
  borderRadius: '10px',
  padding: '18px 22px',
  marginBottom: '20px',
  boxShadow: '1px 1px 3px rgba(0,0,0,0.06)'
}}>
    <div style={{
  display: 'flex',
  alignItems: 'flex-start',
  gap: '14px'
}}>
      <span style={{
  fontSize: '22px',
  lineHeight: '1',
  flexShrink: 0
}}>
        {icon}
      </span>
      <div>
        {title && <div style={{
  fontSize: '16px',
  fontWeight: 600,
  color: 'var(--recommended-title)',
  marginBottom: '6px'
}}>
            {title}
          </div>}
        <div style={{
  fontSize: '14px',
  lineHeight: 1.65
}}>
          {children}
        </div>
      </div>
    </div>
  </div>;

export const RememberCallout = ({title, children, icon = "🪢"}) => <div style={{
  backgroundColor: 'var(--recommended-bg)',
  borderLeft: '4px solid #f63b92',
  borderRadius: '10px',
  padding: '18px 22px',
  marginBottom: '20px',
  boxShadow: '1px 1px 3px rgba(0,0,0,0.06)'
}}>
    <div style={{
  display: 'flex',
  alignItems: 'flex-start',
  gap: '14px'
}}>
      <span style={{
  fontSize: '22px',
  lineHeight: '1',
  flexShrink: 0
}}>
        {icon}
      </span>
      <div>
        {title && <div style={{
  fontSize: '16px',
  fontWeight: 600,
  color: 'var(--recommended-title)',
  marginBottom: '6px'
}}>
            {title}
          </div>}
        <div style={{
  fontSize: '14px',
  lineHeight: 1.65
}}>
          {children}
        </div>
      </div>
    </div>
  </div>;

<WorkflowDiagramTopNavASERP highlight="C" />

<div style={{ border: "2px solid #f63b92", borderRadius: "8px", padding: "16px", backgroundColor: "transparent" }}>
  <DataMappingDiagram />
</div>

Data Mapping transforms Export Item data into the **structured fields required by your Accounting System (AS/ERP).**

This step ensures that all required financial, contextual, and reporting data is correctly transferred.

## Prerequisites

Before you begin:

* You've [fetched the export item payload data](/docs/current/how-tos/accounting-integrations/how-to-fetch-export-item-data-for-as-erp-processing)
* You've completed [accounts mapping](/docs/current/how-tos/accounting-integrations/how-to-determine-accounts-mapping-for-as-erp-processing)
* You're familiar with the [Integration Design for data mapping](/docs/current/integration-design/exports/integration-design-exports-data-mapping)

## Mapping Order

Mappings must be applied in the following order:

1. Mandatory datapoints
2. Invoice datapoints (if applicable)
3. Optional datapoints
4. VAT handling

<RememberCallout title="Remember">
  Apply mappings sequentially to avoid overwriting required accounting data.
</RememberCallout>

## Relevant Export Item Fields

<Accordion title="Example Export Item Payload (Journal Entry)">
  ```json theme={null}
    {
        "companyId": "12abc3d4-e567-890e-1234-abc56e78fabc",
        "accountingEntryId": "59540ed2-0d68-4e36-9e31-58223975d9e9",
        "type": "card_purchase",
        "subType": null,
        "date": "2025-12-10T15:46:34Z",
        "amount": {
          "inSupplierCurrency": {
            "currency": "GBP",
            "value": 6366
          },
          "inWalletCurrency": {
            "currency": "GBP",
            "value": 6366
          }
        },
        "note": "Printer ink",
        "files": [
          {
            "url": "<string>",
            "type": "image/jpeg",
            "size": 13010
          }
        ],
        "supplier": {
          "code": "1340472473",
          "name": "Target",
          "categoryCode": "1000",
          "country": "GB",
          "account": null,
          "taxIdentifier": null
        },
        "user": {
          "id": "6b71f6bd-e83d-4d49-88ee-2b8cda2d57cf",
          "name": "Luke Richardson",
          "code": null
        },
        "team": {
          "id": "747aaf60-56c6-4b46-ad92-f8a0cb59cf8b",
          "code": "5678",
          "name": "Engineering"
        },
        "accountingEntryLines": [
          {
            "accountingEntryLineId": "0c76ea71-aaaa-4ece-bb68-e1166ccaea04",
            "lineAmount": {
              "inSupplierCurrency": {
                "currency": "GBP",
                "value": 6366
              },
              "inWalletCurrency": {
                "currency": "GBP",
                "value": 6366
              }
            },
            "netAmount": {
              "inSupplierCurrency": {
                "currency": "GBP",
                "value": 6366
              },
              "inWalletCurrency": {
                "currency": "GBP",
                "value": 6366
              }
            },
            "account": {
              "id": "7966c3ba-e4de-4574-8604-6cfa48d62cc8",
              "code": "6990000",
              "name": "Printing & Stationary",
              "identifier": "6990000"
            },
            "tax": {
              "id": "997d8526-5872-484d-ba07-c7a07e08e555",
              "code": "0001",
              "type": "inclusive",
              "amount": {
                "inSupplierCurrency": {
                  "currency": "GBP",
                  "value": 0
                },
                "inWalletCurrency": {
                  "currency": "GBP",
                  "value": 0
                }
              },
              "rate": 0.00
            },
            "tags": []
          }
        ],
        "additionalInformation": {
          "reconciliationId": "2500001",
          "reconciledEntries": null,
          "attendees": [],
          "invoiceInformation": null
        },
        "bookkeeping": {
          "method": "journal"
        },
        "vendor": {
          "id": "22e1f2c9-1360-4291-ab41-6b23dcea8888",
          "name": "TestVendor",
          "code": "acc1234",
          "externalId": "ext12345",
          "registrationNumber": "reg001234",
          "taxRegistrationNumber": "taxreg1234",
          "country": "UK",
          "defaultCurrency": "GBP"
        },
        "contraAccount": {
          "id": "993d664c-9b7c-4efc-a677-510e69200857",
          "code": "0876000",
          "name": "0876000_ChartAccounts",
          "identifier": "0876000"
        },
        "_links": {
          "web": {
            "exportItem": "https://app.staging.pleo.io/export/export-item/0c76ea71-aaaa-4ece-bb68-e1166ccaea04"
          }
        },
        "servicePeriod": null
      },
     # [other Export Items omitted for brevity]
     # [Pagination omitted for brevity]
  ```
</Accordion>

### Supplier

```json theme={null}
"supplier": {
  "name": "GOOGLE*ADS8693645259",
  "country": "DK"
}
```

### User & Team

```json theme={null}
"user": { "name": "John Doe" },
"team": { "name": "Marketing" }
```

### Notes

```json theme={null}
"note": "Printer ink"
```

### Tags

```json theme={null}
"tags": [
  { "code": "<string>" }
]
```

## Steps

### 1. Map Mandatory Datapoints

These fields must always be mapped.

Typical mappings:

```pseudo theme={null}
entry.account = mappedExpenseAccount
entry.amount = accountingEntryLines[].lineAmount.inWalletCurrency.value
entry.currency = accountingEntryLines[].lineAmount.inWalletCurrency.currency
entry.date = date
entry.taxCode = accountingEntryLines[].tax.code
entry.description = buildDescription()
entry.dimensions = tags
entry.reconciliationId = additionalInformation.reconciliationId
```

Include:

* Expense account (from Accounts Mapping)
* Amount (wallet currency)
* Currency
* Date
* Tax code
* Tags / dimensions
* Reconciliation data

### 2. Map Invoice Datapoints (if applicable)

Apply only if:

```pseudo theme={null}
type == "invoice" OR type == "invoice_payment"
```

Mappings:

```pseudo theme={null}
entry.invoiceNumber = additionalInformation.invoiceInformation.invoiceNumber
entry.invoiceDate = additionalInformation.invoiceInformation.invoiceDate
entry.dueDate = additionalInformation.invoiceInformation.dueDate
entry.paymentDate = additionalInformation.invoiceInformation.paymentDate
```

Currency handling:

* `invoice` → supplier currency
* `invoice_payment` → wallet currency

<RememberCallout title="Remember">
  Provide exchange rates if required by the Accounting System.
</RememberCallout>

### 3. Map Optional Datapoints

Optional fields enhance reporting.

Examples:

```pseudo theme={null}
entry.netAmount = accountingEntryLines[].netAmount.inWalletCurrency.value
entry.taxAmount = accountingEntryLines[].tax.amount.inWalletCurrency.value
entry.team = team.code
entry.employee = user.code
entry.memo = note
```

<RememberCallout title="Remember">
  Optional fields must never overwrite mandatory fields.
</RememberCallout>

### 4. Apply VAT Handling Rules

Determine whether to send VAT explicitly.

```pseudo theme={null}
if accountingSystem.calculatesVAT:
    do not send VAT amount
else:
    send VAT amount from Pleo
```

### 5. Build Final Entry Structure

Combine all mapped data into the final structure expected by your Accounting System.

```pseudo theme={null}
entry = {
    accounts: mappedAccounts,
    amounts: mappedAmounts,
    metadata: mappedFields
}
```

## Results

After completing this step:

* All required data fields are mapped
* Optional enhancements are included where supported
* Entries are complete and ready for posting

***

## What Comes Next?

<WhatComesNext href="/docs/current/how-tos/accounting-integrations/how-to-transfer-attachments-for-as-erp-processing">
  How to Transfer Attachments
</WhatComesNext>

***

<div className="text-xs uppercase" style={{ fontVariant: 'small-caps' }}>
  this how-to is part of:
</div>

<div className="mt-4 flex flex-wrap gap-2">
  <a
    href="/docs/current/guides/accounting-system-processing-workflow-guide"
    className="inline-flex items-center rounded-full border border-gray-300 dark:border-gray-600
px-3 py-1 text-xs font-medium
bg-white dark:bg-[#1f262b] text-black dark:text-white
hover:bg-gray-100 dark:hover:bg-[#2b2f33]
transition-colors"
  >
    AS/ERP Processing Workflow Guide
  </a>

  <a
    href="/docs/current/guides/export-integration-workflow-guide"
    className="inline-flex items-center rounded-full border border-gray-300 dark:border-gray-600
px-3 py-1 text-xs font-medium
bg-white dark:bg-[#1f262b] text-black dark:text-white
hover:bg-gray-100 dark:hover:bg-[#2b2f33]
transition-colors"
  >
    Export Integration Workflow Guide (Step 5)
  </a>
</div>

***

## Related Reading

* [Export Lifecycle](/docs/current/platform/exports/lifecycle)
* [Connection and Authorisation Overview](/docs/current/integration-design/auth/integration-design-auth-overview)

***