Skip to main content

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.

Payhawk avatar
Written by Payhawk
Updated over 2 weeks ago

Payhawk uses its custom template builder to provide custom file exports for accounting and reporting purposes in Excel and CSV.

In Payhawk, you can:

When you use the manual file export functionality in Payhawk, you can also use default templates that cannot be customized. For more information, see the export overview for Payhawk accountants.

Available data for customization

The following table summarizes the elements of the custom file export template that can be customized.

For more information about how to define the specific information you need to include in the custom export file, see the articles on available export fields and options settings.

Customizable template 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?