JA Technology Solutions
Data & Finance Tools
Tools for working with banking, accounting, healthcare, payments, and EDI file formats. Parse files into structured views, validate before importing, convert between formats, and generate test data — all in your browser.
QuickBooks Explorer
Explore and create QuickBooks Desktop QB IIF and QuickBooks Online CSV files. Parse, validate, convert, and generate — all in your browser.
Data & FinanceBAI2 File Explorer
Parse BAI2 bank statement files into structured views with type code lookup, transaction details, and CSV export.
Data & FinanceNACHA/ACH File Explorer
Parse ACH payment files into readable records. View entries, totals, and export to CSV or JSON.
Data & FinancePositive Pay Generator
Generate Positive Pay fraud prevention files from check data. Chase, BofA, Wells Fargo, and generic formats.
Data & FinanceBAI2 File Generator
Generate BAI2 bank statement test files with configurable accounts, transactions, and auto-calculated control totals.
Data & FinanceOFX/QFX Explorer
Parse OFX and QFX bank statement files. View account info, transactions, and balances. Export to CSV.
Data & FinanceSWIFT MT Explorer
Parse SWIFT MT financial messages (MT103, MT940, MT700). Block structure, field lookup, and transaction tables.
Data & FinanceBusiness Day Calculator
Count business days between dates or add/subtract business days. Includes US holiday awareness and payment term shortcuts.
Data & FinanceDepreciation Calculator
Calculate asset depreciation schedules using straight-line, declining balance, sum-of-years-digits, or MACRS methods.
Data & FinanceCheck Digit Validator
Validate and calculate check digits for UPC, EAN, credit cards (Luhn), and ABA routing numbers.
Data & FinanceLanded Cost Calculator
Compute per-unit landed cost with freight, duty, insurance, and fees — single SKU or multi-line shipment.
Shipping & LogisticsEDI File Parser
Upload or paste any EDI file — parsed into labeled segments with export to CSV, JSON, and SIL.
Retail & POSEDI 810 Invoice Builder
Enter invoice details, paste a CSV, or import from QuickBooks — download a valid X12 EDI 810 invoice ready to submit to a trading partner.
Retail & POSEDI 850 Purchase Order Builder
Enter PO details, paste a CSV, or import from QuickBooks — download a valid X12 EDI 850 purchase order ready to send to a supplier.
Retail & POSEDI 856 Advance Ship Notice Builder
Build a valid X12 EDI 856 advance ship notice — nested HL shipment/order/item loops, carrier and BOL details, and one-click pre-fill from a prior 850.
Retail & POSEDI 997 Functional Acknowledgment Builder
Paste any inbound X12 document — the tool lists each transaction set so you can mark it accepted or rejected, then download a valid 997 ready to transmit.
Data & FinanceEDI 855 Purchase Order Acknowledgment Builder
Paste the inbound 850 — the tool pre-fills every line as accepted, then you mark the ones that change quantity, price, or ship date, or reject the ones you can't fulfill.
Retail & POSEDI 820 Remittance Advice Builder
Tell the payee which invoices you're paying. Load 810s to populate invoice entries, set action codes and amounts, and download a valid 820.
Data & FinanceX12 Segment Reference
Searchable EDI X12 segment and element dictionary with 43 segments, 27 transaction sets, and qualifier codes.
Data & FinanceHL7 Message Explorer
Parse HL7 v2.x healthcare messages with segment descriptions, field labels, and message type identification.
Data & FinanceFHIR Resource Explorer
Parse HL7 FHIR JSON resources with resource-specific rendering. Supports Patient, Observation, Bundle, and more.
Data & FinanceISO 8583 Explorer
Parse ISO 8583 payment card messages with MTI breakdown, bitmap visualization, and data element parsing.
Data & FinanceUniversal File Converter
Convert between CSV, Excel, TSV, JSON, and delimited formats with smart auto-detection and Force Text columns.
Data & FinanceFixed-Width ↔ CSV
Convert between fixed-width text files and CSV. Editable column definitions with name, start, and length.
Data & FinanceParquet File Explorer
View and explore Apache Parquet files entirely in your browser. See schema and metadata, browse data with filtering, export to CSV/JSON/Excel, or convert files to Parquet.
Data & FinanceIBAN Validator
Validate IBAN check digits and decode country and BBAN structure using the ISO 13616 mod-97 algorithm.
Data & FinanceAmortization Calculator
Calculate loan amortization schedules with monthly payment, principal/interest breakdown, and extra payment analysis.
Data & FinanceMICR Line Decoder
Parse the MICR E-13B line from a check to extract routing number, account number, check number, and amount.
Data & FinanceCard Number Validator
Validate card numbers with the Luhn algorithm and detect card network from prefix ranges.
Data & FinanceAll tools run entirely in your browser. Your data never leaves your machine. Need help? Ask James.
Other Tool Categories
Retail & POS
Barcodes, point-of-sale files, retail math, and fiscal calendars.
Shipping & Logistics
Freight estimation, container loading, route optimization, and trade compliance.
Inventory & Warehouse
Reorder planning, cycle counting, warehouse slotting, and cost allocation.
Networking
Subnet math, MAC vendor lookup, email authentication, and WHOIS.
Development
Format converters, encoders, hashes, regex, JWT, SQL, and more.
IBM i & Mainframe
EBCDIC, packed decimal, COBOL copybook, DDS, BMS, and fixed-width.