How to Create a Positive Pay File From NetSuite
NetSuite holds all the data your bank needs for positive pay: check numbers, amounts, issue dates, and payees. What it does not do is hand you a finished positive pay file in your bank's exact layout. Banks each want their own column order, date format, and sometimes fixed-width spacing. So the job has three steps: pull the check data out of NetSuite as CSV, line up the columns, and convert that into the bank's file.
This guide walks through all three. NetSuite navigation varies by account, role, and edition, so the menu paths below are described in general terms. The data you are after is the same in every account: your outgoing check payments.
What a positive pay file actually is
Positive pay is a bank fraud control. Each time you cut checks, you send the bank a list of the checks you issued: check number, amount, issue date, and usually the payee name. When a check hits the bank, it is matched against your list. Anything that does not match gets flagged for you to approve or reject. If positive pay is new to you, start with what is positive pay for the full picture, then come back here for the NetSuite export.
Step 1: Export your check data from NetSuite to CSV
NetSuite gives you two practical ways to get check payment data out as CSV. Pick whichever your role has access to.
Option A: a transaction saved search (most control)
A saved search lets you choose exactly which columns and rows you export, which makes the later mapping much easier. In general terms:
- Create a new transaction saved search.
- Filter the type to your outgoing payments. For checks written against the bank account, that is typically Check and Bill Payment transactions. Add a date range so you only get the batch you just printed.
- Add result columns for the fields your bank needs: check or document number, amount, transaction date, payee or entity name, and the bank account. Keep the columns to what the bank uses. Extra columns are easy to drop later, but a clean export saves time.
- Run the search, then export the results to CSV.
Saving the search means next month you reopen it, change the date range, and export again. Same columns every time.
Option B: a register or payment list export (fastest)
If you do not want to build a search, NetSuite lets you view payment and check registers and export the visible list to CSV directly. Open the relevant bank account register or your bill payment list, set the date range to the checks you issued, and use the Export to CSV action. This is quicker but gives you less control over the columns, so expect to clean up the file before converting.
Either way, the goal is the same: a CSV with one row per check and columns for check number, amount, and date at minimum.
Step 2: Check the data before you map it
Open the CSV and confirm a few things, because these are what bank uploads usually reject:
- Check numbers are present and numeric. Voided checks should still be included as voids if your bank's format supports a void status. Do not silently drop them.
- Amounts are clean. Some banks want a plain number like
1250.00, others want cents with no decimal like125000, and many reject currency symbols or thousands separators. Note which your bank wants now. - Dates are consistent. NetSuite exports follow your account's date preference. Your bank will want a specific format such as
MM/DD/YYYYorYYYYMMDD. You do not have to fix this by hand; the converter handles date formatting. - Only the right account. If you write checks from more than one bank account, filter to a single account per file. Banks match a positive pay file to one account number.
Step 3: Convert the CSV to your bank's positive pay format
This is the step NetSuite leaves to you, and the step where a converter saves real time. Rather than rearranging columns and reformatting dates in a spreadsheet for every batch, you map the NetSuite CSV once and reuse it.
PositivePayMaker is a free tool that does exactly this. You load your NetSuite CSV or Excel export in the browser, tell it which column is the check number, which is the amount, which is the date, and which is the payee, then it writes the file in your bank's layout. It runs entirely in your browser, so your check data never gets uploaded to a server. It includes 11 bank layouts, six of which are built from published bank specifications including Chase and Huntington, plus a custom format builder for banks that use their own spec. You can see the full list of supported bank formats.
If your bank is not a preset, the custom format builder lets you set the exact column order, delimiter, date format, and amount style your bank's spec document calls for. Save it and that layout is there next time.
Always test the first file with your bank
No matter how you generate the file, upload your first one as a test and confirm your bank accepts it before you rely on it. Bank specs change, and a layout that worked last year can be tightened without much notice. After you generate a file, run it through the built-in file validator to catch obvious problems like blank check numbers or malformed amounts before the bank does.
A note on cost
You do not need to buy desktop software for this. As of 2026, the common paid options are Windows-only desktop programs: Big Red Consulting's PositivePay File Creator runs about $119 the first year then $99 per year and requires Microsoft Excel installed, and Treasury Software's Bank Positive Pay runs roughly $30 to $90 per month per seat. PositivePayMaker is free, works in any modern browser on Mac or Windows, and keeps your check data on your own machine.
The NetSuite side and the conversion side are separate skills. If you also run QuickBooks for another entity, the same converter handles that export too; see the QuickBooks positive pay guide.