Positive Pay from QuickBooks Desktop: the Check Detail report method
QuickBooks Desktop does not produce a positive pay file. There is no menu item that exports the fixed-width or CSV layout your bank wants, and Intuit support threads going back years confirm it: the standard answer is to run a report, push it to Excel, and reshape the data by hand. That works, but it is fiddly and easy to get wrong on the columns that matter most to fraud screening.
This guide covers the part QuickBooks Desktop actually does well: pulling a clean list of issued checks with the right fields. Then it shows where the manual approach breaks down, and how to turn that export into a bank-ready file without a paid add-on.
Start with the Check Detail report
The report most bookkeepers land on for positive pay is Check Detail. In QuickBooks Desktop:
- Open the Reports menu, hover Banking, and choose Check Detail.
- Set the date range to the check run you are submitting. Most banks want issued checks uploaded the same day they print, before the checks clear, so keep your ranges tight and consistent.
- Click Customize Report and add the columns the bank needs: issue date, check number (the report calls it Num), amount, and payee name. Remove the columns the bank ignores so the export is lean.
- Filter to the correct bank account. If you print from more than one account, run one report per account, because positive pay files are submitted per account number.
Once the layout is right, click Memorize at the top of the report and give it a name like "Positive Pay Upload." Next run you reopen the memorized report, change the dates, and you are done customizing. That single step saves the most time over a year of weekly uploads.
Export to Excel or CSV
With the report on screen, use the Excel dropdown and choose to create a new worksheet, or select Create a comma separated values (.CSV) file if you would rather work in plain CSV. If QuickBooks warns that the report has too many columns, open Advanced in the export dialog and uncheck Space between columns. That message is a sign you still have report columns the bank does not need, so trimming them in Customize Report first usually clears it.
What comes out is a spreadsheet of your issued checks. What the bank wants is a specific file: usually a CSV or fixed-width text file with the account number, check number, amount, issue date, and often the payee, in an exact column order with a date format and amount format the bank defined. QuickBooks does not know that layout, so the gap between "spreadsheet of checks" and "file the bank accepts" is yours to close.
Voids are where this goes wrong
Positive pay is only as good as the void handling. When you void a check in QuickBooks Desktop, the amount changes to $0.00 but the transaction stays in the register with a VOID memo, which preserves your check-number sequence and audit trail. The risk is that a $0.00 voided check, or a check you voided after a prior upload, slips into your positive pay file and tells the bank to honor a check you never intended to pay.
Two habits keep this clean:
- Exclude $0.00 voided checks from the issue file unless your bank specifically accepts void records. Many positive pay systems have a separate "void" or "stop" record type; a plain $0.00 line in the issue file can confuse the match.
- Check the Audit Trail before each upload. Open Reports, hover Accountant & Taxes, and choose Audit Trail. Searching for "void" or "deleted" surfaces checks that were created and later changed, including the original amount before the void. This is the report that catches a check edited after you already sent it to the bank.
If a check was voided after a prior submission, most banks want a void or stop-payment record so the issue list and the bank's records agree. Confirm how your bank expects voids before your first upload, because a mismatch here is exactly what positive pay exists to catch.
Turn the export into a bank file for free
Once you have the Excel or CSV export from Check Detail, PositivePayMaker converts it into your bank's positive pay layout in the browser. It is free and runs entirely client-side, so your check register never leaves your computer and nothing is uploaded to a server. You map your columns once, pick your bank's format, and download the file.
The tool ships with 11 bank layouts, six of them built from published specifications including Chase and Huntington. If your bank is not on the list, the custom format builder lets you match any column order, delimiter, date format, and fixed-width field positions the bank gave you, and the built-in validator checks the result before you submit. Banks describe their exact layout in the treasury or business-banking section of their online portal, or through your treasury contact, so pull that spec and build to it once.
When a paid add-on makes sense
If you submit large check runs every day and want positive pay generated straight from the QuickBooks data with no spreadsheet step, a dedicated tool may be worth the cost. Big Red Consulting's PositivePay File Creator for QuickBooks Desktop reads your bank account data and writes the file directly. It is Windows-only and priced at $119 for the first year, then $99 per year after, with a 30-day trial. Treasury Software sells an installed Windows product (roughly $29.95 to $89.95 per month depending on tier) with 350-plus bank layouts, aimed at higher-volume or multi-account shops. MoneyThumb and ProperSoft also sell paid desktop converters.
For most small businesses running a weekly or twice-weekly check batch, the free export-and-format path is enough, and you avoid a recurring subscription for a once-a-week task. The trade-off is the manual mapping step, which the memorized report and a saved format make quick after the first time.
Verify the first file with your bank
Whatever method you use, treat the first generated file as a test. Send it to your bank's treasury team or upload it to their portal and confirm it imports cleanly before you rely on it for fraud protection. Banks reject files over small things: a date format the spec did not match, a leading zero stripped from a check number, an amount with a decimal where the bank wanted implied cents. Catching that on file one is far cheaper than a rejected upload on a day checks are clearing.
If you also use QuickBooks Online, the workflow differs slightly. See the QuickBooks positive pay overview for the cross-product version of this process.