AIStacker
DataNew

Overview

Zengin Bank File Format Validator

Audit fixed-width Zengin (.txt) files for field length violations, invalid Zenkaku characters in Hankaku fields, and trailer hash total mismatches.

Category hub

Data

Problems

5

FAQ

3

全銀ファイル バリデーター

全銀フォーマット(.txt)をフィールド単位で検証。半角フィールドへの全角文字混入・固定長違反・トレーラ合計不一致を検出します。

全銀ファイル(.txt)の内容を上のテキストエリアに貼り付けるか、サンプルを読み込んで検証してみてください。

What you can solve

Why does my Zengin file get rejected with an Invalid Format error?

The most common causes are full-width characters in half-width fields and records that are not exactly 120 bytes. Use this validator to identify the exact line and field causing the failure. The error list shows you the specific violation so you can fix just that field rather than rebuilding the entire file.

How do I check whether full-width characters are in half-width Zengin fields?

Paste the file content and click Validate. The tool scans recipient names, bank names, and branch names in every data record and flags any that contain full-width characters. Legacy ERP exports and copy-pasted data from spreadsheets are the most frequent sources of Zenkaku contamination in Zengin files.

How do I fix a mismatch between the trailer total count and actual data records?

The trailer record (type 8) must report exactly the same number of data records (type 2) that appear in the file. This validator compares both counts automatically and flags a mismatch if they differ. The most common cause is manually adding or deleting rows after the file was exported from an ERP system.

What causes Zengin records to be the wrong length?

Each Zengin record must be exactly 120 single-byte characters. Records longer or shorter than 120 characters cause the entire file to be rejected. Common causes are pasting from Excel which strips trailing spaces, line-ending characters being included in the field count, or fields being padded with full-width spaces instead of half-width spaces.

What are the valid account type codes in Zengin format?

The Zengin specification allows only three account type values: 1 for ordinary savings (普通預金), 2 for current account (当座預金), and 4 for savings account (貯蓄預金). Any other digit will cause the record to be rejected. Fixed-term deposits (code 3) are not valid targets for bank transfer files.

Typical workflow

Guides for this workflow

Supporting guides that connect this tool to the broader category workflow.

Open category hub

What is

What is Zengin Bank File Format Validator?

Legacy ERP systems and payroll software often output Zengin files with subtle formatting issues that only surface at upload time: full-width Katakana in half-width fields, records that are not exactly 120 characters, or trailer records whose total count does not match the actual data rows. By then, the entire batch fails silently.

This validator parses each Zengin record by field — header (type 1), data (type 2), trailer (type 8), and end (type 9) — and flags every violation with a line number and field name so you can fix it before it reaches the bank portal.

How to use

How to use Zengin Bank File Format Validator

Paste the raw text content of a Zengin .txt file into the textarea and click Validate. The tool checks each record type individually and lists all field-level violations. Click any error row to inspect that record's parsed fields. Use the Copy auto-fixed button to get a version with full-width ASCII characters converted to half-width.

Example

Example

Scenario: A payroll file exported from an old ERP contains data records where the recipient name field holds full-width Katakana.

Input: ...0001ヤマダ タロウ (correct) vs. ヤマダ タロウ (invalid)

Result: Line 4 · Recipient Name: Contains Zenkaku characters

Common use cases

Common use cases

1. Validating Zengin payroll files exported from legacy ERP or Excel before batch upload.

2. Diagnosing 'Invalid Format' rejections from Mizuho, MUFG, or other bank portals.

3. Auditing third-party vendor payment files for encoding compliance.

4. Verifying trailer record hash totals after manual row additions or deletions.

Frequently asked questions

Frequently asked questions

Which Zengin record types does this validator support?v
All four standard record types: header (1), data (2), trailer (8), and end (9). Each is parsed against the standard Zengin field layout with individual field-level checks.
Can this tool fix Zenkaku characters automatically?v
The Copy auto-fixed button converts full-width ASCII digits and Latin letters to half-width equivalents. For Katakana conversion (ヤマダ → ヤマダ) use the dedicated Zenkaku/Hankaku converter tool. Always review auto-fixed output before uploading.
Is it safe to paste payroll or banking data here?v
Yes. All validation runs locally in your browser. No data is transmitted to any server. Your recipient names, account numbers, and transfer amounts stay entirely on your machine.