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:
Click on an empty cell within the file (for example, Header).
In the Cell configuration dialog, in the Value field, type @ to display the list with available options.
From the drop-down menu, select the desired predefined value.
Click on Save changes.