Skip to main content
All CollectionsPayhawk for administratorsExports
Managing the accounting templates
Managing the accounting templates

Enable, archive, restore, or delete your custom exports and modify the templates for exporting company expense and payment data.

Updated over a week ago

Finance teams can export expense and payment data for settled transactions from the Export app and, then, use that data for accounting purposes to share it with external ERP systems and accounting software.

For the Finance team to select and use an accounting template from the Export app, Payhawk administrators need to enable it from the Payhawk account of the respective entity.

If you have already customized Excel or CSV templates, some of the features for the pre-defined accounting templates may not be available.

Adding new templates

To enable the desired accounting export template:

  1. In the Payhawk web portal, go to the Settings > Exports > Templates tab.

  2. Click on the + Add template button.

  3. In the dialog that opens, select the desired template format by clicking on the Use this button.

  4. Provide a name for the template and click on Add.

Once you confirm the selection, the accounting template will be added to the list of templates under the ACTIVE section.

Mapping accounts for accounting templates

To be able to share the accounting data from the specified export template to the external ERP system or accounting software you are using, you need to fill in the external ID values so that the accounts between the two systems can be mapped.

  1. Go to the Settings > Exports > Accounts mapping tab.

  2. Against the listed Payhawk expense types, funds accounts, specific accounts, and entity names, fill in the corresponding external IDs.

  3. Under Custom mapping, fill in any custom fields you have created in Payhawk and want to be exported with the accounting template. To add more custom fields, use the + Add button.

  4. When done, click on Save changes so that the mapping data can be applied to the template.

Archiving accounting templates

If you no longer need an accounting template, you can archive it.

  1. Go to Settings > Exports > Templates.

  2. Click on the three dots menu of the accounting template you want to archive and select the Archive option.

As a result, the archived template will be moved under the Settings > Exports > Templates > ARCHIVED section.

Alternatively:

  1. Go to Settings > Exports > Templates.

  2. Select the desired template by clicking on it.

  3. Click on the three dots menu to the upper right and select Archive.

Re-activating accounting templates

Even though you might have archived an accounting template, you can restore its active state if you need to use it again:

  1. Go to the Settings > Exports > Templates > ARCHIVED section.

  2. Click on the three dots menu of the accounting template you want to activate and select the Re-activate option.

As a result, the restored template will be moved under the Settings > Exports > Templates > ACTIVE section.

Renaming accounting templates

To rename an accounting template:

  1. Go to Settings > Exports > Templates.

  2. Select the desired template by clicking on it.

  3. Click on the three dots menu to the upper right and select Rename.

  4. In the dialog that opens, update the name and click on Rename.

Deleting accounting templates

To delete an accounting template used for scheduled export, you need to configure another template that will be used for the scheduled export.

To permanently remove an accounting template:

  1. Go to Settings > Exports > Templates.

  2. Click on the three dots menu of the desired template and select the Delete option.

  3. In the dialog that opens, select the checkbox and click on Delete template.

Alternatively:

  1. Go to Settings > Exports > Templates.

  2. Select the desired template by clicking on it.

  3. Click on the three dots menu to the upper right and select Delete.

  4. In the dialog that opens, select the checkbox and click on Delete template.

Publishing and enabling the templates

For the Payhawk accountants at your company to start using accounting templates, you need to publish them so that their latest version becomes available to use in the Export app.

  1. Go to Settings > Exports > Templates.

  2. Select the desired template by clicking on it.

  3. Click on Publish template button. As a result, a confirmation will be displayed.

Viewing the history of template updates

Any changes Payhawk administrators make to an accounting template are available to see in the history log of that template.

  1. Go to Settings > Exports > Templates.

  2. Select the desired template by clicking on it.

  3. Click on the three dots menu to the upper right and select View history. As a result, the dialog with the template history opens for you to view.

From here, you can restore a previous version or duplicate a previous version and set it as a new template.

Restoring previous template versions

From the dialog showing the template history, click on the three dots menu against the version you want to restore and select the Restore this version option. As a result, the current version will be updated and the history log will display the action.

Duplicating accounting templates

You can use an existing accounting template and build another one on top of it. In such cases, you can duplicate the existing template.

From the dialog showing the template history, click on the three dots menu against the version you want to duplicate and select the Duplicate as new template option. As a result, the current version will be added to the list of active templates.

Useful resources

Did this answer your question?