Skip to main content
All CollectionsPayhawk for administratorsExports
Overview of accounting templates
Overview of accounting templates

Use and customize the available file exports as templates to export company expenses and payments to your ERP system or accounting software.

Updated over 5 months ago

Payhawk uses its template builder engine to provide accounting and reporting templates for Excel and CSV file export.

In Payhawk, you can export expense and payment data for accounting purposes from the Export app and download expense and payment data for reporting purposes from the Expenses app. For more information, see the overview of exporting expenses and payments at Payhawk.

Available data for customization

The following table summarizes the available file export elements in the export templates you can customize.

For a reference to the specific export fields, refer to the list of all available fields you can add to your custom export data.

Customizable elements

Configuration options

Sheets and files

  • Joining multiple values in a single cell (concatenation).

    • Prefixes and suffixes

    • Trailing characters

    • Leading characters

  • Restricting text size to be less than a specified length (field trimming).

  • Defining file headers and footer rows.

Individual cells

  • Functions

    • Conditional values

    • Splitting of values

    • Value aggregation

  • Date

    • Date format

    • Date delimiters

  • Amount

    • Decimal delimiter

    • Decimal places

    • Text literal for amount (debit credit)

  • Country format

    • ISO2

    • ISO3

Filters

  • Date filters

    • Created date

    • Document date

    • Service period

    • Review date

    • Settlement datе

  • Currency filters

    • Balance per number of balances

    • Debit

    • Credit

  • Status filters

    • Draft

    • Reviewed

    • Archived

    • Approved

    • Unapproved

    • Pending

    • Payment status (Unpaid, Pending, or Settled)

  • Expense categorization filters

    • Teams

    • Custom fields

    • Category

    • Document type

  • Expense type filters

    • Card

    • Bank

    • Reimbursement

    • Mileage

    • Per Diem

    • Cash

    • Cash in advance

Useful resources

Did this answer your question?