BankFileKit

Union Bank & 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 Union Bank & Trust accepts.

Built from Union Bank & Trust's published spec · Read 10/29/2026 · Source

Make your Union Bank & Trust file Try it with a sample file

What Union Bank & Trust receives

The Union Bank & 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

Union Bank & Trust , Issued check file, tab delimited

positive-pay-ubt-20261026.txtCreated 10/26/2026 (example)

File check: Passed

Example Office Supply Co.	1001	168812	10/1/2026	IExample Janitorial, LLC	1002	689524	10/2/2026	IExample Property Mgmt LLC	1003	45000	10/3/2026	VExample Employee One	1004	210450	10/15/2026	IExample Construction and Landscaping Services of Northern County	1005	1250000	10/20/2026	I

4 checks$23,187.861 void

Compare these totals with your QuickBooks report.

  1. Line 1. One check per line: payee, check number, amount, issue date and issue/void code, in this order.

  2. 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 Union Bank & Trust

Note: Already have a Union Bank & Trust import map?

Your file has to match the map you upload it with. Add a new map with the settings below, or use My bank isn't listed to make a file that matches the map you have.
  1. Log in to UBT Business, open Risk & Reporting and select Positive Pay. Select Launch Advanced Options.
  2. Under Security/Account Administration, select File Mapping, then Add New.
  3. 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.
  4. Leave File Does Not Contain Issued Date unchecked, because this file has the issue date. Leave 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.
  5. Issued Payee: Column 1. Check Number: Column 2. Amount: Column 3, with Insert Decimal Point checked. Issued Date: Column 4, with Dates in file do not include separators unchecked.
  6. 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 to save the mapping.
  7. To send a file: in Positive Pay, open Submit Issued Check File. Choose this mapping, the file and the account the checks are written on, then select Process File.

What's in the file

What each check line holds, in the Union Bank & Trust file
ColumnFieldExampleRules
1PayeeExample Office Supply Co.Exactly as printed on the check.
2Check number1001Digits only, up to 15.
3Amount168812No decimal point: the last two digits are cents. No $ or commas. Up to $99,999,999.99.
4Issue date10/1/2026M/D/YYYY.
5Issue/void codeII for issued checks, V for voids.

.txt file · Tabs between fields · No header row · Windows line endings

Good to know

  • This is Union Bank & Trust in Nebraska, at ubt.com.
  • Union Bank & Trust lets you map your own file. This layout follows the column order in UBT's mapping example: payee, check number, amount and issue date, plus a record type with I for issued and V for void.
  • Amounts have no decimal point, so $1,688.12 is written 168812. UBT's guide asks you to check Insert Decimal Point for .txt files.
  • You choose the account when you upload, so each file is for one account.
  • If you use Payee Match, the payee name must match the printed check exactly, including titles like Mr. and symbols like &.

Where Union Bank & Trust's guide doesn't say

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

  • BankFileKit default: The issue date is in the file (decided 10/29/2026). UBT's guide lists File Does Not Contain Issued Date as a required setting, but its own mapping example maps a date column.
  • BankFileKit default: Tab between fields in a .txt file (decided 10/29/2026). UBT's guide says commas in payee names cause errors when a file is mapped as .csv.
  • BankFileKit default: I and V codes in the record type column. UBT's mapping screen has Record Type, Issued Item Code and Void Item Code, but its guide doesn't say which codes to use.
  • BankFileKit default: Dates like 10/1/2026 (month and day without leading zeros), as in UBT's mapping example.
  • 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. No limit on payee name length. UBT's guide doesn't publish limits.
  • BankFileKit default: Line endings: Windows (CRLF). Text: plain ASCII.

Note: Send a test file to Union Bank & Trust first

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

Source

BankFileKit isn't affiliated with or endorsed by Union Bank & Trust.

Other banks

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