Positive Pay from QuickBooks Online: Export, Fix the Account-Number Gotcha, and Convert

QuickBooks Online does not produce a positive pay file. There is no menu item, no report type, and no add-on from Intuit that outputs the check issue file your bank wants. What QBO does give you is the underlying data: a list of the checks you issued, with their numbers, dates, amounts, and payees. The job is to pull that data, add the one field QuickBooks leaves out, and reshape it into your bank's exact layout. This page walks through each step and points out the part that trips up most bookkeepers.

Step 1: Run the Check Detail report

The Check Detail report is the cleanest source in QBO because it already filters to check transactions, so you are not sorting deposits and journal entries out of a giant transaction list. Open Reports, search for Check Detail, and run it. The "Detail" reports are available on Essentials, Plus, and Advanced; if you are on Simple Start, run a Transaction List by Date instead and filter to checks.

Set the date range to the run you are uploading, usually the day's or the week's printed checks. Then customize the columns so the export carries what your bank's format needs and nothing it does not:

Use the Customize panel to add or remove columns and reorder them, then export with the report's Export to Excel button. You now have a spreadsheet with one row per check. Save it as .xlsx or .csv; either works as input to the converter.

One detail worth checking before you trust the export: filter to issued, printed checks only. Voided checks and bill payments made by other methods can sneak into a broad report. If your bank's positive pay program also wants void records, you will handle those separately, since a printed-check report will not flag them as voids.

Step 2: The bank account number gotcha

This is the part nobody warns you about. A positive pay file almost always has to carry the bank account number the checks are drawn on, because the bank matches the issue file to the right account. QuickBooks check exports do not include that number. The check number, issue date, dollar amount, and payee come out fine, but the account number is simply not a field QuickBooks writes into a check export. Intuit's own community threads confirm this and recommend adding the account number as a column yourself.

So before you convert, open the exported spreadsheet and add a column for the account number. Type your full bank account number into every row. It is the same value on each line, since one file is one account. If you run positive pay on more than one checking account, keep the exports separate, one file per account, and put that account's number in its own export. Do not mix two accounts into one upload; banks reject files where the account number does not match the checks.

While you are in the spreadsheet, glance at the check numbers. QuickBooks sometimes stores them as text with a leading zero or as a number that dropped one. Your bank's spec will tell you whether check numbers are padded to a fixed width. If they are, you will set that in the next step rather than editing by hand.

Step 3: Convert to your bank's layout

Now you have a spreadsheet with check number, date, amount, payee, and account number. The last step is turning those columns into the precise file your bank accepts, which means the right field order, the right date format, amounts with or without a decimal point, and either comma-delimited or fixed-width columns. Every bank specifies this differently, and the spec lives in your bank's treasury or business-banking portal, or with your treasury contact. If you do not have it, ask the bank for the positive pay file format before you build anything.

PositivePayMaker does this conversion in your browser, for free. You upload the spreadsheet you just exported, map your columns to the fields the bank wants, and download the formatted file. It includes layouts built from published specifications for banks like Chase and Huntington, plus a custom format builder for matching any spec your bank hands you, and a file validator to sanity-check the output. Because the tool runs entirely client-side, your check register never leaves your computer; nothing is uploaded to a server. If your bank is not one of the built-in layouts, the custom builder or a generic CSV or fixed-width preset will reproduce its spec field by field. See the positive pay file format reference for what these layouts usually contain.

Convert your QuickBooks export now

Always verify the first file with your bank

Treat your first generated file as a draft. Upload it to the bank's positive pay portal, or send it to your treasury contact, and confirm it imports with zero errors before you rely on the process. The usual rejections are an account number that does not match, a date format the bank does not expect, or check numbers padded to the wrong width. All of those are quick fixes in the converter once the bank tells you what it saw. After one clean upload, the same column mapping works for every future run.

When a paid desktop tool makes sense

If you would rather pull check data straight from QuickBooks without exporting a report by hand, paid tools exist and can be worth it at higher volume.

These make sense if you need a permanent QuickBooks integration, are on Windows with Excel, and run files often enough that the subscription pays for itself. If you cut a positive pay file occasionally, or you are on a Mac, or you simply do not want to install software, the free browser converter covers the same workflow: export from QBO, add the account number, convert, verify.

Quick recap

  1. Run and customize the Check Detail report, then export to Excel.
  2. Add a bank account number column, since QuickBooks omits it.
  3. Map your columns to the bank's spec and convert.
  4. Verify the first file with your bank before going live.

For more on the destination format, read the QuickBooks positive pay overview, which covers the Desktop workflow as well.

Create your positive pay file