Webster Bank Positive Pay File: Process and How to Build One

Webster Bank runs check fraud protection through its Payee Positive Pay service. You send the bank a list of every check you issued, and Webster matches each one against checks that come in for payment. When something does not match, the bank flags it and asks you to pay or return it before money leaves your account.

The piece most bookkeepers get stuck on is the file itself. You have a check register in QuickBooks or a spreadsheet, and Webster wants a check issue file in a specific layout. This page explains how Webster's process works, where the exact file format comes from, and how to turn your register into a file that uploads cleanly.

How Webster Bank positive pay works

Webster offers two flavors of check positive pay, and they behave differently:

• Payee Positive Pay. You upload a check issue file each day you write checks. Webster validates incoming checks against your list by account number, issue date, check serial number, dollar amount, and payee name. This is the version that needs a file from you.
• Reverse Positive Pay. No file upload. The bank sends you a daily list of checks presented against your account, and you review and decide which to pay or return. Less work up front, but you carry more of the review burden and there is no payee-name check.

If you are on Payee Positive Pay, you submit your issued-check file and any void file two ways: through Direct Transmission (an automated file feed, usually set up for higher volumes) or through e-Treasury, Webster's online treasury platform, where you can also key in check data by hand for a small number of items. e-Treasury is the same portal where you approve or return flagged checks each day.

Where the file spec comes from

Webster does not publish the field-level layout for its positive pay file on its public website, and we will not guess at one. Banks treat the exact column order, field widths, date format, and whether the file is fixed-width or delimited as account-specific configuration. Getting those details wrong is the most common reason a first upload bounces.

Get the real specification from one of these sources before you build anything:

• Your Webster treasury management representative or implementation contact, who configures the format when your service is set up.
• The file format documentation inside e-Treasury, often found near the positive pay upload or import screen.
• Webster Treasury Management / Client Support. Webster lists 855.274.2800 for client services on its positive pay pages. Ask specifically for the "check issue file format" or "positive pay import map" for your account.

When you ask, request a sample file and a written field map: the order of fields, exact character widths (for fixed-width files), the date format (MMDDYYYY versus MM/DD/YYYY is a frequent trip-up), how the check amount is written (with or without a decimal, leading zeros, implied cents), and which record types or header rows Webster expects. Confirm whether your account is configured for payee name matching, since that adds a payee field to the layout.

Build the file from your register with PositivePayMaker

Once you know Webster's layout, you need to reshape your check register into it. QuickBooks does not export a positive pay file natively, and neither do most accounting tools, so this step is usually manual spreadsheet work or a paid converter.

PositivePayMaker is a free tool that does the reshaping in your browser. You upload your check register as a CSV or Excel file, map your columns (check number, date, amount, payee, account) to the fields Webster wants, and it generates the formatted file. Because Webster's published layouts are not available to encode as a one-click preset, use the custom format builder to match Webster's spec exactly: set the field order, choose fixed-width or delimited, set the date format and amount style, and add any header your bank requires. You can save that configuration and reuse it every time you run positive pay.

Two things worth knowing:

• Your check data never leaves your computer. The tool runs entirely client-side in the browser. Nothing is uploaded to a server, which matters when the file contains account numbers and payee names.
• There is a built-in file validator. Run your generated file through it to catch obvious problems, such as ragged column widths or malformed dates, before you hand it to Webster.

Verify your first file with Webster

No tool can confirm that a layout matches your specific Webster account configuration, because that configuration lives on the bank's side. After you generate your first file, send a small test through e-Treasury and confirm with your Webster contact that it imported with the correct check counts and dollar totals. Once one real file goes through clean, you can trust the same configuration for daily runs.

When a paid tool might fit better

PositivePayMaker covers the common case: a bookkeeper or business owner turning a register into a positive pay file. If your needs are heavier, paid options exist. Treasury Software sells a Bank Positive Pay product (roughly $14.96 to $89.95/month depending on tier, installed on Windows) and maintains pre-built maps for hundreds of banks, including a Webster-specific configuration; it can suit higher-volume shops that want vendor-maintained formats and support. Big Red Consulting's Positive Pay File Creator (around $119 the first year, then $99/year, Windows-only, with a QuickBooks edition that needs Excel installed) integrates more tightly with QuickBooks desktop. Both cost money and run on Windows; PositivePayMaker is free and runs in any browser. Pick based on volume and how much you value vendor-maintained bank maps.

Quick checklist

1. Confirm you are on Payee Positive Pay (file upload) versus Reverse Positive Pay (no file).
2. Get the exact file spec and a sample from your Webster treasury contact or e-Treasury.
3. Export your check register from QuickBooks or your accounting software as CSV/Excel.
4. Use the custom format builder to match Webster's layout, then generate the file.
5. Validate it, upload a test through e-Treasury, and confirm totals with Webster before going live.

Create your positive pay file