ZERO-UPLOAD BROWSER WORKFLOWVerified Tier-A (wells-fargo-arp-165-payee)Verified Nov 2026

QuickBooks Online to Wells Fargo Positive Pay Guide

Step-by-step guide to exporting checks from QuickBooks Online and converting them into a bank-ready Wells Fargo Positive Pay file without Split duplicates, negative amounts, or leading-zero corruption.

Recommended Accounting Report

Check Detail Report (filtered to Paid / Printed Checks & Voided Checks)

Export File: CSV / Excel Export (.csv / .xlsx)

Target Bank Specification

Wells Fargo

Verified Tier-A layout (wells-fargo-arp-165-payee) with 8-rule Pre-Flight & Byte Ruler.

Step-by-Step Export & Positive Pay Compilation Checklist

  1. 1

    Run the QuickBooks Online Check Detail report

    Open Reports -> Search for "Check Detail", set Transaction Date to your check run range, and click Customize -> Filter -> Checking Account so only one bank account is exported per file.

    Never use Expenses by Vendor Summary; QBO inserts "-Split-" lines and multiple expense lines for single checks.
  2. 2

    Enable Num, Date, Name, Amount, and Memo/Description columns

    Ensure "Num" (Check Number), "Date", "Name" (Payee), "Amount", and "Memo/Description" appear before exporting via Export -> Export to CSV.

  3. 3

    Do NOT reopen the raw CSV directly in Excel

    Drag the untouched QBO CSV directly into PositivePayFileGenerator.com. Our browser engine automatically strips top company banner lines, skips "-Split-" allocation lines, removes the bottom "TOTAL" row, converts parenthesized negatives "($245.50)" into Void flags, and preserves leading zeros.

    Opening and saving a CSV in Excel strips leading zeros from 8-digit account numbers and check serial numbers and adds a UTF-8 BOM that breaks byte-1 parsers.
  4. 4

    Compile to Wells Fargo Positive Pay specification

    Select the verified Wells Fargo preset (wells-fargo-arp-165-payee) inside PositivePayFileGenerator.com, verify the 8-rule Pre-Flight Check banner shows 0 blocking errors, and download your 165-byte Fixed-Width ARP (*03 / 320 / &) ready for upload.

    Wells Fargo ARP requires *03 header, 320 (Issue) / 370 (Void) 3-digit codes, and "&" trailer hash control totals.

Portal Rejections Prevented Automatically

  • Split expense lines duplicating the same check number inside Check Detail exports
  • Parenthesized negative voids "($245.50)" and "-$1,500.00" rejecting numeric bank parsers
  • Top company header rows and bottom "TOTAL" summary row corrupting line counts
  • Excel silently dropping leading zeros and injecting UTF-8 BOM (EF BB BF) bytes
  • Using 85-byte lines on an account enrolled in 165-byte Payee Positive Pay

Controller Pre-Upload Verification Checklist

  • Filtered Check Detail to single bank account
  • Confirmed "-Split-" sub-rows collapsed to one item per Check #
  • Verified Voids carry explicit Void indicator instead of negative signs
  • Checked ASCII payee transliteration (no curly quotes or diacritics)
  • Selected Wells Fargo format (165-byte Fixed-Width ARP (*03 / 320 / &))

Other Accounting Integrations for Wells Fargo

Integration FAQ

Why does Wells Fargo reject raw QuickBooks Online CSV exports?

Raw QuickBooks Online exports include report banner lines, split/GL detail rows, parenthesized negatives, or UTF-8 BOM markers that conflict with Wells Fargo (165-byte Fixed-Width ARP (*03 / 320 / &)) requirements. Running the export through PositivePayFileGenerator.com normalizes the register 100% locally in your browser first.

Does QuickBooks Online accounting data leave my browser when formatting for Wells Fargo?

No. PositivePayFileGenerator.com parses your check register, calculates integer-cent batch totals, applies byte alignment rules, and builds your upload file entirely client-side with zero server uploads.