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 |