Positive Pay file
Turn a QuickBooks Check Detail report or an Excel check list into your bank's Positive Pay file. You see every line before it goes to your bank.
1. Upload
- Banks
- Alerus (no payee)
- Alerus (with payee)
- Associated Bank
- 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
Type your bank's name or pick it from the list.
Your layout
Note: Not a bank-verified format
For example "Operating account."
Example positions. Replace them with the positions from your bank's spec.
Leave blank to end each line after its last field.
Header and trailer lines (optional)
One line before the checks.
One line after the checks.
When this is off, the total adds issued checks only.
Adds zeros in front. 6 turns 1001 into 001001. Leave blank to write numbers as they are.
Leave blank if your bank doesn't set one.
Leave blank if your bank wants it empty.
For example V.
More options
Error: Finish your layout
Set up your bank once
Goes in the file name your bank needs.
Saved in this browser only, not encrypted. It's never sent anywhere.
Account ending in is saved on this computer.
Goes in every row of your file. It stays in your browser.
Encrypted with a passphrase only you know. We can't recover it if you forget it.
Drop your Check Detail report here
Upload the Check Detail report exactly as QuickBooks exported it, as CSV or Excel. No cleanup needed. The file stays in your browser.
Error: We couldn't use this file
Match your columns
This report has checks from more than one bank account. Each Positive Pay file is for one account. Make one file per account.
Some bookkeepers record paper checks as Expense in QuickBooks Online. Only rows with a check number made of digits are added.
Note: Payee names
Vendor list (optional)
A QuickBooks Desktop vendor list with "Print on check as," or an Excel list with two columns: Vendor and Name on check. Payee names then match your printed checks.
Needs attention: Payee names weren't changed
2. Check
Pick your bank to start.
The file proof shows exactly what goes to your bank, line by line, before anything leaves this page.
Every check in your file
Error: Fix this before you download
Needs attention: Left out of your file
| Row | Check # | Date | Payee | Amount | Status |
|---|
Find it in your check register. It stays on this page and isn't saved.
3. Download
Your download options appear here after your file is checked.
Needs attention: You already downloaded this file
Send a test file to your bank first
This is your first file for your bank. Send a test file to your bank first and confirm it was accepted. Your bank's treasury or cash management team can tell you how.
Download your file
You confirmed that your bank accepted your test file.
- Download the test file below. It has your first 3 checks and is free.
- Upload it through your bank's test or file validation option.
- Wait for the bank to confirm it was accepted.
You only need to do this once for each bank.
Download file turns on after you tick the box above.
See plans. Payments open soon.
You must review every file before submitting it to your bank. You are solely responsible for the files you upload to your bank and for the payments, checks and account details they contain. BankFileKit creates files from the data you provide. It does not send payments, verify payees or guarantee that your bank will accept a file.
Files made on this computer (0)
Saved only in this browser: dates, totals, check number ranges and the last 4 digits of an account. Never payee names or full account numbers. The files themselves aren't saved.
Files you download will be listed here, on this computer only.
| Date | Bank or layout | File | Checks | Check numbers | Total | Type | Remove |
|---|