How to Create a Positive Pay File From QuickBooks Desktop Enterprise
QuickBooks Desktop Enterprise does not export a positive pay file in your bank's format. Intuit has confirmed in its support channels that the option to create a positive pay file is not available in QuickBooks Desktop, including the Enterprise edition. There is no menu item that produces a check issue file matching a bank layout. To meet a positive pay requirement, you run a report listing the checks you issued, export it, then convert that data into the file your bank expects.
If positive pay is new to you, read what is positive pay first. In short, your bank matches every check that clears against a list you sent and flags anything that does not match before it pays. That list is the positive pay file, sometimes called a check issue file.
A note on ERPs that do have native positive pay
Some larger systems build positive pay export in. Microsoft Dynamics 365 Finance, for example, generates positive pay files through its Electronic Reporting framework: you assign a format to each bank account, and it produces a file with text or XML output depending on the format you configure. QuickBooks Desktop Enterprise has no equivalent, so you still export the data and reshape it yourself.
Step 1: Run the Check Detail report
The cleanest source for issued checks is the Check Detail report. Go to the Reports menu, hover over Banking, and select Check Detail. Set the date range to cover the checks you need to report. You can also read the check register (Banking menu, then Use Register), but the report filters and exports more cleanly.
Step 2: Filter to issued checks only
Your file must list checks you wrote, not deposits, other bill payments, or journal entries. Click Customize Report, open the Filters tab, choose Transaction Type, and set it to Check. While you are there, open the Display tab and confirm these columns are on:
- Date, the check issue date.
- Num, which holds the check number. QuickBooks labels this column
Num, not "Check Number," so do not go looking for that exact name. - Name, the payee. Include this because many bank layouts match on payee as well as number and amount.
- Amount, the check amount.
Step 3: Watch the column gotchas
Two things trip people up here. First, the Num column must hold a clean check number and nothing else. If a check was recorded with text like EFT, DEBIT, or a blank in the Num field, those rows are not real printed checks and should not go in the file. Filter or delete them first, because a check issue file with junk check numbers is useless to the bank.
Second, amounts on a check report can appear as negatives because the money is leaving the account. Most bank specs want a plain positive number, sometimes with an implied decimal (so $1,042.50 becomes 104250). Confirm what your bank expects and strip any minus signs, dollar signs, or commas.
Step 4: Export and check the date format
With the report filtered, click the Excel dropdown and choose Create New Worksheet, or export to CSV. If QuickBooks warns that the report has too many columns, choose Advanced and uncheck Space between columns.
QuickBooks Desktop usually writes dates in MM/DD/YYYY form, but your bank's spec may require YYYYMMDD or another exact format. If the dates do not match the spec, the file can be rejected, so make them match first. For the difference between layout styles, see fixed-width vs CSV positive pay.
Step 5: Convert the export with PositivePayMaker
Once you have a clean export, you need to reshape it into your bank's exact layout. Every bank defines its own fixed-width or delimited format, and typing one by hand is error-prone.
PositivePayMaker does the conversion in your browser. You upload the QuickBooks export (CSV or Excel), map the columns (Num to check number, Amount to amount, Date to issue date, Name to payee), pick your bank's layout, and download a file ready for your bank's portal. It is free and runs client-side, so your check data never leaves your browser.
It ships with several bank layouts, including specs published by Chase and Huntington, plus a custom format builder for banks not in the list. If your bank's field positions are account-specific, the builder lets you set each column, width, and date format yourself. To understand the fields a bank file contains, read the positive pay file format guide, and check supported formats to see if yours is built in.
Validate the first file with your bank
Treat the first file as a test. Generate it, run it through the file validator to catch structural problems, then send it to your bank and confirm the check numbers and amounts match. A single field off by one position can reject the whole batch. If the bank bounces it, see why a positive pay file gets rejected.
Why not just buy a desktop add-on?
You can. Third-party tools such as Big Red Consulting's Positive Pay File Creator and Transaction Pro Exporter work with QuickBooks Enterprise and produce bank files, but they are Windows-only paid software, and some still require Microsoft Excel installed. If you already exported a clean Check Detail report, a free browser tool covers the same ground. The workflow is the same one QuickBooks users and Xero users follow. For smaller shops, see positive pay for small business.