---
title: "The Rows group cell type for Administrators - Payhawk Help Center"
slug: "understanding-the-rows-group-cell-type"
description: "See the options groups and options in the Rows group cell type, which set export field data without line item details, such as expense and supplier fields."
updated: 2026-10-20T07:30:40Z
published: 2026-10-20T07:30:40Z
canonical: "payhawk.com/understanding-the-rows-group-cell-type"
---

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

# Understanding the Rows group cell type

In the export file, the **Rows group** cell type includes the available options groups and their options that allow you to configure the export field data without any line item-specific information.

| **Options group** | **Options** | **Options' settings** |
| --- | --- | --- |
| **FUNCTIONS** |  |  |
|  | [**Running balance**](/help/terms-and-definitions-of-export-field-options) |  |
|  | [**Split**](/help/terms-and-definitions-of-export-field-options) | - **Attribute** - **Split string by** - **After split get item #** |
|  | [**Leading/Trailing characters**](/help/terms-and-definitions-of-export-field-options) | - **Attribute** - **Max. characters** - **Character** - **Position** |
| **PAYHAWK ACCOUNT** |  |  |
|  | **Name** |  |
|  | **Street name and number** |  |
|  | **City** |  |
|  | **Country** |  |
|  | **Account base currency** |  |
|  | [**Account balance**](/help/terms-and-definitions-of-export-field-options) | - **Balance** - **Amount** |
| **ACCOUNTS MAPPING** |  |  |
|  | **General account** |  |
|  | **Fees account** |  |
|  | **Accounts payable - Bank** |  |
|  | **Accounts payable - Cash** |  |
|  | **Accounts payable - Mileage** |  |
|  | **Accounts payable -** **Per Diem** |  |
|  | **Accounts payable - Reimbursable** |  |
| **CATEGORIZATION** |  |  |
|  | **Account code** |  |
|  | **Category name** |  |
|  | **Amortization schedule** |  |
|  | **Amortization external ID** |  |
|  | **Amortization start** |  |
|  | **Amortization end** |  |
| **EXPENSE** |  |  |
|  | **Approval status** |  |
|  | **Review status** |  |
|  | **Created date** |  |
|  | **Spend ID** |  |
|  | **Expense line ID** |  |
|  | **Spend external ID** |  |
|  | **Note** |  |
|  | [**Attachment Url**](/help/terms-and-definitions-of-export-field-options) |  |
|  | **Document currency** |  |
|  | **Payment wallet currency** |  |
|  | **Last review date** |  |
|  | **Last reviewer name** |  |
|  | **Last reviewer external ID** |  |
|  | **VAT name** |  |
|  | **VAT code** |  |
|  | **VAT rate %** |  |
|  | **Expense owner name** |  |
|  | **Expense owner external ID** |  |
|  | **Due date** |  |
|  | **Settlement date** |  |
|  | **Expense total amount (Base Currency)** |  |
|  | **Net amount (Base Currency)** |  |
|  | **Tax amount (Base Currency)** |  |
|  | **Expense discount amount (Base Currency)** |  |
|  | **Expense total amount (Document Currency)** |  |
|  | **Expense net amount (Document Currency)** |  |
|  | **Expense tax amount (Document Currency)** |  |
|  | **Expense discount amount (Document Currency)** |  |
|  | **Payment wallet amount with fees** |  |
|  | **Payment fees** |  |
|  | **Expense total amount (Payment Currency)** |  |
|  | **Expense net amount (Payment Currency)** |  |
|  | **Expense tax amount (Payment Currency)** |  |
|  | **Document date FX rate** |  |
|  | **Payment FX rate** |  |
|  | **Date of payment** |  |
|  | **Payment source** |  |
|  | **Payment reference** |  |
|  | **Spend type** |  |
|  | **Expense URL** |  |
|  | **Last exported at** |  |
|  | **Last exported by** |  |
| **PAYMENT** |  |  |
|  | **Card name** |  |
|  | **Cardholder name** |  |
|  | **Card last 4 digits** |  |
|  | **Payment paid currency** |  |
|  | **Merchant category code** |  |
|  | **Card transaction location** |  |
|  | **Card transaction country code** |  |
|  | **Merchant name** |  |
| **SUPPLIER** |  |  |
|  | **Supplier name** |  |
|  | **Supplier VAT number** |  |
|  | **Supplier external ID** |  |
|  | **Supplier country** |  |
|  | **Supplier payment currency** |  |
|  | **Supplier bank account holder name** |  |
|  | **Supplier bank account IBAN** |  |
|  | **Supplier bank account BIC/SWIFT** |  |
|  | **Supplier bank account number** |  |
|  | **Supplier bank account routing number** |  |
|  | **Supplier bank account sort code** |  |
| **DOCUMENT** |  |  |
|  | **Document number** |  |
|  | **Document type** |  |
|  | **Document date** |  |
|  | **Service period** |  |
| **CUSTOM FIELDS** |  |  |
|  | **Dynamic list of custom fields** |  |
| [**CALCULATED FIELDS**](/help/terms-and-definitions-of-export-field-options) |  |  |
|  | [**Line item row number**](/help/terms-and-definitions-of-export-field-options) |  |
|  | [**Row number**](/help/terms-and-definitions-of-export-field-options) |  |
|  | [**Journal entry number**](/help/terms-and-definitions-of-export-field-options) |  |
|  | [**Current date**](/help/formatting-the-accounting-templates) |  |