Skip to main content
Understanding the Rows group cell type

Check out the list of all fields available in the Rows group cell type and tailor your accounting data export.

Payhawk avatar
Written by Payhawk
Updated yesterday

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

  • Attribute

  • Split string by

  • After split get item #

  • Attribute

  • Max. characters

  • Character

  • Position

PAYHAWK ACCOUNT

Name

Address

City

Country

Account base currency

  • 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

Expense ID

Expense line ID

Expense external ID

Note

Document currency

Payment wallet currency

Last review date

Last reviewer name

Last reviewer external ID

VAT name

VAT code

VAT rate %

Expense owner

Expense owner external ID

Due date

Settlement date

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

Expense type

Expense URL

Last exported at

Last exported by

PAYMENT

Card name

Cardholder name

Card last 4 digits

Payment paid currency

Merchant category 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

Did this answer your question?