Skip to main content
Overview of export fields

Learn more about the export fields available in Payhawk and tailor your accounting data export.

Payhawk avatar
Written by Payhawk
Updated today

When using the templates to export accounting data from Payhawk, you can set the specific information you need to include in the export file by using the available options of the options groups.

Depending on the type of data you want to include in the export file, for example, expenses, payments, deposits, and so on, the template sheets provide different options to configure the accounting information the respective sheet will contain.

The information in the template is organized in groups and each group provides different options for configuring the data in the specific type of export field. The structure is the following: Cell type > Options group > Options > Options' settings.

For example, the Layout cell type contains the Header and Footer cells with their FUNCTIONS and PAYHAWK ACCOUNT options groups and options such as Name and Address.

Cell types

The cell types contain information about the type of export fields based on the selected export data.

Cell type

Definition

Layout

Includes the options groups and their available options that allow you to configure the export field data for the header and footer of the template sheet.

Rows group

Includes the options groups and their available options that allow you to configure the export field data without any line item-specific information.

Line items

Includes the options groups and their available options that allow you to configure line item-specific information of the exported data.

Expense payment

Includes the options groups and their available options that allow you to configure the export field data related to all types of payments such as bills and card payments.

Transfer

Includes the options groups and their available options that allow you to configure the export field data related to incoming payments and deposits.

Options groups

The options groups are the categories into which the available options for filling in the values of the respective export fields fall, depending on the type of data you've selected to export.

For example, if you are exporting expense, payment, and fee data, the template sheet will contain the Layout cell type, which displays the ACCOUNTS MAPPING options group with the General account, Fees account, and so on, options.

Options

The options include available selections for populating the respective export fields based on the type of data you’ve chosen to export.

For example, if you are exporting expense, payment, and fee data, the template sheet will contain the Rows group, which displays the FUNCTIONS options group with the Running balance, Split, and Leading/Trailing characters options.

Configuring the Cell type options

To configure the Cell type options:

  1. Click on an empty cell within the file (for example, Header).

  2. In the Cell configuration dialog, in the Value field, type @ to display the list with available options.

  3. From the drop-down menu, select the desired predefined value.

  4. Click on Save changes.

Did this answer your question?