How to create a positive pay file in Excel
Most banks accept a positive pay file (also called a check issue file) as a CSV or fixed-width text file. If you already track your checks in Excel, you are most of the way there. The work is getting your columns into the order and format your bank's specification asks for, then saving the result as the file type they accept. This guide covers the spreadsheet itself: the columns to include, how to format dates and amounts so the upload does not reject, and how to turn the finished sheet into a bank-ready file without retyping anything.
What a positive pay file actually contains
Positive pay is fraud control. Each time you cut checks, you send your bank a list of the checks you legitimately issued. When a check is presented for payment, the bank matches it against your list. If a check number, amount, or account does not match, the bank flags it for your review before paying. The file you upload is just that list of issued checks.
Layouts differ from bank to bank, but nearly every one is built from the same handful of fields:
- Account number, the checking account the checks are drawn on.
- Check number, must be numeric and match the MICR line printed on the check.
- Amount, the check amount, usually with two decimal places and no currency symbol.
- Issue date, the date you wrote or printed the check.
- Payee name, who the check is made out to. Some banks require it, some treat it as optional.
- Issue/void flag, a code (often a single letter like I or V) telling the bank whether this is an issued check or a voided one.
The exact order of these columns, and whether your bank wants a header row, is set by the bank, not by you. Regions Bank's published CSV help card, for example, puts the account number in column A, the amount in column B, the check number in column C, and the issue date in column D. Other banks order them differently. That is why the single most important step is to get your bank's own specification first.
Set up the spreadsheet
Open a new sheet, or start from your existing check register. Put one check per row, and give each value its own column. A clean starting layout looks like this:
- Column A, Account number. Use the full account number with no dashes or spaces unless your bank's spec says otherwise.
- Column B, Check number. Numeric only. Strip any leading text.
- Column C, Amount. See the formatting note below; this is where most uploads fail.
- Column D, Issue date. Usually MM/DD/YYYY.
- Column E, Payee name. Plain text, no commas if you are saving as CSV.
- Column F, Issue/void flag. Often "I" for issued.
You do not have to memorize an order. The converter described below lets you map whatever columns you have to whatever the bank expects, so you can keep your spreadsheet however you like and reorder at export time.
Format the fields so the upload does not reject
Three formatting problems cause the large majority of rejected positive pay uploads. Fix these before you do anything else.
Amounts. Banks generally want a plain number like 1500.00, not $1,500.00. Excel's currency formatting only changes how the number is displayed; the underlying value is fine, but be careful when you save to CSV that the dollar sign and thousands comma do not get written into the file. The safest approach is to format the amount column as Number with two decimal places and no thousands separator. If your bank wants amounts in cents with no decimal point (some fixed-width formats do), that is a conversion the tool can handle for you rather than something to do by hand.
Dates. Excel loves to reformat dates based on your regional settings. A date that shows as 6/1/2026 on screen can be stored as a serial number or written to CSV as 2026-06-01, neither of which may match what your bank expects. Set the issue date column to a Text or explicit date format that produces exactly the MM/DD/YYYY (or whatever your bank specifies) string you need, and spot-check the actual saved file.
Check numbers. If your check numbers have leading zeros, Excel will drop them when it treats the cell as a number. Format that column as Text if leading zeros matter to your bank's matching.
Why you cannot just email the spreadsheet
Your bank's upload portal expects a specific file: a CSV with columns in a fixed order, or a fixed-width text file where each field sits at an exact character position. A raw Excel workbook is neither. You can "Save As" CSV from Excel, but that still leaves you reordering columns by hand every pay cycle, watching for the date and amount traps above, and re-checking the result. For a fixed-width layout, Excel will not produce one at all without a macro.
This is also the gap QuickBooks users run into. QuickBooks cannot export a positive pay file in a bank-specific format natively. Intuit's own support guidance is to export a check report to Excel and adjust it manually, or use a third-party tool. So even QuickBooks shops end up back in a spreadsheet doing the same column work.
Convert your Excel file with the tool
Instead of hand-editing CSV every cycle, you can map your spreadsheet once and reuse it. PositivePayMaker is a free, browser-based converter. You upload your CSV or Excel check register, tell it which of your columns is the check number, which is the amount, the date, the payee, and so on, then pick your bank's layout or build a custom one. It writes the bank-ready file. The whole thing runs in your browser, so your check data never gets uploaded to a server.
The workflow:
- Save your spreadsheet, or just drag the .xlsx straight in.
- Choose your bank from the list of supported layouts, or open the custom format builder if your bank is not listed.
- Map your columns to the layout's fields. The tool remembers the mapping for next time.
- Generate the file and download it.
- Run it through the built-in validator to catch obvious problems before you send it.
If your bank is not one of the preset layouts, the custom format builder handles both delimited (CSV) and fixed-width output, lets you set the date format, choose whether amounts carry a decimal point, and place each field where the spec wants it. Several published layouts, including Chase and Huntington, are built in. For any bank, you can match the exact spec yourself.
When a paid desktop tool makes sense
If you cut hundreds of checks across many accounts and want the file pulled directly from accounting software, a paid installed tool can be worth it. Big Red Consulting's PositivePay File Creator for Excel is an Excel add-in that runs about $119 the first year and $99 per year after, and it requires Excel for Windows. Treasury Software's Bank Positive Pay is a Windows desktop product with 350-plus prebuilt layouts, sold on a monthly subscription in the roughly $30 to $90 range. Both are Windows-only and installed software. For a single account and a once-a-week file, a free browser tool covers the same job without a license or an install.
Always verify the first file with your bank
No guide can promise a file will match your bank's spec, because banks revise layouts and your treasury setup may have account-specific quirks. Before you rely on any tool, including this one, generate one file and confirm with your bank or treasury contact that it imported cleanly. Most banks will tell you exactly which field was off if it does not. Once the first file is accepted, the mapping is set and the rest of your cycles are quick.
For background on the underlying layout, see our positive pay file format reference. If you keep your books in QuickBooks, the QuickBooks positive pay guide walks through exporting the check report first.