---
title: "ETL Import - Itemization Transaction, Account and Client Data"
slug: "etl-import-itemization-transaction-account-and-client-data"
updated: 2023-02-27T21:51:44Z
published: 2023-02-27T21:51:44Z
canonical: "docs.interprose.com/etl-import-itemization-transaction-account-and-client-data"
stale: true
---

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

# ETL Import - Itemization Transaction, Account and Client Data

## **Itemization Transactions**

**Itemization Transactions** are owing or received adjustments and received payments or credits associated with account validation itemization data following the assignment of an account in ACE.

The itemization balance of an account combined with any unassigned transactions and adjustments posted to the account will typically match the current account balance. Itemization Transactions can be loaded using the itemizationTransactions ETL Layout.

**![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/Itemization1.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A49%3A15Z&se=2026-10-31T19%3A49%3A15Z&sr=c&sp=r&sig=TYCNTsFHYoz3CU5nAqMMHZQhPeW%2F8pt87isc2ZtsIgM%3D)**

## **Itemization Balances**

**Itemization Balances** are total amounts that can be loaded with the accounts or as updates using the account ETL Layout.

When values are loaded this way as itemization interest, fees, payments or credits, associated itemization transactions will be automatically created in ACE.

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/itemization2.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A49%3A15Z&se=2026-10-31T19%3A49%3A15Z&sr=c&sp=r&sig=TYCNTsFHYoz3CU5nAqMMHZQhPeW%2F8pt87isc2ZtsIgM%3D)

Using the **Client** **ETL Layout**, defaults for the **Itemization Date Source** and the **Itemization Description** can be loaded to each client profile.

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/itemization3.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A49%3A15Z&se=2026-10-31T19%3A49%3A15Z&sr=c&sp=r&sig=TYCNTsFHYoz3CU5nAqMMHZQhPeW%2F8pt87isc2ZtsIgM%3D)

### **ETL Layouts**

The following **ETL Layouts** with related fields mentioned above can be downloaded:

[Account document layout](/v1/docs/account-document-layout-1)

[Client layout](/v1/docs/client-layout)

[Itemization transaction layout](/v1/docs/itemization-transaction-layout)

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/itemization4.png?sv=2026-02-06&spr=https&st=2026-10-31T18%3A49%3A15Z&se=2026-10-31T19%3A49%3A15Z&sr=c&sp=r&sig=TYCNTsFHYoz3CU5nAqMMHZQhPeW%2F8pt87isc2ZtsIgM%3D)