Simmons Bank Positive Pay file

Works with your QuickBooks report exactly as exported. No cleanup.

Turn your QuickBooks Check Detail report or Excel check list into the check issue file Simmons Bank accepts.

Built from Simmons Bank's published spec · Read 10/26/2026 · Source

Make your Simmons Bank file Try it with a sample file

What Simmons Bank receives

The Simmons Bank file BankFileKit makes from a sample QuickBooks report with fake checks. You see this proof for your own file before anything leaves your browser.

File proof

Simmons Bank , Issued items file, comma delimited

positive-pay-simmons-20261026.csvCreated 10/26/2026 (example)

File check: Passed

111001,10/01/2026,Example Office Supply Co.,1688.12,221002,10/02/2026,'Example Janitorial, LLC',6895.24,331003,10/03/2026,Example Property Mgmt LLC,450.00,V41004,10/15/2026,Example Employee One,2104.50,51005,10/20/2026,Example Construction and Landscaping Services of Northern County,12500.00,

Line 1. One check per line: check number, issue date, payee, amount and issue/void code, in this order.
Line 2. A payee name with a comma goes in single quotes ('), so the bank reads it as one name.
Line 3. A voided check, marked V, with its original amount. QuickBooks shows voids as $0.00, so BankFileKit asks you for the original amount.

Set it up once at Simmons Bank

Note: Already have a Simmons Bank import map?

Your file has to match the map you upload it with. Add a new map with the settings below, or use My bank isn't listed to make a file that matches the map you have.

In Treasury Connect, open the Issued Items Template Formatting Tool and choose Delimited.
Format Name: any name you'll remember, for example BankFileKit. Exclude Header Rows: 0. Exclude Footer Rows: 0.
Item Amount: Decimal Included. Issued Date Format: mm/dd/yyyy. Void Indicator: V. Leave Checking Indicator, Savings Indicator and Void Date Format blank.
Column Order: Item Number 1, Issued Date 2, Payee 3, Item Amount 4, Void Indicator 5. Leave Account Number, Account Type and Void Date blank.
Save the format, then upload your BankFileKit file as a .csv.

What's in the file

What each check line holds, in the Simmons Bank file
Column	Field	Example	Rules
1	Check number	1001	Digits only, up to 15.
2	Issue date	10/01/2026	MM/DD/YYYY.
3	Payee	Example Office Supply Co.	Exactly as printed on the check.
4	Amount	1688.12	Dollars and cents with a decimal point. No $ or commas. Up to $99,999,999.99.
5	Issue/void code		Blank for issued checks, V for voids.

.csv file · Commas between fields · No header row · Windows line endings

Good to know

Simmons lets you map your own file in Treasury Connect. This layout uses the same column numbers as the example in Simmons's guide: check number, issued date, payee, amount and a void indicator (V on voided checks, blank otherwise).
The payee name should match exactly what is printed on the check, including capitalization and punctuation.
Simmons's text qualifier is a single quote, so a payee name with a comma is wrapped in single quotes. A payee with both a comma and an apostrophe can't be sent; BankFileKit tells you how to fix it.

Where Simmons Bank's guide doesn't say

BankFileKit fills these in with safe defaults. Your test file confirms them with Simmons Bank before you send a live file.

BankFileKit default: Line endings: Windows (CRLF). Simmons's guide doesn't say.
BankFileKit default: Text: plain ASCII.
BankFileKit default: Voided checks carry the original check amount, as in Simmons's sample.
BankFileKit default: Check numbers up to 15 digits and amounts up to $99,999,999.99. Simmons's guide doesn't publish field lengths.

Note: Send a test file to Simmons Bank first

Before your first live file, download the free test file with your first 3 checks, send it to Simmons Bank, and confirm it was accepted. BankFileKit can't guarantee that Simmons Bank will accept a file.

Source

Treasury Management Quick Reference Guide: Positive Pay File Format and Mapping, Simmons Bank. Date printed: January 2026. Pages 1-3. https://www.simmonsbank.com/siteassets/pdfs/qrg-positive-pay-file-format-and-mapping-2026.pdf. Read 10/26/2026.

BankFileKit isn't affiliated with or endorsed by Simmons Bank.

Other banks

See every bank, or set up your own layout if your bank uses a different one.