Associated 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 Associated Bank accepts.
Built from Associated Bank's published spec · Read 10/29/2026 · Source
What Associated Bank receives
The Associated 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
Associated Bank , Issued check file, tab delimited
positive-pay-associated-20261026.txtCreated 10/26/2026 (example)
File check: Passed
1001 Example Office Supply Co. 10/1/2026 1688.12 I1002 Example Janitorial, LLC 10/2/2026 6895.24 I1003 Example Property Mgmt LLC 10/3/2026 450.00 V1004 Example Employee One 10/15/2026 2104.50 I1005 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 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 Associated Bank
Note: Already have a Associated Bank import map?
- In Associated Connect, open Account Details & Services, then the Treasury Services tab and Fraud Services, and select Launch Advanced Options.
- From the menu, choose Company Maintenance, then File Mapping, and select Add New.
- Profile name: anything you'll recognize, for example BankFileKit. File Format: Delimited Text. Delimiter: Tab. Select File: choose 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: open Transaction Processing, then Submit Issued Check File. Choose the file, your account in Account Nickname and this mapping in File Mapping Format, then select Process File.
What's in the 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. |
.txt file · Tabs between fields · No header row · Windows line endings
Good to know
- Associated Connect lets you map your own file. This layout uses the same columns as the example on Associated's mapping screens: check number, payee, issued date and amount, plus a record type with I for issued and V for void.
- It's tab-delimited because Associated advises against comma-delimited files when payee names have commas.
- 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, including words like and or or between names.
Where Associated Bank's guide doesn't say
BankFileKit fills these in with safe defaults. Your test file confirms them with Associated Bank before you send a live file.
- BankFileKit default: Tab between fields, so commas in payee names never split a column. Associated Bank's screen also offers comma, space and semicolon.
- BankFileKit default: Dates like 10/1/2026 (month and day without leading zeros), as in the example on the mapping screen.
- 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. Associated Bank's guide doesn't publish limits.
- BankFileKit default: No limit on payee name length. Associated Bank's guide doesn't publish one.
- BankFileKit default: File extension .txt. Line endings: Windows (CRLF). Text: plain ASCII.
Note: Send a test file to Associated Bank first
Source
- Associated Connect Reference Guide: ACH and Check Positive Pay, Associated Bank. Date printed: 07/26. Pages 25-29. https://www.associatedbank.com/pdf/ACH_and_Check_Positive_Pay_Upgraded_User_Guide.pdf. Read 10/29/2026.
BankFileKit isn't affiliated with or endorsed by Associated Bank.
Other banks
- Alerus
- Bank of Hawaii
- Columbia Bank
- Dollar Bank
- First Citizens
- Huntington
- Mechanics Bank
- Rockland Trust
- Simmons Bank
- Synovus
- TD Bank
- Truist
- Union Bank & Trust
- United Community
See every bank, or set up your own layout if your bank uses a different one.