Rockland Trust 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 Rockland Trust accepts.

Built from Rockland Trust's published spec · Read 10/29/2026 · Source

Make your Rockland Trust file Try it with a sample file

What Rockland Trust receives

The Rockland Trust 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

Rockland Trust , Issued check file, CSV

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

File check: Passed

111001,1688.12,100126,Example Office Supply Co.221002,6895.24,100226,"Example Janitorial, LLC"31004,2104.50,101526,Example Employee One41005,12500.00,102026,Example Construction and Landscaping Services of Northern County

Line 1. One check per line: check number, amount, issue date and payee, in this order. Voided checks aren't sent in this layout.
Line 2. A payee name with a comma goes in double quotes, so the bank reads it as one name.

How to send it to Rockland Trust

Rockland Trust sets up the file mapping for you when Positive Pay starts. Tell Rockland Treasury Operations you'll send a CSV file with no header row: Column A check number, B amount, C issue date (MMDDYY) and D payee name.
Download the free test file from BankFileKit and send it to Rockland as your sample. Rockland's guide says any later change to the file map needs new testing.
Once Rockland confirms the mapping, upload each file in Positive Pay before you release the checks.

What's in the file

What each check line holds, in the Rockland Trust file
Column	Field	Example	Rules
1	Check number	1001	Digits only, up to 15.
2	Amount	1688.12	Dollars and cents with a decimal point. No $ or commas. Up to $99,999,999.99.
3	Issue date	100126	MMDDYY.
4	Payee	Example Office Supply Co.	Exactly as printed on the check.

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

Good to know

Column order follows Rockland's guide: check number, amount and issue date in columns A to C, then the payee name. No header row or totals.
Rockland's file has no void column, so voided checks are left out of the file. Contact Rockland Trust to void them.
Dates are six digits, MMDDYY, as Rockland's guide asks.
The payee name is optional for Rockland, and needed only if you use Payee Match.

Where Rockland Trust's guide doesn't say

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

BankFileKit default: A payee name is put in double quotes only when it has a comma, the way Excel saves a CSV file (decided 10/29/2026). Rockland's guide doesn't say how commas are handled.
BankFileKit default: The account number column is left out. Rockland lists it as optional.
BankFileKit default: Check numbers up to 15 digits and amounts up to $99,999,999.99. Rockland's guide doesn't publish limits.
BankFileKit default: Line endings: Windows (CRLF). Text: plain ASCII.

Note: Send a test file to Rockland Trust first

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

Source

Positive Pay File Format User Guide, Rockland Trust. Date printed: V 3.11.2026. Pages 2-3. https://www.rocklandtrust.com/assets/files/FW77e3GD/Positive_Pay_File_Format_User_Guide_Final.pdf. Read 10/29/2026.

BankFileKit isn't affiliated with or endorsed by Rockland Trust.

Other banks

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