Johnson Financial Group 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 Johnson Financial Group accepts.

Built from Johnson Financial Group's published spec · Read 10/29/2026 · Source

Make your Johnson Financial Group file Try it with a sample file

What Johnson Financial Group receives

The Johnson Financial Group 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

Johnson Financial Group , Issued check file, comma delimited

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

File check: Passed

111001,Example Office Supply Co.,10/1/2026,1688.12,I221002,"Example Janitorial, LLC",10/2/2026,6895.24,I331003,Example Property Mgmt LLC,10/3/2026,450.00,V41004,Example Employee One,10/15/2026,2104.50,I51005,Example Construction and Landscaping Services of Northern County,10/20/2026,12500.00,I

Line 1. One check per line: check number, payee, issue date, amount and issue/void code, in this order.
Line 2. A payee name with a comma goes in double 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 Johnson Financial Group

Note: Already have a Johnson Financial Group 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 AccessJFG, open the Cash Management menu and select Positive Pay, then select Launch Advanced Options.
Under Client Maintenance, select File Mapping, then Add New. Profile Name: anything you'll recognize, for example BankFileKit.
File Format: Delimited Text. Delimiter: Comma. Text Qualifier: " (double quote). Choose File: a file you downloaded from BankFileKit, then select Next.
Leave File Does Not Contain Issued Date, First Row Contains Column Names, Skip Rows at Beginning and Skip Rows at Ending unchecked. File Totals Options: Do Not Require File Totals. Select Next.
Check Number: Column 1. Issued Payee: Column 2. Issued Date: Column 3, with Dates in file do not include separators unchecked. Amount: Column 4, with Insert Decimal Point unchecked.
Record Type: Column 5, with Convert Negative Amounts to Voids unchecked. Issued Item Code: I. Void Item Code: V. Leave Stop Pay Item Code blank. Select Next, check the summary and select Save.
To send a file: in Positive Pay, select Submit Issued Check File. Choose this file mapping and your account, choose the file, then select Process File.

What's in the file

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

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

Good to know

Johnson Financial Group lets you map your own file. This layout uses check number, payee, issued date and amount, plus a record type with I for issued and V for void.
You choose the account when you upload, so each file is for one account.
If you use Payee Positive Pay, the payee name must match the printed check exactly, or the payee matching can create extra exceptions.
Johnson Financial also builds file maps for you. Call Treasury Management Support at 888.769.3796 if you'd rather they set it up.

Where Johnson Financial Group's guide doesn't say

BankFileKit fills these in with safe defaults. Your test file confirms them with Johnson Financial Group before you send a live file.

BankFileKit default: Column order and I and V codes are BankFileKit's choice. Johnson Financial's guide lets you map any order.
BankFileKit default: A payee name is put in double quotes only when it has a comma. The mapping screen in Johnson Financial's guide shows a Text Qualifier set to " (double quote), but its text doesn't describe it, so the steps say to check that setting.
BankFileKit default: Dates like 10/1/2026 (month and day without leading zeros).
BankFileKit default: Voided checks carry the original check amount.
BankFileKit default: Check numbers up to 15 digits and amounts up to $99,999,999.99. No limit on payee name length. Johnson Financial's guide doesn't publish limits.
BankFileKit default: Line endings: Windows (CRLF). Text: plain ASCII.

Note: Send a test file to Johnson Financial Group first

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

Source

Positive Pay File Import Mapping: CSV (Comma-delimited) File Formats, Johnson Financial Group. No date printed. Pages 2-25. https://www.johnsonfinancialgroup.com/siteassets/documents/banking/commercial/client-resources/positive-pay/positive-pay-file-import-mapping--csv-files-1.pdf. Read 10/29/2026.

BankFileKit isn't affiliated with or endorsed by Johnson Financial Group.