How to export from QuickBooks

Open the report or list that contains the payments you need to export.
Export to Excel or CSV. QuickBooks Online commonly uses Reports → Export to Excel.
Open the file and confirm routing numbers and account numbers are text, not numbers.
Remove totals rows, blank lines, and header rows that are not payment data.
Upload the file in the generator and review the suggested column mapping.

Column mapping preset

The generator recognizes common QuickBooks export headers and suggests column mapping automatically. Match your export to these importer fields:

QuickBooks export column	Maps to
Employee / Vendor / Payee name	Recipient name
Routing number / Bank routing	Routing number
Account number / Bank account	Account number
Account type / Checking or Savings	Account type
Amount / Payment amount	Amount
Employee ID / Vendor ID	Recipient ID

Column	Required	Notes
Recipient name	Yes	Payee or employee name as it should appear on the bank statement.
Routing number	Yes	Nine-digit ABA routing number including check digit.
Account number	Yes	Recipient bank account number, up to 17 characters.
Account type	Yes	Use checking or savings.
Amount	Yes	Payment amount in dollars. Use 0 for prenote files.
Recipient ID	No	Optional employee or vendor ID carried in the entry detail record.
Addenda	No	Optional 80-character payment reference written to an addenda record.
Remittance details	No	Optional invoice or credit memo text used only for the downloadable remittance CSV report.

If your QuickBooks export needs cleanup first, download the NACHA import template and paste normalized rows into it before upload.