Skip to main content

Mapping the default and custom template export fields

Identify how default file export fields correspond to the custom file export fields in Payhawk templates.

Payhawk avatar
Written by Payhawk
Updated in the last 15 minutes

In Payhawk, if you're working with an integration outside of the supported live ERP integrations, you still have flexible options to manage your accounting data by exporting it manually using either the default file exports or the fully customizable file export.

The default file export uses a predefined template for exporting accounting data in a fixed format and cannot be customized. In the system, this export may be labeled as (legacy).

The custom file export starts with a blank template that allows you to define the structure of your exported data. You can tailor the file by configuring sheets, cells, and other export options.

The following table shows which fields are included in each type of file export and how the fields in the default (legacy) file export correspond to those in the custom file export.

Default (legacy) file export

Custom file export

Date

Settlement date

Payment ID

Payment ID

Payment description

Payment reference

Paid amount

Payment paid amount

Paid currency

Payment paid currency

Credit

Payment wallet amount with fees

Currency

Payment wallet currency

Account number

Payment source

Expense ID

Expense ID

Expense note

Note

Expense line note

Note

Expense category

Category name

Account code

Account code

Document number

Document number

Document date

Document date

Supplier name

Supplier name

Supplier external ID

Supplier external ID

Supplier VAT

Supplier VAT number

Supplier country

Supplier country

Supplier payment details

Supplier bank account IBAN

Total expense (currency)

Total amount (Base Currency)

Tax (currency)

Tax amount (Base Currency)

Tax rate name

VAT name

Tax rate code

VAT code

Accounting FX rate

Document date FX rate

Expense owner

Expense owner

Expense owner ID

Expense owner external ID

Approval status

Approval status

Expense report ID

Expense report ID

Transaction ID

Deposit ID

Date

Deposit date

Sender name

Deposit sender

Sender account

Deposit sender IBAN

Reference

Deposit description

Amount

Deposit amount

Currency

Deposit currency

Did this answer your question?