Payment File Templates

Payment file templates are the saved output formats used when your team generates payment files. They control the row layout, filename pattern, delimiter, and the columns that appear in each export.

Where payment file templates fit

Area How payment file templates are used
Payment Files The selected template decides how the generated file is built.
Accounting Exports Templates help match the output to the receiving banking or finance process.
Suppliers Supplier bank and reference data often populate the exported columns.

Create a payment file template

  1. Go to Purchasing → Payment File Templates.
  2. Click Create Template.
  3. Enter the template name.
  4. Add a description if needed.
  5. Choose whether the template should use aggregated rows or line-level rows.
  6. Set the filename pattern.
  7. Choose whether the template should be export-once only.
  8. Click Create.

Edit a payment file template

  1. Go to Purchasing → Payment File Templates.
  2. Open the template you want to change.
  3. Update the name, delimiter, row mode, filename pattern, or status.
  4. Review the Output Columns table.
  5. Add, remove, reorder, or disable columns as needed.
  6. Click Save Template.

Delete a payment file template

  1. Open the template.
  2. Click Delete Template.
  3. Confirm the change.

Things to know

  • A template can be active or inactive.
  • Static columns can be added when a file format needs a fixed value in every row.
  • Export-once templates are designed to stop the same lines being exported repeatedly through that template.

Next article

Tax Rates

Tax rates are the tax settings Purchasing uses on purchase order and invoice lines. They let your team keep the available rates up to date and control which one

Continue →

Related articles

Purchase Orders

Purchase orders are the records you use to request, approve, and track purchases in OpsOS. They hold the supplier, line items, approval status, and settlement p

Approval Groups

Approval groups are the sign-off rules used when a purchase order or estimate is submitted. They decide who needs to approve, in what combination, and when extr

Suppliers

Suppliers are the companies you buy from in Purchasing. A supplier record stores the contact details, address, bank details, compliance documents, and linked pu

Templated Lines

Templated lines are saved purchase order lines you can reuse when the same costs come up regularly. They help you build purchase orders faster and keep repeated