In the export file, the Expense payment cell type includes the available options groups and their options that allow you to configure the export field data related to all types of payments such as bills and card payments.
Options group | Options | Options' settings |
FUNCTIONS |
|
|
|
| |
|
| |
|
| |
PAYHAWK ACCOUNT |
|
|
| Name |
|
| Street name and number |
|
| City |
|
| Country |
|
| Account base currency |
|
|
| |
ACCOUNTS MAPPING |
|
|
| General account |
|
| Fees account |
|
| Accounts payable - Bank |
|
| Accounts payable - Cash |
|
| Accounts payable - Mileage |
|
| Accounts payable - Per Diem |
|
| Accounts payable - Reimbursable |
|
PAYMENT |
|
|
| Payment ID |
|
| Payment external ID |
|
| Payment status |
|
Payment type | ||
| Payment reference |
|
Payment beneficiary | ||
| Payment initiated date |
|
| Settlement date |
|
| Payment paid currency |
|
| Payment paid amount |
|
Payment wallet amount with fees | ||
| Payment wallet currency |
|
| Payment wallet amount |
|
| Payment FX rate |
|
Payment fees | ||
| Payment FX fees |
|
| Payment ATM fees |
|
| Payment transfer fees |
|
| Card name |
|
| Cardholder name |
|
| Card last 4 digits |
|
| Merchant category code |
|
| Card transaction location |
|
| Card transaction country code |
|
| Merchant name |
|
| Last exported at |
|
| Last exported by |
|
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 |
|
| 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 |
|
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 |
|
|
| |
|
| |
|
| |
|
| |
|
|