Free finance ops templates

Excel / CSV starters for PayBatchKit, CamtSheet and the IBAN checker · Pro pack planned later

Free Excel and CSV starters that match the columns our browser tools expect. Fill the sheet, then open the tool — your data stays on your device. Sample rows are fictional.

Pro Finance Ops pack ($19–29) is planned for when checkout opens (localised DE/FR sheets, more samples, reconciliation dashboard). Nothing can be bought on this site yet.

SEPA credit transfer (pain.001)

Columns: Name, IBAN, Amount, Reference, optional BIC and structured address (Street, Building number, Post code, Town, Country) for pain.001.001.09.

Download .xlsx · Download .csv · Open PayBatchKit · Guide

SEPA direct debit (pain.008)

Columns: Name, IBAN, Amount, Mandate ID, Mandate date, Sequence (FRST / RCUR / OOFF / FNAL), Reference, optional address. Put your Creditor Identifier in the tool header.

Download .xlsx · Download .csv · Open direct debit generator · Guide · FRST vs RCUR

NACHA / ACH payroll & vendors

Columns: Name, Routing, Account, Account type (checking/savings), Amount, ID. Company / ODFI fields go in the tool header.

Download .xlsx · Download .csv · Open NACHA generator · Guide

Australian ABA (Cemtex) bulk payments

Columns: Account name, BSB (NNN-NNN), Account number, Amount, Reference. Direct Entry User ID and bank code go in the tool header.

Download .xlsx · Download .csv · Open ABA generator · Guide

Bank reconciliation (camt / MT940 ready)

Import sheet columns match CamtSheet export, plus Matched / Internal ref / Notes. A Balance check sheet holds opening vs closing maths.

Download workbook .xlsx · Import columns .csv · MT940 guide

IBAN column helper

Paste a column of IBANs. The sheet normalises spaces and flags basic shape (length / country letters). For full mod-97 and country length checks, use the free IBAN checker (authoritative).

Download .xlsx · Sample .csv · How validation works

How to use

  1. Download the template that matches your payment type.
  2. Replace the yellow sample rows with your own data (keep the header row).
  3. Open the linked tool → paste or upload → Preview → download the bank file.
  4. Always check your bank's preview (count and total) before approving.

General information only — not financial, tax or legal advice. File formats and bank requirements change; confirm against your bank's current documentation.