James Allman | JA Technology Solutions LLC
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, a duplicate Bank Reference # audit, 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. Separate transactions by account in multi-account files, view balances, and 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 & FinanceEDI 852 Product Activity Builder
Report sell-through and on-hand quantities per item, with an optional per-store SDQ breakdown, and download a valid X12 852 ready to send.
Retail & POSEDI 875 Grocery Products PO Builder
Enter grocery PO details and line items with case UPCs. Download a valid UCS X12 875 grocery products purchase order ready to send.
Retail & POSEDI 880 Grocery Products Invoice Builder
Enter grocery invoice details and line items with case UPCs. Totals compute automatically. Download a valid UCS X12 880 ready to submit.
Retail & POSX12 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 & FinanceCSV & Delimited Text Converter: CSV, TSV, Pipe, Excel
Convert CSV, TSV, pipe-delimited, custom-delimiter text, and Excel files into CSV, TSV, pipe, JSON, JSONL, Excel, YAML, XML, Markdown table, HTML table, or SQL INSERT statements.
Data & FinanceFixed-Width ↔ CSV
Convert between fixed-width text files and CSV. Editable column definitions with name, start, and length.
Data & FinanceFile Compare & Merge
Compare two text or code files with line-level diff and intra-line word/character highlighting. Side-by-side, unified, and inline views. JSON structural mode. Unified-patch export and apply.
DevelopmentParquet 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 & FinanceExcel Converter
Convert Excel workbooks to CSV, JSON, XML, and 8 other formats. Multi-sheet picker, Force Text columns.
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 & FinanceCSV SQL Query Tool
Upload CSV, Excel, or Parquet files and query them with real SQL, joins across files included, or ask a question in plain English and review the generated SQL.
DevelopmentCSV to SQL Generator
Convert CSV data to SQL CREATE TABLE and INSERT statements with automatic type detection and dialect-specific output.
DevelopmentGS1 Application Identifier Parser
Parse GS1-128 and DataMatrix Application Identifier strings into structured, human-readable fields with validation.
Retail & POSShrink & Waste Calculator
Calculate inventory shrink, known waste, COGS, and gross profit by department with industry benchmark comparison.
Retail & POSVendor Cost Change Impact Calculator
See how a vendor case cost change affects unit cost, margin, and GP%, and the retail that restores your original margin.
Retail & POSACH Return Code Lookup
Look up Nacha ACH return reason codes (R01 to R85) and notification of change codes: what each means, who returns it, and the return window.
Data & FinanceBAI2 Type Code Reference
Search BAI2 type codes from the BAI file specification: balance status codes, credit codes, and debit codes, with plain-language descriptions.
Data & FinanceUPC-E to UPC-A & GTIN Converter
Convert between UPC-E, UPC-A, GTIN-13, and GTIN-14 forms of the same product code, with check digits computed and validated.
Retail & POSIncoterms 2020 Reference & Comparison
Browse all 11 Incoterms 2020 rules, compare any two side by side, and see the classic responsibility matrix for risk, freight, duty, and insurance.
Shipping & LogisticsFIFO / LIFO / Average Cost Calculator
Calculate COGS and ending inventory under FIFO, LIFO, and perpetual weighted average from a transaction ledger, with per-sale cost layer breakdowns.
Data & FinanceEDI 894/895 DSD Delivery/Return Explorer
Decode X12 EDI 894 and 895 DSD delivery/return documents into a readable summary: header, parties, line items, totals, plus raw segments and CSV export.
Retail & POSDEX/UCS File Explorer
Decode a DEX/UCS direct-store-delivery file: the DXS/DXE application envelope plus the embedded 894/895 delivery and return records.
Retail & POSAll tools run entirely in your browser. Your data never leaves your machine. Need help? Ask James.
Other Tool Categories
Retail & POS
Barcodes, POS files, retail math, and fiscal calendars.
Grocery & Fresh Departments
Meat, produce, deli, bakery, seafood, and floral department math and operations.
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.